Objective Cell $($Max$)$

Cell Name Original Value Final Value

$B$$1$ Profit $0960000$

Variable Cells

Cell Name Original Value Final Value Integer

$B$$4$ Amount EZ $0250$ Contin

$C$$4$ Amount S $0200$ Contin

Constraints

Cell Name Cell Value Formula Status Slack

$E$$7$ Mfg Time $2100$ $E$$7<=$$D$$7$ Binding $0$

$E$$8$ Frames $200$ $E$$8<=$$D$$8$ Not Binding $80$

$E$$9$ FA and Test $1000$ $E$$9<=$$D$$9$ Binding $0$

Variable Cells

Final Reduced Objective Allowable Allowable

Cell Name Value Cost Coefficient Increase Decrease

$B$$4$ Amount EZ $250024001200960$

$C$$4$ Amount S $200018001200600$

Constraints

Final Shadow Constraint Allowable Allowable

Cell Name Value Price R$.$H$.$ Side Increase Decrease

$E$$7$ Mfg Time $2100266\mathrm{.}66666672100900360$

$E$$8$ Frames $20002801$E$+3080$

$E$$9$ FA and Test $10004001000120300$

Answer the following questions for Embassy. You can use the Excel Sensitivity Report to

answer the questions. The step$-$by$-$step handout has detailed instructions how to complete this

work sheet.

$1.$ How many EZ$-$Riders should be produced?

$2.$ How many Sports should be produced?

$3.$ How many Sports are left not produced?

$4.$ How much Manufacturing time is left unused?

$5.$ What is the total profit?

$6.$ By how much can the profit on EZ$-$Riders increase before the solution would

change?

$7.$ To what value can the profit on Sports increase before the solution would change?

$8.$ By how much can Assembly time increase before there is a change in the dual

$($shadow$)$ price?

$9.$ You are given some additional time for Manufacturing time that will increase the

demand constraint from $2100$ to $2400$ for a total cost of $$50,000.$ Would you say yes

or no$?$ Explain.

$10.$ If Manufacturing time decreases by $100$ and Assembly increases by $50,$ should the

solution be rerun? Explain.

$11.$ If Manufacturing increases by $750$ and Assembly decreases by $150,$ should the

solution be rerun? Explain.