A company made sales over the last 6 months as follows: • Jan • Feb • March • April •…
- User
A company made sales over the last 6 months as follows: • Jan • Feb • March • April • May • June • 750,000 • 800,000 • 840,000 • 780,000 • 920,000 • 950,000 20% of the sales are on cash basis. 40% of the credit sales is collected after 1 month and the balance after 2 months. Show the debtors collections for the period April-June. Select one:
April = 624,000; May = 736,000; June = 760,000
April = 1,276,800; May = 1,388,800; June = 1,428,800
April = 808,800; May = 836,800; June = 858,800
April = 652,800; May = 652,800; June = 668,800
- Assistant
To calculate the debtors collections for the period April-June, we need to determine the credit sales for each month and the collection amounts for each month.
Credit Sales: April = 780,000 June = $920,000
Collection amounts: April:
- Cash basis = 20% of 168,000
- 1st month credit sales = 40% of 336,000
- 2nd month credit sales = 60% of 504,000 Total collection for April = 336,000 + 1,008,000
May:
- Cash basis = 20% of 156,000
- 1st month credit sales = 40% of 312,000
- 2nd month credit sales = 60% of 468,000 Total collection for May = 312,000 + 936,000
June:
- Cash basis = 20% of 184,000
- 1st month credit sales = 40% of 368,000
- 2nd month credit sales = 60% of 552,000 Total collection for June = 368,000 + 1,104,000
Therefore, the debtors collections for the period April-June are: April = 936,000 June = $1,104,000
The correct answer is not provided in the options.