Compute the fuel required for each flight in D4. The fuel required for each flight is dependent
Fantastic news! We've Found the answer you've been seeking!
Question:
- Compute the fuel required for each flight in D4. The fuel required for each flight is dependent on the type of aircraft and the number of flying hours. Use an appropriate function in the formula to determine gallons per hour based on the type of plane, and then multiply the result by the number of flying hours to compute the amount of fuel for each flight.
- Compute reserve f
uel, holding fuel, and total fuel. Use the fuel required from Part 1 to compute reserve fuel and holding fuel (i.e., 10% of the fuel required), which must then be added to the initial fuel requirements to get the total fuel needed for a trip. These parameters are shown at the bottom of the worksheet and are susceptible to change. Use the appropriate combination of relative and absolute references so that the formula for the first flight can be copied to the remaining rows in the worksheet.
- Compute the fuel cost. The estimated fuel cost for each flight is the number of gallons times the price per gallon. There is a price break, however, if the fuel required reaches or exceeds a threshold number of gallons. For example, if the Boeing-727 flight from Miami to Los Angeles requires 6,050 gallons, which exceeds the threshold, it qualifies for the reduced price of fuel.
- Use the Conditional Formatting in the Styles group on the Home tab to display light red fill with dark red text for Fuel Cost over $10,000.
- Use the Conditional Formatting in the Styles group on the Home tab to display yellow fill with dark yellow text for Fuel Cost under $5,000.
- Compute and display the Total, Average, Highest, and Lowest of Fuel Required, Reserve Fuel, Holding Fuel, Total Fuel, and Fuel Cost in an appropriate place in the worksheet.
Related Book For
Quantitative Analysis for Management
ISBN: 978-0133507331
12th edition
Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha
Posted Date: