Purchase Solution

Break-Even Point Questions for Flecker Vending and Morgan Tool

Not what you're looking for?

Ask Custom Question

Using an Excel spreadsheet (see attached file), complete Problems 1 & 2 below.

Problem 1 - Flecker Vending Company

Flecker Vending Company operates and services snack vending machines located in restaurants, gas stations, and factories in four northwestern states. The machines are rented from the manufacturer. In addition, Flecker must rent the space occupied by its machines. The following expense and revenue relationships pertain to a contemplated expansion program of 45 machines.

Fixed monthly expenses follow:

Machine rental: 45 machines @ $46.50 $2,093
Space rental: 45 locations @ $25.00 1,125
Part-time wages to service the additional 45 machines 1,200
Other fixed costs 350
Total monthly fixed costs $4,768

Other data follow:
Per Unit Per $100 of Sales
Selling price $1.00 100%
Cost of snack .75 75
Contribution margin $ .25 25%
Required:

These questions relate to the above data unless otherwise noted. Consider each question independently.

1. What is the monthly break-even point in number of units? In dollar sales?

2. If 30,000 units were sold, what would be the company's net income?

3. If the space rental cost were doubled, what would be the monthly break-even point in number of units?
In dollar sales?

4. If, in addition to the fixed rent, Delgado Food Services Company paid the vending machine manufacturer $.02 per unit sold, what would be the monthly break-even point in number of units? In dollar sales? Refer to the original data.

5. If, in addition to the fixed rent, Delgado paid the machine manufacturer $.04 for each unit sold in excess of the break-even point, what would the new net income be if 30,000 units were sold? Refer to the original data.

Problem 2 Morgan Tool Company

Chico Ruiz, president of Morgan Tool Co., has asked for information about the cost behavior of manufacturing support costs. Specifically, she wants to know how much support cost is fixed and how much is variable. The following data are the only records available:

Month Machine Hours Support Costs
May 900 $ 9,200
June 1,350 12,500
July 990 8,000
August 1,250 11,000
September 1,800 14,000
Required:

1. Find monthly fixed support cost and the variable support cost per machine hour by the high-low method.

2. Explain how our analysis for Requirement 1 would change if new October data were received and machine hours were 1,700 and support costs were $15,800.

Purchase this Solution

Solution Summary

Break-even point for Flecker Vending and Morgan Tools are examined in the solution.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
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.

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.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.