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
Get step-by-step solutions from verified subject matter experts
