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 ...

    • Reporting Explained: Troubleshooting- Item On-Hand Calculated Cost

      Business Need: This report is helpful for understanding an items current calculated cost.  How it works: This report displays a single item’s current on hand valuation based on on-hand adjustments from receipts/invoices and physical inventories. When ...

    • 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 ...

    • Recent Articles

    • Best Practices for Collecting Inventory Accounts During Business Hours

      This document will provide recommendations for clients who must count during business hours. Yellow Dogs best practice for performing a physical inventory is to capture counts outside of business hours, however; Yellow Dog understands that there are ...

    • Yellow Dog/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...

    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...

    • Yellow Dog/Shopify Integration Overview

      This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...

    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...