PREPARE AN ANALYSIS REPORT FOR CASH BUDGET 2015 PLEASE.

Thank you!

0 P 13 B C D E F G N Oct. Nov. Dec. 2 Revenue (previous year) 3 Purchases 4 5 Payment schedule 6 Cash sales - 2046 30-day payment - 80% 8 60-day payment 9 10 Purchase schedule Paid in 1st month - 50% 12 Paid during 2nd 60 days - 50% 14 Jan. Feb. March April May June Jul. Aug. Sept. Oct. Nov. Dec. Total 15 16 Revenue 150000160000 160000 T70000 200000 200000 200000 230000 220000 190000 180000 160000 156000 ###### 17 18 Cash sales - 30000 32000 34000 40000 40000 40000 46000 44000 38000 36000 32000 31200 443200 19 30-payment- 0 120000 128000 128000 136000 160000 760000 160000 184000 176000 752000 144000 128000 ###### 20 60-day payment- 0 0 O 0 0 0 0 0 U 0 0 U 0 0 21 22 Total monthly receipts 30000 152000 162000 176000 200000 200000 206000 228000 214000 188000 176000 159200 23 24 Purchases 60000 60000 80000 80000 80000 90000 90000 70000 60000 60000 60000 25 60000 850000 26 Paid during 1st month - 30000 30000 40000 40000 40000 45000 45000 35000 27 Paid during 2nd 60 days = 30000 30000 30000 30000 425000 0 30000 30000 40000 40000 40000 45000 45000 35000 30000 30000 30000 395000 28 29 Total monthly purchases 30000 60000 70000 80000 80000 85000 90000 80000 65000 60000 60000 60000 820000 30 31 Receipts 30000 152000 162000 176000 200000 200000 206000228000 214000 188000 176000 159200 ###### 32 33 Expenses 34 Purchases 30000 60000 70000 80000 80000 85000 90000 80000 65000 60000 60000 60000 820000 35 Freight in 7000 7000 7000 7000 7000 7000 7000 7000 7000 7000 7000 7000 84000 36 Labour 30000 32000 35000 40000 50000 48000 50000 45000 35000 35000 30000 30000 460000 37 Other 0 0 38 Salaries - Distribution 5000 5000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 70000 39 Commissions 6000 6000 6000 7000 7000 7000 8000 8000 7000 6000 6000 6000 80000 40 Travel 2000 2000 3000 3000 3000 4000 4000 4000 3000 3000 2000 2000 35000 41 Advertising 2000 2000 2000 2000 3000 3000 3000 3000 3000 3000 2000 2000 30000 42 Other - Distribution 0 43 Salaries - Administration 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 120000 44 Leasing 3000 3000 3000 3000 3000 3000 3000 3000 4000 4000 4000 4000 40000 45 Other - Administration 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 2000 13000 46 Interest income 0 47 Finance costs 7000 7000 7000 7000 7000 9000 9000 9000 12000 12000 12000 12000 110000 48 Taxes 0 49 Purchase of non-current assets 0 50 51 Total expenses 103000 135000 150000 166000 177000 183000 191000 176000 153000 147000 140000 141000 ###### 52 53 Surplus (-) /month -73000 17000 12000 10000 23000 17000 15000 52000 61000 41000 36000 18200 54 Surplus(-) /cumulative -73000 -56000 -44000 34000 -11000 6000 21000 73000 134000 175000 211000 229200 55 56 Beginning bank balance 70000 14000 26000 36000 59000 76000 91000 143000 204000 245000 281000 57 Receipts 30000 152000 162000 176000 200000 200000 206000 228000 214000 188000 176000 159200 58 Expenses 103000 135000 150000 166000 177000 183000 191000 176000 153000 147000 140000 141000 59 Ending bank balance -3000 14000 26000 36000 59000 76000 91000 143000 204000 245000 281000 299200 60 61 62 63 -3000