Question

In: Accounting

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

QUESTION 3 Regression Analysis

Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d

Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data 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 costs based on machine hours (MH), what would be the estimated support overhead costs (to the nearest $) for a month in which 3,000 machine hours were used?

(b)Using Excel, perform three regression analyses to regress Overhead Cost against Machine Hours, then against Batches, then against both of them simultaneously. Paste your results into Word. State the cost equation from each. Analyse and comment on the results of each regression as you perform it and determine the best one 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 projected Overhead Cost in a month in which there were 2000 machine hours worked and 150 batches produced.

Solutions

Expert Solution

a)
High Low method
Step 1 Machine Hours Cost of utilities
High Month 6 3800 $48,000.00
Low Month 8 1800 $46,000.00
Difference 2000 $2,000.00
Step - 2 Variable cost per Machine hour = $815/92 $1.00
Fixed Cost
June = $48,000 - ($1 x 3800) $44,200.00
July = $46,000 - ($1 x 1800) $44,200.00
Step -3 Fixed Cost per month $44,200.00
Total Cost = $44200 + ($1 x Machine Hours)
Total Cost = $44200 + ($1 x 3000) $47,200.00
b)
x = Maintenance ; y = Machine Hours
y = mx + b.
Slope (m) -$2.30
Intercept (b) $59,198.78
Y = $-2.30 X + $59,198.78
x = Maintenance ; y = Batches
y = mx + b.
Slope (m) $234.57
Intercept (b) $6,555.56
Y = $234.57 X + $6555.56
c)
Batches variable works best because its fixed cost is less than the machine hours variable though variable cost per unit is very high as compared to negative in case of machine hours and its not practical to have negative variable cost per unit
d)
Y = $-2.30 X + $59,198.78
Y = $-2.30 x 2000 + $59,198.78 $54,590.02
Y = $234.57 X + $6555.56
Y = $234.57 x 150 + $6555.56 $41,740.74

Related Solutions

QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
QUESTION 4 CVP Analysis Guide to marks: 20 marks – 4 for a, 4 for b,...
QUESTION 4 CVP Analysis Guide to marks: 20 marks – 4 for a, 4 for b, 4 for c, 8 for d Show all calculations to support your answers. A manufacturer can make two products, A and B. The following data are available:B Product A B Total Sales price per unit $12 $15 Variable cost per unit $8 $10 Total fixed costs/month $5000 (a)Calculate the unit contribution margin for each product. (b)This month the manufacturer will specialise in making only...
QUESTION 3 (20 MARKS) QUESTION 3 (20 MARKS) An analysis of the Business School graduates found...
QUESTION 3 QUESTION 3 An analysis of the Business School graduates found that 210 out of 318 randomly selected graduates used An analysis of the Business School graduates found that 210 out of 318 randomly selected graduates used  a statistical inference technique during their first year of employment.a statistical inference technique during their first year of employment. (a) Calculate a 90% confidence interval for the proportion of graduates who used a statistical inference (a) Calculate a 90% confidence interval for the...
Question 3 (10 marks) A student used multiple regression analysis to study how family spending (y)...
Question 3 A student used multiple regression analysis to study how family spending (y) is influenced by income (x1), family size (x2), and additions to savings (x3). The variables y, x1, and x3 are measured in thousands of dollars. The following results were obtained. ANOVA df SS Regression 3 45.9634 Residual 11 2.6218 Total Coefficients Standard Error Intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 Write out the estimated regression equation for the relationship between the variables....
QUESTION 3: SYSTEM CONFIGURATION [5+5 = 10 Marks] a) Be aware of the options available for...
QUESTION 3: SYSTEM CONFIGURATION [5+5 = 10 Marks] a) Be aware of the options available for setting password requirements under Windows, as well as the options available under Linux. Discuss good and bad practices for setting passwords and why administrators may enforce logon hours and logon locations for Windows users. [5 Marks] b) Explain what Multi Factor Authentication (MFA) is – a method of authentication which requires a user to supply two or more types of authentication drawn from these...
Question C [SD1: 5 Marks]             A multiple regression analysis between yearly income (Y in $1,000s),...
Question C [SD1: 5 Marks]             A multiple regression analysis between yearly income (Y in $1,000s), college grade point average (X1), age of the individuals (X2), and the gender of the individual (X3; zero representing female and one representing male) was performed on a sample of 10 people, and the following results were obtained. Coefficients Standard Error Intercept   4.0928 1.4400     X1 10.0230 1.6512     X2   0.1020 0.1225     X3 -4.4811 1.4400 ANOVA DF SS MS F Regression 360.59 Residual...
Correlation and Regression Analysis Question 2                  (6 marks) The marks in a Physics exam (P) and...
Correlation and Regression Analysis Question 2                  The marks in a Physics exam (P) and a Chemistry exam (C) were recorded for 15 students: Physics 25 46 63 45 78 18 84 48 73 50 61 89 38 36 30 Chemistry 31 44 58 49 66 12 61 56 70 57 62 56 29 40 38 Draw a scatter diagram and comment. Find the regression line where the Chemistry mark is the explanatory variable and the Physics mark is the response...
Question 3: Variance Analysis (20 marks in total) The following standard cost data relate to the...
Question 3: Variance Analysis (20 marks in total) The following standard cost data relate to the operation of Dragon Company for 2016. The standard cost per unit is based on the normal annual production of 15,000 units. Standard cost per unit Direct materials 4kg @ $5.00 per kg $ 20.00 Direct labour 2hrs @ $12.50 per hr $ 25.00 Variable overhead 2hrs @ $3.00 per hr $ 6.00 Fixed overhead 2 labour hrs @ $5.00 per hr $ 10.00 Total...
QUESTION 1 (10 Marks- 5 each)- This question contains two sub questions a and b. Describe...
QUESTION 1 (10 Marks- 5 each)- This question contains two sub questions a and b. Describe five requirements of the COBIT framework. Compare the followings in terms of capacity, expenses, processing power, size and users they support: Supercomputers Mainframe Computers Comparison Element Supercomputers Mainframe Computers
Question 1 Required: a) . Discuss the objective of financial statement analysis. (5 Marks) b) Do...
Question 1 Required: a) . Discuss the objective of financial statement analysis. b) Do you think financial reporting plays any role in the capital markets? Explain in your own words. c) . Why do you think it is important to review the strategy of a company before and after completing a financial statement analysis? Explain. d). The following note appears in the financial statements of a company: “The financial statements have been prepared on the historical cost basis, except for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT