Reference no: EM132914699
Case Study: COUGAR SPORTS LIMITED Cougar Sports Limited (CSL) was established in 1996 by Mr. Amjad, a leading entrepreneur from Sialkot. Mr. Amjad had a mission to make his company the leading national manufacturer and exporter of gloves used in cricket. Cougar Sports Limited (CSL) makes three different models of cricket gloves; Batting glove, Keeping glove, and Fielding glove. Each glove requires three processes; Cutting, Stitching, and Packaging. The company has limited capacity for each process which is estimated as 6,250 hours, 5,375 hours, and 8,425 hours for cutting, stitching, and packaging, respectively. The production time requirements and profit contribution for each model of glove is given in the following table: Production Time (hours) Model CUTTING STITCHING PACKAGING Profit per Glove (Rs.) Batting 1.3 1.9 0.7 625 Keeping 0.8 1.5 0.4 520 Fielding 1.9 1.3 1.1 780 CSL estimates that it will be able to sell as many Batting gloves it produces, but the demand for Keeping and Fielding gloves is estimated to be only 3,500 and 2,800 respectively. Furthermore, CSL has already accepted an order of 750 Batting gloves from one of its regular customers in South Africa. In light of the given information, CSL is interested in determining the most suitable production plan that will maximize the total profit for the company.
Q : Formulate a Linear Program (LP) for the above problem. NOTE: Clearly define the variables, and label each constraint.
Q: Use Excel SOLVER to solve the above LP and obtain an Answer Report