- L71 A B D 1 M 3 4 5 Problem 2 A Manufacturer Has Three Plants With Access Production Capacity It Can Use This Capacity 1 (24.01 KiB) Viewed 25 times
- L71 A B D 1 M 3 4 5 Problem 2 A Manufacturer Has Three Plants With Access Production Capacity It Can Use This Capacity 2 (34.36 KiB) Viewed 25 times
- L71 A B D 1 M 3 4 5 Problem 2 A Manufacturer Has Three Plants With Access Production Capacity It Can Use This Capacity 3 (27.96 KiB) Viewed 25 times
- L71 A B D 1 M 3 4 5 Problem 2 A Manufacturer Has Three Plants With Access Production Capacity It Can Use This Capacity 4 (33.8 KiB) Viewed 25 times
- L71 A B D 1 M 3 4 5 Problem 2 A Manufacturer Has Three Plants With Access Production Capacity It Can Use This Capacity 5 (25.27 KiB) Viewed 25 times
M N 55 56 57 58 59 60 61 62 63 64 65 66 8 & 93819 5. The sensitivity report for this model is provided in the Answers sheet. Use it to answer the following sensitivity questions. 5.1 How much the unit profit of the large size product produced in plant 1 can decrease, before the current production changes? a. Any drop in the unit profit will change the optimal production plan b. From the sensitivity report the change is 588.23. c. Two coefficients are changing (1) Plant 1= 1200.: () Large product 900 Therefore we cannot answer. 5.2 How much should the company be willing to pay for 100 sq-ft of additional storage in each plant, when each addition is considered individually? Remember: The objective is profit maximization a. The company should not pay any amount in plant 1, not pay any amount in plant 2, and 289.2157 dollars in plant 3. b. The company should pay any amount charged in plant 1, pay any amount charged in plant 2, and 289.2157 ollars in plant 3 c. The company should only pay 5000/100*289.2157 in plant 3. d. None of the above. 67 69 70 71 72 73 74
N 0 Variable Cels Cell $1525 SU$25 SV525 ST$20 $U$26 SV526 $T$22 SU527 SVS27 Name La Plant Large Planta Plants Medium Plant Medium Plan 2 Medium Planta Small Punti Stant Smail Planta Final VW 3:46.0734 0 0 242.1560 41.1765 416.6667 blood Reduced Objective Cost Coefficient 0 1000 0 1000 1000 1100 1100 1100 300 700 -300 700 - 300 700 Allowable Allowable Increase Decrease 100 0 15.30 0 1+30 100 103 16:30 O 300 1E430 300 16.30 100 1E30 Constraints Cell ST$28 SUS20 $1528 Final Name Value Production in Plant 563 253 Production in Punta 4411265 Production in Plan 416 6067 Equal a 12 0.400196 Equal Pant23 0.490196 Space Occupied Pant: 11764.73 Space Occupied Pant2 0617:54 Shadow Constraint Price R. Side . 1200 0 900 BS0 1200000 2100000 0 13000 0 12000 w Allowable Allowable Increase Decrease LE30 6117547 1430 45.235 1430323123 0.051470588 0.28399 0.0514705880-164709 1E301215 TE0512) SUS 51537 SUSS no
$V$27 San Frantz Small Plant 3 OO -300 -300 700 700 0 300 300 1E+30 1E30 10 Constraints OOO Cell ST$28 $U$28 $V$28 $T$32 $U$32 ST$37 $U$37 SV$37 $WS25 SW526 SW$27 SW$25 SW$26 SW$27 Final Name Value Production in Plant 1 588.2353 Production in Plant2 441.1765 Production in Plant3 416.6667 Equal Plant 1,2 0.490196 Equal % Plant 2,3 0.490196 Space Occupied Planti 11764.71 Space Occupied Plantz 6617.647 Space Occupied Plant3 5000 Large Production 346.0784 Medium Production 1100 Small Production 0 Large Product sales 346.0784 Medium Product sales 1100 Small Product sales 0 Shadow Constraint Price R.H. Side 1200 900 850 1200000 0 2100000 0 0 13000 0 12000 289.2156863 5000 0 1000 100 1100 0 700 0 900 0 1200 0 750 Allowable Allowable Increase Decrease 1E+30 611.7647 1E+30 458.8235 1E+30 433.3333 0.051470588 0.288399 0.051470588 0.164799 18-30 1235.294 1E+30 5382.353 525 1196.61 1E+30 653.9216 100 242.1569 15.30 700 1E+30 553.9216 15.30 100 15.30 750
tratto diting M N Variable Cells Cell $T$25 $U$25 $V$25 $T$26 $U$26 $V$26 $T$27 $U$27 $V$27 Name Large Plant 1 Large Plant2 Large Plant3 Medium Plant 1 Medium Plant2 Medium Plants Small Plant 1 Small Plant2 Small Plant Final Value 346.0784 0 0 242.1569 441.1765 416.6667 Reduced Objective Cost Coefficient 0 1000 0 1000 0 1000 0 1100 0 1100 0 1100 -300 700 -300 700 -300 700 Allowable Allowable Increase Decrease 100 0 0 1E30 0 15.30 0 100 1E+30 0 1E+30 0 300 1E+30 300 1E+30 300 1E+30 OOO