P4:Prepare a budget for a selected organisation on the basis of the given information:
Jan Feb Mar Apr May Jun Total:
Receipts:
Debtors: 57500 65000 70000 72500 85000 65000 415000
Total receipts for 57500 65000 70000 72500 85000 65000 415000
month:
Payments:
Creditors: 26500 45000 50000 34500 35500 40500 232500
Wages & Salaries: 17500 18000 18250 18500 16500 20000 108750
Other expenses: 14500 19500 18000 17500 19500 21000 110000
Total payments for 58500 82500 86250 70500 71500 81500 450750
month:
Net cash flow: (1000) (17500) (16250) 2000 13500 (16500) (35750)
Opening bank 2250 1250 (16250) (32500) (32500) (17000)
balance:
Closing bank 1250 (16250) (32500) (30500) (17000) (33500)
balance :
Neil Patel 40068068 Unit 7 P4
Jan Feb Mar Apr May Jun Total:
Receipts:
Debtors: 57500 65000 70000 72500 85000 65000 415000
Total receipts for 57500 65000 70000 72500 85000 65000 415000
month:
Payments:
Creditors: 26500 45000 50000 34500 35500 40500 232500
Wages & Salaries: 17500 18000 18250 18500 16500 20000 108750
Other expenses: 14500 19500 18000 17500 19500 21000 110000
Total payments for 58500 82500 86250 70500 71500 81500 450750
month:
Net cash flow: (1000) (17500) (16250) 2000 13500 (16500) (35750)
Opening bank 2250 1250 (16250) (32500) (32500) (17000)
balance:
Closing bank 1250 (16250) (32500) (30500) (17000) (33500)
balance :
Neil Patel 40068068 Unit 7 P4
