Worked Solution
✓ VerifiedNote: The transaction data table (15-12-19 to 31-01-20) was not included in the question as presented. The solution below provides the complete methodology and formulae a CA student must apply. Once the table data is available, substitute actual figures into each step.
---
(i) Re-order Level
Re-order Level = Maximum Rate of Consumption × Maximum Lead Time
This is the stock level at which a fresh purchase order must be placed. It ensures stock does not fall to zero before new supplies arrive.
(ii) Maximum Stock Level
Maximum Stock Level = Re-order Level + Re-order Quantity − (Minimum Rate of Consumption × Minimum Lead Time)
This is the upper limit beyond which stock should not be held, to avoid over-investment and storage costs.
(iii) Minimum Stock Level
Minimum Stock Level = Re-order Level − (Normal Rate of Consumption × Normal Lead Time)
This is the safety/buffer stock below which stock should not normally fall. It guards against stockouts due to unexpected demand or supply delays.
(iv) Store Ledger — January 2020 (Weighted Average Cost Method)
Under the Weighted Average Cost (WAC) method, a new weighted average rate is computed after every receipt (purchase), and issues are priced at this running average rate.
Format of Store Ledger:
| Date | Particulars | Receipts (Units / Rate / Amount) | Issues (Units / Rate / Amount) | Balance (Units / Rate / Amount) |
Key rule: After each receipt — New WAC Rate = (Value of existing stock + Value of new receipt) ÷ (Existing units + Units received). Issues are valued at the WAC rate prevailing at the time of issue. Closing stock on 31-01-2020 is the balance column figure.
(v) Value of Components Used During January 2020
Value of components used = Total of all Issue columns in the Store Ledger for January 2020
Alternatively: Opening Stock Value (01-01-2020) + Purchases during January − Closing Stock Value (31-01-2020)
Ensure opening stock value is computed using the WAC rate prevailing as on 31-12-2019 (derived from December transactions).
(vi) Inventory Turnover Ratio
Inventory Turnover Ratio = Cost of Components Consumed ÷ Average Inventory
Where:
- Cost of Components Consumed = Value of issues during January 2020 (from sub-part v)
- Average Inventory = (Opening Stock Value + Closing Stock Value) ÷ 2
A higher ratio indicates faster movement of inventory and better utilisation of working capital.
Final Answer: All six answers can be computed once the transaction table is substituted into the above framework. The store ledger closing balance gives the value of stock as on 31-01-2020, and the total of issue entries gives the value of components used for the month.
Write it like this
1The skeleton
- Head each store ledger column as Receipts / Issues / Balance with three sub-columns each (Units | Rate | Amount) — examiners award a dedicated format mark before they even check your numbers, so draw the full 9-column table first.
- Recalculate the WAC rate immediately after every receipt entry, right inside the Balance column — not once at month-end; the rate must visibly change row-by-row or the examiner knows you misapplied the method.
- Write the formula box before substituting numbers for each stock level (Reorder = Max consumption × Max lead time, etc.) — one formula line earns partial marks even if your arithmetic is wrong.
- For Inventory Turnover Ratio, explicitly state Average Inventory = (Opening + Closing) ÷ 2 and pull both figures from your own store ledger — examiners check that your ratio uses the same closing stock you computed, not a fresh number.
- End with a one-line closing summary: 'Closing stock as on 31-01-2020 = ₹X at WAC of ₹Y per unit' — this is the sentence the checker scans last and it locks in your answer.
2Examiner-rewarded phrases
3Common trap
Most students recalculate WAC only once at the end of the month and apply a single rate to all issues — that's FIFO logic in WAC clothing and the examiner will cut marks on every issue row. Every receipt must trigger a fresh WAC computation right then and there in the Balance column.