Purchase Solution

High Low method, Sensitivity analysis, operating leverage, break even

Not what you're looking for?

Ask Custom Question

Bonkers, Inc. makes highly processed and sugary cereals for people that don't care
about their health. One of their costs is shipping of their products. In the year 2010
Bonkers incurred the following shipping costs:

MONTH NUMBER OF TONS SHIPPED COST

January 1,000 $225,000
February 1250 $235,000
March 1750 275,000
April 2250 320000
May 3000 330000
June 3500 345000
July 3450 350000
August 3300 343000
September 2750 315000
October 2000 255,000
November 1500 245,000
December 1250 240,000

Bonkers would like to know if you can come up with a cost formula to show its
management how much of its cost is fixed and how much is variable, or if it WORK SPACE
is even possible to do this. Using the high-low method, determine the
fixed cost and variable cost per ton to ship Bonkers cereas. Then
enter a cost formula in the form Y =a+bx Leave no spaces between the variables.
Looking at the other months and costs of shipping, do you think that the
high-low cost formula you calculated in 1 above is accurate?

1) VARIABLE 1
FIXED 2
COST FORMULA 3

word bank
yes
2) 4 no

Attachments
Purchase this Solution

Solution Summary

The expert examines high low method, sensitivity analysis and operating leverages.

Solution Preview

Please see the attachment. Please see the cell formula for calculation details.

High Low Method - We take the highest and the lowest values. Highest is June 3,500 and lowest in Jan 1,000
The variable cost is calculated as (change in cost)/(change in units)
Fixed cost = Total cost - Total variable cost
Cost function = Fixed cost + variable cost ...

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.