Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 480 Jan. Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 500 4,350 2,960 May June 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43,200 4,800 $ 3,600 Average Average cost per hour a (intercept) b (coefficient) 24 $ $ 684.65 400 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range of

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter2: Building Blocks Of Managerial Accounting
Section: Chapter Questions
Problem 9EA: The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express...
icon
Related questions
Question
Armer Company is accumulating data to use in preparing its annual profit plan for the coming year.
The cost behavior pattern of the maintenance costs must be determined. The accounting staff has
suggested the use of linear regression to derive an equation for maintenance hours and costs.
Data regarding the maintenance hours and costs for the last year and the results of the regression
analysis follow:
Maintenance
Machine
Month
Cost
Hours
$ 4,200
Jan.
480
Feb.
3,000
320
Mar.
3,600
400
Apr.
2,820
300
May
4,350
500
June
2,960
310
July
3,030
320
Aug.
4,470
520
Sept.
4,260
490
Oct.
4,050
470
Nov.
3,300
350
Dec.
3,160
340
Sum
$43, 200
4,800
$ 3,600
$
$
$ 684.65
Average
400
Average cost per hour
a (intercept)
b (coefficient)
9.00
7.2884
Standard error of the estimate
34.469
R-squared
0.99724
t-value for b
60.105
At 400 hours of activity, Armer management can be approximately two-thirds confident that the
maintenance costs will be in the range of
Transcribed Image Text:Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 Jan. 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43, 200 4,800 $ 3,600 $ $ $ 684.65 Average 400 Average cost per hour a (intercept) b (coefficient) 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range of
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cost estimation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials of Business Analytics (MindTap Course …
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
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning