• Skip to main content

Jack Regehr

Jack Regehr

  • Hotel Operations Analytics
  • Inventory Valuation
  • Budget Analytics

Inventory Valuation

Instead of using a snapshot table, these measures calculate the Units In Stock dynamically at query time. The table calculates the unit price for each product at any given point in time. The inventory value is calculated product by product, because each product might have a different price. The Value Buy and Value Sell algorithms determine the average value of the selected product in the movements table in the last day of movement until the selected period.

Copyright © 2026 ยท Created by Jack Regehr Wichita, KS