Photo AI

You are provided with the incomplete Debtors’ Collection Schedule and Cash Budget of Zeppo Bazaar - NSC Accounting - Question 6 - 2017 - Paper 1

Question icon

Question 6

You-are-provided-with-the-incomplete-Debtors’-Collection-Schedule-and-Cash-Budget-of-Zeppo-Bazaar-NSC Accounting-Question 6-2017-Paper 1.png

You are provided with the incomplete Debtors’ Collection Schedule and Cash Budget of Zeppo Bazaar. 6.1 Calculate the expected monthly percentage of goods sold on cr... show full transcript

Worked Solution & Example Answer:You are provided with the incomplete Debtors’ Collection Schedule and Cash Budget of Zeppo Bazaar - NSC Accounting - Question 6 - 2017 - Paper 1

Step 1

Calculate the expected monthly percentage of goods sold on credit.

96%

114 rated

Answer

To calculate the expected monthly percentage of goods sold on credit, use the following formula:

Percentage of goods sold on credit=(Credit SalesTotal Sales)×100\text{Percentage of goods sold on credit} = \left( \frac{\text{Credit Sales}}{\text{Total Sales}} \right) \times 100

Where:

  • Credit Sales = R70,000
  • Total Sales = Credit Sales + Cash Sales = R70,000 + R17,500 = R87,500

Thus, Percentage=(70,00087,500)×100=80%\text{Percentage} = \left( \frac{70,000}{87,500} \right) \times 100 = 80\%

Step 2

Complete the Debtors’ Collection Schedule for March 2017.

99%

104 rated

Answer

The Debtors' Collection Schedule for March 2017 should reflect the expected collection pattern based on previous credit sales and payments received:

MonthCredit SaleFebruaryMarch
December 2016R74,000R16,280R0
January 2017R68,000R27,200R146,960
February 2017R70,000R0R70,000
March 2017R64,000R0R64,952
Cash from debtors-R67,480R64,912

Step 3

Explain why the owner is concerned. Give TWO reasons with supporting figures.

96%

101 rated

Answer

  1. The owner is concerned because actual amounts collected from debtors in February (R43,870) were less than the budgeted amount (R67,490). This indicates cash flow issues.

  2. Credit terms are set at 30 days, yet 48% of debtors are taking 60 days or more to settle their debts, which could hamper the liquidity of the business.

Step 4

Suggest ONE solution for this problem.

98%

120 rated

Answer

One potential solution is to offer discounts for early or prompt payments. This could incentivize customers to settle their debts within the required timeframe.

Step 5

Calculate the following (a) and (b) as provided in the budget.

97%

117 rated

Answer

a) Payment to creditors = R87,500 × 95% = R83,125.

b) Salaries of sales assistants = R20,000 (fixed rate).

Step 6

The percentage increase in rent on 1 March 2017.

97%

121 rated

Answer

The percentage increase in rent can be calculated as:

Percentage Increase=(12,54411,20011,200)×100=12%\text{Percentage Increase} = \left( \frac{12,544 - 11,200}{11,200} \right) \times 100 = 12\%

Step 7

The amount of the interest on the investment expected to be received in March 2017.

96%

114 rated

Answer

The amount of interest expected can be calculated as follows:

Interest=Principal×Rate×Time=R16,830×8%×(2/12)=R330\text{Interest} = \text{Principal} \times \text{Rate} \times \text{Time} = R16,830 \times 8\% \times (2/12) = R330

Step 8

Identify TWO payments that you consider to be poorly managed in February 2017.

99%

104 rated

Answer

  1. Advertising: The business did not allocate sufficient budget towards advertising to influence sales effectively. Suggestion: Increase the advertising budget to boost sales and visibility.

  2. Stationery: There is excessive expenditure on stationery. Suggestion: Minimize waste and manage purchases efficiently.

Join the NSC students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

Other NSC Accounting topics to explore

;