Creating maintenance budget forecast
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.
Select "Create Forecast" under the "Create Maintenance Budget Forecast" business component.
The "Create Maintenance Budget Forecast" page appears.
Enter the following fields in the "Search Criteria" group box, to search for an aircraft for which you wish to generate a maintenance budget forecast. Data entry in the following fields is optional:
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.
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:
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. |
Click the Search pushbutton to retrieve the search results.
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”:
The system displays one of the following, if the identifier is “Model”: or “SubFleet”.
|
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.
|
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.
Enter the following field:
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. |
Check the box in the Select column of the multiline to select the sub fleet, aircraft model or aircraft, for generating the forecast.
Note: Ensure that atleast one record is selected in the multiline.
Click the "Create Forecast" pushbutton to generate the maintenance budget forecast.
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:
Considers the system date, as the forecast start date. If the forecast is generated in the middle of the month, the start date of the month will be considered as the forecast start date.
For example, if the current system date is 10 Jan 2005, the forecast start date will be considered as 01 Jan 2005.
Calculates the forecast end date, by considering the user-defined forecast duration, from the start date.
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.
Retrieves all the “Active” work units that are associated with the aircraft and with the components attached to the aircraft, from the “Aircraft Maintenance Program” and the “Component Maintenance Program” business components.
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.
Resets the schedule dates of the precluded work units as identified in the "Aircraft Maintenance Program" or "Component Maintenance Program" business components, whenever a superceding work unit is executed.
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. |
| |
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
Retrieves the parameters for computation of material cost and resource cost from the "Maintenance Task", "Aircraft Maintenance Program" or "Component Maintenance Program" business component for scheduled work units, and from unscheduled work orders or "Flight Log" business component for unscheduled work units.
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. |
Resource Hrs * Estimated Nos * Resource Rate per hour. |
|
The resource cost is retrieved from the “HR Setup” business component. | |
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. |
|
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. |
|
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. |
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.
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. |