PLEASE if it is possible to perform the calculations in EXCEL and put all the formulas that were used (clearly)

REFERENCE BOOK: Manufacturing Planning and Control for Supply Chain Management (2nd edition)

Class: Production Planning and Control

Thank you

Problem 1 (27.5 points). The Toda Cola Inc. company, specifically the HR department, needs to identified the quantity of employees required each month for the next sixth- month production period. Based on past experience, the company is estimating that demand over the next six months will be as follow: Month Forecast Demand July 1250 August 1100 September 950 October 900 November 1000 December 1150 Although the company estimated that they will end with 300 units, the inventory on hand at the end of June was 500 units. The company wants to maintain a minimum inventory of 300 units each month at a holding cost of $3 per unit, and would like to have 400 units on hand at the end of December Each unit requires five employees per hour to produce, there are 20 working days each month and each employee works eight hours per day. The work force at the end of June was 35 employees. On average, each employee is paid $2,080 per month. Based on the effort of interviewing and training new employees, Toda Cola Inc. estimates that it costs $600 for each employee hired. Firing pay amounts to $1,200 per employee. a. (15 points). Determine a minimum inventory production plan that allows arbitrary hiring and firing. Determine planned production, number of employees needed, hires or fires. b. (8 points). Evaluate the costs that will be incurred per period based on the information given from the company. c. (4.5 points). What is the aggregate total cost for the six- period production plan