Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | $ | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started