Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in the appearance of the polymer-based trim around the fuel tank and seat. Each Razor’s trim requires 2 pounds of polymer and 3 hours of production time while each Zoomer requires 1 pound of polymer and 4 hours of production time. Assume that 900 pounds of polymer and 2,400 labor hours are available for production of these items in the coming week
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information:
Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and...
Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in...
Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in...
Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $40. The bikes are identical mechanically and only differ in...
Problem 1: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed the number of Zoomers by more than 300. Each Razor produced and sold results in a profit of $70 while each Zoomer results in a profit of $A0. The bikes are identical mechanically and only...
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...
Max Z=33,600X1=240X2=420Using the solver report and the sensitivity report answer the questions below. Please show your work:1. Assume that there is a disruption in the supply of polymer. Rather than 900 lbs of polymer, assume the organization only received 700 lbs. What will be the optimal profit?2. Assume the organization has decided to develop up to 800 bikes, rather than 700. What will the optimal solution change by?
Humax Manufacturing produces two popular grades of commercial synthetic grass among its many other products. In the coming production period, the manager needs to decide how many rolls of each grade should be produced to maximize profit. Each roll of Grade X grass carpet uses 50 units of synthetic grass fiber, requires 25 hours of production time, and needs 20 units of foam backing. Each roll of Grade Y grass carpet uses 40 units of synthetic grass fiber, requires 28...