please show all workings

B D G H 104 For Durrington Ltd prepare a cash flow forecast for each of July, August and September Sales () Purchases of material (.) Production wages () May 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 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 The supplier of material is paid 60 days after purchase. All other costs are paid in the month they are in The bank balance at 1st July is 180 000 REVISION 80% of customers pay 2 months after the date of sale 20% of customers pay 3 months after the date of sale 125 126 127 28 29 30 31 Debtors at 30th June will settle their debts as follows: 220,000 in July 300,000 in August 144,000 in September 32 33 The supplier of material is paid 60 days after purchase. All other costs are paid in the month the 34 35 36 The bank balance at 1st July is 180,000 37 38 39 REVISION 10 Cash Budget 11 CASH IN 2 3 24 CASH OUT 35 16 47 18 NET CASH IN OPENING CASH BALANCE CLOSING CASH BALANCE