Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

bottom answer was wrong Removing any outliers Identified in the scattergraph, use Excel to perform a new regression analysis. (Round intercept value to 5 decimal

bottom answer was wrong
image text in transcribed
image text in transcribed
image text in transcribed
Removing any outliers Identified in the scattergraph, use Excel to perform a new regression analysis. (Round "intercept" value to 5 decimal places and "Unit Production to 7 decimal places.) Coefficients Intercept Unit Production What is the cost equation with the new results? (Round variable cost per unit to 2 decimal places.) Overhead Cost = $ 10.600 + 16.05 Units Type here to search Your company is preparing an estimate of its production costs for the coming period. The controllerecimates that direct material costs are $45 per unit and that direct labor costs are $21 per hour Estimating Overhead, which is applied on the back of direct labor costs, is difficult. The controler's office estimated overhead costs at $3,600 for fed costs and 518 per unit for variable costs. Your colleague, Lance who graduated from a rival school, has already done the analysis and reports the correct cost equation as follows: Overhead = $10,600 - $16.05 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says. "With 82 percent of the variation in overhead explained by the equation. It certainly should be adopted as the best basis for estimating costs. When asked for the data used to generate the regression, Lance produces the following: Month Unit Production 3,048 Overhead $57.144 60,756 77.4e 56,412 81.396 72,252 3.000 1.40 3.928 3.316 4.016 73,596 77,772 GO,048 61.612 73.92 73.248 3.192 3. GS 4.00 3. The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee Cileck my work Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $45 per unit and that direct labor costs are $21 per hour. Estimating overhead. which is applied on the basis of direct labor costs, is difficult The controller's office estimated overhead costs at $3,600 for fixed costs and $18 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct cost equation as follows: Overhead = $10,600 - $16.05 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says. With 82 percent of the variation in overhead explained by the equation. It certainly should be adopted as the best basis for estimating costs." When asked for the data used to generate the regression, Lance produces the following: Overhead $57,144 60, 756 77,040 56,412 81,396 72,252 Unit Production 3,848 3,249 4,176 3.000 3, 408 3.928 3,336 4,016 4, 12e 3,192 3369 4.88 3.BR 63,852 73,596 77,772 68,848 61.632 71,920 73,249 The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee Required Removing any outliers Identified in the scattergraph, use Excel to perform a new regression analysis. (Round "intercept" value to 5 decimal places and "Unit Production to 7 decimal places.) Coefficients Intercept Unit Production What is the cost equation with the new results? (Round variable cost per unit to 2 decimal places.) Overhead Cost = $ 10.600 + 16.05 Units Type here to search Your company is preparing an estimate of its production costs for the coming period. The controllerecimates that direct material costs are $45 per unit and that direct labor costs are $21 per hour Estimating Overhead, which is applied on the back of direct labor costs, is difficult. The controler's office estimated overhead costs at $3,600 for fed costs and 518 per unit for variable costs. Your colleague, Lance who graduated from a rival school, has already done the analysis and reports the correct cost equation as follows: Overhead = $10,600 - $16.05 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says. "With 82 percent of the variation in overhead explained by the equation. It certainly should be adopted as the best basis for estimating costs. When asked for the data used to generate the regression, Lance produces the following: Month Unit Production 3,048 Overhead $57.144 60,756 77.4e 56,412 81.396 72,252 3.000 1.40 3.928 3.316 4.016 73,596 77,772 GO,048 61.612 73.92 73.248 3.192 3. GS 4.00 3. The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee Cileck my work Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $45 per unit and that direct labor costs are $21 per hour. Estimating overhead. which is applied on the basis of direct labor costs, is difficult The controller's office estimated overhead costs at $3,600 for fixed costs and $18 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct cost equation as follows: Overhead = $10,600 - $16.05 per unit Lance also reports that the correlation coefficient for the regression is 0.82 and says. With 82 percent of the variation in overhead explained by the equation. It certainly should be adopted as the best basis for estimating costs." When asked for the data used to generate the regression, Lance produces the following: Overhead $57,144 60, 756 77,040 56,412 81,396 72,252 Unit Production 3,848 3,249 4,176 3.000 3, 408 3.928 3,336 4,016 4, 12e 3,192 3369 4.88 3.BR 63,852 73,596 77,772 68,848 61.632 71,920 73,249 The company controller is somewhat surprised that the cost estimates are so different. You have therefore been assigned to check Lance's equation. You accept the assignment with glee Required

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

Lead Auditor ISO 22000 2018 Food Safety Management Systems FSMS Course

Authors: Marius Hauta

1st Edition

B0BTSCBJ82, 979-8376159750

More Books

Students also viewed these Accounting questions