Calculated Cost explained: First in First Out

Calculated Cost explained: First in First Out


  • Cost is calculated as the first inventory value brought in for an item. Meaning If you buy 10 @ $10 and then 15 @ $25, the cost of an item will be $10 until the first 10 are depleted. Then the cost will be $25. 
  • Many things can impact the timeline of FIFO 
  • Backdating documents 
  • Sales depleting inventory 
  • If our example we could buy 10 @ $10, then transfer 4 @ $10 at 4:30pm but then our sync runs and pulls in sales and we actually sold 10 @ $10 at 4:00pm. BC we are inserting adjustments prior to our transfer, the COGS will be $10. 
  • So what do you do? Back date transfers to allow for the incoming of hourly sales if needed. 







    • Related Articles

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

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

    • Calculated Cost Explained: Last Vendor Price

      Cost is calculated as last vendor price regardless of depletion. Meaning if the vendor price at 10am was $15 and you changed the vendor price to $7 at 10:30 and sales were pulled at 11, the cost of goods would be for $7  

    • Recent Articles

    • Yellow Dog/Resort Suite Integration Overview

      This document will provide an overview of the Yellow Dog Resort Suite Integration Integration Approach This is a two-way file exchange integration – we pull sales and push items Sales – pulls sales from a CSV file Summary: will provide sales as a ...

    • Yellow Dog/Spa Soft Integration Overview

      This document will provide an overview of the Yellow Dog Spa Soft Integration Integration Approach This is a 2Way integration – pulling sales and pushing items Sales – pulled in from the Spa Soft API Multiple RVCs are support per Yellow Dog store ...

    • How To: Create Interface Codes for Spa Soft

      This document will review creating new interface codes for the Spa Soft Integration in Yellow Dog Software Overview If additional Department, Class, Division, Cuserdef1, Cuserdef2, Cuserdef3, PMS Posting IDs need to be added to items in Yellow Dog ...

    • Yellow Dog/Brink Integration Overview

      This document will provide an overview of the Yellow Dog Brink Integration Integration Approach This is a 1Way Integration – pulling sales only Sales – pulled in from the Brink API Mapping Recipes For ingredients to be depleted from inventory, all ...

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