Question: Below is the output for a linear program model in excel Answer Report: Objective CellMax Cell Name SE$10 Total Profit: Original Value Final Value 0

Below is the output for a linear program model in
Below is the output for a linear program model in excel Answer Report: Objective CellMax Cell Name SE$10 Total Profit: Original Value Final Value 0 4100 Variable Cells Cell Name $B$10 produced Tables $C$10 produced Chairs Original Value Final Value Integer 0 30 Contin 0 40 Contin Slack Constraints Cell Name $0$13 Carpentry LAS Total $D$14 Painting and varnish LHS Total $&$10 produced Tables $C$10 produced Chairs Cell Value Formula Status 240 $D$13$F$13 Binding 100 $D$14c=$F$14 Binding 30 $B$100 Not Binding 40 $C$100 Not Binding 0 0 30 40 Sensitivity Report: Variable Cells Cell Name $B$10 produced Tables SC$10 produced Chairs Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 30 20 30 3.333333333 0 50 2.5 15 Constraints Cell Name $0$13 Carpentry LKS Total $D$14 Painting and varnish LHS Total Final Shadow Constraint Allowable Allowable Value Price RH. Side Increase Decrease 240 15 240 60 40 100 5 100 20 20 How much would total profit increase if you were given an extra hour of carpentry hour (Hint: shadow price) It would decrease by 15 dollars It would not increase because carpentry is not binding It would increase by 15 dollars It would increase by 5 dollars

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!