The 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 1 or 'Ci') motorcyles and wants to ensure the number of 'Sportster 1200' produced does not exceed the number of 'Sportster 883' by more than 170 (= Constraint 2 or 'CII'). 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 profits violation of CII? 2) Determine the number of 'Sportster 1200' and 'Sportster 883' Motor500 needs to produce to maximize its total profit (include all constraints). Sportster 1200 Sportster 883 quantity production total profits 3) What happens to your optimal solution if Motor500 increases the max production target (CI) by 100? Sportster 1200 Sportster 883 quantity production total profits 4 What happens to your optimal solution if Motor500 can decrease the production time of the 'Sportster 883' by 23%? Sportster 1200 Sportster 883 quantity production total profits ReadMe Info Answer_1 Worksheet_1 Dataset_1 Answer_2 Worksheet_2 Dataset_2 Answer_3 Worksheet_ 3 D ataset_3 1 Dataset_1 Painting (hrs) Profit per desk mio 00 3 Table 1 4 Model iTable Desks Deskus Capacity (hours/month) 52 $80 Cutting (hrs) 0.7 2.3 2.3 200 Assembling (hrs) 1.6 2.7 5.3 300 $86 3.2 0.5 $79 : Share Comments File Hi H N Home Insert Page Layout Formulas Data Review View i Rules fomu w Bal Q d PageBreak Page Custom Gids H ings Zoom 70% 7am to Preview Layout Views Selection Hep Search = a deve side by side 5 7e New Arene free 2 Schnous serong charms Window AI Pans u htleb Windowostin Windows A B C D E F G H I J K L M N O P The motorcycle manufacturing company Motor 500 produces two popular motorcycles Sportster 1200 and 8R3). In the coming month, the manufacturer plans to produce up to 930 - Constraint 1 or 'C') motorcyles and wants to ensure the number of Sportster 1200 produced does not exceed the number of 'Sportster 5' try more than 1/0 = Constraint 2 ur 'ClI'). Each 'Sportster 1200' produced and sold results in a profit of $1180, while each 'Sportster " results in a profit of $670. The hikes 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 cach 'Sportster 383' requires 1.4 pounds of polymer and 5.3 hours of production time. Assume that 1300 pounds of polymer and zou labor hours are available for production. Assume that motorudes can be produced in fractions. Please note, unless stated otherwise, each question is independent of one another. of the Sportster RRI" (ignore the polymer " Determine the total profit of the company at Motorson decides to produce of the Sportster 1200 and and production constraints). Does this production decision violate Constraint ir? tutulmu viation of 21 Determine the number of 'Sportster 1200' and 'Sportster A' Motors needs to produce to maximize its total profit (include all constraints). Sportster 1200 Sportster 883 Quantity duran total profits 31 What happens to your optimal solution il Motorso increases the max production target (CI) by 100? Soortster 1200 Sportster 883 Quantity duran total profes 4 What happens to your optimal solution if Motors can decrease the production time of the 'sportster 83' by 23%? ReadMe nfo Answer) Worksheet Dataset Answer 2 Worksheet_2 Dataset_2 Answer_3 Worksheet3 Dataset_3 E DI - + 1005 3:57 PM Type here to search 24 11/20