Please attach a valid Excel file and answer all the questions in detail.

Case Study: PRISTINE CARPET COMPANY Pristine Carpet Company is one of the leading carpet producers in the region, and supplies to customers all over the globe. The company has orders for fifteen different types of carpets that the company can either produce on two types of looms: Batura looms and Haramosh looms. Haramosh looms produce standard tufted carpeting. Batura looms can also produce standard tufted carpeting but also allow the incorporation of designs (such as flowers or corporate logos) into the carpeting. The following table summarizes the orders for each type of carpet that must be produced in the coming quarter (13 weeks) along with their production rates and costs on each type of loom, and the cost of subcontracting each order. Note that the first 4 orders involved special production requirements that can only be achieved on a Batura loom or via subcontracting. Assume that any portion of an order may be subcontracted. Demand Yds Haramosh YHECY Subcontract Cestyd Carpet 1 2 3 4 5 6 7 16.500 56,400 47,000 27,000 77.500 179.500 170,000 67,000 7.500 67,500 68,500 83,000 10,000 381,000 63,500 Batura Ya Hr Costyd 4.510 52,77 4,796 2,53 4,629 2.89 4.256 2.43 5.145 1.82 3,806 1,76 4,165 1.71 5.251 1.56 3.223 1,63 3.216 1.55 3,744 1,64 4.157 1.57 4.422 1.49 5.281 1,31 4,222 1,51 NA NA NA NA NA NA NA NA 4.828 $1.50 3,935 1,71 5,456 1,68 5,356 1.47 5.547 1.50 3,817 1.39 3.835 1,64 4.256 1.56 4.521 1.45 5,353 1.30 4.244 1.50 $2.81 2,62 2.44 2.73 1,76 1.76 1.76 1.59 1.54 1,63 1,80 1.63 1.44 1,69 9 10 11 12 13 14 1.78 15 Pristine currently owns and operates 18 Batura looms and 75 Haramosh looms. To maximize efficiency and keep pace with demand, the company operates 24 hours a day. 6 days a week. Each machine is down for routine maintenance for approximately 5 hours per week. QUESTIONS: Formulate a Linear Programming model, and solve it on Excel using the Solver. Use the Answer and the Sensitivity reports to answer the following questions: NOTE-1: Use the Sensitivity report to answer the post-optimality questions. Do not re-run the Solver until you show evidence that it has become inevitable to do so. NOTE-2: Give complete working reasoning for answer to each question. NOTE-3: Question 1 is worth 50 marks, and rest are 5 marks each. 1. What is the optimal production plan and associated cost? 2. Is the solution degenerate? And is it unique optimal? 3. What would happen to the total cost if one of the Batura machines broke and could not be used at all during the quarter? 4. What would happen to the total cost if an additional Batura machine was purchased and available for the quarter? 5. What would happen to the total cost if one of the Haramosh machines broke and could not be used at all during the quarter? 6. What would happen to the total cost if an additional Haramosh machine was purchased and available for the quarter? 7. Explain the shadow prices and the values in the "Allowable Increase" column of the Sensitivity Report for the products that are bemg outsourced. & How much money does it cost to produce carpet order 2? How much would the total costs decrease if that ander were eliminated? Explain. of the compete in ander 5thgl 15 all all for the same amount whick ny af carpet should Pristine encourage its salesforce to sell more of? Why? 10. If the cost of buying the carpet in order I increased to $2,80 per yard, would the optimal solution change? Why? 11. If the cost of buying the carpet in order 15 decreased to $1,65 per yard, would the optimal solution change? Why