Prepare a Debtors Collection Schedule using the below information?
Prepare a Debtors Collection Schedule using the below information?
INFORMATION
Extract of the Statement of Comprehensive Income for the month ended 31 May 2022
Sales 100 000
Cost of sales 50 000
Rent income 2 500
Advertising 5 000
Salaries and wages 15 000
Rates and taxes 900
Other operating expenses 20 000
Additional information
1. Sales are expected to increase by 20% each month.
2. Thirty percent (30%) of the sales is for cash and the balance is on credit. Collections from credit sales are as
follows:
* 30% in the month of the sale, and these customers are entitled to a discount of 5%;
* 65% in the month after the sale.
The balance is usually written off as
3. Inventories are kept at a constant level. The business uses a fixed mark-up of 100% on cost. All purchases are
for cash.
4. In terms of the lease agreement, the rental will increase by R3 000 per annum with effect from 01 July 2022. Rent
is received monthly.
5. Advertising is paid monthly and is estimated to be the same percentage of sales as for May 2022.
6. Salaries and wages will increase by 10% with effect from 01 June 2022.
7. Rates and taxes will be paid in one instalment for the year during July 2022. Rates are calculated at
80 cents (R0.80) per R100 on the value of the premises. The premises are valued at R1 500 000.
8. Other operating expenses are expected to increase by 5% per month. These expenses are paid for in the month
in which they are incurred.
9. The balance in the bank on 31 May 2022 is expected to be R25 000.
Step by step
Solved in 4 steps
