break even, what if, high-low
Not what you're looking for?
High Low, Profit Equation [Lo 2] Rhetorix, Inc. produces stereo speakers. Each unit (a pair of speakers) sells for $900. Below is information on production/sales and costs for 2010.
Production and sales in unit Production costs Selling and Admin Costs
January 105 $88,860 $23,570
February 117 $97,600 $25,200
March 95 $83,007 $22,495
April 106 $89,600 $23,720
May 115 $96,200 $24,950
June 125 $103,500 $26,250
July 128 $105,670 $26,690
August 132 $108,550 $27,200
September 138 $112,978 $28,030
October 126 $104,200 $26,400
November 124 $102,750 $26,150
December 108 $91,050 $23,900
Total 1421 $1,183,965 $304,645
Average cost per unit $83,319,141 $21,438,776
Use the high low method to identify the fixed and variable cost components for both production costs and selling and administrative costs.
"B. The company estimates that production and sales in 2011 will be 1,550 units. Based on this estimate, forecast income before taxes for 2011.
Michael Bordellet is the owner/pilot of Bordellet Air Service. The company flies a daily round trip from Seattle's Lake Union to a resort in Canada. In 2007, the company reported an annual income before taxes of $4,100 although that included a deduction of $60,000 reflecting Michael's "salary".
Revenue $449,280
($360 x 1,248 passengers)
Less costs:
Pilot (owner's salary) $70,000
Fuel (35,657 gallons x $4.15) $147,977
Maintenance (variable) $127,920
Depreciation of plane $25,000
Depreciation of office equipment $2800
Rent expense $40,000
Insurance $20,000
Miscellaneous (fixed) $7500 441,197
Income before taxes $8,083
Revenue of $449,280 reflects six round trips per week for 52 weeks with an average of four passengers paying $360 each per round trip (6 x 52 x4 x $360= $449,280). The flight to the resort is 400 miles one way. With 312 round trips (6 per week x 52 weeks), that amounts to 249,600 miles. The plane averages 7 miles per gallon.
Required
a. How many round trips is Michael currently flying, and how many round trips are needed in total to break even?
b. How many round trips are needed so that Michael can draw a salary of $110,000 and still not show a loss?
c. What is the average before-tax profit of a round trip flight in 2010?
d. What is the incremental profit associated with adding a round trip flight?
Purchase this Solution
Solution Summary
Break even, what if and high low methods are analyzed.
Purchase this Solution
Free BrainMass Quizzes
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.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)