To answer the questions, we need to calculate the total price per unit for the purchases made, the cost of goods sold (COGS), and the value of closing stock.
a) Total price per unit for the purchases made in January and June 20.22
January Purchases:
- Quantity: 45 units
- Unit price: R4,500
- Total customs duties: R9,000
- Total freight charges: R4,500
Total cost of January purchases: \[ \text{Total Cost} = (\text{Unit Price} \times \text{Quantity}) + \text{Custom Duties} + \text{Freight Charges} \] \[ \text{Total Cost} = (4,500 \times 45) + 9,000 + 4,500 = 202,500 + 9,000 + 4,500 = 216,000 \] Total price per unit for January purchases: \[ \text{Total Price per Unit} = \frac{\text{Total Cost}}{\text{Quantity}} = \frac{216,000}{45} = 4,800 \]
June Purchases:
- Quantity: 10 units
- Unit price: R4,800
- Total customs duties: R3,500
- Total freight charges: R2,000
Total cost of June purchases: \[ \text{Total Cost} = (4,800 \times 10) + 3,500 + 2,000 = 48,000 + 3,500 + 2,000 = 53,500 \] Total price per unit for June purchases: \[ \text{Total Price per Unit} = \frac{\text{Total Cost}}{\text{Quantity}} = \frac{53,500}{10} = 5,350 \]
Answer to a):
- Total price per unit for January: R4,800
- Total price per unit for June: R5,350
b) Cost of Goods Sold (COGS) for the 20.22 financial year
Sales from February-May:
- Sales units: 35 units
- Selling price per unit: R5,000
Sales from June-November:
- Sales units: 25 units
- Selling price per unit: R5,500
Total Units Sold: \[ \text{Total Units Sold} = 35 + 25 = 60 \text{ units} \]
To find COGS, we need to determine how many units were sold from each purchase:
- Units from January: 45 units
- Units from June: 10 units
To account for COGS, we can assume inventory is sold in the order it is acquired (the FIFO method), meaning we’ll exhaust the January stock first:
- From January: 45 units (all sold)
- From June: 15 units (we need an additional 15 units to make 60, the total sold)
Cost of Goods Sold Calculation:
- For January - 45 units at R4,800 each: \[ COGS_{January} = 45 \times 4,800 = 216,000 \]
- For June - 15 units at R5,350 each: \[ COGS_{June} = 15 \times 5,350 = 80,250 \]
Total COGS for the financial year: \[ \text{Total COGS} = COGS_{January} + COGS_{June} = 216,000 + 80,250 = 296,250 \]
Answer to b):
- Cost of Goods Sold (COGS): R296,250
c) Closing Stock Value
We are left with 10 units from June that were not sold, as we sold a total of 60 units.
Closing Stock Calculation:
- Closing stock consists of the 10 units from June at R5,350 each: \[ \text{Closing Stock Value} = 10 \times 5,350 = 53,500 \]
Answer to c):
- Value of Closing Stock: R53,500
To summarize:
- Total price per unit for January: R4,800
- Total price per unit for June: R5,350
- Cost of Goods Sold for 20.22: R296,250
- Value of Closing Stock: R53,500