Q21

Bart Incorporated manufactures auto parts. The demand forecast for one of its key products during the next 8 months is provided in the table below. An employee can produce an average of 10 units a month during regular time and overtime. The company does not use under- time or vacation time as options. But, the company relies on hiring, layoffs, anticipation inventory, and overtime as potential supply options. Based on a detailed analysis, the company has determined the inputs (work force level and overtime, in terms of number of employees) as indicated in the following table. Each employee on the payroll costs $2000 in regular-time wages per month. Overtime wages are 50% more than regular-time wages. The company can hire and train a new employee for $2000 and lay off one for $1000. Inventory costs $50 per unit on hand at the end of each month. At the beginning of the planning horizon, Bart Incorporated has 80 employees and anticipation inventory of O. Inventory must be entered as number of units. Utilized time, hires, and layoffs must be entered in terms of number of employees. Please refer to the following aggregate planning table. Based on the inputs provided, fill the derived and calculated parts of the aggregate plan (do not touch the "Inputs" section). 3 8 Total 800 750 1000 700 1200 800 1250 1000 80 85 85 95 95 95 95 10 20 Period Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertime cost Overtime cost Inventory cost Hiring cost Layoff cost Q20 021 Q22 Q23 Q24 Q25 Total Cost O 5 O 10 O 15 0 20 O None of the above