please show workings

283 2014 285 4,04 For Dumington Ltd prepare a cash flow forecast for each of July, August and September 286 287 288 May Sales (E) Purchases of material (E) Production wages (E) June July August September 360,000 480,000 630,000 60,000 60,000 70,000 90,000 110,000 105,000 135,000 165,000 290 791 292 293 094 95 296 297 390 299 300 301 302 303 804 Fixed production costs are 45,000 per month, including depreciation of 5,000 per month Fixed costs of the sales department are 14,000 per month New equipment, costing 400,000 will be purchased in September Some existing equipment will be sold in September for 5,000 80% of customers pay 2 months after the date of sale 20% of customers pay 3 months after the date of sale Debtors at 30th June will settle their debts as follows: 220,000 in July 300,000 in August 144,000 in September 305 The supplier of material is paid 60 days after purchase. All other costs are paid in the month they are incurred 306 307 The bank balance at 1st July is 180,000 306 REVISION Cash Budget CASH IN CASH OUT NET CASH IN OPENING CASH BALANCE CLOSING CASH BALANCE