Top-line Furniture operates fabrication facilities in Edmonton and Montreal. The two products made at both plants are Loveseat and Daybed sofas. The products have many similarities in their manufacturing, but the equipment and labor skills at the two plants differ. Two critical resources that are in limited supply are labor for sewing and fabric cutting time. Information about the products, plants and resources is summarized below. 

Develop a production plan to assist Top-line furniture so that they maximize their profits. 

a) Formulate the linear programming model. 

b) Use Excel Solver to solve the problem and attach a copy of your spreadsheet model with the answers AND the sensitivity report.

Edmonton Montreal Loveseat Daybed Loveseat Daybed Cutting hours/unit 89 Sewing hours/unit 90 Profit 82 93 87 85 102 95 2500 2100 2100 1900 Resource availability Edmonton Montreal Cutting hours Sewing hours 6000 5500 25000 20000