please answer on excel

MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost = SR 17 per unit per month Average pay rate - SR 10 per hour Labor-hours to produce a unit 4 hours per init Daily working hours - 8 hours a) Using excel, calculate the total cost of the following plan: - Plan: Is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. Answer in Field) Attach your solutions. Add your answer Jx Cost Information Inventory carrying cost - Subcontracting cost per unit Average pay rate per hour Average pay rate per day Overtime pay rate Labor-hours to produce a unit $ $ $ $ 3 per unit per month 20. per unit 10 per hour 80 per day 17 $17 per hour (above 8 hours per day) 4.0 4 hours per unit One employee daily production ?? units per emplyee 30 Monthly Forecasts MONTH EXPECTED PRODUCTION DAYS DEMAND Jan 800 21 Feb 500 18 Mar 600 18 Apr 1,050 22 May 1.150 19 June 1.100 20 5,200 118 Plan 2 (constant workforce by meeting the lowest demand per day month + Sub-contracting) e In House daily production = ?? unit per day - Total Units Produced in house ?? Units Subcotract Units units Number of Regular Employees ?? Regular Time Employee Total regular employees costs ?? Total Subcontracting Cost ?? Total Cost ?? 21