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.

Answers: 3

Show answers

Other questions on the subject: Business

Business, 22.06.2019 08:40, jasonr182017

During january 2018, the following transactions occur: january 1 purchase equipment for $20,600. the company estimates a residual value of $2,600 and a five-year service life. january 4 pay cash on accounts payable, $10,600. january 8 purchase additional inventory on account, $93,900. january 15 receive cash on accounts receivable, $23,100 january 19 pay cash for salaries, $30,900. january 28 pay cash for january utilities, $17,600. january 30 firework sales for january total $231,000. all of these sales are on account. the cost of the units sold is $120,500. the following information is available on january 31, 2018. depreciation on the equipment for the month of january is calculated using the straight-line method. the company estimates future uncollectible accounts. at the end of january, considering the total ending balance of the accounts receivable account as shown on the general ledger tab, $4,100 is now past due (older than 90 days), while the remainder of the balance is current (less than 90 days old). the company estimates that 50% of the past due balance will be uncollectible and only 3% of the current balance will become uncollectible. record the estimated bad debt expense. accrued interest revenue on notes receivable for january. unpaid salaries at the end of january are $33,700. accrued income taxes at the end of january are $10,100

Answers: 2

continue

Business, 22.06.2019 15:20, byler47

Capital financial corporation will lend 90 percent against account balances that have averaged 30 days or less; 80 percent for account balances between 31 and 40 days; and 70 percent for account balances between 41 and 45 days. customers that take over 45 days to pay their bills are not considered acceptable accounts for a loan. the current prime rate is 16.50 percent, and capital charges 3.50 percent over prime to charming as its annual loan rate. a. determine the maximum loan for which charming paper company could qualify.

Answers: 1

continue

Business, 22.06.2019 17:50, hinokayleen5053

Which of the following is an element of inventory holding costs? a. material handling costs b. investment costs c. housing costs d. pilferage, scrap, and obsolescence e. all of the above are elements of inventory holding costs.

Answers: 1

continue

Business, 22.06.2019 19:00, mairadua14

12. to produce a textured purée, you would use a/an a. food processor. b. wide-mesh sieve. c. immersion blender d. food mill.

Answers: 1

continue

Do you know the correct answer?

The following information relates to Tea Limited, a company that will commence business on 1 January...