Answer Happy

d. None of the above. 4. To prevent layoffs management wants the percent of the available capacity used for production be equal among all plants (for example, capacity in plant 1 is 1200 units. If this plant produces 500 units, it uses 500/1200 = 41.67% of its capacity. Then all the plants must use 41.67% of their capacity - that is, equal workload for all plants). Write the constraints needed to secure this requirement (in the Answer sheet). Plant1 Plant2 Capacity avail 1200 units 900 Storage avail 13000 sqft 12000 Required starage per unit 20 sq-ft 15 Plant3 850 5000 12 Large $1000 Medium 1100 Small 700 Profit/unit

Variable Cells Final Value 346.0784 Reduced Cost Allowable Increase Allowable Decrease 100 0 1E+30 0 0 0 ooooo Objective Coefficient 1000 0 1000 0 1000 0 1100 0 1100 0 1100 0 Cell $T$25 $U$25 $V$25 $T$26 $U$26 $V$26 $T$27 $U$27 $V$27 1E+30 100 Name Large Plant 1 Large Plant2 Large Plant3 Medium Plant 1 Medium Plant2 Medium Plant3 Small Plant 1 Small Plant2 Small Plant 3 0 242.1569 441.1765 416.6667 0 1 E+30 1 E+30 300 300 lol 0 0 -300 700 1E+30 1E+30 0 700 -300 -300 0 700 300 1E+30 Constraints Shadow Price Constraint R.H. Side 1200 0 Oo 0 900 850 0 0 1200000 2100000 Final Value 588.2353 441.1765 416.6667 0.490196 0.490196 11764.71 6617.647 5000 346.0784 1100 0 0 Cell $T$28 $U$28 $V$28 $T$32 $U$32 $T$37 $U$37 $V$37 $W$25 $W$26 $ $27 $ $25 $W$26 $W$27 13000 Name Production in Plant 1 Production in Plant2 Production in Plant3 Equal % Plant 1,2 Equal % Plant 2,3 Space Occupied Plant1 Space Occupied Plant2 Space Occupied Plant3 Large Production Medium Production Small Production Large Product sales Medium Product sales Small Product sales Allowable Allowable Increase Decrease 1E+30 611.7647 1E+30 458.8235 1 E+30 433.3333 0.051470588 0.288399 0.051470588 0.164799 1E+30 1235.294 1E+30 5382.353 525 1196.61 1E+30 653.9216 100 242.1569 1 E+30 700 1E+30 553.9216 1E+30 100 0 289.2156863 12000 5000 1000 0 100 1100 0 0 346.0784 0 700 900 1200 750 1100 0 oo 0 0 1E+30 750