Here is a LP model of a manufacturing process concerned with the production of for variants of the same product, A.B.C. and D. each of which will yield a certain profit per titold, and each requires a certain time for amek packing and polishing Given the current state of the labor force the company estimates time limit nailable for each of the ability operation. The objective is to determine how many of each variant to malce to achieve the great posible profit while satisfying all court Maximize 15.4+2.5B+3C+45D Subject to Assembly 2.4+4B+30 +7D5100,000 minutes Polish 3.4+2B+3C +4D $ 50.000 minutes Pack 2.1+3B+2C+5D 560,000 minutes 4.B.C.D20 Figure 1. Excel spreadsheet used to solve the LP model.Cells BS.ES are the designated cells for the optimal values of A B.C. and product variants while cell F3 is the designated cell for the objective function value. Cells F11F13 designate the left-hand side of the constraints. NOTE: To answer the questions on Sensitivity Analysis you first need to solve the problem in Excel and obtain the sensitivity Report, F G H Solver Parameters 1 Product-Mix Problem (4 Products and 3 Resources) 2 D Our of Total Subject to the Constraints 1.5 2.5 3 4.5 7 4 Decision Variables 5 Units to Make 6 7 Objective 8 Profit 9 10 Constraints 11 Assembly 12 Polish 13 Pack 14 15 Add Constant 16 17 18 Cell Reference 19 20 21 Ox 22 2 3 2 4 2 3 3 3 2 Used Relation Available 100000 50000 60000 5 Media Mage Unconstrained variables Fontingative Sgleda Sorvin Mehe GRG Moe Solving Method Samo Select CRG Honiline engine some wo haninem. Select the LP Simple engine for linear Solver Problems, and select the ultion engine for Sale Canon Model OC2 and which constraints are binding hint. Requires Bocel solution and Sensitivity Report 08.2 0.1 and 3 E none of the above Refer to the 10 modes above. By how much would the profit contribution of product Variant nas to increase before will be profitable to produce 8?pire Requires Bucet soution and Sensety 082 OC 2.5 O. 16000 O E none of the above Refer to the 19 mode above Suppose that the production manager procures an additional 23000 minutes of polish time what impact will this have on the current optimal objective function value? O A an increase of $20000 OB an increase of 540000 OC no change OD an increase of $10000 O E none of the above Refer to the LP mode above. Suppose that the production manager has an additional 10000 minutes of assembly time. What impact will this have on the current optimal objective function value? Reguires Excelsition and sensitivity Report O A no change 08. decrease of 18000 O can increase of 5100000 OD an increase of $12000 O E none of the above Refer to the model above. Suppose that the objective function coefficient for product variant increases by $2. What impact will this have on the current values of the optimal solution (Hint: Requires Excel solution and sensitivity Report) O A product A will be produced OB.solution will become infeasible O no change OD. product A will not be produced O E. not enough information is provided