Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started