Purchase Solution

Flex-Budget

Not what you're looking for?

Ask Custom Question

Using the attached data and format from the budget tab create a flex-budget for the month of July using 3 or 4 different planned units of sales. Base your assumptions on several different factors:

* The trends in actual sales shown at the bottom of the Budget tab
* The activity levels needed to turn a profit since the June actual figures resulted in a loss, and
* The likelihood of achieving different levels of unit sales

Purchase this Solution

Solution Summary

Your tutorial created 25 different flexible budgets for July. This gives the student a sensitivity analysis and shows when the sales "toggle" to break even from June's loss levels. June's actual prices, actual sales quantity and actual materials and labor costs were used instead of budget to give a more realistic forecast for July. An estimate is given when the firm might breakeven given the current growth rates in sales of the two products. The solution provides the flexible budget using the format given and also in a contribution margin format for comparison and study.

Solution Preview

See attached for your flexible budget computations and discussion.

Given that June was a loss, I decided to use the June actual sales prices and cost of materials and labor to make the July flexible budgets more realistic. I also started the flex budget at June actual activity levels and then increased mid-grade by 1% and high end by 2% increments. That is the budget percent increases for each product. I updated only one ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


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

Balance Sheet

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

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basic Social Media Concepts

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