preparing cash budget

please show workings

404 For Durrington Ltd prepare a cash flow forecast for each of July, August and September D H 205 266 27 220 200 May Sales (6) 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 292 293 294 395 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 296 192 90 399 300 Debtors at 30th June will settle their debts as follows: 220,000 in July 300,000 in August 144,000 in September 301 02 303 304 305 306 307 300 09 The supplier of matemal is paid 60 days after purchase. All other costs are paid in the month they are incurred The bank balance at 1st July 15 180.000 DISION Cash Budget CASH IN 1 2 3 4 5 6 7 CASH OUT 8 NET CASH IN OPENING CASH BALANCE CLOSING CASH BALANCE 9 0