Photo AI

Calculate the following on 28 February 2021, the financial year-end: 4.1.1 Value of the closing stock 4.1.2 Stock turnover rate INFORMATION: The following information relates to the running shoes - NSC Accounting - Question 4 - 2021 - Paper 2

Question icon

Question 4

Calculate-the-following-on-28-February-2021,-the-financial-year-end:--4.1.1-Value-of-the-closing-stock-4.1.2-Stock-turnover-rate--INFORMATION:--The-following-information-relates-to-the-running-shoes-NSC Accounting-Question 4-2021-Paper 2.png

Calculate the following on 28 February 2021, the financial year-end: 4.1.1 Value of the closing stock 4.1.2 Stock turnover rate INFORMATION: The following informa... show full transcript

Worked Solution & Example Answer:Calculate the following on 28 February 2021, the financial year-end: 4.1.1 Value of the closing stock 4.1.2 Stock turnover rate INFORMATION: The following information relates to the running shoes - NSC Accounting - Question 4 - 2021 - Paper 2

Step 1

4.1.1 Value of the closing stock

96%

114 rated

Answer

To calculate the value of the closing stock, we will first find the total cost of stock available for sale and then subtract the cost of goods sold.

  1. Find Total Purchases:

    • Total purchases during the year:
      • From the purchases table:
        • 15 April 2020: R459 200
        • 20 September 2020: R378 000
        • 5 January 2021: R769 500
    • Total purchases = R459 200 + R378 000 + R769 500 = R1 606 700
  2. Calculate Cost of Sales:

    • Sales Revenue:
      • 2,216 units sold at R1,400 each: 2,216 * R1,400 = R3,100,400.
    • We also need to calculate the total cost of the units sold using the weighted-average method.
    • Total Cost of Opening Stock = R101090 for 206 pairs.
    • Calculate average cost per unit: [ ext{Average Cost per Unit} = \frac{Total Value of Stock}{Total Quantity} = \frac{R3,018,250}{420} = R7,210.71 ]
    • Total closing stock value: [ \text{Closing Stock} = Total Cost of Goods Available - Cost of Goods Sold ]
    • Thus; [ Closing Stock = R1,606,700 + R101090 - (R7,210.71 \times 2,216) = R373,800 ]

Step 2

4.1.2 Stock turnover rate

99%

104 rated

Answer

To calculate the stock turnover rate:

  1. Formula:

    • Stock Turnover Rate = ( \frac{Cost of Goods Sold}{Average Stock} )
  2. Cost of Goods Sold:

    • We've already calculated the cost of goods sold while doing the closing stock calculation.
    • Cost of Goods Sold = Total Cost of Goods Available - Closing Stock = R2,346,040 - R373,800 = R1,972,240.
  3. Average Stock:

    • Average Stock = ( \frac{Opening Stock + Closing Stock}{2} )
    • Average Stock = ( \frac{R101090 + R373800}{2} = R236,445 )
  4. Calculating Turnover:

    • Now substituting values back into the formula:
    • [ Stock Turnover Rate = \frac{R1,972,240}{R236,445} \approx 8.3 times ]

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

;