5.Budget and Financial Analysis
The cash flow set out below is a 12-month budget. The budgeted revenue is worked out using the £290017 set out in the Vodafone Pack and divided by 12 to show monthly revenue. As I will be paid in one-month arrears the first month I will not receive any revenue. The budgeted cost is worked out in the same way using the total cost given in the Vodafone Pack.
The two columns below once again show the budgeted Revenue from the Vodafone pack and in terms of the planned costs they are using the proposed costs that I have set out and once again dividing it by 12 to show monthly costs.
Please find below a comparison table of current costs (as set out in the Vodafone pack) to the proposed cost savings that I expect to enforce. Please also bare in mind that the salary figure of £61,500 takes into account the £27,000 salary of the store manager which will no longer be needed as I will take up that position and I have estimated the Assistant Manager having a salary of around £20,000.
Copyrights 2018 all rights reserved.
Hillal Namajee
Vodafone
Business Plan
In the supplied current budget for 2017/18 wages are reduced by £47000 by deleting two of the three full-time posts (Store Manager replaced by me (£27000) and Assistant Manager (estimated wages of £20000) by the Technical Advisor who will exercise management responsibilities in my absence. This will reduce the wage bill by around 43%. The corresponding savings in tax and NI will be £8477 and in pensions contribution as £2294. So the total staff costs savings will be £57,771, a saving of around 47%.
The reduction in the planned variable costs as opposed to budgeted is £13054, a saving of around 44%.
The saving in the budgeted annual operating costs will be £70,824, an overall saving of around 29%.
The planned cost savings will put the store on a sustainable financial footing.
After the above planned savings, the budgeted required cash flow requirement of £108509 falls to £77365 (worked on the basis of % of total budgeted total costs).
However, actual budgeted cash flow requirement be £69054 and will have positive cash flow in the 7th month. After cost savings the cash flow requirement falls to £19815.
Financial Analysis
My own Capital of £60,000 will cover the cash flow requirement of £19815 after the savings have been made, leaving a contingency fund of £40185. So, if Vodafone can deploy the current Store Manager and the Assistant Manager, then I have more than sufficient funds of my own to cover costs.
However, if the current Store Manager and the Assistant Manager were transferred to me under TUPE, then it would take me some months to achieve the required savings to put the store on sound financial basis. This will then involve me in taking a loan from my family of around £10,000. Two other options are a bank loan or Vodafone to make a loan to me of £10,000 in month 4 against the first month’s revenue paid in arrears at the current base rate plus around 2% which I would be able to repay with interest in the 12th month.