In: Accounting
Use the following information provided by Ashleigh Enterprises to prepare the:
4.1 Debtors Collection Schedule for March and April 2021.
4.2 Cash Budget for March and April 2021.
Note: * Where applicable, round off amounts to the nearest Rand. * Use separate monetary columns for each month.
INFORMATION 1. The following are estimates for the first four months of 2021: January (R) February (R) March (R) April (R) Sales 140 000 120 000 190 000 230 000 Purchases 70 000 60 000 85 000 115 000 Wages 9 000 9 000 ? ? 2. Forty percent (40%) of the sales are for cash and the balance is on credit. Collections for credit sales are as follows: 30% during the month of the sale; 65% in the month following the sale. The remaining 5% is written off as bad debts. 3. All purchases are on credit. Creditors are paid two months after the month of purchase. 4. Ashleigh Enterprises will make an investment of R60 000 in fixed deposit on 01 March 2021. Interest of R400 per month is expected to be received from March 2021. 5. Rent expense amounts to R156 000 per year and is payable monthly. 6. Wages will be increased by 9% on 01 March 2021. 7. A new computer is expected to be purchased for R15 000 cash during April 2021. 8. Commission payable to sales personnel is calculated at 10% of sales and it is paid one month later. 9. The bank balance on 28 February 2021 is expected to be R30 000 (favourable).
Receipts from Sales on account: 30% of current month's Sales 65% of previous month,s Sales Debtors Collections Schedule March April 34,200 (190,000 *60% * 30%] [230,000 * 60% * 30%] 46,800 [120,000 * 60% * 65%] (190,000 * 60% * 65%] 81,000 41,400 Total Sales in March = R190,000 Cash Sales = 40% and the balance 60% is credit sales 74,100 Total Salesin April = R230,000 Cash Sales = 40% and the balance 60% is credit sales 115,500 February Sales = R120,000 Total Cash Collections