You are given the following data for your production facility. Your manager asks you to complete the chart below, filling in the missing data based on the decision to use a Level production strategy for meeting demand in the next 6 months. Assume 8 working hours per day. JAN FEB MAR APR MAY Demand Forecast 1,800 1,500 1,100 900 1,100 Working Days 22 19 21 21 22 JUN 1,600 20 Total 8,000 125 420 units Beginning Inventory Beginning Labor 40 workers Inventory Holding Shortage Hiring and training Layoff Labor time required Straight time cost (8 hrs) Overtime cost Outsourced cost $1.50/unit/month $8.00/unit/month $200.00/worker $250.00/worker 6 hours/unit $5.00/hour $6.00/hour $20.00/unit Calculate the following for January month only. (1) Beginning Inventory: _ (2) Working Days: (3) Production Hours: (4) Actual Units Produced: (5) Demand Forecast: _ (6) Ending Inventory: (7) Shortage Cost: (8) Inventory Holding Cost: (9) Straight Time Labor Cost: (8 - LSL USL-X) 1 ko ko s 2- USL=8. TC = (DxC) + 8 xs+ 2 x H LSL - X p= Total # Defective Total # of Observations lope = # 20$ VH (1 5) Pins) s n MP MP + ML OTTL - J(T +L)o V USL = +zo Q = d(T + L) + 2OT.L-1 LSL = 7 - zo R = (d x L) + (z xo/VD) F, = a*A-1 + (1-a)*F-1 Quantity = AD + (Z xo) SS= 2x Standard Normal Distribution Values 0.5 0.54 Z -4.5 -3.33 -0.279 -2.33 -2.05 Probability 0.00003 0.0005 0.39 0.01 0.02 0.05 0.09303 0.2941 0.30854 Probability 0.69146 0.7059 0.90697 0.95 0.98 0.99 0.610 0.9995 0.99997 1.32 1.64 2.05 2.33 0.2791 3.33 4.5 -1.64 -1.32 -0.54 -0.5