I want proper answer. Please show me all the steps in excel.

5. A company is making footballs. It must decide how many footballs to produce each month. Monthly demands, which it decided to satisfy on time, are in Table 1. Month 1 2 3 4 5 Demand 80 40 30 60 90 Table 1: Monthly demand In each of the months, manufacturing of footballs occurs first and after it is done, the amount of on- hand after production, which also includes the ending inventory of the previous month, can be used to satisfy the current month demand. To make one football, three units of component are needed. The company can buy the components in the market and the price per unit of the component along the five months is given in Table Month 1 2 3 4 5 Component price/unit ($) 1.1 1.5 1.6 1.2 1.0 Table 2: Monthly component price The unit inventory cost of football per month is $0.2. The components can be bought in advance of the manufacture and unit inventory cost of component per month is $0.1. These costs will stay the same across the production period. The company does not have any initial inventory components or footballs and the capacities of production and storage are infinite. Make an Excel file that can determine the production plan that minimizes the total costs (component purchase cost + football inventory cost + component inventory cost). (20 points)