Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Managers Interpreting Accounting Information for Decision Making

Authors: Paul M. Collier

4th edition

978-111997967, 1119979676, 978-1119979678

More Books

Students also viewed these Accounting questions

Question

In what ways did Taylorism seek to degrade workers?

Answered: 1 week ago