Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Paige Company wants to develop a cost equation to determine its total electricity cost for a given month. It has determined that kilowatt hours

The Paige Company wants to develop a cost equation to determine its total electricity cost for a given month. It has determined that kilowatt hours used is the best predictor of electricity cost. It has collected the following data for the months of January through August of the current year to help in developing the cost equation.
PAIGE COMPANY
DATA FOR ESTIMATING ELECTRICITY COST
Month Electricity Cost Kilowatt Hours Used
January $ 50,0004,500
February 65,0006,000
March 40,0003,500
April 30,0002,500
May 60,0005,400
June 70,0007,200
July 75,0008,300
August 69,0006,800
After running the data through regression analysis, the following output results were obtained.
PAIGE COMPANY
DATA FOR ESTIMATING ELECTRICITY COST
OUTPUT FROM REGRESSION ANALYSIS
Intercept 13,108
b coefficient 8.0122
R squared 0.9643
Using the high-low method for cost estimation, what is the cost equation that the company should use to estimate electricity cost?
Question 18 options:
Electricity Cost = $10,600+($ 7.759 x Kilowatt Hours Used).
Electricity Cost = $14,476+($ 7.292 x Kilowatt Hours Used).
Electricity Cost = $7.7590+($10,600 x Kilowatt Hours Used).
Electricity Cost = $ 6,434+($ 8.261 x Kilowatt Hours Used).

Step by Step Solution

3.47 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

To find the cost equation using the highlow method you first need to identify the high and low points from the data provided The high point is July with 75000 kilowatt hours used and 83000 in electricity cost while the low point ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis And Decision Making

Authors: Christian Albright, Wayne Winston, Christopher Zappe

4th Edition

538476125, 978-0538476126

More Books

Students also viewed these Accounting questions