Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wilkens Company Wilkens Company wants to determine the cost behavior pattern of maintenance costs. Wilkens has decided to use linear regression by employing the equation

Wilkens Company Wilkens Company wants to determine the cost behavior pattern of maintenance costs. Wilkens has decided to use linear regression by employing the equation y = a + bx for maintenance costs. The prior year's data regarding maintenance hours and costs, are given in the data below.

Hours of Activity Maintenance cost
January 490 5,700
February 325 4,210
March 425 5,050
April 360 4,510
May 500 5,680
June 450 5,260
July 425 5,050
August 375 4,630
September 470 5,420
October 485 5,550
November 365 4,550
December 350 4,250
total 5,020 59,860

1a. Solve for A and B variable provide the graph (scatter gram) show trend line, formula, and R-Squared.

A

B

"R-SQUARED"

1b. Refer to the Wilkens Company. Based upon the data derived from the regression analysis, what maintenance costs should be budgeted for a month in which 485 maintenance hours will be worked?

1c. Refer to the Wilkens Company. What is the percentage of the total variance that can be explained by the regression equation?

1d. What is meant by cost behavior? Explain how it relates to the following terms: fixed, variable, and mixed cost.

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

Operational Profitability Conducting Management Audits

Authors: Robert M. Torok, Patrick J. Cordon

1st Edition

0471172251, 978-0471172253

More Books

Students also viewed these Accounting questions

Question

Explain what is meant by the terms unitarism and pluralism.

Answered: 1 week ago