2 3 4 5 6 $ 22 23 24 March Purchases 7 8 9 Cash Sales 10 Credit Sales 11 Total Collections 12 13 14 15 Budgeted Cost of Goods Sold 16 add: Desired Ending Inventory 17 Total Needs 18 less: Beginning Inventory 19 Required Purchases 20 21 Ready S 25 April Purchases 26 May Purchases 27 June Purchases 28 Total Disbursements 29 30 31 32 Commissions 33 Rent 34 Other Expenses 35 Total Disbursements 36 37 38 39 Cash Balance Beginning 40 Add: Cash Collections 41 Total Cash Available 42 43 Less Cash Disbursements 44 For Inventory 45 For Expenses 46 For Equipment 47 Total Cash Disbursements 48 Excess (deficiency) of Cash 49 Borrowing 50 Repayments 51 Interest Paid 52 Ending Cash Balance 53 54 30 Sheet1 Mon March 50,000 $ Louis Schedule of Expected Cash Collections NIII Budgeted Sales April May June July 60,000 $72,000 $90,000 $ 48,000 Schedule of Expected Cash Disbursements - Merchandise Purchaes April May $ $ $ Tues Merchandise Purchases Budget April $ May 45,000 $ 54,000 43,200 $ 54,000 88,200 $ 108,000 36,00