Question
The management of Sondela Limited has decided to prepare a cash budget for May and June 20X9. The following information is available: February March April
The management of Sondela Limited has decided to prepare a cash budget for May and June 20X9. The following information is available:
| February | March | April | May | June |
Sales: Cash | R250 600 | R290 500 | R305 700 | R300 000 | R320 000 |
Sales: Credit | R410 500 | R500 000 | R585 800 | R580 000 | R600 000 |
Purchases | R595 400 | R684 700 | R700 800 | R690 000 | R710 000 |
Salaries and wages | R65 800 | R65 800 | R65 800 | R65 800 | R65 800 |
Sundry expenses | R18 700 | R19 400 | R25 400 | R20 500 | R21 500 |
Additional information:
- Cash in respect of credit sales is collected as follows:
50% during the month following sale
30% during the second month after sale
15% during the third month after sale
5% is uncollectible
- The following discounts are allowed on sales
10% on cash sales
5% on credit sales; if accounts are settled within the month following sales.
- All salaries, wages and sundry expenses are paid in cash.
- Sundry expenses include depreciation of R3 000 per month.
- 60% of all purchases are on credit and are paid during the month following that of the transaction. The rest represent cash purchases.
- On the 30th June a dividend of R5 000 was declared.
- The cash balance on the 30th April was R10 500. Sondela Limited always keeps a minimum cash balance of R10 000.
- Any shortages are financed with bank loans at 15% interest per annum, payable monthly.
REQUIRED
The management of Sondela Limited has decided to prepare a cash budget for May and June 20X9. The following information is available:
| February | March | April | May | June |
Sales: Cash | R250 600 | R290 500 | R305 700 | R300 000 | R320 000 |
Sales: Credit | R410 500 | R500 000 | R585 800 | R580 000 | R600 000 |
Purchases | R595 400 | R684 700 | R700 800 | R690 000 | R710 000 |
Salaries and wages | R65 800 | R65 800 | R65 800 | R65 800 | R65 800 |
Sundry expenses | R18 700 | R19 400 | R25 400 | R20 500 | R21 500 |
Additional information:
- Cash in respect of credit sales is collected as follows:
50% during the month following sale
30% during the second month after sale
15% during the third month after sale
5% is uncollectible
- The following discounts are allowed on sales
10% on cash sales
5% on credit sales; if accounts are settled within the month following sales.
- All salaries, wages and sundry expenses are paid in cash.
- Sundry expenses include depreciation of R3 000 per month.
- 60% of all purchases are on credit and are paid during the month following that of the transaction. The rest represent cash purchases.
- On the 30th June a dividend of R5 000 was declared.
- The cash balance on the 30th April was R10 500. Sondela Limited always keeps a minimum cash balance of R10 000.
- Any shortages are financed with bank loans at 15% interest per annum, payable monthly.
REQUIRED
Prepare a cash budget for May and June 20X9.
Prepare a cash budget for May and June 20X9.
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