What is Weighted Average Method (Inventory)?

S7-SA7-0347

Grade Level:

Class 12

AI/ML, Physics, Biotechnology, FinTech, EVs, Space Technology, Climate Science, Blockchain, Medicine, Engineering, Law, Economics

Definition

What is it?

The Weighted Average Method (WAM) in inventory helps businesses calculate the average cost of all their goods available for sale. It considers both the cost and the quantity of each purchase to find a single average cost for all items, instead of tracking individual item costs. This method assumes that all goods are mixed together and cannot be distinguished.

Simple Example

Quick Example

Imagine you buy mangoes for your juice shop. First, you buy 10 kg for Rs 100 per kg. Later, you buy 20 kg for Rs 120 per kg. If you want to know the average cost per kg for all your mangoes, you can't just average Rs 100 and Rs 120. You have more of the Rs 120 mangoes, so their price should have a bigger 'weight' in the average. WAM helps you find this true average.

Worked Example

Step-by-Step

A small electronics shop, 'Gadget Guru', buys mobile phone chargers.

Step 1: On Jan 1, Gadget Guru buys 50 chargers at Rs 200 each.
---Step 2: On Jan 15, they buy 30 more chargers at Rs 220 each.
---Step 3: To find the total cost of all chargers, multiply quantity by cost for each purchase and add them up. (50 chargers * Rs 200) + (30 chargers * Rs 220) = Rs 10,000 + Rs 6,600 = Rs 16,600.
---Step 4: Find the total number of chargers purchased. 50 + 30 = 80 chargers.
---Step 5: Calculate the weighted average cost per charger. Total Cost / Total Quantity = Rs 16,600 / 80 chargers = Rs 207.50 per charger.
---Answer: The weighted average cost per charger is Rs 207.50.

Why It Matters

Understanding weighted averages is crucial for careers in Finance, Economics, and even Data Science. Businesses use it to value their inventory, which impacts their profits and taxes. In fields like AI/ML, similar averaging techniques are used to combine data points and make predictions, showing how fundamental this math concept is for future innovations.

Common Mistakes

MISTAKE: Simply averaging the per-unit costs without considering quantities. For example, averaging Rs 200 and Rs 220 to get Rs 210 in the example above. | CORRECTION: Always multiply each cost by its respective quantity (weight) before adding them up.

MISTAKE: Forgetting to include all purchases in the calculation. | CORRECTION: Ensure you account for every unit purchased and its cost to get a true overall average.

MISTAKE: Confusing Weighted Average with FIFO (First-In, First-Out) or LIFO (Last-In, First-Out) inventory methods. | CORRECTION: WAM assumes all items are mixed and an average cost is used, unlike FIFO/LIFO which track specific purchase costs for items sold.

Practice Questions

Try It Yourself

QUESTION: 'Chai Point' buys milk. First, 100 litres at Rs 40/litre. Then, 50 litres at Rs 45/litre. What is the weighted average cost per litre of milk? | ANSWER: Rs 41.67 per litre (approx)

QUESTION: A grocery store buys 20 kg rice for Rs 60/kg, 30 kg for Rs 55/kg, and 10 kg for Rs 65/kg. What is the weighted average cost per kg of rice? | ANSWER: Rs 58.33 per kg (approx)

QUESTION: 'Sweets Corner' makes ladoos. They buy 5 kg of besan for Rs 80/kg. A week later, they buy 8 kg for Rs 75/kg. Before selling any ladoos, they buy another 7 kg for Rs 82/kg. What is the weighted average cost of besan per kg for making their ladoos? | ANSWER: Rs 78.50 per kg

MCQ

Quick Quiz

Which of the following is the main idea behind the Weighted Average Method for inventory?

To always sell the oldest stock first.

To find a single average cost for all available inventory.

To track the exact cost of each individual item sold.

To assume the most recent purchases are sold first.

The Correct Answer Is:

The Weighted Average Method calculates a single average cost for all units in inventory, assuming they are indistinguishable. Options A, C, and D describe other inventory costing methods (FIFO, specific identification, LIFO respectively).

Real World Connection

In the Real World

Big e-commerce companies like Flipkart or Amazon, which manage millions of products, use inventory costing methods like the Weighted Average Method. While they use advanced software, the core idea helps them value the huge stock in their warehouses, calculate their profits accurately, and manage their finances. Even local kirana stores or small businesses selling crafts use this logic to price their items correctly.

Key Vocabulary

Key Terms

INVENTORY: Goods a business holds for sale | PER-UNIT COST: The cost of a single item | WEIGHT: The importance or quantity of a particular item in a calculation | AVERAGE: A central value in a set of numbers | FIFO: First-In, First-Out inventory method

What's Next

What to Learn Next

Now that you understand Weighted Average, explore the FIFO (First-In, First-Out) and LIFO (Last-In, First-Out) inventory methods. These are other ways businesses track costs and will help you see different approaches to valuing inventory.