Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

REQUIRED Use the information provided below to prepare the following for August and September 2023: 1. Debtors Collection Schedule (4 marks) 2. Cash Budget (16

REQUIRED Use the information provided below to prepare the following for August and September 2023: 1. Debtors Collection Schedule (4 marks) 2. Cash Budget (16 marks) INFORMATION The following information was provided by Orlando Enterprises: 1. The bank balance on 31 July 2023 is expected to be R80 000 (favourable). 2. The expected sales are as follows: image text in transcribed 3. Customers who purchase for cash are entitled to a 5% discount. Collections from credit sales are expected to be as follows: 3.1 20% in the month of sale, and these debtors receive a 2% discount 3.2 80% in the month after the sale 4. The expected purchases (excluding discounts) are as follows:

image text in transcribed

5. A discount of 10% is receivable on all cash purchases. Creditors are paid two months after the month of purchase. 6. The proprietors cash drawings will amount to R20 000 for September 2023. 7. The monthly salaries amount to R120 000. Salaries will increase by 7.5% with effect from 01 September 2023. 8. The final instalment on the loan, R12 000, together with interest at 18% p.a. for one month will be paid at the end of August 2023. 9. A vehicle will be purchased during August 2023 for R480 000. A deposit of 20% will be paid during August 2023. The balance of the loan plus interest of R71 400 will be paid in 36 equal monthly instalments from September 2023. 10. Cash operating expenses are expected to amount to R80 000 for July 2023 and are expected to increase by 2% per month thereafter.

\\begin{tabular}{|l|c|c|c|c|} \\hline & June & July & August & September \\\\ \\hline Cash sales & R408 000 & R480 000 & R412 000 & R300 000 \\\\ \\hline Credit sales & R500 000 & R540 000 & R224 000 & R340 000 \\\\ \\hline \\end{tabular} \\begin{tabular}{|l|c|c|c|c|} \\hline & June & July & August & September \\\\ \\hline Cash purchases & R240 000 & R288 000 & R246 000 & R200 000 \\\\ \\hline Credit purchases & R260 000 & R280 000 & R220 000 & R180 000 \\\\ \\hline \\end{tabular}

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

DCAA Contract Audit Manual Volume 1

Authors: Defense Contract Audit Agency

1st Edition

B08HTL19V5, 979-8684992995

More Books

Students also viewed these Accounting questions

Question

LO 2.5 Identify and explain four global operations strategy options

Answered: 1 week ago