Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethical Obligations and Decision Making in Accounting Text and Cases

Authors: Steven Mintz, Roselyn Morris

3rd edition

007786221X, 978-0077862213

More Books

Students also viewed these Accounting questions

Question

15.11 Prove the linearizability property of Algorithm 49.

Answered: 1 week ago

Question

Describe what a good profits chart might look like.

Answered: 1 week ago