Q2) -Expected Demand- 1300 ---Production Days -21 -1000- 18 Month- Jan- Feb Mar... Apr- May-- Jun- -1100- -18 -22 -1550-- - 1550- -1600- --19 -20 Cost Information: Inventory carrying cost - SR 8 per unit per month Average pay rate = SR 15 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) What is the average production per day? ( 1 Mark) ( Answer in field) b) Using excel, calculate the cost of the following plan : ( 2 Marks) - we assume that the production per day is average requirements (average production per day) and that we have a constant workforce, no overtime or idle time, no safety stock, and no subcontractors. The firm accumulates inventory during the slack period of demand, January through March, and depletes it during the higher-demand warm season, April through June. We assume beginning inventory = 0 and planned ending inventory = 0. Attach your solutions. Q2) -Expected Demand- 1300 ---Production Days -21 -1000- 18 Month- Jan- Feb Mar... Apr- May-- Jun- -1100- -18 -22 -1550-- - 1550- -1600- --19 -20 Cost Information: Inventory carrying cost - SR 8 per unit per month Average pay rate = SR 15 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) What is the average production per day? ( 1 Mark) ( Answer in field) b) Using excel, calculate the cost of the following plan : ( 2 Marks) - we assume that the production per day is average requirements (average production per day) and that we have a constant workforce, no overtime or idle time, no safety stock, and no subcontractors. The firm accumulates inventory during the slack period of demand, January through March, and depletes it during the higher-demand warm season, April through June. We assume beginning inventory = 0 and planned ending inventory = 0. Attach your solutions