Method for generating a balance sheet that includes operating materials and supplies costs

US11861735B1 · kind B1 · utility

Assignee

• The Government of the United States of America, as represent by the Secretary of the Navy · US

Inventors

• Gilbert F. Lee · Greenbelt, US
• Ruth A. Maticic · Elkridge, US
• Tami L Ellinger · Laurel, US
• Deborah H. Russell · Friendship, US

Key dates

• Filing date: Sep 4, 2020
• Grant date: Jan 2, 2024
• Expiry date: Sep 4, 2040

Classification

• Technology area (CPC G): Physics
• CPC primary: G06Q40/12
• WIPO field: IT methods for management
• WIPO sector: Electrical engineering

Abstract

According to exemplary inventive practice, a transaction code is selected in an ERP system. The transaction code is characterized by cost elements that to a substantial degree entail OM&S costs. ERP reports are generated by drilling down from the cost elements to commitment costs, obligation costs, and actual costs, wherein drilling down from each cost element yields at least one of these three kinds of costs. Raw worksheets are generated in a spreadsheet program by importing data from the ERP reports, wherein each raw worksheet contains data from at least one ERP report. Data are derived from the raw worksheets and are combined and arranged to produce intermediate pivot tables, wherein each intermediate pivot table contains data from at least on raw worksheet. Data are derived from the intermediate pivot tables and are combined and arranged to produce a master worksheet. Data are derived from the master worksheet and are combined and arranged to produce summary pivot tables.