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. Average Temperature Utility Cost January 31°F $ 774 February 41 643 March 43 557 April 44 424 May 46 289 June 50 247 July 53 234 August 60 224 September 50 319 October 40 544 November 30 764 December 10 919 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.
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. Average Temperature Utility Cost January 31°F $ 774 February 41 643 March 43 557 April 44 424 May 46 289 June 50 247 July 53 234 August 60 224 September 50 319 October 40 544 November 30 764 December 10 919 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.
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter8: Time Series Analysis And_forecasting
Section: Chapter Questions
Problem 27P: Hogs & Dawgs is an ice cream parlor on the border of north-central Louisiana and southern Arkansas...
Related questions
Question
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.
| Average Temperature | Utility Cost | |
|---|---|---|
| January | 31°F | $ 774 |
| February | 41 | 643 |
| March | 43 | 557 |
| April | 44 | 424 |
| May | 46 | 289 |
| June | 50 | 247 |
| July | 53 | 234 |
| August | 60 | 224 |
| September | 50 | 319 |
| October | 40 | 544 |
| November | 30 | 764 |
| December | 10 | 919 |
Use the high-low method to estimate utility cost for the upcoming months of January and February. The
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 with 6 images
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College