Question
Marigold, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Marigold desires to maintain a $15,000 minimum
Marigold, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Marigold 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 | $enter a dollar amount | $15,500 | $enter a dollar amount | $16,500 | |||
Collections from sales | 54,000 | enter a dollar amount | enter a dollar amount | 236,090 | |||
Total cash available | 70,500 | 94,000 | 120,000 | enter a total amount for the first part | |||
Less disbursements | |||||||
Materials purchases | enter a dollar amount | 10,000 | 14,000 | 34,000 | |||
Direct labor | 5,000 | 5,000 | 8,000 | 18,000 | |||
Manufacturing overhead | 20,000 | 24,000 | 22,000 | enter a dollar amount | |||
Selling & administrative expenses | 29,000 | 29,500 | enter a dollar amount | enter a dollar amount | |||
Equipment purchase | enter a dollar amount | 15,000 | |||||
Dividends | 5,000 | 5,000 | |||||
Total disbursements | 64,000 | enter a total amount for section one | enter a total amount for section one | enter a total amount for section one | |||
Excess (deficiency) of cash | enter a total amount for the second part | 25,500 | enter a total amount for the second part | enter a total amount for the second part | |||
Minimum cash balance | 15,000 | 15,000 | 15,000 | enter a dollar amount | |||
Cash available (needed) | -8,500 | enter a total amount for the third part | 9,000 | enter a total amount for the third part | |||
Financing: | |||||||
Borrowings | enter a dollar amount | 9,000 | |||||
Repayments | enter a dollar amount | -9,000 | |||||
Interest | -90 | -90 | |||||
Total financing | enter a total amount for section two | -9,090 | -90 | ||||
Ending cash balance | $15,500 | $16,410 | $enter a total amount | $enter a total amount |
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