Sophies Spring Water Sophies S
Cash Budget ended 31 December, 2017 Cash Budg
Q1 Q2 Q3 Q4
(£000's) (£000's) (£000's) (£000's)
Receipts Receipts
Sales income 50.0 70.0 85.0 65.0 Sales inco
Total receipts 50.0 70.0 85.0 65.0 Total rece
Payments Payments
Materials 6.3 8.8 10.6 8.1 Materials
Wages 12.5 17.5 21.3 16.3 Wages
Variable expenses 2.5 3.5 4.3 3.3 Variable e
Electricity 1.3 1.8 2.1 1.6 Electricity
Rent and Rates 16.0 16.0 16.0 16.0 Rent and
Machinery 25.0 0.0 0.0 0.0 Machinery
Telephone 0.5 0.6 0.5 0.6 Telephone
Advertising 2.0 3.0 3.5 2.0 Advertisin
Dividends 1.5 0.0 2.0 0.0 Dividends
Corporation tax 0.0 10.0 0.0 0.0 Corporatio
Total payments 67.6 61.2 60.3 47.9 Total paym
Opening bank balance 215.0 197.5 206.4 231.2 Opening b
Add receipts 50.0 70.0 85.0 65.0 Add receip
Total receipts 265.0 267.5 291.4 296.2 Total rece
Less payments 67.5 61.1 60.3 47.9 Less paym
Closing bank balance 197.5 206.4 231.2 248.3 Closing ba
Cash Budget ended 31 December, 2017 Cash Budg
Q1 Q2 Q3 Q4
(£000's) (£000's) (£000's) (£000's)
Receipts Receipts
Sales income 50.0 70.0 85.0 65.0 Sales inco
Total receipts 50.0 70.0 85.0 65.0 Total rece
Payments Payments
Materials 6.3 8.8 10.6 8.1 Materials
Wages 12.5 17.5 21.3 16.3 Wages
Variable expenses 2.5 3.5 4.3 3.3 Variable e
Electricity 1.3 1.8 2.1 1.6 Electricity
Rent and Rates 16.0 16.0 16.0 16.0 Rent and
Machinery 25.0 0.0 0.0 0.0 Machinery
Telephone 0.5 0.6 0.5 0.6 Telephone
Advertising 2.0 3.0 3.5 2.0 Advertisin
Dividends 1.5 0.0 2.0 0.0 Dividends
Corporation tax 0.0 10.0 0.0 0.0 Corporatio
Total payments 67.6 61.2 60.3 47.9 Total paym
Opening bank balance 215.0 197.5 206.4 231.2 Opening b
Add receipts 50.0 70.0 85.0 65.0 Add receip
Total receipts 265.0 267.5 291.4 296.2 Total rece
Less payments 67.5 61.1 60.3 47.9 Less paym
Closing bank balance 197.5 206.4 231.2 248.3 Closing ba