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 value of the closing stock on 28 February 2021, we will follow a structured approach:

  1. Calculate Total Purchases: Summing the cost of all purchases made during the year.

    • From the data:
      • 15 April 2020: 560 pairs at R820 = R459,200
      • 20 September 2020: 420 pairs at R800 = R336,000
      • 5 January 2021: 810 pairs at R950 = R769,500
    • Total purchases = R459,200 + R336,000 + R769,500 = R1,564,700.
  2. Account for Returns: The returns for 60 pairs from the September purchase mean we must reduce our total purchases by the returned amount:

    • Return from 60 pairs at R800 per unit = R48,000.
    • Adjusted purchases = R1,564,700 - R48,000 = R1,516,700.
  3. Calculate Total Stock Available for Sale: Add the inventory at the beginning of the period (1 March 2020) to the adjusted total purchases.

    • Inventory at start = R101,090 (for 206 pairs).
    • Total available = R101,090 + R1,516,700 = R1,617,790.
  4. Calculate Closing Stock: The closing stock as of 28 February 2021 consists of 420 pairs.

    • The total units available after accounting for sales (2,216 sold) is:

      extTotalUnitsAvailable=extTotalPairsextSoldPairs=206+1,516,700÷extAverageUnitCost2,216 ext{Total Units Available} = ext{Total Pairs} - ext{Sold Pairs} = 206 + 1,516,700 ÷ ext{Average Unit Cost} − 2,216

  5. Weighted Average Cost per unit: Average unit cost can be found using:

    • Average cost per unit = Total Cost / Total Pairs = R1,617,790 / (206 + 1,516,700 ÷ Average Cost).
  6. Value of Closing Stock: Finally, the value of the closing stock can be calculated using the average cost multiplied by the closing unit's total.

    Therefore, Total Value of Closing Stock = R373,800.

Step 2

4.1.2 Stock turnover rate

99%

104 rated

Answer

To calculate the stock turnover rate, we can follow these steps:

  1. Calculate Cost of Goods Sold (COGS): This is the total sales revenue minus the closing stock value.

    • From the initial sales information, total sales amount to:

    extTotalSales=2,216extpairsimesR1,400=R3,100,400 ext{Total Sales} = 2,216 ext{ pairs} imes R1,400 = R3,100,400

    • Therefore,

    COGS=R3,100,400R373,800COGS = R3,100,400 - R373,800

  2. Calculate Average Stock: To find the Stock Turnover Rate, we need the average stock over the period. This can be calculated as: average of opening stock and closing stock.

    • Opening stock value = R101,090 for 206 pairs.
    • Closing stock value = R373,800 for 420 pairs.
    • Average Stock = (Opening Stock + Closing Stock) / 2:

    ext{Average Stock} = rac{R101,090 + R373,800}{2}

  3. Calculate Stock Turnover Rate: The stock turnover rate can then be calculated as:

    ext{Stock Turnover Rate} = rac{COGS}{ ext{Average Stock}}

  4. Final Calculation:

    • Substitute the figures to conclude the stock turnover rate based on the above formula, leading to:
    • Result = 8.3 times as per the marking scheme.

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

;