RedditPP Mascot

RedditPP

r/woweconomy • … • u/Manbeardo

Are there any addons that can track FIFO/LIFO COGS?

For any goblins unfamiliar with real-world standards of retail inventory management, Cost Of Goods Sold (COGS) is a metric of how much money you spent on the things that you sold. It's a very important number because it allows you to track how much money you're making per-SKU (stock keeping unit, AKA item name).

There are [several ways to calculate COGS](https://corporatefinanceinstitute.com/resources/accounting/cost-of-goods-sold-cogs/), but I haven't found any addons that support them. Can any addons track COGS, or am I stuck relying upon simpler gold in/gold out metrics?

Edit: more specific examples:

Consider this sequence of events:

- You buy 10 of an item for 10g each - You sell 5 for 15g each - You buy 5 for 30g each - You sell 5 for 30g each - You buy 10 for 40g each - You sell 10 for 50g each

At the end of that sequence you have spent 650g, gained 725g, and have 5 leftover in your inventory. What do you consider your profit to be? How much did you spend on the items that remain in your inventory? That depends upon which COGS algorithm you choose to use.

First-In-First-Out (FIFO)

| Event | Inventory | COGS | Profit | |-------------|--------------|------|--------| | Buy 10x10g | 10x10g | | | | Sell 5x15g | 5x10g | 50g | 25g | | Buy 5x30g | 5x10g,5x30g | | | | Sell 5x30g | 5x30g | 50g | 100g | | Buy 10x40g | 5x30g,10x40g | | | | Sell 10x50g | 5x40g | 350g | 150g | | Total | 200g | 450g | 275g |

Last-In-First-Out (LIFO)

| Event | Inventory | COGS | Profit | |-------------|--------------|------|--------| | Buy 10x10g | 10x10g | | | | Sell 5x15g | 5x10g | 50g | 25g | | Buy 5x30g | 5x10g,5x30g | | | | Sell 5x30g | 5x10g | 150g | 0g | | Buy 10x40g | 5x10g,10x40g | | | | Sell 10x50g | 5x10g | 400g | 100g | | Total | 50g | 600g | 125g |

Weighted Average

| Event | Inventory | COGS | Profit | |-------------|-----------|---------|---------| | Buy 10x10g | 10x10g | | | | Sell 5x15g | 5x10g | 50g | 25g | | Buy 5x30g | 10x20g | | | | Sell 5x30g | 5x20g | 100g | 50g | | Buy 10x40g | 15x33.33g | | | | Sell 10x30g | 5x33.33g | 333.33g | 66.66g | | Total | 166.66g | 483.33g | 141.66g |

— 0