Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

 
  1. 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.
     
  2. 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.
     
  3. 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.
     
  4. 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.
     
  5. 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.
     
  6. 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. 


Full aren in Heiling TC 153 Pune Boeing 727 DC DC- CN-101 LB127 DC Aus101 DG- DC Trio MIAJFK MIA-ATL MIA OFW MAJU MA-BAL MAL

Pulsa Renau sing Plane Boeing 727 DC- DC- CN-101 L-1011 B127 DC A01 DG- DC Pying hours Folgare 2.75 125 3.15 35 2.25 56 15 12

Fuel Estmates Plane Trip Fying Houn Fuel Regd Resere Fu Hing Fu Totaf Cee Boeing.727 MIAJFK 275 DC-9 MIA-ATL DC-9 MIA OFW 3.15 CN-101 MIASJU 35 L-A01 MIA-JAH 225 Boeng727 MIA LAX Table MIA MSY LAKACN MIA-ATL MA OFW 15 Artus-101 DC- 125 Hewrarth and H Fale DC 315 Beeing 727 MIA LAX MIA MSY 15 Table At-101 -1011 LAXICN MA Doing 127 MIA LAX MIA MSY LAKACN 15 Tellabomaion At-101 DC- MIA-ATI dol MIA-DEW MIA DW DC 115 DC- 115 CN-101 MIA-SJU 35 L-1011 MIA 225 Boeng 27 DC- Boeng 127 MIALAX MIA E MIA LAX DC MAMSY 13 Atus-101 L-1011 LAXCN MIA H 225 Boeing 727 MA-LAX MA-MBY 1.5 Artu 101 LAXCN MIA ATL MIA DFW MIA OFW 125 DC- 3.15 3.15 35 CN-101 MIA SJU MIA 226 Boeing 127 MIA LAX DC- MIA-MSY 15 DC MIA DFW Boeing-127 MIA LAX MIA-MBY LAXCN 55 Abus 101 MIA- MIA LAX 1-1011 225 Boeng 27 55 MIA MSY 15 Arbu-101 LAX-ON MIA ATL DC- 125 3.15 MIA DFW MA DFW MASN 3.15 15 CN-101 L-1011 MIA AH 225 Boeing 727 MIA LAX MIA-MSY MIA LAX 1. Boeing-727 DC Autu-101 5. MIA MSY 15 LAXICN L-1011 MIA AH 225 55 Boeing-27 MIA-LAX MIA MSY LAKCN DC- 1.5 Arbus-101 MIA ATL MIA DPW DC- 1.25 DC- 315 Boeing 27 DC- MIA LAX 55 15 MIA MSY LAXCN MIA H Atu-101 2.25 Boeing-727 DC- MIA-LAX 5 MIA MBY 13 Abus-101 DC- LAXACN MIA ATL MIA-DFW MIA DFW MA SJU MIA H 125 DC 315 115 DC CN-101 225 55 L-101 Doeing.727 DC- MIA-LAX MIAMBY MALAX Boeing-727 DC MIA MSY 15 Atu-101 LAXCN L-1011 MIA-JAH 225 Boeing 127 MA LAX MIA MSY LAX-ICN MIA ATL 15 At-101 125

Step by Step Solution

3.63 Rating (146 Votes )

There are 3 Steps involved in it

Step: 1

The pieces of a capacity To work accurately a capacity should be composed a particular way which is known as the sentence structure The fundamental punctuation for a capacity is an equivalents sign th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Analysis for Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha

12th edition

133507335, 978-0133507331

More Books

Students also viewed these Programming questions