Cash budgeting and the value of budgeting

Cash budgeting and the value of budgeting

There are four parts to this coursework assignment. Answer all parts. The assessment has significant quantitative and qualitative (narrative) content. As a guide, students should expect parts (a), (b) and (c) of the assignment to comprise between 1 and 2 A4 pages, and part (d) to comprise between 4 and 6 A4 pages.

CASE STUDY

Ned Kelly has decided to start a taxi business in his hometown of Broadstairs . An accountant advises that he needs to budget the first year’s profit or loss, and also the cash flow from trading (the capital budget is being calculated separately) so that he can calculate how much overdraft from the bank will be needed.

Ned currently plans to have three taxis and nine drivers, plus £5,000 in the bank on 1 January 2016. Each driver can work five eight-hour shifts per week, and will take four weeks holiday per year including public holidays. At least one taxi will be available for hire 24 hours a day, 365 days per year. No relief drivers will be used and no overtime will be paid. The accountant suggests that each taxi will be used at 60% capacity, spread evenly over the year. The average receipts per taxi hour are expected to be £25 for the first three months, rising to £30 thereafter. It is envisaged that 20% of passengers will pay by credit card, payment in respect of which will be made in the following month, and 30% will be account customers, payment in respect of which will be made in the next but one month. The remainder will pay by cash.

The cost of diesel will be 15% of revenue, paid for in the month following the expenditure. Maintenance costs per taxi will be £120 per month, payable one month in arrears, and annual road tax and licence fees per taxi will be £600, payable at the beginning of the first month’s trading. Monthly depreciation on fixed assets will be £1,000.

Ned will manage the office, and he and four office staff will take bookings and direct drivers. Drivers will each be paid £24,000 gross pa; the four office staff will be paid £16,000 gross pa each. Social security costs and benefits will add another 10% to each month’s salary bill. All staff costs will be paid in arrears on a monthly basis. Utilities (water, gas and electricity) are expected to cost £1,500 a quarter, payable by direct debit in the first week of the following quarter. Rent and local property tax charges will be £18,000 and £5,000 pa respectively, both of which are payable at the beginning of each quarter.

Ned plans to take drawings in cash of £2,500 at the beginning of each month.

To bring the business to the attention of the public, Ned has agreed to spend £5,000 on advertising (including printing of business cards) in the first week. This will cover the first six months worth of promotion. For future advertising, Ned will budget for £500 a quarter.

At the beginning of the second year of trading Ned anticipates buying a fourth taxi for £15,000 cash. He anticipates that his oldest taxi will be sold at that point, for £3,000 cash.
Required:

(a) Prepare a budgeted profit and loss account for the year ended 31 December 2016

(Maximum 200 words)

(b) Prepare a monthly trading cash budget for the first six months and quarterly for the 6 months to 31st December 2016
(Maximum 400 words)
(c) Calculate and explain how much working cash you would recommend Ned needed to obtain and, the overdraft limit you would recommend/allow as his bank manager (You may need to do a weekly cash budget for the first months)
(Maximum 400 words)

(d) Analyse the business plan in terms of cost; volume; profit and in relation to its location and the demographics of the area.
(Maximum 400 words)
(e) Using a Business Report format explain to Ned how budgeting might aid in the achievement of his business goals

(Maximum 1000 words)

find the cost of your paper