Question Details

(Solved) (Latest ver. Aug 2020) - Millard Airport: High Low method - variable cost, fixed cost

Brief item decscription


Item details:

Question:

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
January$22,000 1,200
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.

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 16, 2020

PRICE: $11.5

Solution~00011002.zip (18.37 KB)

Buy this answer for only: $11.5

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

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.

Order Now