A Textile Mill produces 5 different fabrics. each fabric can be woven on one or more of the mill's 38 looms. The sales department forecast of demand for the next month is shown below, along with data on selling price per a yard, variable cost per a yard, and purchase price per a yard. The mill operates 24hrs a day and is scheduled for 30 days during the coming month. The mill has two types of looms; dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only 3 of the fabrics. The mill has a total of 38 looms; 8 are dobbie and 30 regular. the rate of production for each fabric on each type of loom is shown below. The time required to change over from producing one fabric to another is negligible and does not need to be considered. The textile mill satisfies all demand with either its own fabric or fabric purchased from another mill. fabrics that cannot be woven because of limited loom capacity will be purchased from another mill. The purchase price of each fabric is also shown below. Monthly Demand Fabric Demand(yds) Selling price($/yrd) Variable Cost($/yrd) Purchase price($/yrd) 1 16500 .99 .66 .80 2 22000 .86 .55 .70 3 62000 1.10 .49 .60 4 7500 1.24 .51 .70 5 62000 .70 .50 .70 Production Rates Fabric Dobbie Regular 1 4.63 ---- 2 4.63 ---- 3 5.23 5.23 4 5.23 5.23 5 4.17 4.17 Questions; 1. The final production schedule and loom assignments for each fabric. 2. The projected total contribution profit. 3. A Discussion of the value of additional loom time. 4. A discussion of the objective coefficients' ranges. 5. A discussion how the objective of minimizing total costs would provide a different model than the objective of maximizing total profit contribution. This needs to be done on excel. I cant figure out on where everything goes. in terms of constraints and etc does if anyone can link the excel file that would be lovley.