Answer:
a. Sales for November = $192,666.67
b. Sales for December = $312,400,00
c. Total cash collections are as follows:
January = $200,580
February = $201,360
March = $191,750
Explanation:
a. Compute the sales for November.
Sales for November = (Accounts receivable balance at the end of the previous quarter - Uncollected sales from December) / Collection rate two months after the sale = ($107,000 - $78,100) / 15% = $192,666.67
b. Compute the sales for December.
Sales for December = Uncollected sales from December / (Collection rate one months after the sale + Collection rate two months after the sale) = $78,100 / (10% + 15%) = $312,400,00
c. Compute the cash collections from sales for each month from January through March.
Note: See the attached excel file for the schedule of cash collections from sales for each month from January through March.
From the attached excel file, total cash collections are as follows:
January = $200,580
February = $201,360
March = $191,750