QUESTION $3(20$ MARKS$)$

REQUIRED

Use the information provided below to prepare the following for Mustang Enterprises for January and February

$2024.$

$3\mathrm{.}1$ Debtors Collection Schedule $(4$ marks$)$

$3\mathrm{.}2$ Cash Budget. $(16$ marks$)$

INFORMATION

The following information was supplied by Mustang Enterprises:

$1.$ Mustang Enterprises expects to have an unfavourable bank balance of R$40000$ on $31$ December $2023.$

$2.$ The monthly sales were projected as follows:

$2023$ Units

November $44000$

December $53000$

$2024$ Units

January $47000$

February $31000$

$3.$ The selling price is R$20$ per unit $($excluding any discounts$).$ All the goods produced each month are

expected to be sold in the same month. Sixty percent $(60\%)$ of the sales is expected to be on credit and

the balance is for cash. Thirty percent $(30\%)$ of the cash sales is subject to a discount of $10\%.$

$4.$ Credit sales are usually collected as follows:

$20\%$ in the month of sale, and these debtors receive a $5\%$ discount.

$75\%$ in the month after the sale, and the rest is usually written off as bad debts.

$5.$ Manufacturing overheads are paid monthly. The overheads are expected to amount to R$65000$ for

December $2023,$ including R$5000$ for depreciation. Manufacturing overheads are expected to increase

by $5\%$ each month.

$6.$ Labour costs amount to R$6$ per unit and are paid in the month in which they are incurred. Labour costs

per unit are expected to increase by $9\%$ with effect from $01$ February $2024.$

$7.$ Materials cost R$7$ per unit $($excluding any discounts$).$ All the materials are purchased for cash to take

advantage of a discount of $7\mathrm{.}5\%.$

$8.$ R$200000$ is expected to be invested in a fixed deposit account on $01$ February $2024.$ Interest at $9\%$

per annum is receivable monthly, commencing February $2024.$

$9.$ Selling and administrative costs are paid monthly and are expected to total R$56000$ for February $2024,$

after an increase of $12\%$ takes place on $01$ February $2024$