Prepare a scattergraph and plot the tons mined and

Reference no: EM13591881

Company's cost analysis has concluded that utilities cost is a mixed cost, and they are attempting to find a base which the cost might be closely correlated.

Quarter: Tons Mixed Direct Labor 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

Using tons mined as the independent x variable:
1.Determine a cost formula for utilities cost using the least squares regression method.
2. Prepare a scattergraph and plot the tons mined and utilities cost. (place cost on the vertical axis and tons mined on the horizontal axis) Fit a straight line to the plotted points using the cost formula determined by (1)

3. Using the direct labor hours as the independent (x) variable, repeat the computations in (1) and (2) above
4.WOuld you recommend that the company use tons mined or direct labor hours as a base for planning utilities cost?

Reference no: EM13591881

Questions Cloud

On april 3 2011 terry purchased and placed in service a : on april 3 2011 terry purchased and placed in service a building. the building cost 2 million. an appraisal

O november 4 2009 blue company acquired an asset 275-year : on november 4 2009 blue company acquired an asset 27.5-year residential real property for 200000 for use in its

Western acquires used office machine seven-tear class asset : western acquires used office machine seven-tear class asset on november 2 2011 for 75000. this is the only asset

Gz inc manufactures two products that require both machine : gz inc. manufactures two products that require both machine processing and labor operations. although there is

Prepare a scattergraph and plot the tons mined and : companys cost analysis has concluded that utilities cost is a mixed cost and they are attempting to find a base which

The following data has been taken from the management : the following data has been taken from the management accounting reports from spinnaker sales. div a -income from

The equity of webster corporations balance sheet shows the : the equity of webster corporations balance sheet shows the following preferred stock-- 5 cumulative 10 par value 15

What are the five basic principles of cash management that : the oxford company has budgeted sales revenues as follows july august september credit sales 30000 24000 18000 cash

The key criterion for qualifying as a hedge is that the : the key criterion for qualifying as a hedge is that the hedging relationship must be highly effective in achieving

User Account

All Pages