Creating maintenance budget forecast

Unified Glossary

Basics of using a typical web page

Using Online Help

You can create a maintenance budget forecast for a maximum of twelve years, for a sub fleet, aircraft model or an aircraft, in this page.

The "Create Maintenance Budget Forecast" page appears.

Sub Fleet #

The number identifying the sub fleet for which you wish to generate the forecast (Alphanumeric, 20). You can enter the sub fleet number in full or specify it partially using the * character. The system retrieves the sub fleet associated with the number specified here.

Model #

Use the drop-down list box to specify the aircraft model. The system lists all the Active aircraft models defined in the Aircraft business component. The system leaves the field blank by default.

Aircraft Reg#

The registration number of the aircraft (Alphanumeric, 30). You can enter the number in full or specify it partially using the * character. The system retrieves the aircraft associated with the registration number specified here.

Note: The aircraft registration number must have been  associated to a sub fleet, in the "Edit Sub Fleet" activity of the "Aircraft Maintenance Forecast" business component.

AOG?

Use the drop-down list box to specify the grounding status of the aircraft.

  • Select AOG, if you wish to retrieve all the aircrafts for which “AOG Status?” is set as “AOG” in the “Create Aircraft Record” activity of the “Aircraft” business component.

  • Select No, if you wish to retrieve all the aircrafts for which “AOG Status?” is set as “No” in the “Create Aircraft Record” activity of the “Aircraft” business component.

The system leaves this field blank by default.

Aircraft Detail 1

Use the drop-down list box to select any other detail related to the aircraft. The system lists all the Active quick codes that are of type Aircraft Detail 1, as defined in the "Create Quick Codes" activity of the "Aircraft" business component. The system leaves this field blank by default.

Aircraft Detail 2

Use the drop-down list box to select any other detail related to the aircraft. The system lists all the Active quick codes that are of type Aircraft Detail 2, as defined in the "Create Quick Codes" activity of the "Aircraft" business component. The system leaves this field blank by default.

Aircraft Type

Use the drop-down list box to specify the type of the aircraft. The system displays all the Active quick codes of type Aircraft Type defined in the "Create Quick Codes" activity of the "Aircraft" business component. The system leaves this field blank by default.

Aircraft Ownership

Use the drop-down list box to indicate the ownership type of the aircraft. The system provides the following options:

  • Owned - Indicates that the aircraft is owned.

  • Leased - Indicates that the aircraft is taken on lease.

  • Leased out - Indicates that the aircraft is leased out to a third party.

  • Customer Indicates that the aircraft is owned by customer.

The system leaves the field blank by default.

Usage Type

Use the drop-down list box to specify the usage type of the aircraft. The system displays all the quick codes that are in "Active" status and of type Usage Type, as defined in the "Create Quick Codes" activity of the "Aircraft" business component. The system leaves this field blank by default.

Manufacturer Serial #

The MSN or the manufacturers serial number given to the aircraft by the manufacturer at the time of production (Alphanumeric, 40). Ensure that the number is unique for the organizational unit.

Configuration Class

Use the drop-down list box to select the configuration class to which the aircraft belongs. The system lists all the "Active" configuration classes defined in the "Configuration" business component. The system leaves this field blank by default.

Model Type

Use the drop-down list box to specify the model type of the aircraft. The system displays all the quick codes that are in "Active" status and of type Model Type, as defined in the "Create Quick Codes" activity of the "Aircraft" business component.  The system leaves this field blank by default.

Note: The system retrieves the aircraft registration number based on the search criteria, only if the aircraft registration number is mapped to a sub fleet.

The system displays the following in the Search Results multiline:

Identifier #

The aircraft registration number / aircraft model number / sub fleet number.

Note: If all the fields in the search criteria are left blank, or if both the sub fleet number and the aircraft model number are entered, then the system displays all the aircraft registration numbers, aircraft models and the sub fleet numbers defined for the login organization unit, in the specified order.

