80.2K

Verified Solution

Link Copied!

You have been employed as the financial manager of RPP Ltd. One of the points on the agenda for the upcoming board meeting is the forecasted performance of the business for the period January 2023 to April 2023. Also, the board would like to know the impact of the forecast on the cash flow for the same period.

Your predecessor had started the process and left you the following incomplete schedule.

	January 2023	February 2023	March 2023	April 2023
Abbreviate statement of comprehensive income: Sales Cost of Sales Gross Profit Expenses paid in cash Net Profit	R191 400 A E (R15 000) I	R203 500 B F (R16 000) J	R213 400 C G (R17 000) K	R231 000 D H (R18 000) L
Bank Balance: Opening Balance Movement during the month Expenses paid in cash Creditors settled in cash Cash Sales for the month Cash receipts from debtors Closing Balance for the month	R195 320 AC M Q U Y AD	AE AF N R V Z AG	AH AI O S W AA AJ	AK AL P T X AB

Additional Information:

• The business trades at a constant mark-up on cost.
• 60% of sales are on credit.
• Debtors are collected as follows:
• 65% of outstanding amounts are collected during the second month following the month in which the sale took place. (60 days)
• 25% are collected during the third month following the month in which the sale took place. (90 days)
• 5% are collected during the fourth month following the month in which the sale took place. (120 days)
• 5% irrecoverable
• All purchases of inventory are on credit, and creditors are all paid in the month following the month during which the goods were acquired. (30 days)
• All inventory purchased during the month is sold within the same month.
• There are no stock losses.

You gather the following historical data:

Actual Sales	Sept 2022	Oct 2022	Nov 2022	Dec 2022
Total Sales Cost of Sales Gross profit	R159 500 (R119 625) R39 875	R167 200 (R125 400) R41 800	R177 100 (R132 825) R44 275	R187 000 R140 250) R46 750

REQUIRED:

1. Calculate the budgeted cash receipts from debtors for the period January 2023 to April 2023.
2. Calculate the values of A to AM.

Answer & Explanation Solved by verified expert

See Answer