Assignment Activity 4

Much of the work of monitoring nances within a budget is looking for trends and gures that are out of the ordinary in the actual results of the business. Trends in past results give you indications of possible future results in the business. These trends are often not instantaneously visible when you look at the results; relating gures to each other and expressing those gures as a percentage of each other may uncover a hidden trend in the income or expenses of a business. Take a close look at the actual gures for 2018/19 from Joes Cafe; calculate some percentages and look deep into the gures for trends and numbers that don't seem quite right and warrant further investigation.

1.Identify a mistake in the superannuation payments.

2.Identify one positive trend over the year.

3.Identify three negative trends that are causing the trend to lower protably as the year went on.

4.Take a good look at the alcoholic beverage purchases and outline any areas of concern. Outline some possible causes of the alcoholic beverage purchases gures to be that way.

5.If discussions and negotiations with existing or new suppliers, could bring about a 3% saving in food purchases, what effect would this have on the prots of Joe's cafe, if that 3% saving was applied for the whole period of the budget? Saving value? New prot value? % increase in prots.

6.A rostering change in the way the roaster is applied to waited in the caf results in a saving of$250 per week in wages and a proportional decrease in superannuation. What effect will this have on the profit of the caf if applied to the whole budget period? Savings value? New profit value? %Increase in profits.

Give detailed answers to these questions and back up your answers with examples of gures and calculations to show the trend, mistake or areas of concern.

Joes Cafe 2018/19 Actual figures July Aug Sep Oct Nov Dec Jan Feb Mar April Ma June 20012/13 Income Food Sales -din 81 40 73 020 75 250 79 300 87 200 91 320 73 200 68 100 65 120 $7200 69 000 71 000 191 110 Food Sales (TA) 17 010 16 290 16 02 15 250 18 210 15 150 19 900 15 720 14 800 14 250 15 010 15 100 192 710 Bev Sales (A) 12 750 12 20 1 1 930 13 900 12 150 10 72 10 050 9 750 9 650 10 NIX 136 660 Bev Sales (NAY 1720 3 710 1 950 3 250 3 790 3810 50 580 Total 115 880 104 120 106 020 110 760 120 560 125 580 |112 060 99 490 93 220 84 990 97 470 100 970 1 271 060 Expenses Food Purchases 31 490 28 57 28 750 29 310 52 67 133 005 31 190 28 STA 10 150 355 122 Bew Purcha 6:500 6/405 $ 950 8 023 3 900 1 860 4 280 62 210 Bey Puch (NA) 1650 1 070 1400 730 460 Wages 14 040 39 570 39 750 41 530 40 38C 56 810 35 560 134 600 36 350 68 120 1759 3 945 3 496 188 43 780 Rent 7000 17090 1:000 LOOK 000 7900 84 090 Other 9270 8530 901 9415 0850 10 080 9450 8 070 9:260 100 1 13 986 Total 102 733 95 029 95 762 8 550 105 144 108 052 100 133 93 340 NS 938 78 791 28 74T 91 793 1 145 018 Net Profit 13 147 19 091 140 258 12 210 15 416 17 528 11 867 6141 7 282 6 199 8 723 8 177 126 012 Page: 4 of 6 Words 941 6 English (United States) 130 100% Q~FENG 9:19 PM B/25/2020