| Excerpt |
|---|
Also known as Inventory On Hand History. Template creates Tableau data source named |
...
Reports can include trends across the months (or groups of months), showing on hand (or average on hand if multiple months) and turns. Individual report values can be for one item at one location, or the totals and averages for summed groups of items. See also Inventory Planning.
Average On Hand
The data source provides a variety of methods for calculating the average quantity and cost on hand values. Be aware that all averages are based on monthly beginning and/or ending values. For the sake of data processing times and report performance on hand averages are not based on the daily fluctuations during the month.
The default (out of the box) [Avg Cost OH] is the traditional formula for average on hand over a time period:
(Beginning Inventory + Ending Inventory)/2
...
| Anchor | ||||
|---|---|---|---|---|
|
Measure | Meaning |
|---|---|
Avg Cost/Qty OH (Beg+End)/2The traditional method of averaging inventory values | ( |
Avg Cost/Qty OH (Beg+End)/Moaverages each month’s beginning and ending balances, then averages that over the selected date range | ( |
Avg Cost/Qty OH (Sum)/Mo | Sum of all monthly ending balances (in the selected date range) |
Avg Monthly Cost/Qty Sold | Sum of Sales / number of months |
Beginning Cost/Qty OH | The On Hand at the beginning of the selected date range |
Beginning Cost/Qty OH - Month | The OH at the beginning of every month in the selected date range. Using this in a column would sum all the months in that column. |
Cost/Qty OH | On Hand at the end of the selected date range. |
Cost/Qty OH - Month | On Hand at the end of every month in the selected date range. Using this in a column would sum all the months in that column. |
Cost of Sales / Qty Sold | The monthly COGS or Qty, which will sum across the selected date range. Multiplied by -1 so that it displays as positive number. |
Cost/Qty Tran | The net of all transactions, which will sum across the selected date range. |
Monthly Turns By Avg Month End | Alternative turn: uses |
Number of Months | Count of the months in the selected date range. Used in averaging calculations. |
...