Loblaws Company Limited is a conglomerate with several businesses in Canada including apparel, grocery stores, and pharmacies that sell medical products, food, and beauty supplies. You have been hired as a consultant for Loblaws Company Limited to help the company make several decisions to improve efficiency and optimize the use of limited resources. You must solve these decisions using linear programming, and include your models in excel. Make sure to state your conclusion Apparel Production The company has one particular plant where both dresses and jeans are manufactured. The firm has some flexibility to move manufacturing effort between dresses and jeans production, with the current procedures enforcing limits on the maximum and minimum quantity of each product that can be created. Known constraints are provided below: Machine hours available (total): Minimum 39,000 hours Maximum 40,000 hours. The quantity of dresses that can be manufactured: Minimum 30,000 dresses to Maximum 60,000 dresses. The quantity of jeans that can be manufactured: Minimum 20,000 pairs of jeans to Maximum 40,000 pairs of jeans. For every machine hour, the labour cost associated with this is $6.00 per machine hour. Other factors are as follows: Manufacturing Time Material Cost Per Dress 0.5 hours $2.00 Per Pair of Jeans 0.3 hours $1.25 Loblaws Company Limited believes it can sell each dress for $14.00 and each pair of jeans for $11.00. Moreover, the firm believes that cost of material and labour costs will be relatively consistent in future periods. The corporate tax rate is 28%. Loblaws Company Limited wants to determine the ideal number of dresses and jeans to manufacture that will maximize the facilitys net profit after taxes.