Cash Collection Budget
Ana cortes Antiques offers a 2% discount to customers who pay cash at the time of sale and a 1% discount to customers who pay within the first 10 days of the month after sale. Past experience shows that cash collections from customers tend to occur in the following pattern:
Cash collected at time of sale 50%
Collected within cash discount period in first 10 days of month after sale 10
Collected after cash discount period in first month after month of sale 25
Collected after cash discount period in second month after month of sale 12
Never collected 3
Compute the total cash budgeted to be collected in March if sales forecasts are $360,000 for January, $400,000 for February, and $450,000 for March.
Cash collection in March
Cash collected at time of sale 50% = 450,000 X 50% X .98 (2% discount is given) = 220,500
The solution explains how to make a cash collection budget for Ana Cortes Antiques case study with step-by-step calculations and brief explanations.