Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cash Budget Brindle Arts had the following Cash Budget for Quarter 4, 2022. The company requires a minimum cash balance of $ 50,000 Fill
Cash Budget Brindle Arts had the following Cash Budget for Quarter 4, 2022. The company requires a minimum cash balance of $ 50,000 Fill in the missing values: Cash Budget out of 15 points **If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect. October November December Quarter 4 $ 103,130 $ 50,000 Beginning Cash balance $ 50,000 Add cash collections Total cash available $ 892,173 $ 991,822 $1,136,330 $ 2,866,733 Less total cash disbursements: Purchases $ 323,903 $ 361,292 Direct labor $ 126,000 $ 122,598 $ 354,158 Variable manufacturing OH $ 100,800 $ 98,078 $ 283,326 Fixed manufacturing OH $ 125,000 125,000 Variable S&A $ 58,800 $ 75,600 $ 210,000 Fixed S&A Equipment $ 100,000 $ 100,000 $ 130,000 $ 175,000 Total cash disbursements $ 888,692 $ 2,791,070 Cash available before financing $ (35,538) $ 103,130 $ 161,662 $ 75,662 Financing: Borrowings (at beginnings of quarters) $ 86,000 $ $ 86,000 Repayments $ $ - $ 86,000 Interest Total Financing $ (91,160) Ending Cash balance $ 50,462 $ 70,502 $ 70,502
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