April May June Credit sales $ 374,400 $ 349,500 $ 420,500 Credit purchases 148,900 169,300 200,300 Cash disbursements Wages, taxes, and expenses 54,340 70,300 75,170 Interest 12,580 12,580 12,580 Equipment purchases 88,800 135,000 Uncollected credit sales 5% Collected in the month of the sale 35% Collected in the following month 60% Previous month credit sales 235,000 Previous month credit purchases 161,300 Beginning cash 135,000 Output Area: Sales collections = .35 times current month sales + .60 times previous month sales. April May June Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements