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. 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.

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%

Problem 8-44 (Algo) Cost Estimation; High-Low Method [LO 8-3]

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.

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
March
April
May
June
July
August
September
October
November
December
Average
Temperature
31°F
41
43
44
46
50
53
60
50
40
30
10
Utility Cost
$ 786
655
569
436
301
259
246
236
331
556
776
961
Transcribed Image Text:January February March April May June July August September October November December Average Temperature 31°F 41 43 44 46 50 53 60 50 40 30 10 Utility Cost $ 786 655 569 436 301 259 246 236 331 556 776 961
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

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