Horizon BP in Antelope Park, Alaska, has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a year, Horizon has been recording the average daily temperature and the cost of its monthly utility bills for natural gas and electricity. January Average Temperature 31°F Utility Cost $ 764 February 41 633 March 43 547 April 44 414 May 46 279 June 50 237 July 53 224 August 60 214 September 50 309 October 40 534 November 30 754 December 10 884 Required: Use the high-low method to estimate utility cost for the upcoming months of January and February. The forecast for January is a near record average temperature of 5°F; temperatures in February are expected to average 40°F. January February Cost estimation

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
Horizon BP in Antelope Park, Alaska, has noticed that utility bills are substantially higher when the average monthly temperature is
colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used
every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity,
and electricity use is fairly constant throughout the year.
For a year, Horizon has been recording the average daily temperature and the cost of its monthly utility bills for natural gas and
electricity.
January
Average
Temperature
31°F
Utility Cost
$ 764
February
41
633
March
43
547
April
May
44
414
46
279
June
50
237
July
53
224
August
60
214
September
50
309
October
40
534
November
30
December
10
754
884
Required:
Use the high-low method to estimate utility cost for the upcoming months of January and February. The forecast for January is a near
record average temperature of 5°F; temperatures in February are expected to average 40°F.
January
February
Cost estimation
Transcribed Image Text:Horizon BP in Antelope Park, Alaska, has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a year, Horizon has been recording the average daily temperature and the cost of its monthly utility bills for natural gas and electricity. January Average Temperature 31°F Utility Cost $ 764 February 41 633 March 43 547 April May 44 414 46 279 June 50 237 July 53 224 August 60 214 September 50 309 October 40 534 November 30 December 10 754 884 Required: Use the high-low method to estimate utility cost for the upcoming months of January and February. The forecast for January is a near record average temperature of 5°F; temperatures in February are expected to average 40°F. January February Cost estimation
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education