Please solve. All one problem

Digital Controls manufactures two types of adar gun. Model A has accuracy of 1 mile per hour, whereas Model B has accuracy of 3 miles per hour. For the next week there are orders for 100 of Model A and 150 of Model B. Each model A case requires 4 minutes of injection modeling time and 6 minutes of assembly time. Each Model B requires 3 minutes of injection time and 8 minutes of assembly time. For the next week, the plant has 600 minutes of injection time and 1080 minutes of assembly time. The manufacturing costs are $10 per case for Model A and $6 per case for Model B. Sometimes, the plant needs to purchase parts from an outside source, at a cost of $14 for Model A and $9 for Model B. The following decision variables should be used Let AM - number of cases of model A manufactured Let BM = number of cases of model B manufactured Let AP - number of cases of modol A purchased Let BP = number of cases of model B purchased The linear programming model is given below: s Min 10AM + 6BM +14AP -9BP st. 1AM + 1 AP 100 Demand for model A 1BM + 1 BP = 150 Demand for Model B 4AM + 3BM 600 Injection Molding Time 6AM + BBM 0 Enter the model in Excel and use the Solver The optimal solution is a. AM = 100, BM = 60 b. $2170 C. AM = 100, BM = 60, AP = 0 BP=90 d. AM = 100, BP = 60, AP = 0 BM=90 The value of the objective function is 2170 parts o a. b. $2710 c. $2700 d. $2170 Which constraints are binding? a. Demand for Model A and Injection Molding Time (1,3) b. Demand for Model A, Demand for Model B and Assembly Time. (1,2,4) c. None Od. Injection Molding Time (3) If you could change the right-hand side of one constraint by one unit you would change that of constraint assembly time since each additional minute of assembly time will decrease conta by $0.375. Yes No Suppose the manufacturing cost increases to $11.20 per case for model A. The new optimal solution is $2120 a. b. $2290 c. $2190 Outside range so will not change d Suppose the manufacturing cost increases to $11.20 for Model A and decreases to $5 per unit for Model B. Use 100% rule to determine what happens to optimal solution. a. 100% rule not violated so we can re-use answer b. Solution will remain the same. c. None of the above. d. Solution will change since 100% rule is exceeded. By re-running the solver-one solution under the simultaneous change is a. AM = 100 BM=0, AP 100 and BP =15 with Cost = $2210 b. None of the above c. AM = 0 BM=135, AP = 100 and BP =15 with Cost= $2210 d. AM = 0 BM=100 AP = 135 and BP =15 with Cost= $2210