Case-In-Point is a start-up company that makes ultra-slim, protective cases in stylish bold colors for a highly popular smartphone with two models - a large MOR model and a compact BEAG model. Case-InPoint uses thermoplastic polyurethane, or TPU, to make all of its phone cases. The MOR case is larger but is mostly solid color in design. To produce an MOR case, 30 grams of TPU are used with 35 mins of manufacturing time. The BEAG model is smaller but more elaborate in design and requires 22 grams of TPU and 53 minutes of manufacturing time. For each production period, 700 grams of TPU and 1,500 minutes of machine times are available. The profits from the MOR and BEAG cases are $9 and $7.50 respectively. a) Formulate and solve the LP model that maximizes revenue given the constraints. How many MOR and BEAG cases should Case-In-Point make for each production period? b) If the amount of TPU available increases to 1,000 grams for each production period, report the new LP solution and discuss your answer. Perform in excel Case-In-Point is a start-up company that makes ultra-slim, protective cases in stylish bold colors for a highly popular smartphone with two models - a large MOR model and a compact BEAG model. Case-InPoint uses thermoplastic polyurethane, or TPU, to make all of its phone cases. The MOR case is larger but is mostly solid color in design. To produce an MOR case, 30 grams of TPU are used with 35 mins of manufacturing time. The BEAG model is smaller but more elaborate in design and requires 22 grams of TPU and 53 minutes of manufacturing time. For each production period, 700 grams of TPU and 1,500 minutes of machine times are available. The profits from the MOR and BEAG cases are $9 and $7.50 respectively. a) Formulate and solve the LP model that maximizes revenue given the constraints. How many MOR and BEAG cases should Case-In-Point make for each production period? b) If the amount of TPU available increases to 1,000 grams for each production period, report the new LP solution and discuss your answer. Perform in excel