Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the variable- and fixed-cost elements using regression analysis. Present your solution in Data Analytics Problem Sp21 Data for Beaver Corporation's maintenance costs is shown

image text in transcribed
Compute the variable- and fixed-cost elements using regression analysis. Present your solution in Data Analytics Problem Sp21 Data for Beaver Corporation's maintenance costs is shown below. Units Produced Total Cost July 18,000 $32,000 August 32.000 $18,000 September 36.000 $55.000 October 22,000 $38,000 November 40,000 566,100 December 38.000 562.000 Required: the form of a cost equation. (Please use the intercept and Slope fictions in Excel) Maintenance costs Intercept Slope Please see the Excel spreadsheet in the D2L "Content" aren if you need help in setting this problem up. Thank you. Solution Using regression analysis in Excel the intercept and slope are: Intercept: Slope: 4836.39 1.46281 The cost equation is: Total cost $4.836.39 +$1.46281 per unit produced

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

Managerial Accounting

Authors: Harold M. Sollenberger, Arnold Schneider, Lane K. Anderson

9th Edition

0538842822, 978-0538842822

More Books

Students also viewed these Accounting questions

Question

What will be the impacts of future wars and terrorism?

Answered: 1 week ago