Budgets + Planning
Home
Home
     
 
 

Challenges


Quiz:


Download:

Download the spreadsheet that shows a budget forecast for Burger's n Sauce Ltd, a small burger-bar. Complete it by adding the total budgeted expenditure for each month.

Produce a chart to show the expected sales levels.

  1. Why do you think the projected sales levels are different for different months?
  2. The personnel budget includes wages. Why do you think it varies over the year?
  3. At the end of 2001, there was a new scare about the safety of beef. This had an impact on sales throughout 2002 which, for each month, were £100,000 below the budgeted amount. What impact will this have on the performance of the business (use the figures from the budget).
  4. Suggest some strategies that the business could employ for 2003 to improve the financial performance of the business. Consider marketing, production and personnel. What are the advantages and disadvantages of your suggested strategies?

Files:
Excel 95 spreadsheet
CSV format
To download, right-click on the link and choose 'Save Target As...'


 
 
     
Purpose | Challenges