The members of Perfect Projects Ltd decide to prepare a Cash Budget for November and December. The following information is available:

Actual

Budgeted

August

R

September

R

October

R

November

R

December

R

Revenue

Cash

Credit

$194500$

$287300$

$235700$

$350000$

$275000$

$410000$

$250500$

$400400$

$368000$

$697000$

Purchases

$510000$

$490000$

$495000$

$520000$

$680000$

Salaries & Wages

$72600$

$72600$

$72600$

$72600$

$72600$

Sundry Expenses

$17800$

$18400$

$22000$

$22600$

$25700$

Additional information:

$1.$ Credit revenue is collected as follows:

$50\%$ within $30$ days

$30\%$ within $60$ days

$15\%$ within $90$ days

The balance is written off as irrecoverable.

$2.$ The following discounts are allowed on sales:

$10\%$ on cash revenue

$7\mathrm{.}5\%$ on credit revenue if accounts are settled within $30$ days.

$3.$ All salaries, wages and sundry expenses are paid in cash.

$4.$ Sundry expenses include depreciation of R$4200$ per month.

$5.$ Seventy$-$five $(75\%)$ of all purchases are on credit and paid within $30$ days. The balance is

paid in cash.

$6.$ A year$-$end bonus to employees totaling R$20000$ will be paid in December.

$7.$ The cash in the bank on $31$ October was R$44500.$

Required:

Prepare the Cash Budget for November and December using separate columns for each month.The members of Perfect Projects Ltd decide to prepare a Cash Budget for November and December.