please provide excel formulas

Question 1: The table below gives the demand forecast for the next four months. The beginning inventory is 10 units. Complete the table below by developing a level production plan with zero ending inventory at the end of the four-month planning horizon. Calculate the total inventory and backorder cost of the plan if inventory carrying costs are $5 per unit per month (based on ending inventory) and backorder costs are $8 per unit per month (based on ending inventory). [10 points] Period 1 2 3 4 Forecasted demand 120 160 20 70 Planned production Ending inventory Question 2: The production manager at the Boston Paint Company is preparing production and inventory plans for next year. The production manager has received the following quarterly sales forecasts: 3,000 units in Quarter 1; 1,800 in Quarter 2; 2,400 in Quarter 3; and 3,500 in Quarter 4. Based on this and the following information, prepare an optimal (lowest-cost) production plan for the next year for the manager. [30 points) . Current inventory level is 300 units. Current employment level is 600 people. Regular production capacity per employee is 4 units per quarter. Inventory carrying cost is $20 per unit per quarter (based on ending inventory). Hiring and layoff costs are equal at $200 per employee. Regular time production cost per unit is $320. Overtime production cost per unit is $380. Desired closing inventory level is a minimum of 100 units