Note: If either the sub fleet number or the aircraft model number is entered, the system displays the sub fleet number or the aircraft model number as the first row in the multiline, and the associated aircraft registration numbers in the subsequent rows.

Identifier Type

The type of the identifier, which could be "Aircraft", "Model" or "SubFleet".

Forecast Status

The forecast status of the identifier.

The system displays one of the following, if the identifier is “Aircraft”:

  • Not Done – If no forecast has been created for the identifier.

  • In Progress – If the forecast has been initiated for the identifier.

  • Completed – If the forecast is completed for the identifier.

The system displays one of the following, if the identifier is “Model”: or “SubFleet”.

  • Not Done - If no forecast has been done for any of the aircrafts belonging to the model or sub fleet.

  • Partial –If no forecast has been done for some of the aircrafts belonging to the sub fleet or model, and if a forecast has been completed for the other aircrafts belonging to the sub fleet or model.

  • In Progress – If the forecast has been initiated for any one of the aircraft belonging to the sub fleet or model.

  • Completed - If a forecast has been completed for all the aircrafts belonging to the sub fleet or model.

Note: You cannot initiate a forecast for an identifier whose forecast status is “In Progress”.

Last Forecast Date

The last forecast date of the identifier.

  • If the forecast status is “In Progress”, the last forecast date will be the date on which the forecast is initiated.

  • If the forecast status is “Completed”, the last forecast date will be the date on which the forecast was completed.

Model Type

The type of the aircraft model.

Configuration Class

The configuration class to which the aircraft is associated.

Average Flight Hours

The average flight hours per day of the aircraft.

Aircraft Type

The type of the aircraft.

Aircraft Ownership

The ownership type of the aircraft.

Identifier Description

The textual description of the aircraft model / sub fleet.

Total No. Of Aircrafts Associated

The number of aircraft associated with the sub fleet or the aircraft model.

Note: The system displays the total number of aircraft, only if the identifier is sub fleet or aircraft model.

Note: The system displays the “Average Flight Hours”, “Configuration Class”, “Model type”, “Aircraft Type” and the “Aircraft Ownership” details, only if the identifier is aircraft registration number.

Forecast Duration in Yrs.

Use the drop-down list box to specify the duration for which the forecast must be generated The system lists the values 1 to 12 in descending order, and sets the field to 12, by default.

Note: Ensure that atleast one record is selected in the multiline.

The system generates a maintenance budget forecast at the aircraft level, considering the user-defined forecast duration.

Note: A scheduler must be run at regular time intervals to update the actual scheduled and unscheduled work unit count and the cost incurred on the scheduled/unscheduled work units, in the data warehouse.

The system performs the following on clicking the “Create Forecast” pushbutton:

For example, if the current system date is 10 Jan 2005, the forecast start date will be considered as 01 Jan 2005.

Note: If the forecast is done for a model or a sub fleet, the system computes the start date and the end date for each aircraft associated with the model or sub fleet.

Note: If the forecast is done for a model or a sub fleet, the system identifies all the “Active” aircraft maintenance programs associated with each aircraft that belongs to the selected sub fleet or model, and also identifies all the "Active" component maintenance programs associated with all the components attached to each aircraft. The system forecasts all the "Active" work units associated with the identified aircraft maintenance programs and component maintenance programs.

Note: A significant number of work units are precluded by superceding work units, which when executed, fulfill the requirements of the precluded work units, in the "Aircraft Maintenance Program" or "Component Maintenance Program" business components.

For example, if a '300 Hour Inspection' work unit fulfills the requirements of a '100 Hour Inspection' work unit, then the '300 Hour Inspection' work unit would be set as the superceding work unit of the '100 Hour Inspection' work unit. In this case, each time the '300 Hour Inspection' work unit is executed, the next schedule dates of the '100 Hour Inspection' work unit will be reset based on the compliance date of the '300 Hour Inspection' work unit.

