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
Japanese Management Accounting A World Class Approach To Profit Management
Authors: Michiharu Sakurai, Yasuhiro Monden
1st Edition
091529950X, 978-0915299508
