Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question Completion Status QUESTION Burmer Co has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern

image text in transcribed
image text in transcribed
Question Completion Status QUESTION Burmer Co has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern of the maintenance costs must be determined. Data regarding the machine hours and maintenance costs for the last year and the results of the regression analysis are as follows: Month Maintenance Cost Machine Hours Jan $5.040 620 ... Remainder of original data omitted Sum 551,830 6.260 Average 54,319 522 Astat assistant has run regression analyses on the data and obtained the following output using Excel REGRESSION ANALYSIS Y Dependent Variable Maintenance Cost X Independent Variable Maintenance Hours Regression Statistics H 0.998210294 Rosare 0.996423791 Adjusted R Square 0.99606617 Standard Error 470629565 Observations ANOVA Regression dy 35 MS F Significance 1 6171342.448 6171342 2786,257 0.00000000000144 1022149 21656 2214.922 11 6193491,667 ewidual Total Coefficients Standard Error Stet value 1783.7782788 634114772 11.46361 4.47E07 Lower 959 Upper 95 31.504652936051785 Intocat Ciek swand Submit and submit Chek Alla son Statistics 09927024 3791 So 0.99606617 Standard 470525 Com 12 ANOVA ar 1 55 MS Signific 6171342448617342 276.250 0.000000000000144 22149 21856 2214922 10 Total Coregloent Standart Error Stute Le per 221 683447721261 LTET 63153605178 Hours T11025 01230052.78501 1.4401) 0302970317 Un any was the time manance pense for a month the impact opera 600 machous round to whole Gola 155 SEO 54050 HE 54 5 4 8 2 3 5 8 0 e W E R fo T Y U o P S D F G cops bok . J KL Z X CV B NM P control option command COD

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Financial and Managerial Accounting

Authors: Horngren, Harrison, Oliver

3rd Edition

978-0132497992, 132913771, 132497972, 132497999, 9780132913775, 978-0132497978

Students also viewed these Accounting questions