The following projections have been made by Orange Traders for the period ending 31 March 2022: 1. Total sales: February R1 875 000 January March R1 450 000 R1 400 000 2. Cash sales are 42% of total sales and these customers are allowed a cash discount of 4% and the balance is on credit. 3. Credit sales are collected as follows: 15% in the month of the sale 55% in the month after the sale 28% two months after the sale and the balance is written off as irrecoverable. 4. Total purchases: January 62 500 February 150 000 March Cash purchases Credit purchases 200 000 250 000 300 000 325 000 A discount of 4% is received on cash purchases. Creditors are paid in full one month after the month of purchases. 5. Operating expenses amount to R51 500 for January and are paid in cash. They are expected to increase by 1.5% per month thereafter. 6. Monthly salaries amount to R80 000 per month. They are expected to increase by 8.5% with effect from 1 March 2022. 7. Rent income is R17 800 per month. The rent will increase to R19 000 on 1 March 2022. 8. An investment of R320 000 will be made at My Bank on 28 February 2022. The interest rate will be 9% per annum and paid every month starting on 31 March 2022. 9. Orange Traders expects to have an unfavorable bank balance of R124 500 on 1 January 2022.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Use the information supplied to prepare the following for Silver City Traders for the three months ending 31 March 2022.

1.1 Debtors collection schedule.

1.2 Cash budget statement.

January
February
March
Transcribed Image Text:January February March
The following projections have been made by Orange Traders for the period ending 31 March 2022:
1. Total sales:
February
R1 875 000
January
March
R1 450 000
R1 400 000
2. Cash sales are 42% of total sales and these customers are allowed a cash discount of 4% and
the balance is on credit.
3. Credit sales are collected as follows:
15% in the month of the sale
55% in the month after the sale
28% two months after the sale and the balance is written off as irrecoverable.
4. Total purchases:
January
February
March
Cash purchases
Credit purchases
62 500
150 000
200 000
250 000
300 000
325 000
A discount of 4% is received on cash purchases.
Creditors are paid in full one month after the month of purchases.
5. Operating expenses amount to R51 500 for January and are paid in cash. They are expected
to increase by 1.5% per month thereafter.
6. Monthly salaries amount to R80 000 per month. They are expected to increase by 8.5% with effect from
1 March 2022.
7. Rent income is R17 800 per month. The rent will increase to R19 000 on 1 March 2022.
8. An investment of R320 000 will be made at My Bank on 28 February 2022. The interest rate will
be 9% per annum and paid every month starting on 31 March 2022.
9. Orange Traders expects to have an unfavorable bank balance of R124 500 on
1 January 2022.
Transcribed Image Text:The following projections have been made by Orange Traders for the period ending 31 March 2022: 1. Total sales: February R1 875 000 January March R1 450 000 R1 400 000 2. Cash sales are 42% of total sales and these customers are allowed a cash discount of 4% and the balance is on credit. 3. Credit sales are collected as follows: 15% in the month of the sale 55% in the month after the sale 28% two months after the sale and the balance is written off as irrecoverable. 4. Total purchases: January February March Cash purchases Credit purchases 62 500 150 000 200 000 250 000 300 000 325 000 A discount of 4% is received on cash purchases. Creditors are paid in full one month after the month of purchases. 5. Operating expenses amount to R51 500 for January and are paid in cash. They are expected to increase by 1.5% per month thereafter. 6. Monthly salaries amount to R80 000 per month. They are expected to increase by 8.5% with effect from 1 March 2022. 7. Rent income is R17 800 per month. The rent will increase to R19 000 on 1 March 2022. 8. An investment of R320 000 will be made at My Bank on 28 February 2022. The interest rate will be 9% per annum and paid every month starting on 31 March 2022. 9. Orange Traders expects to have an unfavorable bank balance of R124 500 on 1 January 2022.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education