MASTER Student Name Section Number a> 99101112131415ActualandBudgetedUnitSales:AprilMayJuneJulyAugustSeptember1,5001,0001,6001,4001,5001,200 16 Balance Sheet, May 31, 19x5 17 Cash 18 Accounts receivable 19 Merchandise inventory Fixed assets (net) Owner's equity Total liabilities \& equity Average selling price 35 Collected in month of sale 36 Collected in month after sale 37 Collected two months after sale 38 Projected cash payments: 39 Variable expenses 404142Fixedexpenses(permonth)Depreciationpermonth30%ofsales$10,000$1,000 43 44 Answer Section: 44 Answer Section: Sales Budget Units Dollars FORMULA1FORMULA20000 Unit Purchases Budget Desired ending inventory Current month's unit sales FORMULA3FORMULA40000 Total units needed Beginning inventory FORMULASFORMULAG0000 62 Purchases (units) 63 FORMULA7 0=0 64 Purchases (dollars) 65 67 68 69 70 Cash Budget 71 Cash balance, beginning 72 Cash receipts: June$8,000=4August$42,760$142,720 73 Collections from customers: 74 From April sales 75 From May sales 76 From June sales 77 From July sales 78 From August sales 89 Total cash available 81 Cash disbursements: 82 Merchandise 83 Variable expenses 84 Fixed expenses 85 Interest paid 86 87 Total disbursements 88 89 Cash balance before financing on Ino. nonimet modinm hntamn