Please answer problem 2C in Excel with step by step instructions including formulas. Thank you.

Problem 2 ( 75 points) Sunny Co., a manufacturing company, developed the aggregate plan shown in the table below. Cost of regular production is $5 per unit, the cost of producing the same unit on overtime is $7.50, the cost of subcontracting is $9 per unit, and the cost of carrying a unit in inventory from one month to the next is $2. The labor contract at the plant prohibits both overtime and subcontracting output to exceed 300 units (each) in any given period. The plant capacity is 600 units per month produced using two shifts, regardless of the number of days in a month. By policy, management wants to avoid stockouts. January February March April May Forecast 500 750 1200 650 300 Beginning Inventory 100 200 50 0 0 Regular Time 600 600 600 600 300 Overtime 0 0 250 50 0 Subcontracting 0 0 300 0 0 Ending Inventory 200 50 0 0 0 A) Calculate the following costs (20pts): 4.Cost of Regular Production 5. Overtime Production 6. Subcontracting 7. Ending Inventory charges B) The Planning Manager request that the plan should have at least 20 units left in inventory at the start of each month. Formulate a new plan that complies with this request. Calculate the following new costs (20 pts): 8. Cost of Regular Production 9. Overtime Production 10. Subcontracting 11. Ending Inventory charges C) Using Sunny Co's original scenario as the base, the Sales Manager would like to introduce a promotion in January. The promotion consists of discounting the price of the product by 5%. The sales team expects a 10% increase in January demand due to increases consumption. Also, 20% of each the two following months' demand is expected to move forward to January. If there NO changes in the number of units produced with regular time, overtime, and subcontracting from the base case calculate the following (20 pts): 12. Cost of Regular Production 13. Overtime Production 14. Subcontracting 15. Ending Inventory charges