SkySuite Wiki - User contributions [en-gb]

Report GeneralReportsIndex

2025-11-26T12:50:50Z

Franhaddaway: /* Inventory & Financial */

__TOC__

{{Tips and tricks}}

=General Reports=

==Station Provisioning==

===Station Item KPI===

[[StationKPIDetails|Station Item KPI Report]]

===Issue Details===

===Requisition Details===

===Station Receipts===

===Station Count Details===

===RMA Details===

===MRP & Purchase Ordering===

==Warehouse Stock Level & Transactions==

==Inventory & Financial==
===Warehouse Inventory Valuation===

===Network Inventory Valuation===

==Aircraft Loading & Forecasting==

StationKPIDetails

2022-04-07T16:21:54Z

Franhaddaway:

<h1>Station Item KPI Report</h1>

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.

Report GeneralReportsIndex

2022-04-07T15:34:27Z

Franhaddaway: General Reports List