Note: The component-related work units will not be forecasted, if the components attached to the aircraft whose maintenance cost is forecasted, have reached their ultimate life value.

Date-based schedule forecasting

Note: The system retrieves the date-based schedule value for the aircraft/component work units, from the corresponding aircraft maintenance program / component maintenance program.

 

Value Computed

Processing Logic

Notes / Remarks

Next Schedule date

If the Last Performed Date of the work unit is not available:

Threshold Value + Reference Date corresponding to the aircraft registration number.

The Induction Date or the Operational Date defined for the aircraft will be considered as the Reference Date, based on the option set in the “Reference Date Basis” field in the “Edit Schedule Information” activity of the “Aircraft Maintenance Program” business component. If the aircraft is newly inducted, and if the aircraft maintenance program is defined for the first time, the aircraft will not be forecasted, if the reference date basis is not specified.

If the Last Performed Date of the work unit is available:

Last Performed Date + Repeat Fixed Interval for “Recurring” independent date-based schedule which is fixed in nature.

Last Performed Date + Repeat Floating Interval for “Recurring” independent date-based schedule which is floating in nature.

  • If the time unit for date-based calculation is set as “Years” or “Months”, the system converts it into “Days” for calculation.

  • If the schedule type of the work unit is “Recurring”, the system will forecast the work unit repetitively considering the work unit has been complied on the scheduled date, even if the interval is set as “Floating”.

  • The next schedule date for the dependant work units is computed by considering the parent work unit to be complied on the schedule date. 

Earliest Scheduled Date

Schedule Date -- Negative Tolerance.

If the negative tolerance value is not specified in the “Set Options” activity, the negative tolerance is retrieved from the “Aircraft Maintenance Program” business component for the aircraft related work units. For the component related work units, the negative tolerance will be taken from the “Component Maintenance Program” business component.

Latest Schedule Date

Schedule Date + Positive Tolerance.

The positive tolerance will be retrieved from the “Aircraft Maintenance Program” business component and “Component Maintenance Program” business components for the aircraft related work units and component related work units respectively.

Alert Date

Schedule Date -- Alert Value.

If the tolerance / alert value is given in months / years, the system will convert it into days.

 

Parameter-based forecasting

Note: The system retrieves the usage parameter utilization value and the next schedule value for the aircraft/component related work units from the corresponding aircraft maintenance program / component maintenance program.

 

Value Computed

Processing Logic

Notes / Remarks

Next Schedule Value

For "Recurring" independent schedule which is fixed in nature:

Last Performed Value + Repeat Fixed Interval.

If the schedule type of the work unit is “Recurring”, the system will forecast the work unit repetitively considering the work unit has been complied on the scheduled date, even if the interval is set as “Floating”.

 

For "Recurring" independent schedule which is floating in nature:

Last Performed Value + Repeat Floating Interval.

Next Scheduled Date

If the Utilization value of the parameter is available:

Current date +[(Current Parameter Value – Schedule Value) / Utilization value of the parameter].

 

The next schedule date for the dependant work units is computed by considering the parent work unit to be complied on the schedule date. 

If the Utilization value of the parameter is not available:

