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 inform... 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 closing stock on 28 February 2021:

  1. Determine the total value of purchases for the year:

    The cost of each purchase must include carriage, calculated as:

    • Carriage per pair: R25
    • Total pairs purchased: 2 490

    Thus, total carriage = 2 490 * R25 = R62,250

    Next, we calculate the total cost of purchases:

    • Purchases include:
      • 15 April 2020: 560 pairs at R820 = R459,200
      • 20 September 2020: (420 pairs - 60 returns) at R950 = (360 pairs) x R950 = R342,000
      • 5 January 2021: 810 pairs at R950 = R769,500

    Therefore, total cost of purchases:

    extTotalCost=R459,200+R342,000+R769,500+R62,250=R2,236,040 ext{Total Cost} = R459,200 + R342,000 + R769,500 + R62,250 = R2,236,040

  2. Calculate the total goods available for sale:

    extTotalGoodsAvailable=extOpeningStock+extTotalPurchases ext{Total Goods Available} = ext{Opening Stock} + ext{Total Purchases}

    Where Opening Stock is R101,090. Thus:

    extTotalGoodsAvailable=R101,090+R2,236,040=R2,337,130 ext{Total Goods Available} = R101,090 + R2,236,040 = R2,337,130

  3. Calculate the value of closing stock:

    Given that 2,216 units sold can be calculated as:

    extClosingStock=extTotalGoodsAvailableextTotalSales ext{Closing Stock} = ext{Total Goods Available} - ext{Total Sales}

    Total Sales value:

    2,216extpairsextsoldatR1,400=R3,1002,216 ext{ pairs} ext{ sold at} R1,400 = R3,100

    Total pairs sold = 2,216

    extTotalCostofSales=(206+420)=626extpairs(beforesubtractingreturns) ext{Total Cost of Sales} = (206 + 420) = 626 ext{ pairs (before subtracting returns)}

    Thus, closing stock value can be found by:

    extClosingStock=R2,337,130R3,100 ext{Closing Stock} = R2,337,130 - R3,100

    This calculation gives:

    extClosingStock=R373,800 ext{Closing Stock} = R373,800

Step 2

4.1.2 Stock turnover rate

99%

104 rated

Answer

To calculate the stock turnover rate:

  1. Formula for Stock Turnover Rate:

    The formula is:

    ext{Stock Turnover Rate} = rac{ ext{Cost of Goods Sold}}{ ext{Average Inventory}}

  2. Calculate Cost of Goods Sold (COGS):

    • Total Sales Value = 2,216 units sold
    • Cost Price Calculation involves valuation of cost based on average stock purchases.

    Thus, starting with total goods available:

    extCOGS=extTotalGoodsAvailableextClosingStock ext{COGS} = ext{Total Goods Available} - ext{Closing Stock}

    COGS=R2,337,130R373,800=R1,973,230COGS = R2,337,130 - R373,800 = R1,973,230

  3. Calculate Average Inventory:

    The average inventory is calculated as:

    ext{Average Inventory} = rac{ ext{Beginning Inventory} + ext{Closing Inventory}}{2}

    = rac{R101,090 + R373,800}{2} = R236,445

  4. Final Calculation of the Stock Turnover Rate:

    Substituting values:

    ext{Stock Turnover Rate} = rac{R1,973,230}{R236,445} ext{ approx. } = 8.33

Thus,

Stock Turnover Rate = 8.1 times (rounded appropriately).

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

;