FNSACC503 Assessment Task On Manage Budgets And Forecasts

PART A

Task 2 Service industry – Expenses budget

You were required to prepare an Expenses Budget (based on the Accruals system) for the year July 2018 to June 2019.

The calculations for expenses should be linked back to the “Data sheet” where appropriate. You can, in this worksheet also make links back to the Income/Fees budget when that is the expense driver (such as Advertising). Some referencing will also occur within the worksheet itself, for example where Superannuation and Workers Compensation are driven by other expenses such as Salaries and Commissions.

In addition your formula/s could be improved by instead of typing the % increase in (ie Advertising, Commission, Accounting fees and so forth) actually linking this back to the data sheet. This way, any amendment is only required on the data sheet rather than in multiple locations.