Purchase Solution

Green Restaurant: Breakeven and target profit

Not what you're looking for?

Ask Custom Question

(Use the financial statements provided below to compute the percentages for all items included in the income statement sheet as a percent of revenue. Remember that total revenue is always 100 percent. Be sure to use the formula function in Microsoft Excel to show the formulas for each of the percentage you compute. After completion, compute the following: (Attached below is the financial statements (Income Statement and Balance sheet) to compute the percentages for all items included in the income statement sheet as a percent revenue.)
•CVP analysis with the following assumptions:
•Contribution margin
•Contribution margin ratio
•Current variable costs
•Fixed costs
•BEP
In addition, analyze and compute the sales figure forecast in case the owner of The Green Restaurant wants to generate a 15 percent increase in net income before taxes are deducted for the same period next year. Explain the strategies you used for computing the sales figure forecast to generate 15 percent increase in net income before tax deduction for the next year. Then in a Word document, forecast a strategy to increase the net income for the next financial year by 15 percent. Your strategy should help you to decide whether expenses on a particular item need to be decreased or more money can be invested in another item to get better net income.

Purchase this Solution

Solution Summary

See breakeven in sales given assumption and breakeven sales to achieve the new target income (15% increase) in Excel attached. Click in cells to see computations. You discussion gives you five ideas to increase profits and a discussion of how they might work.

Solution Preview

See breakeven in sales given assumption and breakeven sales to achieve the new target income (15% increase) in Excel attached. Click in cells to see computations. You discussion gives you five ideas to increase profits and a discussion of how they might work.

Green Restaurant
Strategy to Increase Before Tax Profits 15 percent

In order to increase profits by 15%, you need to earn $13,322.75 (a 15% increase over current profits). There are a number of potential changes that could help you achieve this goal.

1. Increase sales prices. ...

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
Balance Sheet

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

Lean your Process

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

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.