QUESTION ONE [30]

The following figures are available for Impi (Pty) Ltd

Actual (2020) Budget (2020)

January February March April May

Sales 96 000 120 000 60 000 160 000 200 000

Purchases 100 000 50 000 160 000 84 000 60 000

Sales commission 400 600 1 200 800 400

Wages 800 800 800 ? ?

Additional information:

a. 40% of all sales are for cash.

b. 35% of all purchases are for cash.

c. Collection from debtors are as follows:

o 20% is collected in the month of the sale and 2% discount is granted on these collections.

o 60% is collected in the month following the month of sale.

o 15% is collected in the second month following the month of sale.

o The remaining 5% is written off as a bad debt.

d. Impi (Pty) Ltd will make an investment of R50 000 in fixed deposit on 01 April 2020.

e. Interest of R500 per month on the fixed deposit is expected to be received from 30 April 2020.

f. Creditors are paid 2 months after date of invoice.

g. Rent expense amounts to R8 000 per month and is payable on the first day of each month.

h. Wages will be increased by 10% in April and will increase by a further 5% in May 2020.

i. A new machine is expected to be purchased for R10 000 cash in May 2020.

j. Commission is paid to sales personnel in the month following the month in which it was earned.

k. On 31 March 2020, Impi (Pty) Ltd had a bank overdraft of R28 000.

Required:

1.1. Prepare the debtors' collection schedule for April and May 2020. (10)

1.2. Prepare the cash budget for April and May 2020. (20)