Health Source Hospital (HSH) has a standing contract with an air charter service to deliver critical medications throughout its service network. The contract calls for a fixed monthly payment plus a set of variable charges based on each flight's specific characteristics. The first table below includes information about total monthly cost and the number of flights. Below the table is a computational aid for estimating the fixed and variable cost components via the high-low method. Use the pick lists associated with each boxed area to select the high and low volumes. The remainder of the tables will automatically complete based on your selections. After correctly making each selection, the variable and fixed cost amounts will turn green. Carefully review the underlying logic of the calculations. January February March April May June July August September October November December Highest level Lowest level Difference Total cost Less: Variable cost (variable cost per flight X flights) Flights Fixed cost 7 14 11 18 21 16 8 12 6 18 15 9 Flights 21 Variable cost per flight (cost difference divided by flight difference) >>>> 6 15 HIGH 55,200 46,200 9,000 Cost 23,180 43,780 29,880 48,600 55,200 46,410 26,600 36,108 22,200 47,628 37,800 28,800 Cost 55,200 22,200 33,000 2,200 LOW 22,200 13,200 9,000
Health Source Hospital (HSH) has a standing contract with an air charter service to deliver critical medications throughout its service network. The contract calls for a fixed monthly payment plus a set of variable charges based on each flight's specific characteristics. The first table below includes information about total monthly cost and the number of flights. Below the table is a computational aid for estimating the fixed and variable cost components via the high-low method. Use the pick lists associated with each boxed area to select the high and low volumes. The remainder of the tables will automatically complete based on your selections. After correctly making each selection, the variable and fixed cost amounts will turn green. Carefully review the underlying logic of the calculations. January February March April May June July August September October November December Highest level Lowest level Difference Total cost Less: Variable cost (variable cost per flight X flights) Flights Fixed cost 7 14 11 18 21 16 8 12 6 18 15 9 Flights 21 Variable cost per flight (cost difference divided by flight difference) >>>> 6 15 HIGH 55,200 46,200 9,000 Cost 23,180 43,780 29,880 48,600 55,200 46,410 26,600 36,108 22,200 47,628 37,800 28,800 Cost 55,200 22,200 33,000 2,200 LOW 22,200 13,200 9,000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Health Source Hospital (HSH) has a standing contract with an air charter
service to deliver critical medications throughout its service network. The
contract calls for a fixed monthly payment plus a set of variable charges based
on each flight's specific characteristics. The first table below includes
information about total monthly cost and the number of flights.
Below the table is a computational aid for estimating the fixed and variable cost
components via the high-low method. Use the pick lists associated with each
boxed area to select the high and low volumes. The remainder of the tables will
automatically complete based on your selections. After correctly making each
selection, the variable and fixed cost amounts will turn green. Carefully review
the underlying logic of the calculations.
January
February
March
April
May
June
July
August
September
October
November
December
Highest level
Lowest level
Difference
Total cost
Less: Variable cost (variable cost per flight X
flights)
Flights
Fixed cost
7
14
11
18
21
16
8
12
6
18
15
9
Flights
21
Variable cost per flight (cost difference divided by flight difference) >>>>
6
15
HIGH
55,200
46,200
9,000
Cost
23,180
43,780
29,880
48,600
55,200
46,410
26,600
36,108
22,200
47,628
37,800
28,800
Cost
55,200
22,200
33,000
2,200
LOW
22,200
13,200
9,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education