Click Submit to complete this assessment. Question 4 XYZ Computers has discontinued the production of a certain unprofitable product line. This act created considerable excess production capacity. Management is considering devoting this excess cap 3. The unit profits, sales potential and available capacity are listed in the following solution: Chip 50 Chip 2 20 Chip 3 Unit Profit ($) 25 Minimum Minutes Used Daily Requirement 500 350 500 Machine Minutes Used per Unit of Product 9 3 5 5 4 0 3 o 0 2 Molding Marking Testing 350 118.57 150 Chip 1 26 Chip 2 55 Chip 3 20 Total Profit ($) 2904.76 Production Rate (per week) Sales Potential 20 Use the following sensitivity report for each of the following questions, ANSWER as completely as possible without solving the problem again with the Excel Solver Variable Cells Allowable Allowable Final Reduced Objective Coefficient Decrease Increase Cost Value Cell 50 0 1.25 25 Name Production Rate Chip 1 Production Rate Chip 2 Production Rate Chip 3 26 155 20 20 $B$10 SC$10 SDS10 1 0 25 1E+30 1.19 1.19 20 Constraints Constraint Shadow Allowable Allowable Final Price R.H. Side Increase Value Cell Name 55 Decrease 1375 17333 500 500 4.76 SESS 1.43 350 183.33 350 Molding Marking Testing SES6 $E$7 (a) Suppose the cost for Chip 3 changes to $23. Will the optimal solution change and what can be said about the effect on total profit? Chin? increases hy $19 cents. Will the optimal solution change and what can be said about the effect on total profit