Explore BrainMass

Explore BrainMass

    Cost Behviour, High-Low Method

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. High -Low Method; Scattergraph Analysis (LO2, LO3)

    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 Total Shipping
    Shipped 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

    1. Using the high-low method, estimate the cost formula for shipping expense.
    2. The president has no confidence in the high-low method and would like you to "check out" your results using the scattergraph method. Do the following:
    a. Prepare a scattergraph, using the data given above. Plot cost on the vertical axis and activity on the horizontal axis. Fit a straight line to your plotted points using a ruler.
    b. Using your scattergraph, estimate the approximate variable cost per unit shipped and the approximate fixed cost per month with the quick-and-dirty method.
    3. What factors, other than the number of units shipped, are likely to affect the company's
    shipping expense? Explain.

    2. Cost Behavior; High-Low Method (LO1, LO3)

    Speedy Parcel Service operates a fleet of delivery trucks in a large metropolitan area. A careful study by the company's cost analyst has determined that if a truck is driven 120,000 miles during a year, the average operating cost is 11.6 cents per mile. If a truck is driven only 80,000 miles during a year, the average operating cost increases to 13.6 cents per mile.

    Problem:

    1. Using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation.

    2. Express the variable and fixed costs in the form y = a + bX.

    3. If a truck were driven 100,000 miles during a year, what total cost would you expect to be incurred ?

    © BrainMass Inc. brainmass.com March 6, 2023, 2:43 pm ad1c9bdddf
    https://brainmass.com/business/accounting/cost-behviour-high-low-method-103794

    Solution Preview

    1. High -Low Method; Scattergraph Analysis (LO2, LO3)

    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 Total Shipping
    Shipped 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

    1. Using the high-low method, ...

    Solution Summary

    The solution explains how to calculate the fixed and variable cost using the high low method

    $2.49

    ADVERTISEMENT