The sensitivity report for this model is provided in the Answers sheet. Use it to answer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The sensitivity report for this model is provided in the Answers sheet. Use it to answer the following sensitivity questions. 5.1 How much the unit profit of the large size product produced in plant 1 can decrease, before the current production changes? a. Any drop in the unit profit will change the optimal production plan b. From the sensitivity report the change is 588.23. c. Two coefficients are changing. (i) Plant 1= 1200.; (ii) Large product = 900 Therefore we cannot answer. 5.2 How much should the company be willing to pay for 100 sq-ft of additional storage in each plant, when each addition is considered individually? a. The company should not pay any amount in plant 1, not pay any amount in plant 2, and 289.2157 dollars in plant 3. b. The company should pay any amount charged in plant 1, pay any amount charged in plant 2, and 289.2157 ollars in plant 3. c. The company should only pay 5000/100*289.2157 in plant 3. d. None of the above. 5.3 Management now believes that the sales estimate of the medium size product were too optimistic (too high) by 10%. Management wants to know what is your maximum new profit if you correct the overestimation of the sales mentioned. Do you need to rerun your model with the new sales estimates to answer this question? Answer Yes or No in the Answers sheet. Variable Cells Constraints Cell Final Name Value Large Plant 346.0784 Large Plant $T$25 $U$25 $V$25 Large Plant $T$26 $U$26 $V$26 $T$27 $U$27 $V$27 Cell $T$28 $U$28 $V$28 $T$32 $U$32 $T$37 $U$37 $V$37 $W$25 Medium Pl: 242.1569 Medium Pl: 441.1765 Medium Pl 416.6667 Small Plant Small Plant Small Plant 0 0 Final Value $W$26 Medium Pr $W$27 $W$25 $W$26 Medium Pr $W$27 Small Prod 0 0 0 Name Production 588.2353 Production 441.1765 Production 416.6667 Equal % Pla 0.490196 Equal % Pla 0.490196 Space Occu 11764.71 Space Occu 6617.647 Space Occu 5000 Large Prod 346.0784 1100 0 Small Prod Large Prod 346.0784 1100 0 Reduced Cost Shadow Price oooo 0 0 0 -300 -300 -300 OOO woooa 1200000 2100000 289.2156863 0 100 0 0 0 0 Objective Coefficient 1000 1000 1000 1100 1100 1100 700 700 700 Constraint R.H. Side 1200 900 850 0 0 13000 12000 5000 1000 1100 700 900 1200 750 Allowable Increase Allowable Increase 100 0 0 0 1E+30 1E+30 300 300 300 Allowable Decrease 0 1E+30 1E+30 100 0 0 1E+30 1E+30 1E+30 Allowable Decrease 1E+30 611.7647 1E+30 458.8235 1E+30 433.3333 0.051470588 0.288399 0.051470588 0.164799 1E+30 1235.294 1E+30 5382.353 525 1196.61 1E+30 653.9216 100 242.1569 700 1E+30 1E+30 553.9216 1E+30 1E+30 100 750 The sensitivity report for this model is provided in the Answers sheet. Use it to answer the following sensitivity questions. 5.1 How much the unit profit of the large size product produced in plant 1 can decrease, before the current production changes? a. Any drop in the unit profit will change the optimal production plan b. From the sensitivity report the change is 588.23. c. Two coefficients are changing. (i) Plant 1= 1200.; (ii) Large product = 900 Therefore we cannot answer. 5.2 How much should the company be willing to pay for 100 sq-ft of additional storage in each plant, when each addition is considered individually? a. The company should not pay any amount in plant 1, not pay any amount in plant 2, and 289.2157 dollars in plant 3. b. The company should pay any amount charged in plant 1, pay any amount charged in plant 2, and 289.2157 ollars in plant 3. c. The company should only pay 5000/100*289.2157 in plant 3. d. None of the above. 5.3 Management now believes that the sales estimate of the medium size product were too optimistic (too high) by 10%. Management wants to know what is your maximum new profit if you correct the overestimation of the sales mentioned. Do you need to rerun your model with the new sales estimates to answer this question? Answer Yes or No in the Answers sheet. Variable Cells Constraints Cell Final Name Value Large Plant 346.0784 Large Plant $T$25 $U$25 $V$25 Large Plant $T$26 $U$26 $V$26 $T$27 $U$27 $V$27 Cell $T$28 $U$28 $V$28 $T$32 $U$32 $T$37 $U$37 $V$37 $W$25 Medium Pl: 242.1569 Medium Pl: 441.1765 Medium Pl 416.6667 Small Plant Small Plant Small Plant 0 0 Final Value $W$26 Medium Pr $W$27 $W$25 $W$26 Medium Pr $W$27 Small Prod 0 0 0 Name Production 588.2353 Production 441.1765 Production 416.6667 Equal % Pla 0.490196 Equal % Pla 0.490196 Space Occu 11764.71 Space Occu 6617.647 Space Occu 5000 Large Prod 346.0784 1100 0 Small Prod Large Prod 346.0784 1100 0 Reduced Cost Shadow Price oooo 0 0 0 -300 -300 -300 OOO woooa 1200000 2100000 289.2156863 0 100 0 0 0 0 Objective Coefficient 1000 1000 1000 1100 1100 1100 700 700 700 Constraint R.H. Side 1200 900 850 0 0 13000 12000 5000 1000 1100 700 900 1200 750 Allowable Increase Allowable Increase 100 0 0 0 1E+30 1E+30 300 300 300 Allowable Decrease 0 1E+30 1E+30 100 0 0 1E+30 1E+30 1E+30 Allowable Decrease 1E+30 611.7647 1E+30 458.8235 1E+30 433.3333 0.051470588 0.288399 0.051470588 0.164799 1E+30 1235.294 1E+30 5382.353 525 1196.61 1E+30 653.9216 100 242.1569 700 1E+30 1E+30 553.9216 1E+30 1E+30 100 750
Expert Answer:
Related Book For
Managerial Decision Modeling with Spreadsheets
ISBN: 978-0136115830
3rd edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Posted Date:
Students also viewed these accounting questions
-
Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.
-
When would a company be willing to pay more than the face amount (a premium) for a held-to-maturity security?
-
Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others. (a) Interpret the shadow prices for the...
-
A certain radioactive isotope is a by - product of some nuclear reactors. Due to an explosion, a nuclear reactor experiences a massive leak of this radioactive isotope. Fortunately, the isotope has a...
-
Grinders company issued the following statement of cash flows for 2011. (a) Compute free cash flow for Grinders Company. (b) Explain why free cash flow often provides better information than Net cash...
-
Express the strains x , y , and xy for the element of Figure 8-3 by using the results given in Section 8.2. Evaluate these strains at the centroid of the element; then evaluate the stresses at the...
-
The numbers of false fire alarms were counted each month at a number of sites. The results are given in the following table. Test the hypothesis that false alarms are equally likely to occur in any...
-
Flow of gas through a packed column, a horizontal tube with diameter 4 in. and length 5.5 ft is packed with glass spheres of diameter 1/16 in., and the void fraction is 0.41. Carbon dioxide is to be...
-
Question Analyse and comparsion Amazon and Alibaba financial ratios 1. You have to analyze what the ratios tell us for example, > 1 means....; <1 means...; this would be good if.... 2. You have to...
-
On the geologic map in Fig. G-1 (Appendix G) draw the correct strike and dip symbol in each circle to indicate the attitude of Formation B and each dike. To verify your attitude symbols, Fig. G-2 can...
-
Prove Cauchy's Integral Theorem for k-connected Jordan domains: Let be a k-connected Jordan domain and f(z) be analytic in some domain containing . Then, Sof(z)dz = 0. Hint: Use the Deformation...
-
Colleges and universities that engage in both governmental and business-type activities are required to report which of the following external financial statements? a. The same financial reporting...
-
In Exercises, for all values of x = a where the function is discontinuous, determine if the discontinuity is removable or nonremovable. Exercise 9 In Exercises, find all values x = a where the...
-
Change the filter specifications in Experiment 5.2, designing the filter accordingly, using the firpm command. Analyze the resulting magnitude response and the output signal to the input...
-
How are guard conditions shown on a behavioral state machine?
-
14.27 Let \(\zeta\) denote a generic measure of association. For \(K\) independent multinomial samples of sizes \(\left\{n_{k} ight\}\), suppose that \(\sqrt{n_{k}}\left(\hat{\zeta}_{k}-\zeta_{k}...
-
9. An aluminum rod with resistivity, p, is shaped into a circular loop such that the rod diameter, d, is much smaller than the radius of the loop, a. The loop is placed in the presence of an...
-
Explain five different cases of income exempt from tax with clear examples.
-
What is an unbounded solution? How does Solver indicate that a problem solution is unbounded?
-
Define decision modeling. What are some of the organizations that support the use of the scientific approach?
-
I-Go Airlines has operations in eight cities throughout the United States. It is searching for the best location(s) to designate as a hub, which would then serve other cities within a 1,400-mile...
-
A scientist wants to determine whether people who live in places with high levels of air pollution get more colds than people in areas with little air pollution. Do you think it is possible to design...
-
Draw a simple random sample of eight animals from the list of 40 animals in the table. Exercises 2124 refer to the population of animals in the following table. The population is divided into four...
-
In the 1936 presidential election, Republican candidate Alf Landon challenged President Franklin Roosevelt. The Literary Digest magazine conducted a poll in which they mailed questionnaires to more...
Study smarter with the SolutionInn App