Current date + [(Current Parameter Value – Schedule Value) / (Average Value of the Lead Parameter * Forecast Factor).

 

Cost Details

Note: If the “Labour Productivity” is set as “Considered” in the “Set Options” activity, then the “Productivity” and the “Multiplication Factor” specified in the option settings will be considered for computation of resource cost.

Note: The unscheduled work units are considered for budget forecasting only when the “Historical Period for Unscheduled Cost Calculation” is specified in the “Set Options” activity.  If the historical period is specified, the resource and the material costs will be computed as the ratio between the costs incurred on scheduled and unscheduled work units. 

For example, if the "Historical Period for Unscheduled Cost Calculation" is 5 years, the cumulative labor time for scheduled work units is 20,000 man hours and unscheduled work units is 30,000 man hours, it is assumed that for every 2 hours of estimated scheduled labor time there would be 3 hours of unscheduled labor time. The resource cost will be computed in the ratio of 2:3.

Similarly for material cost computation,

If the "Historical Period for Unscheduled Cost Calculation" is 5 years, the cumulative material cost incurred on standard work units is 1000$ and unscheduled work units is 2,000$, its is assumed that for every 1$ spent on scheduled material requirements, there would be 2$ spent on unscheduled material requirements. The material cost will be computed in the ratio of 1:2.

Note: If “Labour Productivity” is set as “Considered” in the “Set Options” activity, then the system considers the labor productivity and the multiplication factor for labor productivity, for computing labor costs.

 

Cost Computed

Formula

 Example

 Notes / Remarks

Total Cost

Total Maintenance Cost + Total Overhead Cost.

 

 

Average Cost

Total Cost / Forecast Time Period.

 

 

Overhead Cost

Overhead Cost / Flight Hour * Average Flight Hours.

For example, if the Overhead / FH is specified as 10$/FH in the “Set Options” activity, and if the average FH is 8 hours per day, then the overhead cost per day would be 80$.

The overhead costs will not be forecasted, if the “Overhead Per FH” is not specified in the “Set Options” activity.

Total Maintenance Cost

Total Material Cost + Total Resource Cost

 

 

Total Resource Cost

Scheduled Resource Cost + Unscheduled Resource Cost.

 

The resource cost will be equal to the cost incurred on the scheduled work units, if the “Historical Period For Unscheduled Cost Calculation” is not specified in the “Set Options” activity.

Total Material Cost

Scheduled Material Cost + Unscheduled Material Cost.

 

The material Cost will be equal to the cost incurred on the scheduled work units, if the “Historical Period For Unscheduled Cost Calculation” is not specified in the “Set Options” activity.

Scheduled Resource Cost

Resource Hrs * Estimated Nos * Resource Rate  per hour.

 

The resource cost is retrieved from the “HR Setup” business component.

Scheduled Material Cost  

Material Quantity * Material Cost.

 

The material cost (CMAV cost of the part) is retrieved from the “Stock Maintenance” business component.

 

 

Click here for a Case Study (1) on cost computation details, if Part and Resource Requirements are assigned for a work unit in the “Maintenance Task” business component.

Click here for a Case Study (2) on cost computation details, if Part and Resource Requirements are not assigned for a work unit in the “Maintenance Task” business component.

 

Computation of scheduled resource cost

The resource cost estimated against each scheduled work unit which can be a task, standard procedure or a work package, is computed based on the resource hours and skill rate. The resource hours is retrieved from the “Maintenance Task” business component for work units of type task and standard procedure, and from “Aircraft Maintenance Program”, “Component Maintenance Program” business components for aircraft/component related work units of type work package.

Note: While computing the scheduled resource cost, the cost for each skill will be identified separately as the product of the resource hours, skill rate and estimated numbers, and the individual costs will be added to find the total scheduled resource cost.

 

Work Unit Type

Retrieved From…

Notes / Remarks

Task

"Edit Resource Requirements" page in “Edit Task” activity of the “Maintenance Task” business component.

If no values are available in the “Edit Resource Requirements” page, then the resource hours will be considered as zero.

Standard Procedure

“Edit Resource Requirements” page of the “Edit Standard Procedure” and “Edit Resource Requirements” page of  “Edit Task” activity.

  • The resource hours will be calculated as the sum of the resource hours specified at standard procedure level and the resource hours provided for the individual tasks that constitute the standard procedure.

  • If no values are available in the “Edit Resource Requirements” pages of the “Edit Standard Procedure” and “Edit Task” activities, then the resource hours will be considered as zero. 

Work Package

“Edit Work Package Resource Requirement” page in  “Edit Aircraft Work Package” activity of “Aircraft Maintenance Program” business component, for aircraft related work units.

The resource hours will be calculated as the sum of the resource hours specified at the work package level and the resource hours specified for the individual work units that constitute the work package.

For example, if a work package constitutes of 1 standard procedure (SP) and 1 Task and in turn the SP has 2 tasks associated to it, and if the resource hours specified at the work package level, SP level and task level is 2 hours, 1 hour and 1 hour, then the total resource hours will be 2+1+(1*3) = 6 hours, where 3 is the total number of tasks defined for the work package.

“Estimate Resource - Facilities Requirement” and “Estimate Resource - Skills Requirement” pages in the “Modify Work Package” activity of “Component Maintenance Program” business component, for component related work units.

 

Computation of scheduled material cost

The material cost estimated against each scheduled work unit which can be a task, standard procedure or a work package, is computed based on the material requirements recorded for the work unit.  The material requirements is retrieved from the “Maintenance Task” business component for work units of type task and standard procedure and from “Aircraft Maintenance Program”, “Component Maintenance Program” business components for aircraft/component related work units of type work package.

Work Unit Type

Retrieved From…

Notes/Remarks

Task

"Edit Part Requirements" page in “Edit Task” activity of the “Maintenance Task” business component.

If no values are available in the “Edit Part Requirements” page, then the material requirements will be considered as zero.

Standard Procedure (SP)

“Edit Part Requirements” page of the “Edit Standard Procedure” activity and the “Edit Part Requirements” page of the “Edit Task” activity.

  • The material requirements for the SP will be computed as the sum of the material requirements specified at SP level and for the individual tasks that constitute the SP, in the “Edit Part Requirements” page of the “Edit Task” activity.

  • If no values are available in the “Edit Part Requirements” pages of “Edit Standard Procedure” and “Edit Task” activities, then the material requirements will be considered as zero.

Work Package

“Edit Work Package Part Requirements” in  “Edit Aircraft Work Package” activity of the “Aircraft Maintenance Program” business component, for aircraft related work units.

The material requirements for the work package will be computed as the sum of the material requirements estimated at work package level and the material requirements of all the individual work units that constitute the work package.

“Estimate Material Requirement” page in the “Modify Work Package” activity of “Component Maintenance Program” business component, for component related work unit.

 

Case Study - 1

Part and Resource Requirements are assigned for a work unit in the “Maintenance Task” business component.

Case

 

Resource

 

Part

 

Hrs.

 

Qty.

 

Cost

 

Total

 

Cost incurred for the Historical period in $

Sch. Work Unit Count

UnSch. Work Unit Count

Forecasted Details

Cost Type

 

Sch Cost

Unsch Cost

Sch Cost

Unsch Cost

 

A

 

Skills

 

1.25

1

52

65

0

5000

0

25

65

200

Resource

 

P1

NA

25

40

1000

0

10000

0

25

1000

400

Material

 

 

 

 

 

 

 

 

 

 

1065

600

*Total Maintenance Cost

 

B

 

Skills

 

1.25

1

52

65

65

0

15

0

65

0

Resource

 

P1

NA

25

40

1000

1435

0

15

0

1000

0

Material

 

 

 

 

 

 

 

 

 

 

1065

0

*Total Maintenance Cost

 

C

 

Skills

 

1.25

1

52

65

0

0

0

0

65

0

Resource

 

P1

NA

25

40

1000

0

0

0

0

1000

0

Material

 

 

 

 

 

 

 

 

 

 

1065

0

*Total Maintenance Cost

 

D

 

Skills

 

1.25

1

52

65

1500

15000

10

50

65

130

Resource

 

P1

NA

25

40

1000

10000

25000

10

50

1000

500

Material

 

 

 

 

 

 

 

 

 

 

1065

630

*Total Maintenance Cost

* Total Maintenance Cost  = Total Scheduled Cost + Total Unscheduled Cost.

Case A: Scheduled work unit reporting for the historical period is zero.

Case B: Unscheduled work unit reporting for the historical period is zero.

Case C: Scheduled and unscheduled work unit reporting for the historical period is zero.

Case D: Scheduled and unscheduled work unit reporting is available for the historical period.

Note: In Case D, the forecasted unscheduled resource cost is computed as the product of the ratio between the unscheduled and scheduled resource cost for the specified historical period, and the total scheduled resource cost, where,

Unscheduled resource cost for the historical period

=

Resource cost incurred on the unscheduled work units for the historical period/ unscheduled work unit count.

For Example, if the scheduled resource cost is 150$, the unscheduled resource cost is 300$ and the total scheduled resource cost is 65$, then,

Unscheduled Resource Cost       =    (300/150) * 65 = 130.

Note: Similarly, the unscheduled material cost is computed as product of the ratio between the unscheduled and scheduled material cost for the specified historical period, and the total scheduled material cost, where,

Unscheduled material cost for the historical period

=

Material cost incurred on the unscheduled work units for the historical period/ unscheduled work unit count.

For example, if the scheduled material cost is 1000$, the unscheduled material cost is 500$ and the total scheduled material cost is 1000$, then,

Unscheduled Material Cost            =    (500/1000) * 1000 = 500.

 

Case Study - 2

Part and Resource Requirements have not been assigned for a Work Unit in the “Maintenance Task” business component.

Case

 

Resource

 

Part

 

Hrs.

 

Qty.

 

Cost

 

Total

 

Cost incurred for the Historical period in $

Sch. Work Unit Count

UnSch. Work Unit Count

Forecasted Details

Cost Type

 

Sch Cost

Unsch Cost

Sch Cost

Unsch Cost

 

A

 

Skills

 

0

0

0

0

0

5000

0

25

0

200

Resource

 

P1

NA

0

0

0

0

10000

0

25

0

400

Material

 

 

 

 

 

 

 

 

  

  

 

600

*Total Maintenance Cost

 

B

Skills

 

0

0

0

0

12000

0

40

0

0

300

Resource

 

P1

NA

0

0

0

12800

0

40

0

0

320

Material

 

 

 

 

 

 

 

 

 

 

 

620

*Total Maintenance Cost

 

C

 

Skills

 

0

0

0

0

0

0

0

0

0

0

Resource

 

P1

NA

0

0

0

0

0

0

0

0

0

Material

 

 

 

 

 

 

 

 

 

 

 

0

*Total Maintenance Cost

 

D

 

Skills

 

0

0

0

0

1500

15000

10

50

0

450

Resource

 

P1

NA

0

0

0

10000

25000

10

50

0

1500

Material

 

 

 

 

 

 

 

 

 

 

 

1950

*Total Maintenance Cost

* Total Maintenance Cost  = Total Scheduled Cost + Total Unscheduled Cost.

Case A: Scheduled work unit reporting for the historical period is zero.

Case B: Unscheduled work unit reporting for the historical period is zero.

Note: In Case B, the scheduled cost incurred on the work units for the historical period will be considered as the unscheduled cost for the historical period, as the part and resource requirements are not assigned for the work units, in the “Maintenance Task” business component.

Case C: Scheduled and unscheduled work unit reporting for the historical period is zero.

Case D: Scheduled and unscheduled work unit reporting is available for the historical period.

Note: In Case D, the unscheduled resource cost is computed as the sum of the scheduled resource cost and the unscheduled resource cost that correspond to the specified historical period, where,

Unscheduled resource cost for the historical period

=

Resource cost incurred on the unscheduled work units for the historical period/ unscheduled work unit count.

Similarly, the unscheduled material cost is computed as the sum of the scheduled material cost and the unscheduled material cost that correspond to the specified historical period, where,

Unscheduled material cost for the historical period

=

Material cost incurred on the unscheduled work units for the historical period/ unscheduled work unit count.