QUESTION:
YOU CAN USE THIS TEMPLATE:
3. Budgeting: 11 marks Sales John Wilson is the owner/manager of Overnight Courier Solutions, a small transport and courier company that provides logistics services to business. John is about to start the budget process for the year ending 30 June 2020. His marketing manager has contacted customers and analysed market trends, and expects sales to online traders to increase by 30 per cent in 2020. In contrast, transport to local traders is expected to increase by 3 per cent in 2020. The sales activity for 2019 is as follows; Quarter 4 April - June Total for the year Online Logistics Solutions Sales for the year ended 30 June 2019 Quarter 1 Quarter 2 July - October - September December Online 1,000,000 900,000 Traders Local 800,000 600,000 Traders Total $1,800,000 $1,500,000 Quarter 3 January - March 800,000 1,500,000 4,200,000 700,000 1,100,000 3,200,000 $1,500,000 $2,600,000 $7,400,000 Operating Expenses Given the expected increase in sales volumes for 2020, the Office Manager has held meetings with the drivers and sales personnel to identify resources needed to support the increased activity. To assist their deliberations, the income statement for 2019 was used as a basis for discussion. Overnight Courier Solutions Income Statement For the year ended 30 June 2019 Sales 7,400,000 Less: Operating Expenses General administration expenses Electricity and Gas Salaries Sales Commission Loan interest Marketing expenses Vehicle-related expenses Depreciation on motor vehicles Total Operating Expenses Profit 800,000 40,000 1,600,000 370,000 50,000 100,000 2,000,000 800,000 5,760,000 $1,640,000 Additional information The following changes are expected in 2020: General administration expenses are expected to increase by 1 per cent. Utility (electricity and gas) expenses are expected to increase by 2 per cent. Due to uncertainty regarding the cost of fuel an expected increase of 1 per cent in vehicle related expenses is to be allowed in the budget. Salaries will increase by 4 per cent. To encourage sales staff to boost sales to the expected levels, the sales commission will increase from 5 per cent to 5.5 per cent of sales. Marketing-related expenses are expected to increase by 25 per cent. Loan interest and depreciation for 2020 will be the same as for 2019. (a) Prepare the following budgets: (i) a sales budget, (ii) a operating expenses budget and (iii) a budgeted income statement for Online Logistic Solutions for 2020 taking in consideration revenue and cost changes identified by the business. (8 marks) (a)(i) Quarter 4 April - June Total for the year Online Logistics Solutions Sales Budget for the year ended 30 June 2020 Quarter 1 Quarter 2 Quarter 3 July - October - January - September December March Online Traders Local Traders Total (a)(ii) 2020 Working Operating Expenses for 2020 General Admin expenses Utilities Salaries Sales commission Loan Interest Marketing expenses Vehicle-related expenses Depreciation on vehicle fleet Total operating expenses (a)(iii) Online Logistic Solutions Budgeted income statement for 2020 Sales Less Operating expenses General Admin expenses Utilities Salaries Sales commission Loan Interest Marketing expenses Vehicle-related expenses Depreciation on vehicle fleet Profit
