Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Only Need D&E answered Only need D&E answered 8. Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario from Problems 6

Only Need D&E answered

image text in transcribed
Only need D&E answered 8. Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario from Problems 6 and 13 in Chapter 13 0. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you used in the Sensitivity Report. Figure 15.35 Solver Sensitivity Report for Burger Office Equipment Problem A B C D E F G H 6 Variable Cells Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$4 Number Produced Standard 40 0 250 1E+30 55.55555556 10 SC$4 Number Produced Deluxe 0 -100 350 100 1E+30 11 12 Constraints 13 Final Shadow Constraint Allowable Allowable 14 Cell Name Value Price R.H. Side Increase Decrease 15 $D$7 Pine Used 2800 0 5000 1E+30 2200 16 SD$8 Oak Used 0 0 750 1E+30 750 17 SD$9 Labor Used 400 25 400 314.2857143 400 soit be a The allowed to wor additional 50 hours at an overtime premitime of $18/hour d. If the unit profit for standard desks is increased to $280, how will the optimal solution and total profit be affected? e. If the unit profit of standard desks is only $190, how will the optimal solution and total profit be affected

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting A Focus on Ethical Decision Making

Authors: Steve Jackson, Roby Sawyers, Greg Jenkins

5th edition

978-0324663853

Students also viewed these General Management questions

Question

3.3

Answered: 1 week ago