APP Worksheet Below is a partially completed aggregate production plan for Yukun Holiday Ornaments Co. There are currently 4 employees. Assume each worker produces 100 units per month. The owner needs to build a feasible aggregate plan. Aggregated demand is 500 units in May, 540 units in June, 470 units in July, and 390 units in August. These numbers have been entered in the Forecast Sales row, in the table below. Worker production on regular time has also been added in the table below. Here are additional labor, inventory, and other production policies to assist in building an aggregate plan for Yukun. Cost per ornament produced on regular time = $80 each Cost per ornament produced on overtime = $120 each Cost per ornament if subcontracting is used: $150 each A maximum of 80 ornaments may be produced on overtime per month A maximum of 50 ornaments may be produced on subcontracting per month Inventory carrying cost: $50 per ornament in average inventory per month Backorders (stock outs) are not allowed. Beginning inventory: 0 units. Inventory can be built ahead of time to prevent stock outs, but only build when necessary to avoid a stockout, to minimize the high inventory carrying cost. The owner has chosen not to hire or lay off workers during this 4-month period. May Total June 540 July 470 August 390 500 1900 Period Forecast Sales Output Regular Overtime 400 400 400 400 1600 Subcontract 0 Output-Forecast Inventory Beginning Ending Average = (Beg + End)/2 Costs Regular time 0 0 0 0 0 Overtime Subcontract Hiring/Layoff Average Inventory Monthly total Total Cost for plan a. In which months will overtime be required? May only O June only May, June and July O June, July and August O All months will require overtime b. How many units of subcontracting will be required in May, to avoid a backorder situation in June? Enter the appropriate number between 0 and 50: units c. Ending Inventory in May is 20 O-50 -30 10 d. What is "Output minus Forecast" for June? 0-50 O 10 0-10 0 30 O-20 e. Compute the total for "Regular time" in the Costs section. Enter as a whole number without dollar sign, commas, or decimals: $ f. The "Total Cost" for this plan will be $168,600 O $165.100 O $168,350 O $165,950