Question

Alderman Corporation has found that 80% of its sales in any given month are credit sales, while the remainderare cash sales of the credit sales, Alderman Corporation has experienced the following collection pattern November sales for last year were $100,000, while December sales were $120,000. Projected sales for the next three months are as follows S January sales February sales March sales 150.000 125.000 165,000 $ 25% received in the month of the sale 50% received in the month after the sale 18% received two months after the sale 7% of the credit sales are never received Requirement Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar) Alderman Corporation Cash Collections Budget For the Months of January through March January Cash sales Collections on credit sales: 25% Month of sale 50% Month after 18% Two months after Total cash collections

Answer 1

Solution

Alderman Corporation
Cash collection budget
For the month of January through march
	January	February	March
Cash sales	$        30,000.00	$        25,000.00	$        33,000.00
Collection on credit sales
25% Month of sale	$        30,000.00	$        25,000.00	$        33,000.00
50% Month after	$        48,000.00	$        60,000.00	$        50,000.00
18% Two months after	$        14,400.00	$        17,280.00	$        21,600.00
Total Cash collections	$     122,400.00	$     127,280.00	$     137,600.00

Working

	November	December	January	February	March
Sales	$     100,000.00	$     120,000.00	$     150,000.00	$    125,000.00	$     165,000.00
Cash sales	$        20,000.00	$        24,000.00	$        30,000.00	$      25,000.00	$       33,000.00
Credit sales	$        80,000.00	$        96,000.00	$     120,000.00	$    100,000.00	$     132,000.00