Question
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: 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:
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started