Does anyone know how to do this? could you please show work/how in excel? thank you so much.

3.5 0 60 P301 - Problem 7 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 8 employees that work one 8 hour shift each day with 2 paid 15 minute breaks. Assume each quarter has 60 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 $18.50 Qtr 1 1300 Labor Hours/Unit Hiring Cost $2,000.00 Qtr 2 1650 Beginning Inventory Layoff Cost $2,250.00 Qtr 3 2100 Work days per Quarter Subcontract Cost $100.00 Qtr 4 1400 Avg. Labor Cost Hour $18.00 Overtime Labor Cost Hour $27.00 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 ? Qtr 1 Qtr 2 Qtr 3 Qtr 4 Forecast 1300 1650 2100 1400 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 1300 1650 2100 1400 Hours Req. Workers Req. Workers Used Q3) Assume the company decided to use 11 employees, They also plan to use subcontracting to cover any periods where production and on-hand inventory do not cover demand. What would the subcontracting cost be for this plan? (Round production to the nerest whole Q3) Assume the company decided to use 11 employees, They also plan to use subcontracting to cover any periods where production and on-hand inventory do not cover demand. What would the subcontracting cost be for this plan? (Round production to the nerest whole number) Level Capacity Aggregate Plan Period 2 3 4 Forecast 1300 1650 2100 1400 Workers Used Hire/(Fire) Production Production - Forecast Inventory: B.I. E.I. Average Units Subcontracted Total Hiring Cost Firing Cost Reg. Output O.T. Subcontract Costi Inventory Cost Backorder Total Cost: Total Cost For Plan