c$)$ Prepare Codent's cash budget from May $2024$ to August $2024$ from the following budgeted data.

$\backslash$table$[[$Budgeted data,May,June,July,August$],[,,,,],[$Budgeted sales $($units$),500,550,600,650],[\backslash$table$[[$Budgeted purchases$],[($units$)]],600,600,500,500],[$Wages $(),,,,],[$Other overheads $(),660,680,700,800],[\backslash$table$[[$Capital expenditure$],[()]],1,100,1,080,1,150,1,180]]$

The following additional information is available:

$1-$ For the month of May $2024,$ selling price per unit will be $28$ and purchasing price per unit will be $25.$ Both selling and purchase prices are expected to increase by $2\%$ monthly.

$2-55\%$ of the customers pay cash and the remainder take $1$ month to pay.

$3-50\%$ of the purchases are paid for after $1$ month and the remainder in $2$ months' time.

$4-$ Wages are paid in the current month.

$5-$ Other overheads are paid after $2$ months.

$6-$ Capital expenditure is paid in the following month.

$7-$ Opening cash balance for May was $1,800$ overdraft.