Q1. You are to develop a budget for the upcoming 2016/17 financial year. You will be 2.1 Use previous financial data to provided with a Microsoft Excel template 'worksheet' and will need to use the determine allocations for resources previous financial results to develop your budget. You will need to make informed 2.1 Develop budget from previous financial data according to compliance, organisational estimates on new inclusions and the budget should meet organizational requirements and statutory requirements (as per your business plan) and statutory requirements. The following information 2.2 Make informed estimates of new items for inclusion in budget should be considered: 2.3 Prepare budgets in accordance with organisational All sales income items except Sales - Water Cooler will increase on 2015/16 requirements and statutory by CPI (refer www.abs.gov.au and apply 'All Groups CPI' requirements Sales - Water Cooler results for 2015/16 were for three months. Use this PE3, PE4, PE5 result to calculate/budget for 12 months. Service Income 'Service Coolers' should be budgeted per the business plan (refer Appendix 5 in Part A) and Service Other Income and Travelling time will be the same as 2015/16 Cost of sales - Purchases will be 25% of Sales - Spring Water Cost of sales - Equipment will be 60% of Sales - Water Cooler (note that the COS % in the worksheet will be different as it is a % of total revenue) All Expenses should be the same as 2015 except the following: Advertising (refer business plan) 3.1 Circulate budgets and ensure Wages will include additional Sales Manager managers and supervisors are clear about Don't forget to adjust superannuateon budgets, reporting requirements ADBBSB60120/ADHRMBSB60320/ADLMBSB60420 BSBFIN601 Manage Organisational Finances ADBBSB60215 BSBFIM601 Manage Finances Part B 29Jun21 @ACADEMIQUE 2021