Cash Budget Brindle Arts had the following Cash Budget for Quarter 1, 2022. The company requires a minimum cash balance of $ 50,000 Fill in the missing values:**If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect. JanuaryFebruaryMarchQuarter 1Beginning Cash balance $ 50,000 $ 166,756 $ 50,000Add cash collections Total cash available $ 662,638 $ 673,643 $ 812,693 $ 1,931,075Less total cash disbursements: Purchases $ 185,078 $ 189,439 Direct labor $ 86,875 $ 82,875 $ 249,750Variable manufacturing OH $ 65,156 $ 62,156 $ 187,313Fixed manufacturing OH $ 83,333 $ 83,333 Variable S&A $ 38,750 $ 43,750 $ 125,000Fixed S&A $ 38,333 $ 38,333 Equipment $ 150,000 $ 175,000 Total cash disbursements $ 506,887 $ 1,869,498Cash available before financing $ 27,143 $ 166,756 $ 85,577 $ 61,577Financing: Borrowings (at beginnings of quarters) $ 24,000 $ - $ 24,000Repayments $ - $ - $ 24,000 Interest Total Financing $ (25,080) Ending Cash balance $ 51,143 $ 60,497 $ 60,497

Cash Budget is prepared by the Business entity to anticipate the cash requirement for the operations…

Answered: Fill in the missing values: **If a…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

Cash Budget
Brindle Arts had the following Cash Budget for Quarter 1, 2022.

The company requires a minimum cash balance of	$ 50,000

Fill in the missing values:	**If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect.
	January	February	March	Quarter 1
Beginning Cash balance	$ 50,000		$ 166,756	$ 50,000
Add cash collections
Total cash available	$ 662,638	$ 673,643	$ 812,693	$ 1,931,075
Less total cash disbursements:
Purchases	$ 185,078	$ 189,439
Direct labor		$ 86,875	$ 82,875	$ 249,750
Variable manufacturing OH		$ 65,156	$ 62,156	$ 187,313
Fixed manufacturing OH	$ 83,333		$ 83,333
Variable S&A	$ 38,750	$ 43,750		$ 125,000
Fixed S&A		$ 38,333	$ 38,333
Equipment	$ 150,000		$ 175,000
Total cash disbursements		$ 506,887		$ 1,869,498
Cash available before financing	$ 27,143	$ 166,756	$ 85,577	$ 61,577
Financing:
Borrowings (at beginnings of quarters)	$ 24,000	$ -		$ 24,000
Repayments	$ -	$ -	$ 24,000
Interest
Total Financing			$ (25,080)
Ending Cash balance	$ 51,143		$ 60,497	$ 60,497

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution