Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What are the requirements for me to clarify regarding budgets and related policies ? MY-T Bikesaver Cash Budget For the Year Ended 31 December 2021
What are the requirements for me to clarify regarding budgets and related policies ?
MY-T Bikesaver | ||||||||
Cash Budget | ||||||||
For the Year Ended 31 December 2021 | ||||||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year | ||||
Beginning Cash Balance | 0.00 | 97560.00 | 108580.00 | 124560.00 | 0.00 | |||
Capital | 100000.00 | 100000.00 | ||||||
Add: Cash Collections | 70000.00 | 114000.00 | 113000.00 | 124000.00 | 421000.00 | |||
Total Cash available | 170000.00 | 211560.00 | 221580.00 | 248560.00 | 521000.00 | |||
Less: Cash disbursement | ||||||||
Materials | 33950.00 | 63350.00 | 58380.00 | 62570.00 | 218250.00 | |||
Direct Labor | 4960.00 | 4720.00 | 4560.00 | 5328.00 | 19568.00 | |||
Manufacturing Overhead | 22480.00 | 22360.00 | 22280.00 | 22664.00 | 89784.00 | |||
Selling and Administrative | 11050.00 | 12550.00 | 11800.00 | 13300.00 | 48700.00 | |||
Company Van | 30000.00 | 30000.00 | ||||||
Total disbursements | 102440.00 | 102980.00 | 97020.00 | 103862.00 | 406302.00 | |||
Excess/ (Deficiency) | 67560.00 | 108580.00 | 124560.00 | 144698.00 | 114698.00 | |||
Financing: | ||||||||
Borrowing | 30000.00 | 30000.00 | ||||||
Repayment | -30000.00 | -30000.00 | ||||||
Interest | -1500.00 | -1500.00 | ||||||
Total financing | 30000.00 | 0.00 | 0.00 | -31500.00 | -1500.00 | 5% interest expense | ||
Ending cash balance | 97560.00 | 108580.00 | 124560.00 | 113198.00 | 113198.00 |
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