Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / High-Low Method; Scattergraph Analysis LO4 Zerbel Company a wholesaler of large custom-bui...

High-Low Method; Scattergraph Analysis LO4 Zerbel Company a wholesaler of large custom-built air conditioning units for commercial buildings has noticed considerable fluctuation in its shipping

High-Low Method; Scattergraph Analysis [LO4]

Zerbel Company, a wholesaler of large, custom-built air conditioning units for commercial buildings, has noticed considerable fluctuation in its shipping expense from month to month, as shown below:

 

 

Month

Units Shipped

Total Shipping Expense

January . . . . . . . . . .

4

$2,200

February . . . . . . . . .

7

$3,100

March . . . . . . . . . . . .

5

$2,600

April . . . . . . . . . . . .

2

$1,500

May . . . . . . . . . . . . .

3

$2,200

June . . . . . . . . . . . . .

6

$3,000

July . . . . . . . . . . . . . .

8

$3,600

 

Required:

1.       Prepare a scattergraph using the data given above. Plot cost on the vertical axis and activity on the horizontal axis. Is there an approximately linear relationship between shipping expense and the number of units shipped?

 

 

 

 

 

2.       Using the high-low method, estimate the cost formula for shipping expense. Draw a straight line through the high and low data points shown in the scattergraph that you prepared in requirement 1. Make sure your line intersects the axis.

3.       Comment on the accuracy of your high-low estimates assuming a least-squares regression analysis estimated the total fixed costs to be $1,010.71 per month and the variable cost to be

$317.86 per unit. How would the straight line that you drew in requirement 2 differ from a straight line that minimizes the sum of the squared errors?

4.       What factors, other than the number of units shipped, are likely to affect the company’s ship- ping expense? Explain.

Jun 28 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions