QUESTION $4(30$ MARKS$)$ The following information for the $2024$ financial year is available for Skybolt Ltd: $$ Cash sales $120000$ March $127000$ April $110000$ May $135000$ June $140000$ July $115000$ Aug Credit sales $280000$ March $297000$ April $150000$ May $178000$ June $182000$ July $139000$ Aug Purchases $200000$ March $212000$ April $130000$ May $156500$ June $161000$ July $127000$ Aug Salaries and Wages $53000$ March $57000$ April $60000$ May $58000$ June $55000$ July $58000$ Aug Other expenses $15000$ March $17500$ April $18500$ May $18000$ June $19000$ July $21500$ Aug $$ Additional information: $($a$)$ Credit sales are collected as follows: $40\%$ within $30$ days $($the next month$)40\%$ within $60$ days $10\%$ within $90$ days $10\%$ uncollectible $($bad debt$)($b$)$ The following discount is given on sales: $5\%$ on all cash sales $10\%$ on credit sales paid within $30$ days $($c$)$ Purchases are made in cash and receive a discount of $5\%.($d$)$ Wages make up $40\%$ of the salaries and wages line and is paid in cash. Salaries are paid on the $1$st of the following month. $($e$)$ Other expenses include depreciation of R$4000$ per month. The rest of other expenses is split equally between rent always paid in advance on the $1$st of the month and water and electricity which is paid by the $7$ th of the following month. $($f$)$ A dividend of R$200000$ will be declared on $31$ July $2024,$ expected to be paid by $31$ August. $($g$)$ The bank balance on $1$ June $2024$ is R$200000.$ Required: Prepare the cash budget for the period $1$ June to $31$ August $2024$