Question
Scooter City produces their own value scooters for adults to use as an economical means to commute around the city. The low budget scooter is
Scooter City produces their own value scooters for adults to use as an economical means to commute around the city. The low budget scooter is called EagleAir and the upgraded model is the TurboTrax. The manufacturing process for these scooters require frame construction, electronic assembly, and customization & detailing. The time requirements for each model is provided in the table:
EagleAir Model | TurboTrax Model | Minutes Available | |
Frame Construction | 15 | 20 | 3800 |
Electronic Assembly | 10 | 8 | 4400 |
Customization & Detailing | 25 | 40 | 6400 |
The profit for the EagleAir model is $170 each and the profit for the TurboTrax model is $260 each.
Solve using Solver. Answer all questions in Excel include formulas that are being used in the excel file.
a. | What is the linear programming model for this problem? (Refer toformulation from M2: Quiz) |
b. | Find the optimal solution using Excel Solver. |
c. | Will there be excess capacity (minutes) in any area (eg. slack)? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started