it View History Bookmarks People Window Help 36E Srn 10 1121

it View History Bookmarks People Window Help ?36%E) Sr.n 10 11:21:09 PM Jo a E ?

Solution

October November December Quarter Beginning Cash balance 16450 15950 20630 16450 (72070-55620) (124570-103940) Collections from sales 55620 82270 103940 241830 (98220-15950) (241830-55620-82270) Total Cash available (A) 72070 98220 124570 258280 Less Disbursements (16450+241830) Material Purchases 11810 9270 13500 34580 (34580-9270-13500) Direct Labor 5280 5370 7810 18460 Manufacturing Overhead 19910 23420 21840 65170 (19910+23420+21840) Selling and Administrative Expenses 29120 29430 31780 90330 (124570-63780-29010) Equipment Purchase 0 0 15130 15130 (all purchase during december) Dividends 0 0 5500 5500 (5500-5500) (5500-5500) Total disbursements (B) 66120 67490 95560 229170 Excess (deficency) of cash (A-B) 5950 30730 29010 29110 (15000+14010) Minimum Cash balance 15000 15000 15000 15000 Cash available (needed) -9050 15730 14010 Financing Borrowings 10000 0 0 10000 (only increments of $1000) (9050 rounded off to 10000) Repayments 0 -10000 0 -10000 Interest 0 -100 0 -100 Total Financing 10000 -10100 0 -100 Endign Cash balance 15950 20630 29010 29010 (10000+5950) (30730-10100) (29010-0) (29110-100)