Question

Sensitivity Analysis Question The manager of a small breakfast shop is determining how many sausage biscuits and ham biscuits to prepare each morning for customers. Each type of biscuit requires a certain amount of labor time, sausage, ham, and flour. Below is the linear program that defines his problem where x1-# of sausage biscuits to make and x2:# of ham biscuits to make Max Profit-6x1+5x2 Constraints 0.01x1+0.024x2 6 (Labor in terms of hours) 0.1x1< 30 (Pounds of sausage available) 0.15x2< 30 (Pounds of ham available) 0.04x1+0.04x2< 16 (Pounds of flour available) Below is the sensitivity report for this problem. Use this to answer the questions on the next page Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book1]Sheeti Report Created: 9/16/2014 11:57:09 PM $2,190 Total Revenue Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell SBSI x1-# sausage biscuits to make SBS2 x2-# ham biscuits to make 300 100 1E+30 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$6 Labor hours SB$7 Lbs SB$8 Lbs Ham SB$9 Lbs Flour 6 30 30 16 0.6 10 4.285714286 20 1E+30 30 10 16 10 1E+30 125

Answer 1

10 ans AAS