any assistance would be highly appreciated

Question 2 Swiper Superette The owner of Swiper plans to expand the shop in August and has to determine whether he would have enough cash available for the expansion costing R300 000. For operational purposes a minimum bank balance of R200 000 is required. If insufficient cash is available, he will consider getting a loan. The following information is available to assist in the cash forecast. Manufacturing Administrative Credit sales Credit purchases overheads overheads Month R R R R April 420 000 220 000 24 000 40 000 May 428 000 228 000 26 000 36 000 June 460 000 232 000 20 000 34 000 July 436 000 228 000 24 000 36 000 August 468 000 234 000 25 000 38 000 Additional Information: 1. Opening balance of cash on 1st June is estimated as R 40 000. 2. 50% of credit sales are collected in the month of the sale and 50% is collected in the month after the month of sale. 3. A credit period of one month is allowed by creditors. 4. Manufacturing overheads are paid one month later. Manufacturing overheads includes depreciation of R4 000 per month. 5. Administrative overheads are paid in the month in which it occurs. It includes a provision for bad debt of R2 000 per month. Daniels, J. (2020) Prepare the Cash budget for the months of June, July, and August 2020. (20 Marks)