A Company expects to have Rs$.37500$ cash in hand on $1$st April, and requires you to prepare an estimate of cash position during the three months.

$\backslash$table$[[$Month$,\backslash$table$[[$Sales$],[($$$)]],\backslash$table$[[$Purchases$],[($$$)]],\backslash$table$[[$Wages$],[($$$)]],\backslash$table$[[$Factor$],[$Expenses$],[($$$)]],\backslash$table$[[$Office$],[$Expenses$],[($$$)]],\backslash$table$[[$Selling$],[$expenses$],[($$$)]]],[$Feb$,75,000,45,000,9,000,7,500,6,000,4,500],[$March$,84,000,48,000,9,750,8,250,6,000,4,500],[$April$,90,000,52,500,10,500,9,000,6,000,5250],[$May$,120,000,60,000,13,500,11,250,6,000,6,570],[$June$,135,000,60,000,14,250,14,000,7,000,7,000]]($i$)$ Period of credit allowed suppliers $1$ month.

$($ii$)30\%$ of sales for cash and period of credit allowed to customers for credit is $1$ month.

$($iii$)$ Delay in payment of all expenses: $1$ month.

$($iv$)$ Income tax of Rs$.57,500$ is due to be paid on June $15$th$.$

$($v$)$ The company is to pay dividend to shareholders and bonus to workers of Rs$.15,000$ and Rs$.22,500$ respectively in the month of April.

$($vi$)$ A plant has been ordered to be received and paid in May. It will cost Rs$.1,20,000.$