Use the spreadsheet to determine the total profit for each

Assignment Help Basic Statistics
Reference no: EM13590095

1) Consider a resource-allocation problem having the following data:

Resource             1 Activity       2   Amount resource available

                A             1             0              5

                B             0            1              4

                C             2            1              9

                D             3           4              21          

Unit profit               30          20

The objective is to determine the number of units of each activity to undertake so as to maximize the total profit.

(a) Formulate a spreadsheet model for this problem. 

(b) Graph the feasible region. Use this graph to identify all the corner points.

(c) Use the spreadsheet to determine the total profit for each of these corner points. Then use this information to identify an optimal solution. 

(d) Use the Excel Solver to confirm this optimal solution. 

(e) Use the graphical method to confirm this optimal solution

Reference no: EM13590095

Questions Cloud

Discuss earnings management as it relates to estimates : discuss earnings management as it relates to estimates that are required in formulating the financial statements.
Nick has made the decision to seek this outside financing : warf computers inc. was founded 1 5 years ago by nick warf a computer programmer. the small initial investment to start
Mfg company experiences the following cost behavior : mfg company experiences the following cost behavior patterns each week fixed costs supervisors salary 2000 factory rent
If machine 2 was purchased on november 1 instead of april 1 : in recent years howard company has purchased three machines. because of fre- quent employee turnover in the accounting
Use the spreadsheet to determine the total profit for each : 1 consider a resource-allocation problem having the following
Calculate the indifference point between the two cost : the cost structure of two firms competing in the same industry is represented by the following cost formulas company x
There have been many theories regarding how the pyramids at : choose one 1 of the topics below and develop a three to four 3-4 paragraph essay of at least 250-500 words which
A newspaper ad submitted and published this week with the : 1. financial statement ratios support informed judgments and decision making most effectivelya. when viewed for a
A contractor susan meyer has to haul gravel to three : a contractor susan meyer has to haul gravel to three building sites. she can purchase as much as 18 tons at a gravel

Reviews

Write a Review

Basic Statistics Questions & Answers

  Evidence to support the society claim

A human society claims that less than 36% of US. households own a dog. In random sample of 397 U. S. households, 151 say they own a dog. At mean=0.03, is there enough evidence to support the society's claim?

  Lines experience surface finish problem between given range

What is the probability that none of the lines experiences a surface finish problem in 40 hours of operation. What is the probability that all three lines experience a surface finish problem between 20 and 40 hours of operation.

  Explain observation-parameter and population

Identify the following as either (a) observation, (b) parameter, (c) population, (d) sample, or (e) statistic: All employees at that place of employment.

  Normally distributed in the population

Assume that the data are normally distributed in the population. Now go back and examine the $1,250 figure published by Runzheimer International. Does it fall into the confidence interval computed from the sample data? What does it tell you?

  Find probability exactly three will have mild side effect

In testing a new drug, researchers found that 10% of all patients using it will have a mild side effect. A random sample of 12 patients using the drug is selected. Find the probability that: exactly three will have this mild side effect.

  Develop a regression model to predict the price of stock

Develop a regression model to predict the price of stock 1 and 2 based on the Dow Jones Industrial Average

  Anova-bps-formatted results

Carry out an ANOVA and  describe in detail  in a BPS-formatted Results section:

  Umber of intersections in each states

Interstate 90 is the longest of the east-west U.S. interstate highways with its 3,112 miles stretching from Boston, MA at I-93 on the eastern end to Seattle WA at the Kingdome on the western end. It travels across 13 northern states; the number of..

  A sample of n 4 scores has a mean of m 12 a second sample

a sample of n 4 scores has a mean of m 12. a second sample of n 6 scores has a mean of m 8. if the two samples are

  Probability that sample of steady smokers spend in a range

Assume a steady smoker spends on average $20 with a standard deviation of $5 per week on cigarettes. What is the probability that a sample of 100 steady smokers spend between $19.50 and $21?

  Probability that hour total of n service request will arrive

With a mean of 1/μ1 minutes for major language request and a mean of 1/μ2 minutes for minor language request. what is the probability that in the next hour a total of n service requests will arrive?

  Find the probability that all the people have blue eyes

What is the probability that they all have blue eyes? Would it be unusual to randomly select four people and find that they all have blue eyes? Why or why not?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd