Question

Stem Ano CALCULATOR PRINTER VEnsion BACK NEXTA Ixercise 5-27 Bramble Incoreowed the owing cash budget for the fourth quarter on the song an ounts, acuming that Brmble des res to maintain $15.000 minimum monthly cash balance and all ruiment was purchased dur december. Any required borrowing and repayments must be made in even increments of $1,000 (Enter answers are my l or d s blandnotenie) October December Quarter November $15.50 516,290 Being cash balance Collections from sales SEO 241.390 Total che 90 12520 Les disbursements Materials purchases 9370 13.160 30 090 18.550 Director naturing the 20.100 329 Selling administrative tenses Equipment nuchas Dividends 4 Total distret Excen (anticenor) of cash. Minimum cash baco 15.000 15,000 Cash wilsblended) ng Borrowings Repayment interest Total Ending a balance Click if you would like to show Work for this question:

Answer 1

Bramble Inc. Cash budget Calculation October =72,580-56,290 # Quarter October 16,290 56,290 72,580 November December Quarter 15,530 22,320 16,290 82,100 103,000 241,390 97,630 125,320 257,680 November December =125,320-103,000 =97,630-15,530 =241,390-56,290-82,100 =16,290+241,390 =35370-9,370-13,960 12,040 5,020 20,100 28,890 9,370 5,740 21,660 29,450 =125,320-13,960-7,830-21,970-15,440-4,940-15,000-14,730 Cash avail less disbursements less Min Cash bal less 14,730 Beginning Cash balance Collections from sales Total cash available Less: disbursements Materials purchases Direct labor Manufacturing overhead Selling and administrative expenses Equipment purchase Dividends Total disbursements Excess (deficiency) of cash Minimum Cash balance Cash available (needed) Financing Borrowings Repayments Interest Total financing Ending Cash balance 13,960 7,830 21,970 31,450 15,440 4,940 95,590 29,730 15,000 14,730 35,370 18,590 63,730 89,790 15,440 4,940 227,860 29,820 15,000 14,820 =72,580-66,050 =125,320-95,590 66,050 6,530 15,000 (8,470) 66,220 31,410 15,000 16,410 =31,410-15,000 9,000 As cash is needed of $8,470 in Oct As cash is available of $16,410 to repay in Nov (9,000) (90) (9,090) 22,320 9,000 (9,000) (90) (90) 29,730 9,000 15,530 29,730