Question

The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on sales: 50% in month of sale 30% in month following sale 20% in second month following sale The accounts receivable balance on January 1 of the current year was $81,000, of which $50,000 represents uncollected December sales and $31,000 represents uncollected November sales. The total cash collected during January by LaGrange Corporation would be:

Answer 1

Answer: $186,000

Explanation:

January is the 2nd month from November which means that all of November's $31,000 will be collected in January.

January is the first month after December so 30% of December sales should be collected in January. 50% has already been collected in December and this left $50,000.

Total credit sales in December must have been:

= 50,000 / 50%

= $100,000

Amount to be collected in January for December:

= 100,000 * 30%

= $30,000

Amount to be collected from January credit sales:

= 50% * 150,000

= $75,000

January cash sales = $50,000

Total cash in January :

= 31,000 + 30,000 + 75,000 + 50,000

= $186,000