It is now 1 year later and you are required to review the profit and loss account for 2015 - 2016, as well as the cash flow statement The Principal Consultant has also asked you to focus on reviewing the conference costs as, while there was very positive feedback from the conference and the company wishes to run it next year, there needs to be revisions to the budget and a potential price increase for the conference fee to make the conference profitable. The Principal Consultant would like you to report on a proposed conference fee given a 10% increase in all the recorded costs for the conference as shown in the profit and loss statement (and that match the conference costs for the document you reviewed in Assessment Task 2) and assuming 70 people will attend the 2017 conference. The Principal Consultant would also like a 20% retum on the conference costs. Complete the following activities: 1. Write a financial performance report. Analyse the information provided in Profit and Loss 2017/18 and Cash Flow Statement 2017/18. Based on your analysis, develop a short report for the Principal Consultant that includes Review of overall performance and grosset profit margins. Calculation of variation in actual versus budgeted amounts for each income source. Calculation of variation in actual versus budgeted costs, focusing particularly on conference costs. Recommended revisions to the budget for conference costs for 2017/18. Proposed conference fee for 2018 conference assuming attendance of 70 people and to make a profit of at least 20%. I 2. Send an email to the Principle Consultant (your assessor). The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should introduce and summarise the contents of the attachment. Attach your financial performance report to the email: Budget Forecast Excel POFIA Ariel M 13 Excel 11 - AT ANGLE- 0.%. BIU. 1 LED EAN IC VA D F 1 L 0 Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget 82,500 122.000 87 625 83,000 98 000 121.000 8.000 20 360 12 000 9000 250 10,000 89,500 105,000 10,000 150 150 9000 70,500 133600 12,000 200 11 000 10,000 250 12000 1.100,000 40.000 5.000 108,000 12.000 11 000 82,500 132,250 118250 130360 96825 108650 116150 96250 93700 143700 1,261,000 Grow Management Consultants Pty Ltd 4 Budget Forecast 5 July 17 to June 18 2 Jul Aug 8 9 Actual Actual 10 INCOME 11 Consulting fees 97 975 85000 12 Conference 6,000 13 E-book 14 Executive search 7000 8.000 15 8 NET INCOME 104,975 99,000 17 EB EXPENSES 19 Salaries wages 42.000 42.000 20 Superannuation 5,000 5,000 21 Clearing 800 800 22 Accounting fees 0 0 23 Advertising and marketing 1000 O 24 Contract wiiter (e-book) 10,000 3,580 25 Computer software 0 2,600 20 Motor vehicle expenses 653 451 27 0 672 28 Insurance 0 0 Office Supplies 100 120 30 Leasefloan payments 100 120 31 Rent 3.580 3.5801 2 Sundnes 200 200 s Travel and Accommodation 1583 0 1001 0 54 Repas & maintenance 35 Teknhone 300 290 42.000 5,000 42.000 5,000 42,000 5 000 800 o 700 42,000 5.000 800 0 2000 3,590 42.000 5000 800 0 0 3.580 3.680 42,000 5,000 800 5.623 500 3580 0 870 0 0 180 200 3,580 140 1,435 400 310 340 0 177 329 120 100 3.500 170 1,974 42.000 5000 B00 0 0 3580 0 140 0 329 180 210 3,500 230 122 o 200 42,000 5,000 800 0 800 3.580 2000 253 1470 D 190 50 3500 200 0 400 300 8008088099930108 42.000 5.000 800 0 0 3,500 o 0 0 3,370 230 0 3.580 140 O 300 310 920 1,048 0 230 200 3.580 170) 128 0 330 42,000 5.000 00 0 0 3,580 0 500 0 O 130 150 3500 230 171 240 338013883810 504,000 60.000 9.600 6,000 500 11,000 4.000 5.000 4,000 4.000 1.500 1,300 42.960 2,000 5.000 1,8 3.000 250 200 3.580 223 0 210 320 665,360 56110 59,95 57079 55.900 56.400 59,310 56.471 55 243 60,638 65.718 69,413 65,416 5956 37 TOTAL EXPENSES B SURPLUS DEFICIT 39,746 31,779 37 800 49.340 36.184 B7520 81,810 69.711 39,687 16,782 77007 39,559 de Forecast It is now 1 year later and you are required to review the profit and loss account for 2015 - 2016, as well as the cash flow statement The Principal Consultant has also asked you to focus on reviewing the conference costs as, while there was very positive feedback from the conference and the company wishes to run it next year, there needs to be revisions to the budget and a potential price increase for the conference fee to make the conference profitable. The Principal Consultant would like you to report on a proposed conference fee given a 10% increase in all the recorded costs for the conference as shown in the profit and loss statement (and that match the conference costs for the document you reviewed in Assessment Task 2) and assuming 70 people will attend the 2017 conference. The Principal Consultant would also like a 20% retum on the conference costs. Complete the following activities: 1. Write a financial performance report. Analyse the information provided in Profit and Loss 2017/18 and Cash Flow Statement 2017/18. Based on your analysis, develop a short report for the Principal Consultant that includes Review of overall performance and grosset profit margins. Calculation of variation in actual versus budgeted amounts for each income source. Calculation of variation in actual versus budgeted costs, focusing particularly on conference costs. Recommended revisions to the budget for conference costs for 2017/18. Proposed conference fee for 2018 conference assuming attendance of 70 people and to make a profit of at least 20%. I 2. Send an email to the Principle Consultant (your assessor). The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should introduce and summarise the contents of the attachment. Attach your financial performance report to the email: Budget Forecast Excel POFIA Ariel M 13 Excel 11 - AT ANGLE- 0.%. BIU. 1 LED EAN IC VA D F 1 L 0 Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget 82,500 122.000 87 625 83,000 98 000 121.000 8.000 20 360 12 000 9000 250 10,000 89,500 105,000 10,000 150 150 9000 70,500 133600 12,000 200 11 000 10,000 250 12000 1.100,000 40.000 5.000 108,000 12.000 11 000 82,500 132,250 118250 130360 96825 108650 116150 96250 93700 143700 1,261,000 Grow Management Consultants Pty Ltd 4 Budget Forecast 5 July 17 to June 18 2 Jul Aug 8 9 Actual Actual 10 INCOME 11 Consulting fees 97 975 85000 12 Conference 6,000 13 E-book 14 Executive search 7000 8.000 15 8 NET INCOME 104,975 99,000 17 EB EXPENSES 19 Salaries wages 42.000 42.000 20 Superannuation 5,000 5,000 21 Clearing 800 800 22 Accounting fees 0 0 23 Advertising and marketing 1000 O 24 Contract wiiter (e-book) 10,000 3,580 25 Computer software 0 2,600 20 Motor vehicle expenses 653 451 27 0 672 28 Insurance 0 0 Office Supplies 100 120 30 Leasefloan payments 100 120 31 Rent 3.580 3.5801 2 Sundnes 200 200 s Travel and Accommodation 1583 0 1001 0 54 Repas & maintenance 35 Teknhone 300 290 42.000 5,000 42.000 5,000 42,000 5 000 800 o 700 42,000 5.000 800 0 2000 3,590 42.000 5000 800 0 0 3.580 3.680 42,000 5,000 800 5.623 500 3580 0 870 0 0 180 200 3,580 140 1,435 400 310 340 0 177 329 120 100 3.500 170 1,974 42.000 5000 B00 0 0 3580 0 140 0 329 180 210 3,500 230 122 o 200 42,000 5,000 800 0 800 3.580 2000 253 1470 D 190 50 3500 200 0 400 300 8008088099930108 42.000 5.000 800 0 0 3,500 o 0 0 3,370 230 0 3.580 140 O 300 310 920 1,048 0 230 200 3.580 170) 128 0 330 42,000 5.000 00 0 0 3,580 0 500 0 O 130 150 3500 230 171 240 338013883810 504,000 60.000 9.600 6,000 500 11,000 4.000 5.000 4,000 4.000 1.500 1,300 42.960 2,000 5.000 1,8 3.000 250 200 3.580 223 0 210 320 665,360 56110 59,95 57079 55.900 56.400 59,310 56.471 55 243 60,638 65.718 69,413 65,416 5956 37 TOTAL EXPENSES B SURPLUS DEFICIT 39,746 31,779 37 800 49.340 36.184 B7520 81,810 69.711 39,687 16,782 77007 39,559 de Forecast