A B C 1 D E 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1. An firm produces products, A and B. Each model uses one (the same) part, of which there are only 2,500 available. Also, the company has allocated a maximum of 800 hours of assembly time this week for producing these products; product A requires 15 minutes (.25 hours) each, and B requires 30 minutes (.5 hours) each to produce. The firm will sell a maximum of 4,000 A's this week and a maximum of 1,000 B's. Profits for the A are $100 each, and profits for the B are $400 each. Define the variables and derive the LP model for the problem. Implement it in Excel. Solve the problem in Excel and state your solution. Generate the sensitivity report and based on the sensitivity report define the range of optimality of the objective function coefficients. Explain the meaning of one of the intervals. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 868 G