EP2223218A1 - Commodities cost analysis database - Google Patents

Commodities cost analysis database

Info

Publication number
EP2223218A1
EP2223218A1 EP07869648A EP07869648A EP2223218A1 EP 2223218 A1 EP2223218 A1 EP 2223218A1 EP 07869648 A EP07869648 A EP 07869648A EP 07869648 A EP07869648 A EP 07869648A EP 2223218 A1 EP2223218 A1 EP 2223218A1
Authority
EP
European Patent Office
Prior art keywords
cost
data
commodity
subparts
costs
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
EP07869648A
Other languages
English (en)
French (fr)
Other versions
EP2223218A4 (de
Inventor
Gilbert C. LAMB
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Boeing Co
Original Assignee
Boeing Co
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Boeing Co filed Critical Boeing Co
Publication of EP2223218A1 publication Critical patent/EP2223218A1/de
Publication of EP2223218A4 publication Critical patent/EP2223218A4/de
Ceased legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising

Definitions

  • Figure 15 is a diagram illustrating a single national stock number (NSN) part costs tab display screen in accordance with an advantageous embodiment of the present invention
  • Figure 16 is a diagram illustrating a single NSN detailed part costs tab display screen in accordance with an advantageous embodiment of the present invention
  • Figure 17 is a diagram illustrating a cost with related NSN tab display screen in accordance with an advantageous embodiment of the present invention
  • Figure 18 is a diagram illustrating all flight hours and NSN failures tab display screen in accordance with an advantageous embodiment of the present invention.
  • Figure 20 is a flowchart of a process for generating a set of cost analysis data tables for an identified commodity in accordance with an advantageous embodiment of the present invention
  • FIG. 1 an exemplary diagram of a data processing environment is provided in which advantageous embodiments may be implemented. It should be appreciated that Figure 1 is only exemplary and is not intended to assert or imply any limitation with regard to the environment in which different embodiments may be implemented. Many modifications to the depicted environment may be made.
  • FIG. 1 depicts an exemplary diagram of a data processing environment in which an advantageous embodiment of the present invention may be implemented.
  • Network data processing system 100 is a network of computers in which embodiments may be implemented.
  • Network data processing system 100 contains network 102, which is the medium used to provide communications links between various devices and computers connected together within network data processing system 100.
  • Network 102 may include connections, such as wire, wireless communication links, or fiber optic cables.
  • a commodity is a repairable equipment or component having one or more parts.
  • Each part in a commodity can include one or more subparts .
  • Each subpart in a part can also include one or more sub-subparts as well.
  • the term commodity can be used to refer to an airplane, as well as a radio that is installed or to be installed inside the airplane.
  • subpart refers to a part, piece, or constituent of a commodity or another part.
  • a subpart may have one or more subparts of its own, which can be referred to as sub-subparts.
  • a sub-subpart may also have subparts, and so forth.
  • the different processes for the advantageous embodiments of the present invention may be implemented in a server, client, or combination of server and client computers.
  • the processes and data may be located at a single client, such as client 110, alternatively, the processes for providing the simulations may be located on a server, such as server 104 with the client containing a process for providing user input and presenting output, such as through a browser program.
  • the different processes for the advantageous embodiments of the present invention may also be implemented in any database system, such as relational database system 114 connected to a network, a server, a client, or combinations of server and client computers.
  • network data processing system 100 may include additional servers, clients, databases, data storage devices, and other devices not shown in Figure 1.
  • a computer implemented method for managing aircraft fleet maintenance and logistics is provided.
  • the process identifies a set of cost driver subparts corresponding to an aircraft type commodity based on part data obtained by using data mining techniques to filter relevant part data from a plurality of data sources.
  • the process populates a commodity database to display cost-related failure data and inherit configurations for the commodity based on maintenance and supply data from a set of data sources .
  • the process computes an estimated future repair cost for the set of cost driver subparts in the commodity database.
  • the commodity database is used to examine equipment health of the commodity.
  • cost analysis tables 306 are stored in data storage device 308.
  • Data storage device 308 is any type of known or available device for storing data, including but not limited to, random access memory (RAM) , nonvolatile random access memory (NVRAM) , read only memory (ROM) , main memory, cache, a hard disk, a secondary storage device, such as a flash memory or floppy disk, or any other type of data storage device.
  • RAM random access memory
  • NVRAM nonvolatile random access memory
  • ROM read only memory
  • main memory main memory
  • cache main memory
  • a hard disk such as a flash memory or floppy disk
  • secondary storage device such as a flash memory or floppy disk, or any other type of data storage device.
  • data storage device 308 is a local data storage device located on, or in association with, computer 300.
  • data storage device 308 can also include one or more remote data storage devices located on one or more remote computers .
  • Data sources 310 are accessed via server 312.
  • Server 312 is any type of server, such as server 104 and 106 in Figure 1.
  • Server 312 can be a server on a network, such as network 102 described in Figure 1.
  • Computer 300 accesses server 312 via network device 314.
  • Network device 314 is any type of known or available network access software for allowing computer 300 to access a network.
  • Network device 314 connects to a network connection, such as network 102 in Figure 1.
  • the network connection permits access to any type of network, such as a local area network (LAN), a wide area network (WAN), or the Internet.
  • data sources 310 are located remotely to computer 300.
  • one or more data sources in data sources 310 are located on or locally to computer 300.
  • computer 300 can access data sources located on or locally to computer 300 in addition to data sources located remotely to computer 300.
  • Commodities database manager 304 presents cost analysis tables 306 to a user by means of user interface 316.
  • cost analysis tables 306 organize and rank cost analysis data in accordance with a keyed hierarchical coding sequence.
  • cost analysis data in cost analysis tables 306 can be organized and ranked in accordance with any known or available organizing and ranking method.
  • a cost driver subpart is not a part that is used only once in a single custom designed piece of equipment.
  • a cost driver subpart can include a part that is not a part of significant repair and/or replacement cost, and/or a part that is used only once in a single custom designed piece of equipment.
  • Commodities cost analysis database 400 is a relational database for organizing, sorting, and ranking cost analysis data, such as commodities cost analysis database 302 in Figure 3.
  • This illustrative example includes processes performed by a user that are used as inputs and processes performed by commodities cost analysis database 400.
  • a user identifies a commodity based on user data gathering processes and user input (user process 402).
  • the commodity is any type of commodity, including but not limited to, an aircraft, a car, a boat, a radio, an engine, or a radar.
  • Commodities cost analysis database 400 generates a keyed hierarchical breakdown coding sequence for each cost driver subpart of a commodity.
  • the keyed hierarchical breakdown coding sequence provides a code to identify each part and subpart in a hierarchical fashion.
  • the keyed hierarchical breakdown coding sequence also identifies the interrelationships of parts. For example, all subparts that are included in the passenger seat assembly include a common code to identify the passenger seat assembly subpart.
  • the keyed hierarchical coding sequence for a head rest and seat cushions for a passenger seat assembly include a common code sequence identifying subparts of the passenger seat assembly. In this manner, the keyed hierarchical coding sequence identifies subparts and links them to the next higher assembly to which the subparts belong.
  • Commodities cost analysis database 400 combines MIL- STD-1808 and ANSI Y32.16 schemas, or subsequent revisions to those schemas, using a series of alpha-numeric digits to form the unique keyed hierarchical coding sequence for each part or subpart .
  • the keyed hierarchical breakdown coding sequence begins with a two-digit commodities code to identify a given commodity.
  • a two-digit commodities code identifies the type of commodity, as shown in Figure 5. For example, in the sequence "61A1W3", the two-digit commodity code "61" refers to high frequency communications, as shown above.
  • Commodities cost analysis database 400 also generates NSN table 424 based on historical demand for parts by national stock number (NSN) cost data.
  • NSN table 424 provides information regarding historical NSN cost data for one or more parts.
  • Commodities cost analysis database 400 will use the last nine (9) digits of the national stock number (NSN), referred to herein as the national item identification number (NIIN) , as a filter to query VAMOSC historical databases 410 to produce a record listing of four-digit federal supply class (FSC) and nine-digit NIIN.
  • the NIIN is used as a filter to obtain part data, such as sales quantity, total credit quantity, standard price, total credit cost, and net cost from government data sources.
  • aircraft quantity and flying hour table 426 is a table providing information regarding the operational hours during which each part is used.
  • Aircraft quantity and flying hour table 426 provides information regarding aircraft types, quantities of each part used, and flying hours during which each part is used.
  • Commodities cost analysis database 400 obtains this data by filtering for MDS_SRD, which identifies the aircraft.
  • Commodities cost analysis database 400 also filters part data using the AFTOC data flight hours and aircraft quantities using the commodity.
  • Commodities cost analysis database 400 uses this data to calculate minimum and maximum failure rates for parts when determining future costs.
  • the commodity is a non-aircraft commodity.
  • commodities cost analysis database 400 uses operating hours and equipment type on which the part is installed instead of flight hours and aircraft type.
  • Table 500 is a sample list of two-digit codes based on the MIL-STD-1808 assigned to a commodity based on the type of commodity.
  • the two-digit code identifies the type of commodity.
  • the two-digit commodity code is generated based on MIL-STD-1808, subsequent revisions of the MIL-STD-1808, and/or any superseding data sources.
  • MIL-STD-1808 is a U.S. military standard relating to military and commercial aircraft systems. For example, in the part identification sequence "61A1W3", the "61” is a two-digit commodity code that indicates the part is included in a commodity type identified as high frequency (HF) communications as shown at line 502.
  • HF high frequency
  • Selected main part numbers 614 is a display showing manufacturer part numbers for a selected part. In this example, selected main part numbers 614 is displayed to the right of main part 604. However, selected main part numbers 614 can be displayed in any location in a display screen.
  • Selected breakdown part numbers 616 is a listing of manufacturer part numbers for a selected component part in selected main part numbers 614.
  • Double clicking on a selected main part breakdown field, CAGE field, RJSICC field, or RJNJVC field triggers commodities cost analysis database to open a window or screen for a user to view or enter data.
  • the selected main part on main part 604 has a breakdown listing of subparts 606. Each subpart has a corresponding selected breakdown number list 616. When users select a different main part, the corresponding subparts and associated parts appear in selected main parts breakdown 606. When users select a subpart, the corresponding part numbers field, CAGE field, RNCC field, and RNCC fields 616 appear.
  • MDS mission design series
  • Figure 8 is a diagram of a set of summary graphs for commodities sales and repair costs in accordance with an advantageous embodiment of the present invention.
  • a summary graph such as net cost graph 802 is displayed in response to a user selecting an indicator on a commodity form summary, such as net control 610 in Figure 6.
  • Net cost graph 802 is a graph showing a summary of net costs over a given time period. Net cost is an amount paid for all commodity repairs less credits from organizational (local) and depot-level (non-local) repairs. Negative values are not graphed.
  • the process calculates metrics based on historical data, future costs, and projected return on investments (operation 2214) .
  • the process displays the numbers and data calculated in operations 2202-2214 using tables, visual indicators, and/or graphical displays (operation 2216) .
  • the process compares future estimated cost data for cost driver parts with estimated costs for improvements to show a break-even point and cost effectiveness for replacing a cost driver part and/or repairing the cost driver part (operation 2218) , with the process terminating thereafter.

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Finance (AREA)
  • Marketing (AREA)
  • Accounting & Taxation (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Resources & Organizations (AREA)
  • Educational Administration (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
EP07869648A 2007-12-20 2007-12-20 Commodities cost analysis database Ceased EP2223218A4 (de)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/US2007/088377 WO2009082389A1 (en) 2007-12-20 2007-12-20 Commodities cost analysis database

Publications (2)

Publication Number Publication Date
EP2223218A1 true EP2223218A1 (de) 2010-09-01
EP2223218A4 EP2223218A4 (de) 2012-08-29

Family

ID=40801488

Family Applications (1)

Application Number Title Priority Date Filing Date
EP07869648A Ceased EP2223218A4 (de) 2007-12-20 2007-12-20 Commodities cost analysis database

Country Status (2)

Country Link
EP (1) EP2223218A4 (de)
WO (1) WO2009082389A1 (de)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8185780B2 (en) 2010-05-04 2012-05-22 International Business Machines Corporation Visually marking failed components

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6393406B1 (en) * 1995-10-03 2002-05-21 Value Mines, Inc. Method of and system for valving elements of a business enterprise
US5970476A (en) * 1996-09-19 1999-10-19 Manufacturing Management Systems, Inc. Method and apparatus for industrial data acquisition and product costing
US7149739B1 (en) * 2001-05-25 2006-12-12 International Business Machines Corporation System and method for performing ratio planning

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
EPO: "Mitteilung des Europäischen Patentamts vom 1. Oktober 2007 über Geschäftsmethoden = Notice from the European Patent Office dated 1 October 2007 concerning business methods = Communiqué de l'Office européen des brevets,en date du 1er octobre 2007, concernant les méthodes dans le domaine des activités", JOURNAL OFFICIEL DE L'OFFICE EUROPEEN DES BREVETS.OFFICIAL JOURNAL OF THE EUROPEAN PATENT OFFICE.AMTSBLATTT DES EUROPAEISCHEN PATENTAMTS, OEB, MUNCHEN, DE, vol. 30, no. 11, 1 November 2007 (2007-11-01), pages 592-593, XP007905525, ISSN: 0170-9291 *
See also references of WO2009082389A1 *

Also Published As

Publication number Publication date
EP2223218A4 (de) 2012-08-29
WO2009082389A1 (en) 2009-07-02

Similar Documents

Publication Publication Date Title
US7840432B2 (en) Commodities cost analysis database
US11851034B2 (en) Predicting vehicle repair operations
CN105493083B (zh) 用于预评估车辆诊断和维修成本估计的系统和方法
US6524109B1 (en) System and method for performing skill set assessment using a hierarchical minimum skill set definition
US8161045B2 (en) Use of associate memory learning agent technology to identify interchangeable parts in parts catalogs
US7698148B2 (en) Web-based risk management tool and method
US20130151308A1 (en) Lifecycle Obsolescence Forecasting Tool
EP1571541A2 (de) Verwaltung individueller Objektdaten
US20130138538A1 (en) Method And System For Monitoring A Supply-Chain
US20030034995A1 (en) Interactive graphics-based analysis tool for visualizing reliability of a system and performing reliability analysis thereon
WO2003059738A2 (en) Digital cockpit
WO2004079528A2 (en) Quality information management system
US20020188494A1 (en) Method and apparatus for managing an operation
US20040249694A1 (en) Project management method and system
CN120541060B (zh) 基于sql诊断优化与智能调度的数据库运维方法及设备
WO2007130740A2 (en) Parts marking system and method
US20110144786A1 (en) Material management system and method for retooling and producing a manufacturing line
EP2223218A1 (de) Commodities cost analysis database
US8122352B2 (en) Parts marking system and method
CN117829789A (zh) 一种基于多数据融合的航空器服务保障系统和方法
KR100520478B1 (ko) 경영계획 작성시스템
WO2009096979A1 (en) Use of associate memory learning agent technology to identify interchangeable parts in parts catalog
WO2019068075A1 (en) MACHINE ANALYSIS
US20080133383A1 (en) Parts marking system and method
AU2005337460B2 (en) Parts marking system and method

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20090619

AK Designated contracting states

Kind code of ref document: A1

Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU LV MC MT NL PL PT RO SE SI SK TR

AX Request for extension of the european patent

Extension state: AL BA HR MK RS

R17P Request for examination filed (corrected)

Effective date: 20090619

DAX Request for extension of the european patent (deleted)
A4 Supplementary search report drawn up and despatched

Effective date: 20120801

17Q First examination report despatched

Effective date: 20170710

REG Reference to a national code

Ref country code: DE

Ref legal event code: R003

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED

18R Application refused

Effective date: 20190219