Prepare Cash Budget of a Company for April, May and June $2019$ in a columnar

form using the following information

You are further informed that:

$($a$)10\%$ of purchase and $20\%$ of Sale are for cash

$($b$)$ The average collection period of the Co$.$ is $\frac{1}{2}$ month and credit purchase is paid off

regularly after one month

$($c$)$ Wages are paid half monthly and the rent of Rs$\mathrm{.}500$ excluded in expense is paid

monthly

$($d$)$ Cash and Bank Balance on April $1,$ was Rs$\mathrm{.}15,000$ and the company wants to keep it

on end of every month below this figure, the excess cash being put in fixed deposits.