Question: **Please note this is 1 question with 4 parts to get one total answer 0 The owner of a small mill-working plant that builds cabinets


**Please note this is 1 question with 4 parts to get one total answer
0 The owner of a small mill-working plant that builds cabinets is developing his aggregate plan for the next year. The relevant cost data and forecast for the next 4 quarters is provided below. The company currently has 20 employees and works one 8 hour shift each day with 2 paid 15 minute breaks. Assume each quarter has 65 working days, and that it currently has no units in stock. Use this information and the information from the table to answer the questions below. Costs Forecast Other Data Holding Cost/Unit/Quarter $218.50 Qtr 1 1600 Labor Hours/Unit 12 Hiring Cost $2,500.00 Qtr 2 1300 Beginning Inventory Layoff Cost $3,000.00 Qtr 3 2200 Work days per Quarter 65 Subcontract Cost $400.00 Qtr 4 1750 Avg. Labor Cost/Hour $21.50 Overtime Labor Cost/Hour $32.25 Part 1 Q1) If the company used a chase demand startegy and rounded any fractional number of employees to the nearest whole number, how many employees would be used in each quarter? (round final answer to nearest whole number) Qtr 1 Qtr 2 Qtr 3 Qtr 4 Forecast 1600 1300 2200 1750 Hours Req. Workers Req. Workers Used Q2) If the company used a level capacity strategy and rounded any fractional number of employees to the nearest whole number, how many employees would be used? Period 1 2 3 4 Forecast 1600 1300 2200 1750 Hours Req. Workers Req. Workers Used Assume the company decided to go with a level plan using 40 employees. They also have decided to use overtime to cover any periods where production and on-hand inventory do not cover demand. Q3) What would the overtime cost be for this plan? Q4) What would the total cot be for this plan? Level Capacity Aggregate Plan Period 3 4 Forecast 1600 1300 2200 1750 1 1 1600 40 2 1300 40 3 2200 40 4 1750 40 Period Forecast Workers Used Hire (Fire) Production Production - Forecast Inventory: B.I. E.1. Average Overtime Production Overtime Hours Total Cost Hiring Cost Firing Cost Reg. Output O.T. Subcontract Inventory Backorder Total Cost: Total Cost For PlanStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
