The following is the sales budget for Segura, Inc., for the first quarter of 201
ID: 2684488 • Letter: T
Question
The following is the sales budget for Segura, Inc., for the first quarter of 2010. Sales budget for January $129,000 February $146,000 March $161,000. Credit sales are collected as follows: 65% in the month of sales 20 % in the month after sales 15% on the second month after sales The accounts receivable balance at the end of the previous quarter was $92,000 ($67,000 of which was uncollected December sales). a. Compute the sales for Nov. b. Compute the sales for Dec. Compute the cash collection from sales for each month from January through March.Explanation / Answer
The sales must have been the total uncollected sales minus the uncollected sales from December, divided by the collection rate two months after the sale, so:
November sales = ($92,000+ 67,000)/0.15 November sales = $166,666.67
====================
b. The December sales are the uncollected sales from December divided by the collection rate of the previous months sales, so:
December sales = $67,000/0.35 December sales = $191,428.57
c. The collections each month for this company are: Collections = .15(Sales from 2 months ago) + .20(Last months sales) + .65 (Current sales)
.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.