REQUIRED Use the information provided by Empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget. 5. INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024. Budgeted sales figures for 2024 are as follows: 2. January R320 000 R370 000 6. 7. 8. 9. 3. 4. Cash sales Credit sales 10 ● February R370 000 R390 000 Total purchases Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January R410 000 March R310 000 R320 000 February R460 000 April R250 000 R300 000 March R400 000 April R380 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is purchased on credit. Creditors are paid two months after the month of purchase: (Separate entries for cash and credit payments are required.) The proprietor's monthly drawings comprise R12 000 inventory and R10 000 cash. The monthly salaries are expected to amount to R194 400 for April 2024 after an increase of 8% takes effect on 01 April 2024. A fixed deposit, R100 000, will mature (expire) on 31 March 2024. Interest at 12% per annum for three months will also be received. Equipment with a cost price R160 000 will be purchased on 31 March 2024. A deposit 25% will be paid on this date. The balance will be paid in four equal monthly instalments commencing 30 April 2024. Other cash operating expenses are expected to amount to R160 000 for February 2024 and are expected to increase by 5% each month thereafter.
REQUIRED Use the information provided by Empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget. 5. INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024. Budgeted sales figures for 2024 are as follows: 2. January R320 000 R370 000 6. 7. 8. 9. 3. 4. Cash sales Credit sales 10 ● February R370 000 R390 000 Total purchases Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January R410 000 March R310 000 R320 000 February R460 000 April R250 000 R300 000 March R400 000 April R380 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is purchased on credit. Creditors are paid two months after the month of purchase: (Separate entries for cash and credit payments are required.) The proprietor's monthly drawings comprise R12 000 inventory and R10 000 cash. The monthly salaries are expected to amount to R194 400 for April 2024 after an increase of 8% takes effect on 01 April 2024. A fixed deposit, R100 000, will mature (expire) on 31 March 2024. Interest at 12% per annum for three months will also be received. Equipment with a cost price R160 000 will be purchased on 31 March 2024. A deposit 25% will be paid on this date. The balance will be paid in four equal monthly instalments commencing 30 April 2024. Other cash operating expenses are expected to amount to R160 000 for February 2024 and are expected to increase by 5% each month thereafter.
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 33E: A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent...
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
Please answer in text form (without image)
Transcribed Image Text:REQUIRED
Use the information provided by Empire Traders to prepare the following for March and April 2024:
4.1 Debtors Collection Schedule
4.2
Cash Budget.
5.
INFORMATION
The following information was provided by Empire Traders:
1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024.
Budgeted sales figures for 2024 are as follows:
2.
January
R320 000
R370 000
6.
7.
8.
9.
3.
4.
Cash sales
Credit sales
10.
●
February
R370 000
R390 000
Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%.
Collections from debtors are usually as follows:
80% is collected in the month after the sale.
●
20% is collected two months after the sale.
Purchases of inventory are expected to be as follows:
January
February
R410 000
R460 000
Total purchases
March
R310 000
R320 000
April
R250 000
R300 000
March
R400 000
April
R380 000
Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is
purchased on credit. Creditors are paid two months after the month of purchase: (Separate entries for
cash and credit payments are required.)
The proprietor's monthly drawings comprise R12 000 inventory and R10 000 cash.
The monthly salaries are expected to amount to R194 400 for April 2024 after an increase of 8% takes
effect on 01 April 2024.
A fixed deposit, R100 000, will mature (expire) on 31 March 2024. Interest at 12% per annum for three
months will also be received.
Equipment with a cost price R160 000 will be purchased on 31 March 2024. A deposit 25% will be paid
on this date. The balance will be paid in four equal monthly instalments commencing 30 April 2024.
Other cash operating expenses are expected to amount to R160 000 for February 2024 and are expected
to increase by 5% each month thereafter.
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
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
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning