$\backslash$table$[[$Month$,\backslash$table$[[$Sales$],[$Sh$."000"]],\backslash$table$[[$Material$],[$purchases$],[$Sh$."000"]],\backslash$table$[[$wages$],[$Sh$."000"]],\backslash$table$[[$Production$],[$Overheads$],[$Sh$."000"]],\backslash$table$[[$Administrative$],[$Overheads$],[$Sh$."000"]]],[$January$,36,000,12,500,5,000,3,000,2,750],[$February$,48,500,15,500,6,050,3,150,3,350],[$March$,43,000,12,750,5,300,3,000,3,750],[$April$,44,300,15,300,12,500,3,250,4,450],[$May$,51,250,18,500,11,000,4,000,5,500],[$June$,54,350,19,400,11,500,4,100,5,750]]$

dditional information

Depreciation is charged at a rate of $0\mathrm{.}5\%$ of the Sales

Expected cash balance in hand on January $2015$ is Sh$.36,250,000$

$50\%$ of total sales are on cash basis.

Fixed assets are to be acquired in the months of February and April $2015$ at Sh$\mathrm{.}4,000,000$ and Sh$.12,500,000$ respectively.

A Bank loan amounting to Sh$.15,000,000$ is expected to be approved and received by the company on May $2015.$

It is anticipated that a dividend of Sh$.17,500,000$ will be paid in June $2015.$

Debtors are allowed one month credit period.

Creditors for the materials purchases give one month credit period.

Overheads are paid one month in arrears.

Sales commission at the rate of $3\%$ on sales is paid to the salespersons on monthly basis. Required:

A cash budget for the six months period ending $30$ June $2015.$

$(14$ marks$)$