Question: *PLEASE ANSWER USING EXCEL, PREFERABLY EXCEL QM* Solve this problem using the graphical method: Duluth Electronics makes two types of scooters: Falcon and Hawk. The

*PLEASE ANSWER USING EXCEL, PREFERABLY EXCEL QM*

Solve this problem using the graphical method:

Duluth Electronics makes two types of scooters: Falcon and Hawk. The Falcon model has a lighter engine and a smaller frame to make novice riders easier to balance. The Hawk is a little bigger and uses a heavier engine. Falcon requires 6 hours of manufacturing time and Hawk takes only 3 hours. Duluth's main plant in Kentucky has 2,100 hours of engine manufacturing time available. Duluth's vendors have the ability to supply as many Falcon frames as needed, but they only provide 280 Hawk frames. Falcon requires 2 hours of testing and 2.5 hours for Hawk. There are only 1,000 hours available for testing.

The finance department estimates that the Falcon model contributes a profit of $2,400 and the Hawk $1,800.

Determine the optimal solution for this problem.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!