SITXFINO03 Assignment Activity 4 Joes Cafe Actual figures 2018/ 19 2018/19 Income July August September October November December January February March April May June Food sales Dinner 91 120 65120 57200 710020 Food sales TA 17010 16009 15150 18210 15150 10900 15720 14300 14150 15010 15100 192 710 Bew sales A 12730 11100 11700 12200 11900 13990 12190 10720 10050 9750 9650 10700 136 560 4730 THO 4170 30 480 Total 115 650 104,120 108030 110 70 120 540 125 580 112,000 99,490 93, 220 97 470 100.920 1,271,010 Food purchase 31-490 18720 19310 31190 10150 535, 232 Bev PurchiesA 5100 6500 6405 5950 5450 4750 63 60 SOUS 3100 62 310 Bev purchses NA 1650 1070 1400 1140 1790 2360 1730 1140 1320 1460 17,700 wages 41530 Supperannuation 4184 3759 377 3945 4237 3497 CAZE 43 714 7010 7000 7006 7030 Other 9270 8330 9011 9415 11300 10080 9450 8350 8070 9260 10100 113 986 Total 102.734 $5.079 98.350 105,144 108 032 190.134 93, 347 CEC RE 747 92.793 1,145 032 Net profit 13.146 9.091 10.258 12.210 15,416 17 528 11 866 ERT'S 7,282 6.195 8.723 8.177 126 032 Much of the work of monitoring finances within a budget is looking for trends and figures 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 obvious when you look at the results; relating figures to each other and expressing those figures 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 figures for 2018/ 19 from Joes Cafe; calculate some of the percentages and look deep into the figures for trends and numbers that don't seem quite right and warrant further investigation. 1. Identify a mistake in the superannuateon payments at the current rate. 2. Identify one positive trend over the year. 3. Identify three negative trends that are causing the trend to lower profitably 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 figures 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 profits of Joes cafe, if that 3%% saving was applied for the whole period of the budget? Savings value? New profit value? $% increase in profits. A rostering change in the way the roster is applied to waited in the cafe results in a saving of $250 per week in wages and a proportional decrease in superannuateon . What effect will this have on the profit of the cafe 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 figures and calculations to show the trend, mistake or areas of concern. This is a certificate IV unit so make sure your answers are detailed and presented in a professional manner appropriate for a person in a supervisory/management position Note: Give detailed answers to these questions and back up your answers with examples of figures and calculations to show the trend, mistakes, or areas of concern. This is a certificate IV unit so make sure your answers are detailed and presented in a professional manner appropriate for a person in a supervisory/management position