Problem 3Show work in Excel
Millard Airport handles many private flights. The budget officer has compiled the following data regarding airport costs over the past year.
MonthAirport costs Flights originating at the airport
February 19,000 1,000
March 18,000 900
April 19,000 1,150
May 16,500 800
June 20,000 1,100
July 21,000 1,500
August 17,000 800
September 21,000 1,200
October 19,000 1,000
November 24,000 1,400
December 18,000 1,100
1. Determine the variable cost per receiving order using the High-Low method.
2. Determine the fixed cost using the High-Low method.
3. Give the cost equation using the High-Low method to estimate the airport costs.
4. Estimate the airport costs using the High-Low method if the company expects 1,350 flights.
This question was answered on: Sep 16, 2020
Need a similar solution fast, written anew from scratch? Place your own custom order
We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.