please assist

QUESTION 4 lag 4. The information provided below relates to Mendi Enterprises. Required 4.1 Prepare a debtor's colecion schedude for October and November 2017 42 Prepare the Cash budget for October and November 2017, 6 marks) (14 marks) Note: Where appicable, round off all amounts to the nearest Rand. Informatiorn 1. The bank balance on 30 September 2017 was R3 000 (CR) 2. Actual and budgeted sales are as follows Seplember 2009 Oclober 2009 November 2009 Cash sales are estimated at 10% of total sales. 220000 200 000 240 000 4. Deblors are expected to setle their accounts as folows: 70% during te month of sale mese debtors receive a 5% discount. 30% in the blowing the month Actual and budgeted purchases for each month are as follows 5. September 2017 October 2017 November 2017 Fifty percent (50%) of all purchases are for cash. Creators are paid in full in the month folowing the purchase transacion Rent expense amounts to R8 per month, payable monthly Rent wil ncrease by 10% from 01 November 2017 variable seling ad arinistrave expenses are estimated at 25% of sales. They are payable during the month of sale 120 000 100 000 110 000 9 Insurance amounts to R24 000 per annum payable monthly 10. The proprietor intends to make the following drawings during November 2017 Cash R12 000 Trading merchandise, R3 000