Prepare scattergraph and plot tons mined and utilities cost

Assignment Help Financial Accounting

Reference no: EM131201235

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: EM131201235

Questions Cloud

Enter the given transactions into t accounts : Transactions in a Manufacturer's Job Order Costing System.. - - Enter the given transactions into T accounts:

Graph the budget line in labor economics : How to find and graph the budget line in labor economics. Using marginal utility?

Equilibrium size of the innovation city : a. Suppose a group of 1 (thousand) workers form a city. Will other workers have an incentive to join the cluster? b. Suppose a group of 9 (thousand) workers form a city. Will other workers have an incentive to join the cluster? c. Compute the (stable..

What is the algebraic expression of the budget : Suppose a cup of coffee at the campus coffee shop is $2.50 and a cup of hot tea is $1.25. Suppose a student's beverage budget is $20 per week. What is the algebraic expression of the budget?

Prepare scattergraph and plot tons mined and utilities cost : Determine a cost formula for utilities cost using the least squares regression method. - Prepare a scattergraph and plot the tons mined and utilities cost.

Nearest vending machine decreases : In Retireland, no one commutes to work, and everyone consumes a single good (food), which is imported from another region and can be purchased (one meal at a time) from the nearest vending machine. Alternatively, food can be delivered by a distant..

What requirement of section 351 do they violate : Which of the following scenarios will qualify under Section 351 as a nontaxable corporate formation?- For those that do not qualify, what requirement of section 351 do they violate?

Find the rated torque rated volt amperes : A nameplate is given in Example 17.2. Find the rated torque, rated volt amperes, and maximum continuous output power for this motor.

Write a matlab program to compute the kalman gain : Write a MATLAB program gain.m to compute the Kalman gain K(n) for a stationary process with x(n) = Ax(n - 1) + w(n)

User Account

All Pages