Answered step by step
Verified Expert Solution
Question
1 Approved Answer
XX Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are recorded:
XX Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are recorded:
- About 60% of sales are collected 1 month after the sale and the remainder is collected in the second month following the sale.
- The company purchases are 80% of future sales forecasted. These are made 2 months in advance of expected sales.
- Payments for these purchases are made in the next month after purchase.
- Other expenses such as monthly wages and salaries are estimated at 5% of monthly forecast sales.
- You are required to complete the 3-month (January, February, and March) cash budget below for HYD company. Note: Provide answers ONLY for coloured boxes A to X
| November | December | January | February | March | April | May |
|
Sales | 50,000 | 60,000 | 70,000 | 85,000 | 98,000 | 100,000 | 110,000 |
|
Purchases | 56,000 | 68,000 | A | I | Q |
|
|
|
Cash receipts / collections | ||||||||
Sales collected after one month |
|
| B | J | R |
|
|
|
Sales collected after two months |
|
| C | K | S |
|
|
|
Total cash receipts |
|
| D | L | T |
|
|
|
Cash disbursements | ||||||||
Payments for purchases |
|
| E | M | U |
|
|
|
Wages and Salaries |
|
| F | N | V |
|
|
|
Total cash disbursements |
|
| G | O | W |
|
|
|
Net change in cash |
|
| H | P | X |
|
|
|
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