Business Analytics 3 questions due within 8 hrs sharply
Needhelp9438495
GeneralApplianceCorporation.xlsxTransportation Model
| General Appliance Corporation | |||||
| Data | |||||
| Distribution Center | |||||
| Plant | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $12.60 | $14.35 | $11.52 | $17.58 | 1200 |
| Minneapolis | $9.75 | $16.26 | $8.11 | $17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 | |
| Model | |||||
| Distribution Center | |||||
| Plant | Cleveland | Baltimore | Chicago | Phoenix | Total shipped |
| Marietta | 0 | 350 | 0 | 850 | 1200 |
| Minneapolis | 150 | 0 | 500 | 150 | 800 |
| Demand met | 150 | 350 | 500 | 1000 | |
| Cost | |||||
| Total | $28,171.00 |
Answer Report 1
| Objective Cell (Min) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $B$18 | Total Cost | $0.00 | $28,171.00 | |||
| Variable Cells | ||||||
| Cell | Name | Original Value | Final Value | Integer | ||
| $B$13 | Marietta Cleveland | 0 | 0 | Contin | ||
| $C$13 | Marietta Baltimore | 0 | 350 | Contin | ||
| $D$13 | Marietta Chicago | 0 | 0 | Contin | ||
| $E$13 | Marietta Phoenix | 0 | 850 | Contin | ||
| $B$14 | Minneapolis Cleveland | 0 | 150 | Contin | ||
| $C$14 | Minneapolis Baltimore | 0 | 0 | Contin | ||
| $D$14 | Minneapolis Chicago | 0 | 500 | Contin | ||
| $E$14 | Minneapolis Phoenix | 0 | 150 | Contin | ||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $B$15 | Demand met Cleveland | 150 | $B$15=$B$8 | Binding | 0 | |
| $C$15 | Demand met Baltimore | 350 | $C$15=$C$8 | Binding | 0 | |
| $D$15 | Demand met Chicago | 500 | $D$15=$D$8 | Binding | 0 | |
| $E$15 | Demand met Phoenix | 1000 | $E$15=$E$8 | Binding | 0 | |
| $F$13 | Marietta Total shipped | 1200 | $F$13<=$F$6 | Binding | 0 | |
| $F$14 | Minneapolis Total shipped | 800 | $F$14<=$F$7 | Binding | 0 |
Sensitivity Report 1
| Variable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$13 | Marietta Cleveland | 0 | 3.19 | 12.6 | 1E+30 | 3.19 | |
| $C$13 | Marietta Baltimore | 350 | 0 | 14.35 | 1.57 | 1E+30 | |
| $D$13 | Marietta Chicago | 0 | 3.75 | 11.52 | 1E+30 | 3.75 | |
| $E$13 | Marietta Phoenix | 850 | 0 | 17.58 | 0.34 | 1.57 | |
| $B$14 | Minneapolis Cleveland | 150 | 0 | 9.75 | 3.19 | 1E+30 | |
| $C$14 | Minneapolis Baltimore | 0 | 1.57 | 16.26 | 1E+30 | 1.57 | |
| $D$14 | Minneapolis Chicago | 500 | 0 | 8.11 | 3.75 | 1E+30 | |
| $E$14 | Minneapolis Phoenix | 150 | 0 | 17.92 | 1.57 | 0.34 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $B$15 | Demand met Cleveland | 150 | 9.75 | 150 | 0 | 150 | |
| $C$15 | Demand met Baltimore | 350 | 14.69 | 350 | 0 | 150 | |
| $D$15 | Demand met Chicago | 500 | 8.11 | 500 | 0 | 500 | |
| $E$15 | Demand met Phoenix | 1000 | 17.92 | 1000 | 0 | 150 | |
| $F$13 | Marietta Total shipped | 1200 | -0.34 | 1200 | 150 | 0 | |
| $F$14 | Minneapolis Total shipped | 800 | 0 | 800 | 1E+30 | 0 |
