Gain Immediate access to our Essays
FREE access exchanged for your work, or pay £4.99
Words: | Submitted: Thu Jan 13 2005
... he has to know how to use this system because he has to solve those problems like, calculate the profit, tax, finance etc. Tasks c: The alternative solution to this problem would be; * Calculate a cash flow in spread sheet and know how to update. * Using a choice of a software package to set up a spread sheet 'computer model. * To know how to solve formulas in Microsoft excel. Tasks d: The advantages and disadvantages: * Backup files * Formula checked automatically * More accurate. Task c: The objectives of the new system are: * To be able to avoid the plan ahead for negative cash flow. * To be able to take advantages of positive cash flow. * To be able to update the cash flow easily using the Microsoft excel and formulas. Analysis a) Predictive sales figure: April £6,000 May £7,000 June £8,000 July £7,000 August £5,000 September £6,000 Payments for the supplies; 50% of the predicted sale. Quarterly bills; Electricity and gas bills> £500 for May> £400 for August Business rates;> £400 for June ...
FREE access exchanged for your work, or pay £4.99