Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

High-Low, Scattergraph, and Regression Analysis; Manufacturing Company. Kitchen Products, Inc., produces kitchen counter tops. Manufacturing overhead costs tend to uctuate from one month to the

image text in transcribed
High-Low, Scattergraph, and Regression Analysis; Manufacturing Company. Kitchen Products, Inc., produces kitchen counter tops. Manufacturing overhead costs tend to uctuate from one month to the next, and management would like to accurately estimate these costs for planning and decision-making purposes. The accounting staff at Kitchen Products recommends that costs be broken down into xed and variable components. Because the production process is highly automated, most of the manufacturing overhead costs are related to machinery and equipment. The accounting staff believes the best starting point is to review historical data for costs and machine hours: Reporting Period (Month) Total Costs Machine Hours January $278,000 1,550 February 280,000 1,570 March 266,000 1,115 April 290,000 1,700 May 262,000 1,110 June 269,000 1,225 July 275,000 1:335 August 286,000 1,660 September 250,000 1,000 October 253,000 1,020 November 260,000 1,025 December 281,000 1,600 These data were entered into a computer regression program, which produced the following output: Coefcients y~intercept 210,766 1: variable 45.31 Required: a. Use the four steps of the high-low method to estimate total xed costs per month and the variable cost per machine hour. State your results in the cost equation form Y = f + UK by lling in the dollar amounts for f and u. b. Use the ve steps of the scattergraph method to estimate total xed costs per month, and the variable cost per machine hour. State your results in the cost equation form Y = f + UK by lling in the dollar amounts for f and v. c Use the regression output given to develop the cost equation Y = f + UK by lling in the dollar amounts for f and v. d. Use the results of the high~low method (a), scattergraph method (b), and regression analysis (c), to estimate costs for 1,300 machine hours. (You will have three different answersone for each method.) Which approach do you think is most accurate and why? e. Management likes the regression analysis approach and asks you to estimate costs for 5,000 machine hours using this approach (the company plans to expand by opening another facility and hiring additional employees). Calculate your estimate, and explain why your estimate might be misleading

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

Financial Statement Fraud Prevention And Detection

Authors: Zabihollah Rezaee, Richard Riley

2nd Edition

0470543205, 9780470543207

More Books

Students also viewed these Accounting questions

Question

Where in the hiring process are you?

Answered: 1 week ago

Question

Explain all drawbacks of the application procedure.

Answered: 1 week ago

Question

Determine Leading or Lagging Power Factor in Python.

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago