Question
Assignment: A new type of fueling truck is under consideration for an airport on a resort island. The company has been testing one alternative and
Assignment: A new type of fueling truck is under consideration for an airport on a resort island. The company has been testing one alternative and feel it has the potential to significantly reduce fueling time while airplanes are at the airports one gate. With current equipment refueling requires 20 minutes. They estimate that the first fueling operation with this equipment will require 30 minutes. They hope, by spending the money for the new equipment, that within two weeks they will achieve a refueling time of 15 minutes a 25% improvement on the current time. Assume 6 planes per day are schedule to arrive/depart from the island (7 days/week). All flights to and from the island are scheduled to arrive and depart between 6:00 am and 9:00 am. a. Determine the learning rate required to achieve their objective. b. If their learning rate is actually 92%, how many days will it take to get the refueling time below the 20 minutes required with the old system? c. After 10 weeks with a learning rate of 92%, what would be the expected time to refuel planes with the new system? d. What impact (if any) will this change have on the demand for fueling systems and the way they are scheduled? e. What impact might this have on the scheduling of flights to/from this destination? f. Assuming theres demand for up to six additional flights in the scheduling window, what is the business case for purchasing this equipment?
Note: I need step-by-step instructions or to see how assignment is solved in excel to fully understand. Thanks!
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