Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the objective function and its optimal value ? What are the slack / surplus values for different constraints Vario Calculate the profit if
What is the objective function and its optimal value ? What are the slack / surplus values for different constraints Vario Calculate the profit if the coefficient of deluxe " changes to 250 $ $2 $ $2 Will the optimal solution remain the same if simultaneously the coefficient of " standard " changes to 180 coefficient deluxe " changes to 290 ? $B$ 2 $ $2 e. How much will it cost to buy an additional 600 units of labor amount considering it to be a " sunk cost?
Given results after developing the excel LP and Solver: Availability Deluxe Standard 5000 60 80 Fine 750 18 0 Oak 400 16 10 Labor $130 $178 Profit/unit Sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Coefficient Decrease Increase Cost Value Cal Name $$$21 Standard 0 -50 150 50 15.30 Deluxe $C$21 45 0 320 1E-30 80 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease s $E$25 Pine Amount Used 1500 0 5000 15:30 3500 SE$26 Oak Amount Used 450 0 750 15:30 300 ses27 Labor Amount Used 400 20 400 266.5666667 400 its ? 15 minutes on slideStep 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