MacBook Pro Food Food |Bev Actual Budget SITXFINO03 Manage finance within a budget Income Sales Food Sales -din (TA) ev Sales Sales Bev Supera A) (NA) Total Expen Purchase Bev Purchurch nnuatio Week 1 nses s (a ) ( NA ) Wages In Rent Other Total Net Profit 62 400 17 472 Week 2 11 232 4992 96 096 Week 3 83 200 23 296 14 476 6 656 24 000 4 488 1 794 36 516 3286 8666 8100 86 850 9 246 127 628 32 000 5 984 Week 4 93 600 26 208 16 848 7 488 2 392 48 688 4 381 8666 10 800 112911 14 717 104 000 144 144 Week 5 29120 18 720 36 000 6732 8 320 2 691 54 774 4929 8666 12 150 125 942 18 202 160 160 7 480 2990 60 860 5 477 8666 13 500 138 973 21 187 Week 6 78 000 21 840 14 040 6 240 40 000 120 120 30 000 Week 7 72 800 20 384 13 104 5 824 112112 5 610 2 242 45 645 4 107 8 666 10 125 106 395 13 725 28 000 5 236 6 2093 42 602 3 833 8666 9450 99 880 12 232 Week 8 114 400 32 032 20 592 9152 176 176 93 600 26 208 16 848 7488 44 000 8 228 3 289 66 946 6 024 8666 14 850 152003 24 173 Week 9 144 144 36 000 83 200 23 296 14 476 6 656 6 732 2691 54 774 4929 8666 12 150 125 942 18 202 Week 10 127 628 32 000 5984 2392 48 688 4 381 8666 10 800 112911 1 88 400 24 752 15 912 7072 Week 11 136136 34 000 6 358 119426 16 710 93 600 26 208 16 848 7 488 8 2541 51 731 4655 8666 11 475 144 144 Week 12 36 000 6 732 2 691 54 774 4929 8666 12 150 125 942 18 202 72 800 20 384 13 104 5 824 112112 28 000 5 236 2093 42 602 3833 8666 9 450 99 880 12 232 Total 1 040 000 291 200 186 200 83 200 1 600 600 400 000 74 800 29 899 608 600 54 764 103 992 135 000 1 407 055 193 545 Student Name Student Number Student Name Student Number Week 6 -20 + Wool - Budget Forecast SITXFINO03 Manage finance within a budget Food Bev Food Bev Food Bev Sales Expen Purchas Bev Purch Superann Sales - Sales (NA) Total ses es Purchal (NA) Wages uation Rent Other Total Net Profit Income din (TA) Sales (A) 8666 8000 86491 13509 65000 20000 10000 5000 100000 25000 4500 2000 35000 3325 Week 1 8000 125000 30000 6000 2500 45000 4275 8666 10000 106441 18559 Week 2 82000 20000 15000 35000 6500 3000 55000 5225 8666 15000 128391 17609 Week 3 95000 25000 20000 6000 146000 8000 3000 60000 5700 8666 13 500 125366 37634 40000 Week 4 110000 25000 20000 8000 163000 30000 5000 2000 45000 4275 8666 10000 104941 15059 Week 5 75000 23000 15000 7000 120000 5000 200 42000 3990 8666 9500 101156 10844 Week 6 75000 20000 12000 5000 112000 30000 6500 6175 8666 15000 151841 31159 900 Week 7 120000 35000 20000 8000 183000 45000 15000 7000 142000 35000 7000 3000 55000 5225 8666 12000 125891 16109 Week 8 95000 25000 4750 8666 11000 115916 9084 80000 25000 15000 5000 125000 33000 6000 2500 50000 Week 9 120606 20394 20000 6000 141000 35000 6500 2500 52000 4940 8666 11000 Week 10 85000 30000 5225 9000 12000 125725 30275 30000 20000 6000 156000 35000 6500 3000 55000 Week 11 100000 2500 3990 9000 10000 102490 12510 5000 Week 12 70000 25000 15000 5000 115000 30000 42000 403000 75000 31000 601000 57095 104660 123500 1395255 232745 Total 1052000 303000 197000 76000 1628000 Student NameAssessment 2 Your Tasks: Task 1 Use the supplied budget template, and record on variances between actual and forecast budgets. THIS IS A GREEN TAB Provide a fortnightl Itnightly budget report , over the next 12 weeks, which clearly identifies any under or over performances, and the actual and likely reasons for these. Use the table below as a reference list and attach each budget report together with a variance analysis for each to this project Date Budget Variance Reason Discussion with Action Performance/ Area supervisor Budget Cycle Start 1214 /23 Week 2 26 / 4 / 21 Week 4 10 /5 / 25 Week 6 14 / 5 / 20 Week 8 7 / 6 / 23 Week 10 $7/ 9 / 12 Week 12 5/ 7/73 Budget Cycle End 19 / 7 / 23)shift command option Assessment 2 Your Tasks: Task 1 and record on variances between actual and forecast budgets. VariationSSITXFINO06 Manage finance within a budget Sales - Food Sales| Bev Sales | Bev Sales Income din (TA ) Food Bev Purchev Purch ( A ) Superan (NA) Total Expenses | Purchases (a) (NA ) Wages uation Rent Other Total Net Profit Week 1 -2600 -2528 41237 -3104 100D Week 2 1200 3296 - 206 21516 - 39 -100 359 - 4703 - 524-1344 +2628 + 2000 - 16 1-108 +3608 + 106 Week 3 - 800 6470 - 384 +1400 +208 - 3152 $ 1488 - 1856 +1600 + 237 309 - 2261 -296 2850 -244 1593 Week 4 -6000 + 4120 -1280 + 320 - 2840 O -420 -10 +865 -223 0 1360 Week 5 +3000 -1160 - 960 - 750 +20 + 610 1242 +645 -168 1454 -1334 Week 6 -200 + +1104 +824 + 112 -2000 +236 93 +box -11 Week 7 -5600-2968 1+ 592 +1152 - 6*24 -1060 - 172 +287 + 1946 -151 150 167 -6986 Week 8 -1401 +1209 71848 +488 +2145 - 309 -226 - 296 -150 2095 Week 9 $3200 -1 70 - 524 +1656 +2628 -1000 -16 4109 -1312 -369 -3005 5631 Week 10 3 400 - 5248 - 4088 + 107 -4864 -1000 - 64% +41 -2691-235 1-47-1180 -3684 Week 11 1,400 - 3790 - 315> +1428 - 11816 - 209 -276 - 296 334 -12075 334 0 260 -270 . Week 12 12800 -4616 -1896 +$24 -208% 2000 +236 - 407 7 602 -15+ -3000 -200 -1101 +1600 -2331 067 -1-11510 11900 -39 200 Total -12001 -1800 - 0800 +200 -2+400 Student Name Student Number Student Name : Student Number Australia Moreton Education Group Pty Lid, Trading as Queensland Academy of Technology (QAT) ABN 68 10582330 Level 4, 333 Adelaide Street, Brisbane 4000, Queensland Australia PO BOX 10862 Adelaide Street, Brisbane 4000 in Telephone 07 phone 07 3002 0888 Facsimile 07 3002 0808 National Provider Number: 31246 CRICOS Number: 094609M 20/03/2017 Version 1.0