oooo T-Mobile LTE NAME: 1. The quarterly demand for a product(in units) is given below: Quarters: Demand: 8:09 PM texsu.blackboard.com Each unit of product requires 5 hours of labor. A worker works for 500 hours per quarter. Q1 Q2 1300 1400 Compute the number of workers required each quarter to meet demand? No. of Workers, Q1 = No. of Workers, Q2 = No. of Workers, Q3 = No. of workers, Q4= Demand Load Labor hrs Perform a rough-cut capacity planning analysis. Does the plant have the capacity to meet the total demand for the 4 quarters? Assume 7500 labor hours of capacity is available each quarter. Capacity Labor Hrs. Over/Under Q3 Q4 1600 1700 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total Note: Over/Under = Capacity - Load. What is your recommendation? 2% 2. In problem 1, assume the cost of carrying an item in inventory is $50 per unit per year. 2. In problem 1, assume the cost of carrying an item in inventory is $50 per unit per year. Quarters Aggregate Planned Beginning Ending Avg. Qtrly Demand Production Inventory Inventory Inventory Q1 Q2 a) If level production, based on average quarterly demand is planned, compute the annual inventory carrying costs. Assume initial inventory of the product is zero. Use the following table to perform your calculations. 03 Q4 Total = Total = Average Qtrly demand= Average Annual Inventory Annual Inventory carrying cost If the production capacity is limited to 1300 units per quarter and excess demand is met through subcontracting at $60 per unit in the above problem, find the annual subcontracting cost? Actual Demand Production Subcontracted Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total subcontracted= Annual cost=