QUESTION 3 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...

90.2K

Verified Solution

Question

Accounting

QUESTION 3 Regression Analysis
Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 ford
Belinda, the accountant at Murray Manufacturing Company wants toidentify cost drivers for support overhead costs. She has theimpression that the staff spend a large part of their time ensuringthat the equipment is correctly set up and checking the first unitsof production in each batch. Deborah has collected the followingdata for the past 12 months:
Month OH Cost MH Batches
1 $80,000 2,200 300
2 40,000 2,400 120
3 63,000 2,100 250
4 45,000 2,700 160
5 44,000 2,300 200
6 48,000 3,800 170
7 65,000 3,600 260
8 46,000 1,800 160
9 33,000 3,200 150
10 66,000 2,800 210
Total
530,000
26,900 1,980
(a)Using the high-low method to estimate support overhead costsbased on machine hours (MH), what would be the estimated supportoverhead costs (to the nearest $) for a month in which 3,000machine hours were used?
(b)Using Excel, perform three regression analyses to regressOverhead Cost against Machine Hours, then against Batches, thenagainst both of them simultaneously. Paste your results into Word.State the cost equation from each. Analyse and comment on theresults of each regression as you perform it and determine the bestone to use as a basis for future use.
(c)If you had to settle for the results of a simple regression,which one would you use and why?
(d)Using the best regression result determine the projectedOverhead Cost in a month in which there were 2000 machine hoursworked and 150 batches produced.

Month	OH Cost	MH	Batches
1	$80,000	2,200	300
2	40,000	2,400	120
3	63,000	2,100	250
4	45,000	2,700	160
5	44,000	2,300	200
6	48,000	3,800	170
7	65,000	3,600	260
8	46,000	1,800	160
9	33,000	3,200	150
10	66,000	2,800	210
Total	530,000	26,900	1,980

Answer & Explanation Solved by verified expert

3.9 Ratings (567 Votes)

a High Low method Step 1 Machine Hours Cost of utilities High Month 6 3800 4800000 Low Month 8 1800 4600000 Difference 2000 200000 Step 2 Variable cost per Machine hour See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

QUESTION 3 Regression AnalysisGuide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 fordBelinda, the accountant at Murray Manufacturing Company wants toidentify cost drivers for support overhead costs. She has theimpression that the staff spend a large part of their time ensuringthat the equipment is correctly set up and checking the first unitsof production in each batch. Deborah has collected the followingdata for the past 12 months:MonthOH CostMHBatches1$80,0002,200300240,0002,400120363,0002,100250445,0002,700160544,0002,300200648,0003,800170765,0003,600260846,0001,800160933,0003,2001501066,0002,800210Total530,00026,9001,980(a)Using the high-low method to estimate support overhead costsbased on machine hours (MH), what would be the estimated supportoverhead costs (to the nearest $) for a month in which 3,000machine hours were used?(b)Using Excel, perform three regression analyses to regressOverhead Cost against Machine Hours, then against Batches, thenagainst both of them simultaneously. Paste your results into Word.State the cost equation from each. Analyse and comment on theresults of each regression as you perform it and determine the bestone to use as a basis for future use.(c)If you had to settle for the results of a simple regression,which one would you use and why?(d)Using the best regression result determine the projectedOverhead Cost in a month in which there were 2000 machine hoursworked and 150 batches produced.