Material Inventory Valuation Procedure-Weighted Average Inventory Valuation Method
Specific Objective; Definition; Weighted Average Inventory Valuation Method; Example
Specific Objectives
This article is guided by the following 2 specific objectives. The learner/user of this article will be able to;
- Define the term weighted average inventory valuation method
- Compute inventory monetary value using weighted average method
Weighted Average Inventory Valuation Method
Definition
Weighted average method as the name suggests, is the simple average whereby some weights in terms of number of corresponding units to prices are incorporated in computing the issuing price. It entails determination of a new weighted average/mean price to be used for issuance in every inventory issuance transaction that takes place in the business.
FIFO Method is followed when selecting the price and quantity to include and the one to exclude in the computation. This means that if a batch of inventory is exhausted on issuance, its price and corresponding quantity is excluded in the computation of the new price to be used in the proceeding inventory issuance. On the same breath, if a new batch of inventory is received, its corresponding price and quantity is included in the computation of the new price.
Formula for weighted average price is expressed as follows;
Formula
NB1: The computed weighted average price only applies when an issue is being made.
NB2: Determination of Balance Brought Down (Inventory)=Previous inventory monetary Balance Less Monetary Value of Issued Inventory.
NB3: A simplified way of determining the weighted average issuance price is to consider the prices and corresponding units of inventory associated with the receipts of inventory and apply Pick and Drop methodology as you match the inventory balances.
Example
Polite Notice (PN) company ltd provided you with the following inventory details for the month of August 2021
Required
Using the above information, determine the monetary value of closing inventory at the end of August under Weighted Average method.
Solution
The solution to this question requires you to compute the relevant weighted average price as shown below
Explanation of inventory Issuance-Weighted Average Method above
Note: That, total units of inventory before issuance began was 200 units made up of 1stAugust 125 units plus 5th August 75 units. Then…
11th August the first 100 units of inventory was issued and was from the 1st August 125 batch of units of inventory received. The balance after that issuance was 25 units of inventory. On 13th August the next issuance of 50 units of inventory was made and was from two batches; first, 25 units were gotten from the 1stAugust batch of inventory whose balance was 25 units and second, the remaining 25 units was picked from the 5th August batch. On 16th August, received additional 150 units of inventory. So, the current total units of inventory are 50+150=200. On 20th August, another issuance of 75 units of inventory was made. So, 50 units were picked from the 5th August batch of inventory which had a balance of 50 units. This batch got exhausted. Therefore, the remaining 25 units to be issued was from the 16th August 150 batch of units where by the balance thereof was 125 units. Then another additional inventory was received on 25th August of 50 units translating to a total of 175 units of inventory. Then the last issuance was an inventory of 25 units which was picked from the 16th August batch which resulted to a final balance of 100 units. So, after the last issuance, we had a balance of 150 units in total (made up of 100 units of 16th August batch plus 50 units of 25thAugust batch).
Note that the superscripts (i.e., *, ** ,1* and 2*) used below will guide you on which inventory batch each issuance was picked from. This inventory analysis is a computational proof of monetary value of closing inventory as at 30th/08/2021.
