please answer these with caculations questions 7 and 8. Thank You

[20 points] Hot Dee is a hot sauce producer. The demand forecast for the next four weeks, unit production, and inventory holding costs are given in the table below. Currently, there are 500 bottles on-hand. Due to the contract obligations, no shortages are allowed. At the end of the 4th week, the on-hand inventory must be more than 400 units. a. Use the level production strategy. What is a good production level? What is the total cost? (Production + Inventory holding). Show all work. b. Use the chase demand production strategy. Winat is the production level for each week? What is the total cost? Show all work. c. Use the minimum cost strategy (optimization with linear programming). What is the production level for each week? What is the total cost? Show all work including Excel Solver parameters or LPSolve model. [20 points] firm makes a product (product A ) from five components (intermediate Items B,D, and E, and purchased item C). The bill of materials (BOM) of product A shows the required number of subcomponents to make a parent component is given in the parentheses. For example, to make 1 unit of A,1 unit of B and 2 units of D are required. To make 1 unit of B,2 units of C are required, and so on. The gross requirement for product A is 200 units in week 8 . Inventory on-hand for the items are given in the table below. Calculate the net requirement for the six components