Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 3 (20 Marks) REQUIRED Use the information provided below to prepare the following for January and February 2024: 3.1 Debtors Collection Schedule ( 4

image text in transcribed

QUESTION 3 (20 Marks) REQUIRED Use the information provided below to prepare the following for January and February 2024: 3.1 Debtors Collection Schedule ( 4 marks) 3.2 Cash Budget (16 marks) INFORMATION The following information supplied by Orbit Enterprises: 1. Orbit Enterprises expects to have an unfavourable bank balance of R36 000 on 31 December 2023. 2. Expected sales are as follows: 3. Credit sales account for 60% of the total sales. The rest of the sales is for cash. 4. The amounts owed by debtors are usually collected as follows: - 20% is collected in the same month as the credit sales for a 2% cash discount. - 75% is collected in the month after the sale. 5% is written off as bad debts. 5. Forty percent (40%) of the purchases of inventory will be on credit. Creditors are paid two months after the purchase. The rest of the purchases will be for cash. A cash discount of 10% is expected to be received on 50% of the cash purchases. Purchases have been forecasted as follows: 6. The monthly salary expense of R 100000 is expected to increase by 7% from 01 February 2024. 7. Interest on loan for three months at an interest rate of 15% p.a. on the loan balance of R200 000 will be paid on 31 January 2024. 8. Advertising expenses are paid monthly and are estimated to be a fixed percentage of the total sales of the previous month. The advertising expense for December 2023 is expected to be R16 000 . 9. The proprietor's cash drawings are expected to amount to R24 000 per month. 10. Other cash operating expenses are expected to increase by 5% per month. Cash operating expenses for December 2023 are expected to amount to R40 000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Auditing A Tool For Excellence

Authors: David Mills, J. Mills

1st Edition

041245890X, 978-0412458903

More Books

Students also viewed these Accounting questions