Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mac Renovations has been using the home's interior square feet as his cost driver in estimating costs. It was brought to his attention that a

Mac Renovations has been using the home's interior square feet as his cost driver in estimating costs.
It was brought to his attention that a home's external openings might be a better cost driver in estimating costs.
The following data was gathered from the last 12 houses he had painted.
HouseSquare FeetOpeningsCosts
12,5007$ 2,810
23,15012$ 3,742
32,8008$ 3,100
42,8508$ 3,150
54,75016$ 4,700
62,9508$ 3,225
72,7007$ 2,920
82,5506$ 2,836
92,6007$ 3,242
103,70013$ 4,112
112,6507$ 3,210
123,55012$ 3,965
Compute the scattergraph, the total cost equation, and the r-squared for
each cost driver in estimating costs.
Which cost driver is better and why?
(check figure: square feet variable costs = .86 and openings fixed costs = 1,750.76)

Step by Step Solution

3.47 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

EXCEL output Costs 5000 450... 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

Cost Management A Strategic Emphasis

Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins

6th Edition

78025532, 978-0077523732, 77523733, 978-0078025532

More Books

Students also viewed these General Management questions

Question

Explain how humanistic therapists use the technique of reflection.

Answered: 1 week ago