Difference between revisions of "StationKPIDetails"

From SkySuite Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
<h1>Station Item KP Report</h1>
+
<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 1 of days for that station's item
+
†† 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.
+
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
+
†† 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 its not set in either places detailed above then the trend ppan defaults to 180 days
+
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.