Question: QUESTION 5 REQUIRED Use the following information provided by Harvard Enterprises to prepare the: 5.1 Debtors Collection Schedule for March and April 2021. 5.2 Cash

 QUESTION 5 REQUIRED Use the following information provided by Harvard Enterprises

QUESTION 5 REQUIRED Use the following information provided by Harvard Enterprises to prepare the: 5.1 Debtors Collection Schedule for March and April 2021. 5.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. 1. INFORMATION The following figures are estimated for 2021: January February March April Cash sales Credit sales Purchases Sales commission Wages 255 000 144 000 210 000 1 800 8 400 240 000 120 000 180 000 1 500 8 400 192 000 228 000 2 400 140 000 248 000 3 000 ? 2. Collections from credit sales are expected to be as follows: 30% in the month of the sale; 65% in the month following the sale. The remaining 5% is written off as bad debts. Eighty percent (80%) of the purchases are on credit and the balance is cash. Creditors are paid two months after the date of invoice. Harvard Enterprises will make an investment of R150 000 in fixed deposit on 01 March 2021. Interest of R1 000 per month is expected to be received from 31 March 2021. Rent expense amounts to R288 000 per annum and is payable monthly on the first day of each month. Wages will be increased by 10% on 01 March 2021 and will increase by a further 5% on 01 April 2021. A new machine is expected to be purchased for R25 000 cash during April 2021. Commission is paid to sales personnel in the month following the month in which it was earned. The expected bank balance on 28 February 2021 is R50 000 (favourable). 9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!