Need help with these exercises please, Constant Production, JIT Production and MPS.

D ill the necessary cells according to the class exercises and examples |MONTH DEC Monthly Production/Worker Beginning Inventory Work Force Level Straight Production Overtime Production Subcontract Production Monthly Production Sales Forecast Ending Inventory Cost Components Hired Workers Fired Workers Hiring/Firing Cost 7 Regular Production Cost Overtime Cost Subcontract Cost Stock Out Cost Inv. Holding Cost Total Cost Constant Production Exercise 8 9 0 1 22 23 24 25 26 27 28 29 30 31 JAN 65 8500 10000 FEB JIT Production Exercise MPS Exercise G 11000 H MAR 10000 APR 8000 MAY 6000 JUN K 6500 L TOTAL 51500 M Limit of maximum overtime (%) Initial # of workers (People) Initial Inventory (pounds) Regular Production Time (Hours/Month) Regular Production Rate (Pound/Month/Labor) Overtime Production Rate (of regular time) Cost of regular time production ($/hour) Cost of overtime production ($/hour) Cost of carry inventory ($/lb/month) Cost of Stock Out ($/lb/month) Cost of hiring new people ($/person) Cost of laying off people ($/person) Ending Inventory O 20 65 8500 160 90 0.2 5 7.5 0.25 0 150 300 6000 P 1.5 5:01 PM 0 D E cessary cells according to the class exercises and examples MONTH DEC Beginning Inventory Work Force Level Straight Production Overtime Production Subcontract Production Monthly Production Sales Forecast 11000 Ending Inventory Cost Components Hired Workers Fired Workers Hiring/Firing Cost Regular Production Cost Overtime Cost Subcontract Cost Stock Out Cost Inv. Holding Cost Total Cost Constant Production Exercise JIT Production Exercise MPS Exercise JAN 65 8500 F 10000 FEB G H MAR 10000 APR 8000 J MAY 6000 JUN K L TOTAL 6500 51500 M N Limit of maximum overtime (%) Initial # of workers (People) Initial Inventory (pounds) Regular Production Time (Hours/Month) Regular Production Rate (Pound/Month/Labor) Overtime Production Rate (of regular time) Cost of regular time production ($/hour) Cost of overtime production ($/hour) Cost of carry inventory ($/lb/month) Cost of Stock Out ($/lb/month) Cost of hiring new people ($/person) Cost of laying off people ($/person) Ending Inventory O 20 65 8500 160 90 0.2 5 7.5 0.25 0 150 300 6000 1.5 A Fill the yellow highlighted rows Period Forecast Customer Orders This is an extra row for the illustration Inventory Before Production 3 Projected Available Balance - 1(t) Available to Promise (ATP) MPS 50 On Hand Inventory. Planning Time Fence 10 100 Lot Size (Batch Size) - Qt Safety Stock (SS) 0 Constant Production Exercise JIT Production Exercise MPS Exercise EO 9 10 71 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Ready D E 1 25 20 F 2 15 20 + G 3 40 29 H 4 50 21 5 40 17 2008 V 40 14 7 30 50 8 40 11 M 9 40 5 N 10 50 2 O 11 40 10 12 40 12 O O R D ill the necessary cells according to the class exercises and examples |MONTH DEC Monthly Production/Worker Beginning Inventory Work Force Level Straight Production Overtime Production Subcontract Production Monthly Production Sales Forecast Ending Inventory Cost Components Hired Workers Fired Workers Hiring/Firing Cost 7 Regular Production Cost Overtime Cost Subcontract Cost Stock Out Cost Inv. Holding Cost Total Cost Constant Production Exercise 8 9 0 1 22 23 24 25 26 27 28 29 30 31 JAN 65 8500 10000 FEB JIT Production Exercise MPS Exercise G 11000 H MAR 10000 APR 8000 MAY 6000 JUN K 6500 L TOTAL 51500 M Limit of maximum overtime (%) Initial # of workers (People) Initial Inventory (pounds) Regular Production Time (Hours/Month) Regular Production Rate (Pound/Month/Labor) Overtime Production Rate (of regular time) Cost of regular time production ($/hour) Cost of overtime production ($/hour) Cost of carry inventory ($/lb/month) Cost of Stock Out ($/lb/month) Cost of hiring new people ($/person) Cost of laying off people ($/person) Ending Inventory O 20 65 8500 160 90 0.2 5 7.5 0.25 0 150 300 6000 P 1.5 5:01 PM 0 D E cessary cells according to the class exercises and examples MONTH DEC Beginning Inventory Work Force Level Straight Production Overtime Production Subcontract Production Monthly Production Sales Forecast 11000 Ending Inventory Cost Components Hired Workers Fired Workers Hiring/Firing Cost Regular Production Cost Overtime Cost Subcontract Cost Stock Out Cost Inv. Holding Cost Total Cost Constant Production Exercise JIT Production Exercise MPS Exercise JAN 65 8500 F 10000 FEB G H MAR 10000 APR 8000 J MAY 6000 JUN K L TOTAL 6500 51500 M N Limit of maximum overtime (%) Initial # of workers (People) Initial Inventory (pounds) Regular Production Time (Hours/Month) Regular Production Rate (Pound/Month/Labor) Overtime Production Rate (of regular time) Cost of regular time production ($/hour) Cost of overtime production ($/hour) Cost of carry inventory ($/lb/month) Cost of Stock Out ($/lb/month) Cost of hiring new people ($/person) Cost of laying off people ($/person) Ending Inventory O 20 65 8500 160 90 0.2 5 7.5 0.25 0 150 300 6000 1.5 A Fill the yellow highlighted rows Period Forecast Customer Orders This is an extra row for the illustration Inventory Before Production 3 Projected Available Balance - 1(t) Available to Promise (ATP) MPS 50 On Hand Inventory. Planning Time Fence 10 100 Lot Size (Batch Size) - Qt Safety Stock (SS) 0 Constant Production Exercise JIT Production Exercise MPS Exercise EO 9 10 71 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Ready D E 1 25 20 F 2 15 20 + G 3 40 29 H 4 50 21 5 40 17 2008 V 40 14 7 30 50 8 40 11 M 9 40 5 N 10 50 2 O 11 40 10 12 40 12 O O R