Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A regional chain of bakeries developed a Linear Programming model to identify the production plan that would optimize profits. The optimal production plan specifies
A regional chain of bakeries developed a Linear Programming model to identify the production plan that would optimize profits. The optimal production plan specifies what items to produce based on the estimated profit for each product and four key resources: butter, eggs, flour and labor. The model was recently solved using Excel, and the following report was generated. Adjustable Cells Final Reduced Cell Name Value $B$22 Units Produced Cake $C$22 Units Produced Custard Pie Cost 0 1.150000001 5.199999999 1.150000001 Objective Allowable Increase Coefficient Allowable Decrease 1E+30 40 0 6.35 1E+30 1.150000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$28 Butter Required 40 6.35 40 1.666666667 40 $B$29 Eggs Required 480 0 500 16+30 20 $B$30 Flour Required 40 0 50 1E+30 10 $B$31 Labor Hours Required 30 0 40 1E+30 10 Based on the model results, what effect would increasing the supply of flour have on the optimal profit?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started