CHAPTER 26 –
c. The collections each month for this company are:
Collections = .15(Sales from 2 months ago) + .20(Last month’s sales) + .65(Current sales)
February collections = .15($250,714.29) + .20($258,000) + .65($274,200)
February collections = $267,437.14
10. The sales collections each month will be:
Sales collections = .35(current month sales) + .60(previous month sales)
Given this collection, the cash budget will be:
April May June
Beginning cash balance $443,500 $394,227 $503,450
Cash receipts
Cash disbursements
Purchases 247,100 232,850 277,900
Wages, taxes, and expenses 62,964 76,364 79,670
11. Item Source/Use Amount
Cash Source $2,365
Accounts payable Use –$22,126
Accrued expenses Use –$1,140
Intermediate
12. First, we need to calculate the sales from the last quarter of the previous year. Since 50 percent of the
sales were collected in that quarter, the sales figure must have been:
7