Calculated Cost Explained: Perpetual Weighted Average

Calculated Cost Explained: Perpetual Weighted Average


Perpetual Weighted Average 

  • Calculated cost of an item is determined using a weighted average that gets re-evaluated when inventory is purchased and sold/depleted
  • Cost is computed for remaining on hand using FIFO 
  • Buy 10 @ $10, then buy 5 @ $3 | Calculated Cost is $100 + $15 = $115 / 15 = $7.67
  • Sell 5 @ $7.67, next sale will equal 5 @ $10, 5 @ $3 | 50 + 15 = $65 / 10 = $6.5

In Perpetual Weighted Average Global, transfers are always computed at default vendor cost because store-to-store transfers are viewed as inventory sold/depleted/purchased because they still exist globally. 








    • Related Articles

    • Calculated Cost Explained: Weighted Average Per Store & All Stores

      Weighted Average Per Store & All Stores Calculated cost of an item is defined as the average price paid across all history of an item.  Per Store – cost only factors in the price paid for the item in each store independently. Cost can be different in ...

    • Reporting Explained: Inventory History Calculated Cost By Day

      Reporting Explained: Inventory History Calculated Cost by Day Business Need:  This report is helpful for users who want a report to show the calculated costs for items over a period. How it Works:  An Inventory>History>Calculated Cost>By Day report ...

    • Can I change an Items Calculated Cost?

      How do I set or change an item's average cost?   The following is a list of rules that can be used to calculate an item's weighted average cost: An item's weighted average cost is reset every time the item reaches zero on hand.For the most part an ...

    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...

    • Reporting Explained: Summary By Period

      Business Need:  A user would like to see a summary of all activity for items between two dates.  How it Works:  This report will show all movement between two selected dates. This report can filter to as broad as by store, or as granular as by item. ...

    • Recent Articles

    • Yellow Dog/Jonas API Overview

      This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...

    • Retail Best Practices for Physical Inventory Webinar

      Ready to crush your next physical? Check out our latest webinar for tips, tricks, and best practices to make it a breeze.

    • Email Invoice Processing – Error response received when processing unsupported file type

      Yellow Dog Inventory Troubleshooting: Email Invoice Processing – Error response received when processing unsupported file type Issue: User received the following unsuccessful processing response when sending an invoice for invoice staging: “The ...

    • Feature Overview: Client ID

      What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...

    • Feature Overview: Password Recovery

      What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...