The invention relates generally to resource and physical asset management, and more particularly to life cycle and capital expense management systems, such as for vehicle fleet management, using computationally and memory efficient computing infrastructures.
In the art, capital asset management typically relates to the management of physical assets with the goal of minimizing capital expenditures and operating expenses by maximizing the useful life of an asset. Assets and their expenses are tracked to determine an optimal time to replace the asset where the replacement cost is justified by, for example, the ongoing operating or maintenance costs of the asset. One example of such assets are corporate owned vehicles forming part of a fleet of vehicles.
Typically, such resource planning has been performed using spreadsheets, or the like, due to the heavy amount of data, calculations, iterations and analysis being required. Users in an asset owning entity build their own version of source data from a source data database on their local PCs, and then create their own local scripts or equations to operate on the data. This is particularly the case due to the level of customization required for each individual instance of a group of assets which need to be managed. This approach leads to serious performance problems (for both the set of local PCs and the source data database), memory problems (primarily for the local PCs) and data updating and accuracy problems. These problems are serious enough that accurate analysis often takes prior art solutions several days, even under the guidance of a skilled user.
There thus remains a need for a resource planning system which can be applied to capital assets that offers computationally and memory efficient, accurate capital expense and life cycle planning tools.
In one embodiment of the invention, there is provided a system for physical asset resource planning including a CAM (capital asset management) application server configured to execute a life cycle module for generating an asset life cycle model based on user inputs customizing the model for each instance of its execution; and execute a life cycle calculator for generating an annual cost for an asset based on the life cycle model and on a dataset received from the CAM database server. The CAM report server includes a processor configured to execute a presentation module for displaying results of the life cycle module and the life cycle calculator to a user. The CAM database server is configured to store a plurality of datasets related to a plurality of assets and to provide data to the CAM application server for executing the life cycle calculator and to provide data to the CAM report server.
In one aspect of the invention, the CAM application server and the CAM report server communicate to implement a presentation layer in a model-view-controller arrangement, wherein the model component manages data, logic and rules of a CAM application, the view component provides an output representation of information and the controller component accepts inputs from a user and converts the inputs to commands for the model or view components.
In another aspect of the invention, the system includes a fleet management system in data communication with the CAM database to provide the plurality of stored datasets.
In another aspect of the invention, the fleet management system includes a telematics interface, a maintenance interface and a source data database for temporarily storing data received from the telematics interface and from the maintenance interface; and wherein the telematics interface receives data from one or more sensors located on each asset and the maintenance interface receives data from a maintenance shop computer performing maintenance on each asset.
In another aspect of the invention, the CAM application server provides a service layer including an interface for exchanging data with the presentation layer, a business logic model and an object relational mapping module.
In another aspect of the invention, the business logic module defines fixed parameters and rules of the CAM application.
In another aspect of the invention, the object relational mapping module defines the relationship between different data sets and objects to which the business logic module is applied.
In another aspect of the invention, wherein the life cycle module applies a mean annual cost equivalent life-cycle model to determine an optimal time to replace one or more assets.
In another aspect of the invention, the mean annual cost equivalent is determined from
where; i=discount rate
In another aspect of the invention, the CAM application server enables users to generate custom life-cycle models based on user-defined parameters modifying the mean annual equivalent cost model.
In another aspect of the invention, the user defined parameters include one or more of Labor Rate, Cost Per Downtime Hour, Cost per Energy Unit, Total Capitalized Cost, Depreciation Type, Salvage Percentage, Depreciation, Discount Factor, Include Warranty Costs, Maximum Years to Display and Utilization Meter Unit of Measure.
In another aspect of the invention, the CAM application server, via the life cycle module, is configured to remove data outliers from the data received from the CAM database server.
In another aspect of the invention, data outliers are removed based on a sensitivity level determined by a user.
In another aspect of the invention, the life cycle calculator accepts as a user-input a filter of categories of assets to be included in the analysis.
In another aspect of the invention, the user selects a depreciation method for applying depreciation to the analysis.
In another aspect of the invention, the CAM report server is configured to enable the viewing of annual costs for each asset based on the life cycle model.
In another aspect of the invention, the CAM report server accepts user inputs via the presentation layer to display reports and visualizations based on user-selected formats.
In another aspect of the invention, the CAM application server uses the generated data to determine an optimal replacement year for each of the assets.
The invention is illustrated in the figures of the accompanying drawings which are meant to be exemplary and not limiting, in which like references are intended to refer to like or corresponding parts, and in which:
Having summarized the invention above, certain exemplary and detailed embodiments will now be described below, with contrasts and benefits over the prior art being more explicitly described.
Referring now to
By way of example, an operator may want to perform a life cycle analysis for “½ ton trucks”. To do such a task the operator may need a “job table”, a “odometer table”, a “downtime table”, a “fuel table” and a “capital asset value table”—all of which must be queried and then copied into the Excel™ file. Then the operator would need to create a series of calculations, operating on various cells, to create a set of sheets (often four or more) to capture the data required for the task, with one row in each of the four sheets relating to a particular “½ ton truck”. These lookups across the sheets from the source data database would be repeated for each “½ ton truck” in the fleet (often hundreds or even thousands of such trucks) to create one row, in each of the four sheets, for a given truck. So the four sheets might have several thousand rows. Then a dashboard sheet would be created in the Excel file and various formulas would be applied against all of the data in the four sheets, to create a dashboard that included the life cycle analysis of the “½ ton trucks”. Of course the assumptions and configurations would form part of the calculations that would be applied against the data in the four sheets as the calculations were being performed. Having done this for “½ ton trucks”, to at least establish a first model (not having made any changes to assumptions or configurations) the operator would then turn their attention to “¾ ton trucks” and repeat the entire process. And do so for each type of vehicle or asset/equipment that is part of the life cycle analysis (where, for capital management, as described herein, each type may be required to be done simultaneously so an overall plan, for all of a fleet operator's assets, can be created). Returning back to the baseline models that now exist, an operator may want to change an inflation rate, interest rate, or a depreciation percentage, for one or more vehicle types. To do so they would manually change each configuration in the Excel™ file, for each vehicle type, and have the resulting calculations performed (required to update the dashboard) run. This could result in tens of thousands of individual cells being updated each time a change is made. In practice making a change often takes so long to compute that operators leave their PCs 102 for a few minutes to return when the calculation has fully completed. The resources required of the PCs 102 was simply too high to be viable for a PC and the time taken to compute was simply too high to allow efficient operator work.
The phrase capital asset management (CAM) is used throughout this description interchangeably with physical resource planning and management. More generally, CAM tasks according to embodiments of the invention may involve any one or more of the following:
1) Optimizing the entire life-cycle of a group of physical assets, such as a vehicle fleet by:
2) Using synergistic interactions between systems to help fleet operators understand data to make better decisions:
Hardware Architecture
Referring now to
Vehicles in the fleet (exemplified by asset 220) may be substantially any type of vehicle (such as cars, buses, trucks, backhoes and the like) and are typically owned by a fleet owner making use of the invention herein described. Vehicles may include a mobile data terminal 222 (MDT). MDT may be any computing device that is on-board vehicle 220. MDT may communicate with other systems of vehicle, such as odometers, sensors, engines, speedometers, passenger load or capacity counters, vehicle signs, or other systems. MDT may be able to communicate with a communications network via, for example, an antenna or otherwise stores data on an onboard database assessable by the on-board computer 222. MDT 222 is preferably configured to communicate with FMS 212. FMS is also able to obtain vehicle data via telematics interface 214. Maintenance interface 216 is accessible via maintenance shop computer 203 (either physically or wirelessly) to capture maintenance-related data. Fuel usage data source 232 stores data related to fuel consumption of each vehicle.
Client device 202, on board computer 222, maintenance shop computer 230, fuel data sources 232, CAMAS 206, CAMDS 208 and CAMRS 210 are all separate computer systems capable of interacting with each other as herein described. The interactions between these computer systems and the synergies generated by their interactions provide additional benefits to the invention. The computer systems forming the aforementioned elements are exemplified in
Computing device 304 also includes one or more input devices interconnected with main processor 308. Such input devices are configured to receive input and provide data representative of such input to processor 308. Input devices can include, for example, a keypad 316 and a pointing device 318. Thus, keypad 316 can receive input in the form of the depression of one or more keys, and can then provide data representative of such input to processor 308. In variations, a keyboard can be implemented as a soft keyboard relying on a touch screen, for example. A pointing device can be implemented as a computer mouse, track ball, track wheel, touchscreen, and the like. In some examples, such as with on board computer 222, a computing device can include additional input devices in the form of one or more additional buttons, light sensors, microphones and the like. Pointing device 318 can receive input in the form of movement, pressure or swipe gestures, and can then provide data representative of such input to processor 308 in the form of, for example, coordinates representing the location of a virtual cursor, the direction and/or velocity of a swipe gesture, and the like.
Computing device 304 further includes one or more output devices. The output devices of computing device 304 include a display 320. Display 320 includes display circuitry controllable by processor 308 for generating interfaces which include representations of data and/or applications maintained in memory 312. The display circuitry can thus include any suitable combination of display buffers, transistors, LCD cells, plasma cells, phosphors, LEDs and the like. When the input devices of computing device 304 include a touch screen input device, the touch screen (not shown) can be integrated with display 320. The output devices of computing device 304 can also include a speaker 328 interconnected with processor 308. Additional output devices are also contemplated.
Computing device 304 also includes a communications interface 332 interconnected with processor 308. Communications interface 332 allows computing device 304 to perform voice and/or data communications via a link 336, which can be wired and/or wireless, and, where appropriate, with or via a network such as 240. The communication interface 332 receives messages from and sends messages through link 336.
Computing device 304 maintains, in memory 312, one or more files containing a plurality of computer readable instructions and/or data. Typically, files are organized in accordance with a structure and logic referred to as a file system. In this illustrative example, file system 380 maintained in memory 312 represents the structure and organization of files accessible by computing device 304.
Files are typically stored in a non-volatile portion of memory 312 such as a solid state disk or a hard drive. In variations, the files can be stored in other portions of memory 312 such as in volatile memory or in a combination of different portions. In yet other variations, some of the files may be stored in memory or storage locations that are external to computing device 304, such as those maintained at network-based cloud storage (for example source data database 218 may be maintained externally). The location of files can also vary based on the operational state of the computing device 304. For example, files may be maintained in a non-volatile portion of memory 312 when the computing device is turned off. However, at least some of the files may be moved into a volatile portion of memory 312 as the computer device 304 is powered up, or otherwise rendered operational. In variations, files may be moved to volatile memory as the files are accessed by processor 308. Other combinations of memory 312 portions and operational states for storing files within memory 312 will now occur to a person of skill and are contemplated.
Alone or in combination, one or more files can form an application software or a module, such as software on CAMAS 206, CAMRS 210, CAMDS 208, FMS 212 (including telematics interface module 214 and maintenance interface module 216). For example, as illustrated in
Memory 312 can also maintain various files representing information or data that can be utilized by various applications. For example, operating system 370 can utilize a registry data file in carrying out at least some of its functionality, the resource planning applications 360 can use data files while performing its functionalities. By way of example, the following table provides exemplary applications 350, 360:
An operating system such as operating system 370, is a collection of software and/or modules that manages the hardware resources of a computing device. An operating system also provides common services allowing other applications to make use of the hardware resources as appropriate. For example, an operating system can include file system services through which an application such as file manager 350 can access and manipulate the file system supported by the operating system. File system services allow access to basic file management operations by the operating system as well as by applications and modules operating at the computing device 304.
Typically, file system services are provided to help implement a file system in accordance with a specific file system protocol such as the New Technology File System (NTFS). The file system protocol determines the logic and structure according to which files can be organized, the format for naming a file, the format for storing the data and metadata associated with a file, as well as other file system policies that will now occur to a person of skill. In this illustrative example, files are stored in accordance with the file system 380 protocol.
Of course each computing device 304 may have different requirements for processors, memory, and applications. Such requirements may also vary based on the intended use of the computing device (for example the amount of data, expected response times, and number of concurrent users). Exemplary requirements for various computing devices are set out below, based on the numbers of concurrent user devices accessing the system simultaneously.
Software Architecture
Referring now to
The presentation layer 410 is that which an end-user has direct interaction with, and preferably follows a model-view-controller arrangement. A model component 412 directly manages the data, logic and rules of the CAM application. A view component 414 can be any output representation of information, such as charts or diagrams, and may include multiple views or different way of presenting information. A controller component 416 accepts inputs and converts these inputs to commands for the model 412 or view 414 modules. The model component 412 stores data that is retrieved according to commands from the controller 416 and displayed on the view 414. The view generates new output in response to user-based changes in the model. The controller 416 can send commands to the model to update the model's state. It is also capable of sending commands to the view 414 to change the view's presentation of the model. This arrangement facilitates the user's interaction with the CAM application and provides for a significantly faster, and more resource efficient manner of handling the data required for large scale CAM applications. In the preferred embodiment, the presentation layer is implemented on an Internet-accessible page, and accessible via any web browser.
The service layer 420 includes an interface for communicating with the presentation layer, such as a RESTful interface 422, a business logic module 424 and an object relational mapping (ORM) module 426. The service layer 420 is generally only accessible by administrators of the system, the service provider or technical personnel required for updating the core infrastructure. The RESTful interface 422 is generally known in the art as a means for interfacing between a back-end system and a user-facing system, and thus not described in further detail herein. The business logic module 424 defines parameters of the CAM application that are fixed with respect to a specific fleet. The ORM module 424 defines the relationship between different sets of data and objects which feed into the business logic module 424, to which the model on the presentation layer is applied. Finally, the database layer 430 includes a database 432, supported by Oracle or an SQL server, for example.
In the preferred implementation, the CAM layers are arranged such that a single request to the CAM presentation layer via a user interface returns the entire CAM user interface to the requesting clients' browser. Data for the user interface (ie. the presentation layer) may be retrieved via a jQuery AJAX request from the service layer 420. Each AJAX request would be digitally signed and authenticated in the service layer 420. It will be evident that the presentation layer 410 does not communicate directly with the database layer 430. Only the service layer 420 can access the database layer 430. With reference to the hardware in
Obtaining Data from Vehicles in the Fleet
Referring now to
The data collection unit 40 (generalized as MDT 222 in
Referring now to
Communication means provided on the control unit 30 may preferably operate in active and passive modes, depending on the location and use of a particular vehicle in the fleet. In the active mode, as shown in
In the passive mode, communication occurs via Wi-Fi, 900 MHz or RFID based networks, for example. Communication is transmitted on an event-based arrangement, such as vehicle on/off, scheduled transmissions, driver triggered communication or proximity to a receiver. Two-way communication is limited in passive mode. On-demand mode functions when there is a direct connection to the vehicle, for example, when used with vehicle diagnostic tools. It is also contemplated that a combination of active and passive communication modes may be used, depending on the nature of the communication. In the passive mode, it is further contemplated that a data collection terminal 110, shown in
The telemetry module 70 is adapted to receive, or otherwise access, data from the control unit and provides for various functions and abilities as will be described in more detail further below. In one embodiment, shown in
The telemetry module 70 can be used to initiate a number of actions, such as maintenance actions. In the preferred embodiments, the telemetry module 70 further provides the ability for maintenance personnel, for example, to review data from any particular vehicle in the fleet, a group of vehicles in the fleet, or of the fleet as a whole and to further analyze the data or initiate specific actions based on this analysis. The results achieved by the system as herein described allows for improved efficiencies in the management of a large number of vehicles in a fleet.
It will be appreciated by one skilled in the art that the availability of telemetry data and use according to the present invention generally improves fleet management, and in particular the life-cycle improvements made possible by the ability to have near real-time fuel and usage data which improves the accuracy of a life cycle model and reliability of decisions made based on these models. The prior art's reliance on spreadsheet methods typically require reliance on information that is weeks or months old. More specifically, a better picture of vehicle usage and demand may be provided. For example, the telemetry module may analyze the fuel consumption of a particular vehicle in the fleet, a group of vehicles in the fleet and of the entirety of the fleet. In this regard, vehicle performance and driving habits may be optimized to reduce fuel consumption, by, for example, identifying vehicles and driving habits where fuel consumption is above particular benchmark numbers.
In the preferred embodiment, the telemetry module has access to sensor data measure various operating parameters of each and every vehicle, as described above. The telemetry module also has access to vehicle diagnostic codes as output by the engine of each vehicle. With regards to maintenance, unreported problems may be identified before becoming failures, by way of these sensor measurement. Therefore, maintenance schedules and actions can be predicted and performed on a preventative schedule based on an overall fleet schedule. It is also possible to establish condition-based maintenance programs in addition to preventative maintenance programs and to use vehicle performance data to improve warranty coverage and vehicle component selection. The present invention also allows for additional monitoring or driver actions and behavior, for example in monitoring route deviations or collecting operating data to identify poor driving habits. When accidents do occur, collected parameter data may be used to analyze and interpret the vehicle state at the time of the accident. For insurance and regulatory purposes, a log is easily created to show times of service, pre-trip inspections, emissions monitoring and fuel tax reporting.
Furthermore, better operational management of vehicles in the fleets is possible by using GPS tracking and meter data to present a truer picture of vehicle use and demand. Frequent and accurate meter readings are made possible, as are hourly and daily readings to confirm use. The number of vehicle starts and stops and trips made per day may also be monitored.
In terms of fuel management, the system herein described may be used for tracking and tracing of leakage points in fuel consumption, including monitoring engine idle time, monitoring emission/engine parameters to improve performance, monitoring driver behavior related to an increase in fuel consumption, including high acceleration, speed and hard braking and allows for the tracking of unnecessary miles. This information may then be used to anticipate when a vehicle may be ready for its next scheduled maintenance and to account for and plan for this maintenance at appropriate times.
The maintenance management functions use vehicle parameters and diagnostic trouble codes to drive maintenance procedures for individual vehicles. Accordingly, immediate action may be taken to fault code alerts and a condition-based maintenance approach may be implemented. For example, alerts may be monitored to schedule service to avoid unreported problems, and the fault codes may be linked to maintenance records. Using a condition-based maintenance approach involves monitoring operating parameter thresholds to trigger maintenance activities and incorporating parameter data into failure analysis to establish flags for future failures. The parameter data may also be incorporated into warranty claims and both parameter and performance data may be used for vehicle and/or component selection purposes.
Accordingly, the complete maintenance cycle of vehicles in a fleet may be monitored, controlled, and documented using the system and method herein described. Various telemetric applications have been described using passive, active or on-demand communication to transmit data relevant for maintenance purposes including generating work requests, viewing historical data and collecting operational data for all vehicles in the fleet.
The CAM Life Cycle Model Algorithm
Broadly, the CAM applications and facilities enabled by the invention include developing a life cycle model that makes optimal use of the hardware arrangement described above and using the results of the life cycle model, in part, to determine an asset replacement model. The life cycle model improves upon prior art life cycle models by virtue of the innovative hardware and software arrangements as described above. The general state of the art life cycle model is exemplified by models put forward by the American Public Works Association (APWA) and by M. C. Vorster in the 1970s, both of which are summarized below, and key elements of these prior art methods which are improved upon by the present invention are discussed in more detail.
The APWA identifies a number of factors as inputs into their life cycle model which cumulatively add towards a unit's cost. These include depreciation, operations, maintenance, downtime, interest, alternative capital value, inflation, obsolescence, operator training and carrying parts/inventory. These factors are then used to calculate the total period cost for all periods in a lifecycle, which may then be plotted on a chart. The lowest total period is used to determine the optimal replacement period. The APWA model can be applied based on total yearly costs or using a mean period cost analysis.
For example, consider a 6-year analysis of a sample vehicle within a fleet whose total dollar costs for each of the above-noted factors total as follows:
This analysis leads to the conclusion of replacing this vehicle in its third year of operations according to the APWA model total yearly costs analysis.
When using the mean period cost analysis, the costs are as follows, and would lead to replacing the vehicle in the fourth year of operations:
The mean period cost for a replacement cycle R can be calculated as follows:
Or put more simply,
Where
And to summarize,
When comparing the mean period cost analysis versus the total period cost analysis, it is worthwhile to note that both are neutral of the period type being used. That is, they can be used for any user-defined period, such as years, months, usage, etc. It is generally accepted that the mean period cost approach is a better indicator of the optimal replacement period. A comparison of the two approaches and their results is shown in
As will be apparent to those skilled in the art, various modifications and variations to the system and method herein described will be possible, without departing from the spirit of the invention. It will also be apparent to those skilled in the art that the present invention may be used for vehicle rental purposes, vehicle sharing purposes, organizational vehicle control, and provide information and data as required and adapted to each of these types of business.
Another approach is referred to as the mean period cost equivalent analysis. This approach can only be used for analysis over time, but can be used for analysis by usage when usages are converted to time equivalents. The mean period cost equivalent approach is a discounted cash flow model which factors in costs for interest and alternative capital value, but does not factor in inflation. The mean period cost equivalent (or the mean annual cost equivalent, where period is set as annually) can be expressed as follows:
where; i=discount rate
In terms of determining the optimal replacement period, the same approach is used, where the asset is replaced in the year with the lowers mean equivalent annual cost. Consider the example below, where the replacement is made in the fourth year:
To summarize, the mean period cost equivalent is calculated as
Discounting is defined as the operation of evaluating the present value of future cash. The discount rate is the highest alternative investment rate available.
In order to determine the discount factor, that is the factor by which the current cash flow must be multiplied in order to obtain the present value, the following formula is applied:
Where i=Interest rate and r=Replacement period
The Capital Recovery Factor is the factor by which discounted cash values must be multiplied by to obtain the present value of the potential alternative capital value, and can be expressed as:
Where i=Interest rate and r=Replacement period
In addition, the maintenance history of each vehicle in the fleet is to be factored in to the life cycle analysis. It is notable that there is declining maintenance costs at the end-of-life of each vehicle. These can be caused by a number of factors, including major repairs being avoided (i.e., the vehicle can be sold), vehicle usage declines as the vehicles age, better conditioned vehicles are those that kept for the longest time. This leads to skewed data in which maintenance cost trends appear to decline at the end-of-life, and can lead to negative maintenance cost curves across the fleet. The solution to this peculiarity is to base maintenance tends on costs from first-line life, and to forecast future costs beyond the end of life.
One way of doing this is to use what is referred to as the Vorster Method, in which a second degree polynomial regression is used to generate a trend of cumulative maintenance costs. The CAMAS of the present invention extends this to trend the cumulative costs as well.
In contrast the method of the CAMAS of the present invention uses a multi-step curve fitting process made possible by the hardware and software architecture described above. In particular, the CAMAS using a curve fitting process that (a) starts with a second degree polynomial regression fit and (b) generates an increase in the degree of the polynomial to compare the coefficient of determination (R2) to the previous coefficient of determination and (c) repeats steps (a) and (b) until the increase in R2 is less than 25%.
Another improvement provided by the present invention is the inclusion of inflation to inflate historical values to present day values by compounding inflation rates for each kind of cost for each month as reported by government agencies in the jurisdiction of operation (for example, the Federal Reserve Bank in the United States). For example, the historical labor costs are adjusted using US wage inflation rates from “Total compensation for All Civilian workers in Installation, maintenance, and repair”, as found at https://research.stlouisfed.org/fred2/series/CIU1010000430000I.
Another improvement in the model is the introduction of a median absolute deviation factor which provides a robust measure of the variability of a univariate sample of quantitative data, and can be used to eliminate outlier data values. The median is a robust statistic with a higher breakdown point (defining the number of outlier values it takes to contaminate a dataset). Consider a data set of {1, 2, 3, 4, x}, where the average is x. The median has a breakdown point of N/2 where N is the number of elements in the dataset. In this dataset, the median is 3. N/2 is the maximum breakdown point value, after which one cannot tell the outliers from the real values.
The model of the CAMAS of the present invention improves upon the prior art by (i) the addition of historical inflation, (ii) using trended data to get an aggregate value for multiple assets, (iii) optionally includes the cost of downtime and fuel in operating costs, (iv) optionally bases maintenance costs on historical labor costs or standard current year labor rates, (v) optionally bases maintenance cost trending on data for current front-line life-cycle; and, (vi) optionally uses median absolute deviation functions to remove outliers from data sources.
Having thus summarized the model, the life-cycle calculator as would be assessable to a user on the presentation layer of
The CAM Life-Cycle Calculator
In order to ultimately determine the optimal replacement parameters for vehicles in the fleet, the CAM life-cycle calculator is executed by the CAMAS. The end user of the system has direct access to this calculator and is, in general, the user interface for the invention. For the purpose of the example that is discussed below, an equivalent annual cost model is shown, which is exemplified by the modified prior art model discussed above.
The first step which occurs when a user wants to determine the life-cycle of one or more vehicles in the fleet is to import data from the CAMDS for each of the vehicles being assessed. The user interface shows all data imported as shown in
Optionally, a filter is next applied to select a subset of assets to be included in the analysis.
Next, model parameters are set, providing the option to a user to select all or a subset of the factors which go into making a cost determination, as per the model described in the preceding section.
Exemplary parameters and their requirements are shown in the table below:
Once the factors are selected, depreciation parameters are set as well, as shown in
The user next selects the appropriate response to data outliers, although the invention applied the median absolute deviation method as was described above. The user is able to select a sensitivity to outliers. In the preferred embodiment, the sensitivity is selected scale from 0-3, where 0 is no sensitivity to outliers. At the other end of the spectrum, the model can be set to exclude a large number of potential outlier. This interface is exemplified in
Now that the model parameters have been set, and the appropriate way of managing data outliers has been selected, the user is able to execute and run the model. It will be appreciated that compared to prior art methods and systems, the user's ability to select parameters and adjust the way outliers are handled is significantly improved over the prior art, where such parameters are programmed into each instance of executing the model.
Executing the model is exemplified in
Finally, the system generates results in any of a number of ways, and enables the viewing of results in a number of different user-selected formats and visualizations. Some of these are exemplified in
Finally, the CAMAS uses the generated data to determine the optimal replacement year of each of the assets. The final calculation may be based on the mean equivalent annual cost and an estimate of what the average cumulative utilization is in the year with the lowest equivalent annual cost (as described above in the model description). The results of this calculation are:
The data grid presented to the user shows the cost trends in the life-cycle calculation, and preferably includes the following data, with an exemplary life cycle calculator output show in
A life-cycle graph for each of the assets may also be generated, and could have four basic components: Discounted Resale Value, Discounted Cumulative Operating Cost, and Equivalent Annual Costs, and the Cumulative Annual Usage. Such a graph is illustrated in
It will be clear to one skilled in the art from the foregoing that with the volume of data that requires analysis, the particular hardware configuration including the arrangement and interaction of the different servers and software configured to instruct the hardware in a novel manner provides an improvement over the prior art. Indeed, even if one were to provide improvements in computing power to the prior art approach as was shown in
It will be apparent to one of skill in the art that other configurations, hardware etc may be used in any of the foregoing embodiments of the products, methods, and systems of this invention. It will be understood that the specification is illustrative of the present invention and that other embodiments within the spirit and scope of the invention will suggest themselves to those skilled in the art. All references cited herein are incorporated by reference.