In: Accounting
| Your answer is partially correct. Try again. | |
Bramble, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Bramble desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
| October | November | December | Quarter | ||||
| Beginning cash balance | $ | $15,530 | $ | $16,290 | |||
| Collections from sales | 56,290 | 241,390 | |||||
| Total cash available | 72,580 | 97,630 | 125,320 | ||||
| Less disbursements | |||||||
| Materials purchases | 9,370 | 13,960 | 35,370 | ||||
| Direct labor | 5,020 | 5,740 | 7,830 | 18,590 | |||
| Manufacturing overhead | 20,100 | 21,660 | 21,970 | ||||
| Selling & administrative expenses | 28,890 | 29,450 | |||||
| Equipment purchase | 15,440 | ||||||
| Dividends | 4,940 | 4,940 | |||||
| Total disbursements | 66,050 | ||||||
| Excess (deficiency) of cash | 31,410 | ||||||
| Minimum cash balance | 15,000 | 15,000 | 15,000 | ||||
| Cash available (needed) | -8,470 | 14,730 | |||||
| Financing: | |||||||
| Borrowings | 9,000 | ||||||
| Repayments | -9,000 | ||||||
| Interest | -90 | -90 | |||||
| Total financing | -9,090 | -90 | |||||
| Ending cash balance | $15,530 | $22,320 | $ | $ |
| October | November | December | Quarter | |||
| Beginning cash balance | 16,290 | 15,530 | 22,320 | $16,290 | ||
| Collections from sales | 56,290 | 82,100 | 103,000 | 241,390 | ||
| A | Total cash available | 72,580 | 97,630 | 125,320 | ||
| Less disbursements: | ||||||
| Materials purchases | 12,040 | 9,370 | 13,960 | 35,370 | ||
| Direct labor | 5,020 | 5,740 | 7,830 | 18,590 | ||
| Manufacturing overhead | 20,100 | 21,660 | 21,970 | 63,730 | ||
| Selling & administrative expenses | 28,890 | 29,450 | 31,450 | 89,790 | ||
| Equipment purchase in Dec | - | - | 15,440 | 15,440 | ||
| Dividends | - | - | 4,940 | 4,940 | ||
| B | Total disbursements | 66,050 | 66,220 | 95,590 | 227,860 | |
| Excess (deficiency) of cash (A-B) | 6,530 | 31,410 | 29,730 | |||
| Minimum cash balance | 15,000 | 15,000 | 15,000 | |||
| Cash available (needed) | - 8,470 | 14,730 | ||||
| Financing: | ||||||
| Borrowings-Balance | 24,000 | 9,000 | ||||
| Repayments | - 9,000 | - 9,000 | ||||
| Interest | - 90 | - 90 | ||||
| Total financing | 24,000 | - 9,090 | - 90 | |||
| Ending cash balance | 15,530 | 22,320 | 29,730 | $ | ||
| October | November | |||||
| Total cash available | 72,580 | 97,630 | ||||
| Less: Collection of Sales/beg Bala | 56,290 | 15,530 | ||||
| Beginning cash balance | 16,290 | 82,100 | ||||
| Materials purchases-Qtr | 35,370 | |||||
| Less: Nov & Dec | 23,330 | |||||
| Oct Purchases | 12,040 | |||||
| Total disbursements | 66,050 | |||||
| Less: All Other Expense | 66,050 | |||||
| Dividend | - | |||||