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.
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.
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter22: Providing And Obtaining Credit
Section: Chapter Questions
Problem 4MC
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
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
Transcribed Image Text:January
February
March
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning