Question
QUESTION 1 [20 MARKS] Tel-one (Pty) Ltd supplies components for iPads. Information Actual 2014 Estimated January February March April May Sales 192,000.00 240,000.00 120,000.00 320,000.00
QUESTION 1 [20 MARKS] Tel-one (Pty) Ltd supplies components for iPads. |
Information |
| Actual 2014 | Estimated | |||
| January | February | March | April | May |
Sales | 192,000.00 | 240,000.00 | 120,000.00 | 320,000.00 | 400,000.00 |
Purchase | 200,000.00 | 100,000.00 | 320,000.00 | 168,000.00 | 120,000.00 |
Sales commision | 800.00 | 1,200.00 | 2,400.00 | 1,600.00 | 800.00 |
Wages | 1,600.00 | 1,600.00 | 1,600.00 | ? | ? |
2. Cash transactions:
- 40% of all sales are for cash with the balance being on credit. |
- 35% of all purchases are for cash with the balance being on credit.
|
3. Collections for credit sales are as follows:
- 20% is collected in the month of the sale and a 2% discount is granted on these collections. - 60% is collected in the month following the month of sale. - 15% is collected in the second month following the month of sale. The remaining 5% is written off as bad debts.
|
4. Tel-one (Pty) Ltd will make an investment of R150 000 in fixed deposit on 01 April 2014. Interest of R1 500 per month is expected to be received from 30 April 2014.
|
5. Creditors are paid 2 months after the date of invoice.
|
6. Rent expense amounts to R18 000 per month and is payable on the first day of each month.
|
7. Wages will be increased by 10% in April 2014 and will increase by a further 5% in May 2014.
|
8. A new machine is expected to be purchased for R40 000 cash on 1 May 2014. Depreciation is calculated using the straight line method.
|
9. Commission is paid to sales personnel in the month following the month in which it was earned.
|
10. On 31 March 2014 Tel-one (Pty) Ltd had a bank overdraft of R9 000. |
Required:
Use the information provided to:
1.1 Prepare a debtors collection schedule for April and May 2014. (6)
1.2 Prepare the Cash budget for April and May 2014. (14)
Note: Where applicable, round off all amounts to the nearest Rand.
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