In a Word document (or clear handwriting), state the algebraic formulation (identify the decision variables, the objective function and the constraints) for each problem and answer the questions in the problems. It is acceptable to use short notation and/or brief statements to represent the formulation of the problem. Screenshots of the model (use FORMULATEXT to show calculations) and Answer Reports must be included in the Word document. Attached the Excel spreadsheet model for each problem to support your answers. Use formatting (labels, colors, borders) to enhance the readability of your models. EOQ for Multiple Products: In another location, the distributor of the previous problem stocks four different items in common warehouse space. Each item is described by an annual demand rate, a fixed cost per order, a holding cost per year, a unit purchase cost, and a space requirement. The data in the following table describe the four products. - Item 2 3 Demand 5000 10.000 30,000 Fixed cost 400 700 300 50 100 Holding cost 25 250 Purchase cost 500 8 250 100 Space (sq. ft) 12 80 25 1000 S 10 (a) Considering each product separately, as if it were independent from the others, what are the respective economic order quantities? What is the total annual cost of ordering, holding, and purchasing across the four products at these order quantities? (b) What is the minimum total annual cost for the four products if the average space taken up must be no more than 12,000sq. ft? (c) What is the minimum total annual cost for the four products if the average space taken up must be no more than 12,000sq. ft and the number of orders per year must be no more than 65? (d) In part (b), with a square-foot limit on storage space, what is the economic value of more space? (e) In part (c), what is the economic value of more space