Difference between revisions of "StationKPIDetails"
Franhaddaway (talk | contribs) |
|||
| Line 1: | Line 1: | ||
| − | <h1>Station Item | + | <h1>Station Item KPI Report</h1> |
Column - Average Consumption | Column - Average Consumption | ||
| Line 13: | Line 13: | ||
† Elapsed days = days between first and last count dates.<br> | † Elapsed days = days between first and last count dates.<br> | ||
<br> | <br> | ||
| − | †† No. Of Counts = within that Trend Span | + | †† No. Of Counts = within that Trend Span of days for that station's item |
| − | The station par level "Trend Averaged Daily Consumption" figure is determined when a count is approved; in other words, the par level record is updated from the newly | + | The station par level "Trend Averaged Daily Consumption" figure is determined when a count is approved; in other words, the par level record is updated from the newly approved station inventory count. |
Trend Avg Daily Consumption = (First Count Qty† – Current Count Qty + (Total Receipts – Total Returns)) / Days†† | Trend Avg Daily Consumption = (First Count Qty† – Current Count Qty + (Total Receipts – Total Returns)) / Days†† | ||
| Line 23: | Line 23: | ||
† First Count Qty = the oldest approved reported inventory figure for counts within the considered trend span period, e.g. the the earliest reported inventory count figure from the last 180 days.<br> | † First Count Qty = the oldest approved reported inventory figure for counts within the considered trend span period, e.g. the the earliest reported inventory count figure from the last 180 days.<br> | ||
<br> | <br> | ||
| − | †† | + | †† Days between first and last count within the trend days. |
| Line 33: | Line 33: | ||
b) It is set on the station count category. | b) It is set on the station count category. | ||
| − | c) If | + | c) If it is not set in either places detailed above, then the trend span defaults to 180 days. |
Latest revision as of 16:21, 7 April 2022
Station Item KPI Report
Column - Average Consumption
The 'Average Consumption' column is the Historical Consumption which is derived from the latest station par level 'Trend Average Daily Consumption' figure.
The Historical Consumption is calculated as follows:
(Item par level Trend Avg Daily Consumption * Elapsed Days†) / No. of Counts††
Where:
† Elapsed days = days between first and last count dates.
†† No. Of Counts = within that Trend Span of days for that station's item
The station par level "Trend Averaged Daily Consumption" figure is determined when a count is approved; in other words, the par level record is updated from the newly approved station inventory count.
Trend Avg Daily Consumption = (First Count Qty† – Current Count Qty + (Total Receipts – Total Returns)) / Days††
Where:
† First Count Qty = the oldest approved reported inventory figure for counts within the considered trend span period, e.g. the the earliest reported inventory count figure from the last 180 days.
†† Days between first and last count within the trend days.
NOTE: The Trend span can be set in 3 ways:
a) There is an organisation attribute 'TREND_AVG_DAYS' for the Airline.
b) It is set on the station count category.
c) If it is not set in either places detailed above, then the trend span defaults to 180 days.
