$($b$)$ The following information taken from the budgets of Eastleigh Ltd completed during the budget process.

March

April

May

June

E

E

$$

Sales

$5,300$

$5,500$

$5,600$

$5,700$

Purchases

$900$

$950$

$1,000$

$1,100$

Wages

$500$

$500$

$500$

$500$

Overheads

$1,950$

$1,800$

$1,960$

$2,050$

Other information

$$ Eastleigh Ltd sells $25\%$ of its goods for cash. The remainder of customers take one month's credit

$$ Purchases are paid the month after they are incurred

$$ Wages are paid the month they are incurred

$$ Sales staff commissions which are not included in the table above are paid one month in arrears and are calculated on a basis of $20\%$ of the monthly sales revenue.

$$ Overheads are paid the month after they are incurred and the numbers above include $500$ per month of depreciation

$$ Eastleigh Limited intends to buy a new machine for a cost of $6,000$ on $1$st March. The machine will be classified as a non$-$current asset and depreciated over five years on a straight line basis. Payment will be in the form of an initial deposit of $1,200$ paid on $1$st March followed by $12$ equal monthly instalments starting $1$st April.

$$ The cash balance forecast at the beginning of April is $400.$

Required:

$($i$)$ Prepare a cash budget for Eastleigh Ltd for the $3$ months April to June.

$($ii$)$ On $1$st April the part time credit controller, who was

responsible for ensuring customers paid, left Eastleigh Limited and was not replaced. This employee was paid $960$ per annum. This resulted in $8\%$ of credit customers from $1$st April sales onwards taking $2$ months credit and a further $4\%$ of credit customers becoming bad debts. The remaining $88\%$ of credit customers paid after $1$ month as before. If all other budget financials and other information were as given above, calculate the new cash balance at $30$th June.