Charlie Corporation's managers in the stamping department have been studying the overhead cost and the relationship with machine hours. The following are data from the most recent 12 months. Month Overhead Machine hours January  5,030 2,730 February 1,600 600 March 7,210 3,403 April 4,560 2,200 May 6,880 3,411 June 6,520 2,586 July 6,230 3,364 August 5,570 2,411 September 7,728 3,960 October 5,810 2,897 November 4,580 2,207 December 6,010 2,864 The manager of the department has requested a regression analysis of these two variables. The staff person performing the analysis decided to exclude February. She observed the volume of activity was very low for that month because of two factors: a severe flue outbreak and an electrical fire that disrupted operations for about 10 working days.   Required: c. Using the least square (regression) analysis, compute the fixed cost. d. Using the least square (regression) analysis, how much are the estimated overheads for 3,000 machine hours?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 23PPS
icon
Related questions
Question

Charlie Corporation's managers in the stamping department have been studying the overhead cost and the relationship with machine hours. The following are data from the most recent 12 months.

Month Overhead Machine hours
January  5,030 2,730
February 1,600 600
March 7,210 3,403
April 4,560 2,200
May 6,880 3,411
June 6,520 2,586
July 6,230 3,364
August 5,570 2,411
September 7,728 3,960
October 5,810 2,897
November 4,580 2,207
December 6,010 2,864

The manager of the department has requested a regression analysis of these two variables. The staff person performing the analysis decided to exclude February. She observed the volume of activity was very low for that month because of two factors: a severe flue outbreak and an electrical fire that disrupted operations for about 10 working days.

 

Required:

c. Using the least square (regression) analysis, compute the fixed cost.

d. Using the least square (regression) analysis, how much are the estimated overheads for 3,000 machine hours?

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL