Activity 4 The following budget was created at the beginning of the 2018/19 financial year. In November of 2018 you were informed that in January/February/March of 2019 there will be major road works in your area which will affect your customers and your business. The road works will be for 8 weeks (the last two weeks of January, the four weeks of February and the first two weeks of March). You need to make plans for this period and adjust your budget accordingly as you anticipate losing 25% of business for those eight weeks and 10% of business for the two weeks after the road works. Develop and present a new budget for January, February and March 2019 and indicate what changes you will make to keep the budget on track as much as you can. N. B. Remember to present your assignment in a clear and professional manner that would be suitable for use in a business. Omars Indian Restaurant 2018/19 - Original Budget- Assignment 2 September October November December January February March April May 2018/19 Income Food sales Dinner Food sales TA Bev sales A July August June 72800 93600 88400 83200 93600 114400 72800 78000 104000 93600 83200 62400 1,040,000 20384 26208 24752 23296 26208 32032 20384 21840 29120 26208 23296 17472 291,200 13104 16848 15912 14476 16848 20592 13104 14040 18720 16848 14476 11232 186,200 Bev sales NA 5824 7488 7072 6656 7488 9152 5824 6240 8320 7488 6656 4992 83,200 Total 112,112 144,144 136,136 127,628 144,144 176,176 112,112 120,120 160,160 144,144 127,628 96,096 1,600,600 Food purchases 28000 36000 34000 32000 36000 44000 28000 30000 40000 36000 32000 24000 400,000 Bev Purchses A 5236 6732 6358 5984 6732 8228 5336 5610 7480 6732 5984 4488 74,900 Bev purchses NA 2093 2691 2541 2392 2691 3289 2093 2242 2990 2691 2392 1794 29,899 Wages 42602 54774 51731 48688 54774 66946 42602 45645 60860 54774 48688 36516 608,600 Supperannuation 42602 5204 4914 4625 5204 6360 4047 4336 5782 5204 4625 3469 96,372 Rent 8666 8666 8666 8666 8666 8666 8666 8666 8666 8666 8666 8666 103,992 Other Total 9450 12150 11475 10800 12150 14850 9450 10125 138,649 126,217 119,685 113,155 126,217 152,339 100,194 106,624 13500 12150 139,278 126,217 10800 8100 135,000 113,155 87,033 $1,448,763 Net profit -26,537 17,927 16,451 14,473 17,927 23,837 11,918 13,496 20,882 17,927 14,473 9,063 151,837