Inventory Costing Methods Summary

Akhil ScariaAkhil Scaria
3 min read

Overview

This document summarizes the inventory valuation and cost calculations for an item under various costing methods, using the following input data:


Stock Receipts (GRNs)

TypeItemQtyUnit PriceTotal
GRNItem A101001000
GRNItem A101501500
GRNItem A1010100
GRNItem A4100400
3000 (Total Stock Value)

Stock Issues (Invoices)

TypeItemQtyUnit PriceTotal
INVOICEItem A1050500
INVOICEItem A1050500
INVOICEItem A1050500
1500 (Total Issued Qty: 30)

Calculations by Costing Methods

General Facts:

  • Initial Stock Qty: 34

  • Issued Qty: 30

  • Balance Qty after issue: 4


FIFO (First In First Out)

Issue Calculation (oldest first):

  • 10 @ ₹100 = ₹1000

  • 10 @ ₹150 = ₹1500

  • 10 @ ₹10 = ₹100

  • Total Issue Value = ₹2600

Remaining Stock:

  • 4 @ ₹100 = ₹400

  • Unit Cost (Remaining): ₹100.00

  • Closing Stock Value: ₹400.00


LIFO (Last In First Out)

Issue Calculation (latest first):

  • 4 @ ₹100 = ₹400

  • 10 @ ₹10 = ₹100

  • 10 @ ₹150 = ₹1500

  • 6 @ ₹100 = ₹600

  • Total Issue Value = ₹2600

Remaining Stock:

  • 4 @ ₹100 = ₹400

  • Unit Cost (Remaining): ₹100.00

  • Closing Stock Value: ₹400.00


Weighted Average

Average Cost per Unit: ₹3000 / 34 = ₹88.24

Issue Value:

  • 30 @ ₹88.24 = ₹2647.20

Remaining Stock:

  • 4 @ ₹88.24 = ₹352.80

  • Unit Cost (Remaining): ₹88.24

  • Closing Stock Value: ₹352.80


Standard Costing

Standard Cost Assumed: ₹90.00

Issue Value:

  • 30 @ ₹90.00 = ₹2700

Remaining Stock:

  • 4 @ ₹90.00 = ₹360.00

  • Unit Cost (Remaining): ₹90.00

  • Closing Stock Value: ₹360.00


Actual Costing (Lot Based)

Assumes FIFO-style issue per lot tracking. Same as FIFO.

Issue Value: ₹2600

Remaining Stock:

  • 4 @ ₹100 = ₹400

  • Unit Cost (Remaining): ₹100.00

  • Closing Stock Value: ₹400.00


Final Comparison

MethodCost/UnitIssue QtyIssue ValueBalance QtyClosing Stock Value
FIFO₹100.0030₹2600.004₹400.00
LIFO₹100.0030₹2600.004₹400.00
Weighted Avg₹88.2430₹2647.204₹352.80
Standard₹90.0030₹2700.004₹360.00
Actual (FIFO)₹100.0030₹2600.004₹400.00

Notes

  • FIFO and Actual (lot-wise) produce the same result when issued in order.

  • Standard costing ignores GRN prices.

  • Weighted average offers a smoothing method.


0
Subscribe to my newsletter

Read articles from Akhil Scaria directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Akhil Scaria
Akhil Scaria