Calculated Cost Explained: Weighted Average Per Store & All Stores

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 each store. When inventory hits 0, the cost for the item will reset. 
  • For All Stores – cost factors in the price paid for the item in every store and uses the same cost database wise. Cost will never reset and will always include all purchases in history. 
  • For this method cost does not change when something sells. Cost only changes when something is purchased. 





    • Related Articles

    • 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 | ...
    • 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: Employees Per Store

      Business Need:  This report is helpful for users who want a report to show what stores Yellow Dog users have access to.   How it Works:  Employees Per Store report shows all employees that have been created in Yellow Dog and what stores they have ...
    • 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 ...
    • 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 ...