Question: Explain the following exercise: exercise. L M N o P Q Constraints Workforce Capacity Inventory Overtime 0 0 0 0 0 0 0 0 0

Explain the following exercise: Explain the following exercise: exercise.\\\\ L M exercise.\\\\

L M N o P Q Constraints Workforce Capacity Inventory Overtime 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 509 0 0 0 0 0 0 0 0 0 0 100 100 100 100 100 100 100 100 100 100 100 100 0 0 0 0 0 0 A B D E F G H 1 J K Increase Decimal Variables Lt Wt 2 Ot It St Ct Pt 3 Period # Hired #Laid off #Workforce Overtime Inventory Stockout Subcontract Production Demand Price 4 0 0 0 80 0 1,500 0 0 5 1 47 0 127 1,156 304 0 0 5,369 6,565 100 6 2 0 127) 0 0 426 0 5,080 5,810 100 7 3 0 0 127 0 0 898 0 5,080 5,552 100 8 4 0 127 01 0 1,650 0 5,080 5,832 100 9 5 0 0 127 0 0 1,750 0 5,080 5,180 100 10 6 ol 127 0 0 1,521 0 5,080 4,851 100 11 7 0 0 127 0 0 910 0 5,080 4,469 100 12 8 0 0 127 0 0 0 0 5,080 4,170 100 13 9 0 0 127 0 472 O 0 4,571 4,099 100 14 10 0 0 127 0 01 0 0 5,080 5,552 100 15 11 165 0 292 60 5,780 0 0 11,695 5,915 100 16 12 0 292 ol 0 5001 0 0 0 5,280 100 17 94 658 550 0 18 19 Aggregate Plan Costs 20 21 Period Hiring Lay off Regular time Overtime Inventory Stockout Subcontract Material 22 14,100 0 304,800 34,680) 608 0 53,690 23 2 0 0 304,800 0 0 2,130 0 50,800 24 3 0 0 304,800 0 4,490 0 50,800 25 4 0 0 304,800 0 0 8,250 0 50,800 26 5 0 0 304,800 0 0 0 50.800 27 6 0 0 304,800 0 0 7,605 0 50.800 28 7. 0 0 304,800 01 0 4,550 0 50,800 29 8 0 0 304,800 0 0 0 0 50.800 30 9 0 0 304,800 0 944 0 0 45,710 31 101 0 0 304,800 0 01 0 0 50,800 32 11 49,500 700,800 0 11,5601 0 0 116,950 33 12 0 146,0001 0 1,000 0 0 34 35 36 37 Total Cost = $ 2,217,103 38 39 Total Revenue = $ 3,379,000 Promote? (0/1) Base Price $ 100 40 Profit = $ 1,161,897 Month (114) Consumption 41 Forward Buy 0.20 42 43 8,750 0.10

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!