Pace Motorcycles manufactures two sporty motorcycles designed for easy handling and safety.Pace produces the engines for both the Javelyn and Spoiler models at its Rochester, NY plant.Each Javelyn engine requires 8 hours of manufacturing time and each Spoiler engine requires 5 hours of manufacturing time.The plant has 2800 hours of engine manufacturing time available for the next production period.Pace's frame supplier can supply as many Spoiler frames as necessary, but the Spoiler frame is more complex and a maximum of 310 frames can be supplied for the production period.Final assembly and testing requires 2.6 hours for each Javelyn and 3.2 hours for each Spoiler model.The time available in the assembly and testing operation is 1500 hours.The company's accounting department projects a profit contribution of $1850 for each Javelyn produced and $1450 for each Spoiler produced.

a)Complete the model formulation by filling in necessary formulae in cells U4 and T7:T9 , then solve for the optimal solution.

b)How many Javelyn motorcycles should be produced and what is the optimal profit? Type you are answer where indicated.

(c)Use Solvertable to explore how the solution changes for values of spoiler frames available from 290 to 350 in increments of 10 and Javelyn contributions ranging from $1650 to $2050 in increments of 100. Display the table of results

Pace Motorcycles manufactures two sporty motorcycles designed for easy handling and safety.Pace produces the engines for both the Javelyn and Spoiler models at its Rochester, NY plant.Each Javelyn engine requires 8 hours of manufacturing time and each Spoiler engine requires 5 hours of manufacturing time.The plant has 2800 hours of engine manufacturing time available for the next production period.Pace's frame supplier can supply as many Spoiler frames as necessary, but the Spoiler frame is more complex and a maximum of 310 frames can be supplied for the production period.Final assembly and testing requires 2.6 hours for each Javelyn and 3.2 hours for each Spoiler model.The time available in the assembly and testing operation is 1500 hours.The company's accounting department projects a profit contribution of $1850 for each Javelyn produced and $1450 for each Spoiler produced.

c)Pace's frame supplier can resume making 310 Spoiler frames available, but the marketing manager wants Javelyn production to be at least half of total production. It must be clear how you modified your model. Solve your new model.

How many Javelyns should be produced and how much did profit change from part (a)?