subject
Business, 03.06.2020 04:58 semajac11135

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
Month Machine Hours Electricity Costs
January 2,900 $ 18,600
February 3,300 $ 21,400
March 2,300 $ 13,700
April 3,500 $ 23,400
May 4,200 $ 28,450
June 3,700 $ 22,400
July 4,500 $ 24,950
August 3,900 $ 22,950
September 2,400 $ 15,900
October 4,100 $ 26,400
November 5,300 $ 31,400
December 4,900 $ 27,950
Summary Output
Regression Statistics
Multiple R .959
R Square .920
Adjusted R2 .912
Standard Error 1,550.32
Observations 12.00
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 2,992.80 1,933.78 1.55 0.15 (1,315.92) 7,301.52
Machine Hour 5.37 0.50 10.70 0.00 4.25 6.49
If the controller uses the high-low method to estimate costs, the cost equation for electricity cost is: (Round intermediate calculations to 2 decimal places.)
A. Cost = $2,992.80 + $5.37 × Machine-hours.
B. Cost = $130.00 + $5.90 × Machine-hours.
C. Cost = $6.50 × Machine-hours.
D. Cost = $23,670.

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 17:10
To : of $25 up to 35 2 35 up to 45 5 45 up to 55 7 55 up to 65 20 65 up to 75 16 is$25 up to $35 ?
Answers: 1
question
Business, 22.06.2019 17:30
Emery pharmaceutical uses an unstable chemical compound that must be kept in an environment where both temperature and humidity can be controlled. emery uses 825 pounds per month of the chemical, estimates the holding cost to be 50% of the purchase price (because of spoilage), and estimates order costs to be $48 per order. the cost schedules of two suppliers are as follows: vendor 1 vendor 2 quantity price/lb quantity price/lb 1-499 $17 1-399 $17.10 500-999 $16.75 400-799 $16.85 1000+ $16.50 800-1199 $16.60 1200+ $16.25 (a) what is the economic order quantity for each supplier? (b) what quantity should be ordered and which supplier should be used? (c) the total cost for the most economic order sire is $
Answers: 2
question
Business, 22.06.2019 20:40
Robert owns a life insurance policy that he purchased when he first graduated college. it has a $100,000 death benefit and robert pays premiums for it every month out of his checking account. the insurance robert has is most likely da. permanent life insurance o b. term life insurance o c. group life insurance o d. individual life insurance
Answers: 1
question
Business, 22.06.2019 22:20
Mattress wholesalers, inc. is constantly trying to reduce inventory in its supply chain. last year, cogs was $7.47 million and inventory was $1.47 million. this year, cogs is $8.65 million and inventory investment is $1.64 million.a) what was its weeks of supply last ) what is its weeks of supply this ) is mattress wholesalers making progress in its inventory reduction effort? since the number of weeks that cover the supply has mattress wholesalers is making in its inventory reduction effort.
Answers: 3
You know the right answer?
Thane Company is interested in establishing the relationship between electricity costs and machine h...
Questions
question
Mathematics, 02.02.2021 22:40
question
Social Studies, 02.02.2021 22:40
question
Health, 02.02.2021 22:40
question
Social Studies, 02.02.2021 22:40
question
Mathematics, 02.02.2021 22:40
question
Mathematics, 02.02.2021 22:40
Questions on the website: 13722360