Question
Please help! I cant figure out the rest of the amounts where I placed question marks. Please explain how to get the answers. Thank you!
Please help! I cant figure out the rest of the amounts where I placed question marks. Please explain how to get the answers. Thank you!
Topper, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Topper 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
October November December Quarter
Beginning cash balance 16,030 15,130 19,940 16,030
Collections from sales 56,590 82,090 103,950 242,630
---------------------------------------------------------------------------
Total cash available 72,620 97,220 123,890 258,660
Less disbursements
Materials purchases 12,330 9,340 14,460 36,130
Direct labor 5,160 6,020 8,360 19,540
Manufacturing overhead 19,990 23,490 21,820 65,300
Selling &Admin Exp. 29,010 29,340 ??? ???
Equipment purchase 15,170 15,170
Dividends 4,800 4,800
------------------------------------------------------------------------------
Total disbursements 66,490 68,190 ??? ???
------------------------------------------------------------------------------
Excess (deficiency) of cash 6,130 29,030 ??? ???
Minimum cash balance 15,000 15,000 15,000 15,000
------------------------------------------------------------------------------
Cash available (needed) (8,870) 14,030 13,430 ???
Financing:
Borrowings 9,000 9,000
Repayments (9,000) (9,000)
Interest (90) (90)
------------------------------------------------------------------------------
Total financing 9,000 (9,090) (90)
--------------------------------------------------------------------------------
Ending cash balance 15,130 19,940 ??? ???
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