subject
Business, 03.07.2020 19:01 janahiac09

The following information relates to Tea Limited, a company that will commence business on 1 January 2021. The company is preparing its budget for 2021 and will detail the projected activities for each quarter of the year.

Information:
1. Cash at bank on 1 January 2021 amounted to R150 000.
2. Projected sales per quarter for 2021:
First quarter R750 000
Second quarter R825 000
Third quarter R930 000
Fourth quarter R980 000
Fifty percent (50%) of the sales are for cash and fifty percent (50%) are on credit. Cash customers are entitled to a 5% cash discount.

3. Collection of credit sales:

60% of the credit sales are collected in the quarter of the sale.
30% is collected in the following quarter and the balance is written off as a bad debt.

4. Purchases for each quarter are expected to be as follows:

First quarter R100 000
Second quarter R120 000
Third quarter R140 000
Fourth quarter R180 000

All purchases are on credit. 75% of the purchases will be paid for in the quarter of purchase and the remaining 25% in the following quarter.

5. Fixed overheads total R200 000 per year and are paid for equally each quarter.
6. Administrative expenses are paid for in the quarter in which they are incurred and are estimated at a total of R20 000 per quarter.
7. An investment of R150 000 matures on 30 June 2021, and interest of R15 000 will also be received on this date.

Required:

a. Prepare the Debtors Collection Schedule for the four quarters of 2021.
b. Prepare the Cash Budget for the four quarters of 2021.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 12:10
Lambert manufacturing has $100,000 to invest in either project a or project b. the following data are available on these projects (ignore income taxes.): project a project b cost of equipment needed now $100,000 $60,000 working capital investment needed now - $40,000 annual cash operating inflows $40,000 $35,000 salvage value of equipment in 6 years $10,000 - both projects will have a useful life of 6 years and the total cost approach to net present value analysis. at the end of 6 years, the working capital investment will be released for use elsewhere. lambert's required rate of return is 14%. the net present value of project b is:
Answers: 2
question
Business, 22.06.2019 16:30
Why are there so many types of diversion programs for juveniles
Answers: 2
question
Business, 23.06.2019 08:30
The hypothetical country of eurica is experiencing severe competition to its domestic auto industry in the form of foreign imports. many jobs are threatened. eurica places a 25 percent tariff on the price of imported cars. this type of tariff is known as a(n) tariff.
Answers: 1
question
Business, 23.06.2019 13:30
Financial statement: maisie taft started her own
Answers: 1
You know the right answer?
The following information relates to Tea Limited, a company that will commence business on 1 January...
Questions
question
Mathematics, 17.09.2019 19:30
question
Mathematics, 17.09.2019 19:30
question
Mathematics, 17.09.2019 19:30
Questions on the website: 13722367