The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
EXERCISE 3A–2 Least-Squares Regression [LO4]                                                              Â
The Hard Rock Mining Company is developing cost formulas for management planning and  de-
cision making. The company’s cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base with which the cost might be closely correlated. The controller has
Â
Â
100Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Chapter 3 Cost Behaviour: Analysis and Use
Â
suggested that tonnes mined might be a good base to use in developing a cost formula. The pro- duction manager disagrees; she thinks that direct labour-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information:
Â
|
 Quarter |
Tonnes Mined |
Direct Labour-Hours |
Utilities Cost |
|
Year 1: |
 |
 |
 |
|
First |
15,000 |
5,000 |
$50,000 |
|
Second |
11,000 |
3,000 |
45,000 |
|
Third |
21,000 |
4,000 |
60,000 |
|
Fourth |
12,000 |
6,000 |
75,000 |
|
Year 2: |
 |
 |
 |
|
First |
18,000 |
10,000 |
$100,000 |
|
Second |
25,000 |
9,000 |
105,000 |
|
Third |
30,000 |
8,000 |
85,000 |
|
Fourth |
28,000 |
11,000 |
120,000 |
Â
1.             Using tonnes mined as the independent (X) variable:
a.       Determine a cost formula for utilities cost using the least-squares regression method. Calculate the R2 as part of your analysis.
b.       Prepare a scattergram and plot the tonnes mined and utilities cost.
2.             Using direct labour-hours as the independent (X) variable, repeat the computations in 1(a) and (b) above.
3.             Would you recommend that the company use tonnes mined or direct labour-hours as a base for planning utilities cost?
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll