This is a practice problem I am having a difficult time finding with excel.

3) What happens to your optimal solution if Motor500 increases the max production target (Constraint I) by 100? quantity Sportster 1200 Sportster 883 production total profit 4) What happens to your optimal solution if Motor500 can decrease the production time of the 'Sportster 883' by 23%? quantity Sportster 1200 Sportster 883 production total profitThe motorcycle manufacturing company Motor500 produces two popular motorcycles (Sportster 1200 and 883). In the coming month, the manufacturer plans to produce up to 930 (= Constraint I) motorcyles and wants to ensure the number of 'Sportster 1200' produced does not exceed the number of 'Sportster 883' by more than 170 (= Constraint II). Each 'Sportster 1200' produced and sold results in a profit of $1180, while each 'Sportster 883' results in a profit of $670. The bikes are mechanically similar but differ in the appearance of the polymer-based trim around the fuel tank and seat. Each Sportster 1200's trim requires 1.7 pounds of polymer and 4.2 hours of production time, while each 'Sportster 883' requires 1.4 pounds of polymer and 5.3 hours of production time. Assume that 1300 pounds of polymer and 2500 labor hours are available for production. Assume that motorcycles can be produced in fractions. Please note, unless stated otherwise, each question is independent of one another. 1) Determine the total profit of the company if Motor500 decides to produce 550 of the 'Sportster 1200' and 380 of the 'Sportster 883' (ignore the polymer and production constraints). Does this production decision violate 'Constraint II"? total profit violation of CHI? 2) Determine the number of 'Sportster 1200' and 'Sportster 883' Motor500 needs to produce to maximize its total profit (include all constraints). quantity Sportster 1200 Sportster 883 production total profit