Write a report of 100-150 words, on financial data below giving detailed answers to these questions and back up your answers with example figures and calculations to show the trend and mistake or areas of concern. You are also asked to give suggestion for correction to the budget

  • Case Study

 

Below are the actual figures for Walters Restaurant for the last six months.

You are to investigate the figures for trends and for any figures that appear to not be correct.

 

July August September October November December Total
Income
Sales of food 63,525 61,525 60,258 59,125 58,656 55,562
Sales of Alcohol 22,630 22,634 23,653 24,526 25,851 26,861
Coffee 10,946 10,856 10,895 11,856 9,456 10,512
Total income 97,101 95,015 94,801 95,507 93965 92,935
Expenses
Food Purchases 30,654 31,324 29,586 33,076 31,657 30,285
Alcohol Purchases 10,213 10,583 12,682 13,694 14,896 15,854
Wages 20,856 19,856 18,956 20,859 25,532 26,859
Superannuation 1,929 1836 1753 1929 2,361 2,484
Rent 2,000 2,000 2,000 2,000 4,000 2,000
Other 13,125 13,563 13,221 13,681 14,874 12,980
Total Expenses 78,777 79,192 78,198 85,239 93,320 90,462
Net profit/loss 18,324 15,853 16,603 10,268 -645 -2473

 

  1. Identify possible error in expenses
  2. Identify one positive trend in the figures
  3. Identify three negative trends in the figures that are causing lower profits as the month pass.
  4. Study the alcohol purchases for the six months discuss any concerns you have and outline some possible causes for these results
  5. Write a report of 100-150 words, on financial data below giving detailed answers to these questions and back up your answers with example figures and calculations to show the trend and mistake or areas of concern. You are also asked to give suggestion for correction to the budget.

 

The report is to be presented in a professional manner with all details such as subject,

Date and student’s name.