Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make Footnotes and Assumptions for the following table in accordance to CRP Products. Cash Budget Section 9 - Chapter 10 Required -Three (3) years cash
Make Footnotes and Assumptions for the following table in accordance to CRP Products.
| Cash Budget | |||
| Section 9 - Chapter 10 Required -Three (3) years cash Budget/Financing | |||
| *Must include rich assumptions in foot notes | |||
| 2022 | 2023 | 2024 | |
| $ | $ | $ | |
| Beginning Cash | 40,000.00 | 28,200.00 | 22,865.00 |
| Cash recepits from sales | 95,300.00 | 197,150.00 | 353,248.00 |
| Total Available Cash | 135,300.00 | 225,350.00 | 376,113.00 |
| All payouts | |||
| Raw material purchase | 14,000.00 | 67,000.00 | 109,600.00 |
| Direct labour | 10,000.00 | 16,000.00 | 33,000.00 |
| Plant manager's salary | 3,000.00 | 20,000.00 | |
| Indirect labour | 1,600.00 | 2,200.00 | 3,200.00 |
| Factory utilities | 1,800.00 | 2,500.00 | 27,000.00 |
| Factory rent | 70,000.00 | 13,000.00 | 27,000.00 |
| Factory insurance | 200 | 300 | 700 |
| Packaging cost | 850 | 1,610.00 | 3,350.00 |
| Factory repairs | 805 | 1,600.00 | 3,300.00 |
| Manager Salary | 35,000.00 | 38,500.00 | 8,750.00 |
| Office expences | 3,000.00 | 3,300.00 | 3,600.00 |
| Administrative expenses | 28,000.00 | 30,000.00 | 27,000.00 |
| Marketing Expenses | 23,000.00 | 25,200.00 | 27,400.00 |
| Freight | |||
| Less: Total Disbursements | 191,255.00 | 206,210.00 | 293,900.00 |
| Ending Cash Balance |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Auditing A Practical Approach with Data Analytics
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
1st edition
1119401747, 978-1119401742
