EP1518203A4 - Procede de calcul de la valeur economique creee par une activite commerciale - Google Patents

Procede de calcul de la valeur economique creee par une activite commerciale

Info

Publication number
EP1518203A4
EP1518203A4 EP03763134A EP03763134A EP1518203A4 EP 1518203 A4 EP1518203 A4 EP 1518203A4 EP 03763134 A EP03763134 A EP 03763134A EP 03763134 A EP03763134 A EP 03763134A EP 1518203 A4 EP1518203 A4 EP 1518203A4
Authority
EP
European Patent Office
Prior art keywords
data
cost
product
calculating
grade
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.)
Withdrawn
Application number
EP03763134A
Other languages
German (de)
English (en)
Other versions
EP1518203A2 (fr
Inventor
Neal T Heires
Jared R Guckenberger
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.)
EIDP Inc
Original Assignee
EI Du Pont de Nemours and 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
Priority claimed from US10/609,389 external-priority patent/US7444307B2/en
Application filed by EI Du Pont de Nemours and Co filed Critical EI Du Pont de Nemours and Co
Priority claimed from PCT/US2003/020892 external-priority patent/WO2004006056A2/fr
Publication of EP1518203A2 publication Critical patent/EP1518203A2/fr
Publication of EP1518203A4 publication Critical patent/EP1518203A4/fr
Withdrawn legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR 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/10Office automation; Time management

Definitions

  • Field of the Invention A business process that collects data for multiple business activities from diverse sources, and facilitates the calculation of economic value added for these specific business activities.
  • a business In order to make pricing decisions, a business has an ongoing need to understand its real costs. With knowledge of real costs the business management can determine what effect changing a price charged to a particular customer, or to a particular market or market segment, or within a particular region, will have on the profitability of the business.
  • Profit on a particular sale was then calculated by first adding the regional freight and duty to the sum of the fixed cost and variable cost to produce a "total cost”. This total cost was then subtracted from the selling price, to determine a measure of profitability called "manufacturing contribution”. With these data, a product manager could then calculate what the manufacturing contribution was for each grade of product sold to all customers or to a particular customer based on the difference in selling price or distribution costs. However, this "manufacturing contribution" term did not account for non-manufacturing fixed cost, taxes, and cost of working capital. This shortcoming made it difficult to calculate after tax earnings of a specific sale of product to a customer or group of customers. Businesses typically accounted for these other fixed costs separately.
  • the prior art ATOI calculation did not provide a good determination of whether a particular activity, such as a sale of a particular product, increased or decreased the profitability (i.e., the economic value) of the business.
  • a particular activity such as a sale of a product
  • the actual sales expense or effort applied to achieve that sale is needed.
  • This actual expense or effort includes: selling effort, research and development (R&D) effort, and technical service effort.
  • R&D research and development
  • the specific tax rates for the region in which the sale occurred (as well as the tax rates where the manufacturing occurred), the amount of working capital required to maintain inventory, the plant investment to support the sale and the cost of capital also had to be accounted for.
  • a historically difficult process was to collect the sales data for each accounting period (typically a year) and assign each sale to a market and a market segment. While sales data could be routinely extracted from a global sales database, the sales and marketing personnel had to identify the market in which the sales belong. Historically this was done relatively infrequently, such as every three to four years. Historical efforts to determine economic value added by product and market were carried out by periodically (typically no more than three to four years) surveying the business organization to determine which sales belonged in which markets, and to determine how people in the business were dedicated or allocated to these sales. For a diversified manufacturing or marketing business this could be an extensive effort involving several million dollars of expense.
  • Integrated systems typically take years to implement. Once a changeover to such a system is made it has to work or the business effectively shuts down. 3. Integrated systems are expensive, costing tens of millions of dollars. 4. Integrated systems can be inflexible, requiring changes to be made to the entire system to get the desired results. As an example, if an integrated system is implemented for only one region, to get global results the systems in other regions must be changed over to the integrated system. ' . • .-. ⁇ ,.. . • •. , . • .,:., ,., , repet>
  • the present invention improves the quality and timeliness of the "cost by type report" (mentioned above) by inputting the business activity data, such as manufacturing detail, into a single relational database in a common format. Updates of business activity (data manufacturing cost by type or grade, etc.) data may be achieved much more easily than prior art systems.
  • aggregate cost or “aggregate cost of manufacture” of a product means cost averaged over all sources (i.e., different manufacturing units or locations) of that product. Costs associated with a specific asset (i.e., a manufacturing unit, also generally termed equipment) may be based on the fraction of time that a product occupies that specific asset or upon the volume fraction of product that occupies the asset.
  • the term "manufacturing contribution”, also known in the art by the term “gross contribution”, means the selling price per unit, less the total of any rebates or discounts, less freight and duty, less the fixed and the variable manufacturing costs, all multiplied by the sales volume.
  • MCunit (Punit " Runit - FD un it - VMC un it - FMC un it)
  • MC MCunit x SV
  • MC un i t Manufacturing Contribution per unit of product (items, pounds, kilograms, etc.)
  • MC total Manufacturing Contribution
  • P un i t represents the price per unit
  • FDuni t represents freight costs and duty per unit
  • VMC un it represents variable manufacturing cost per unit
  • FMC un it represents fixed manufacturing cost per unit
  • SV sales volume, i.e., total units sold. Another way to define Manufacturing Contribution or Gross
  • EVA Economic Value Added
  • SVA Shareholder Value Added
  • EVA ((MC U nit " SC U nit - RD un it - OC unit -AC-unlt) (1 - TX) - (NRAunit x CC )) x SV
  • SC selling cost
  • RD research and development cost
  • OC one time charges for the period
  • AC administration cost
  • TX is the effective tax rate
  • NRA net RONA assets (Accounts Receivable - Accounts Payable + Inventory + Permanent Investment - Depreciation)
  • CC is the average cost of capital.
  • RONA is the commonly used Return On Net Assets.
  • Economic value added is therefore the net profit generated by a business activity after all of the associated business costs have been subtracted, the effective taxes have been subtracted and the cost of capital has been accounted for.
  • SVA sharedholder value added
  • the present invention is a method or process of computing an economic value created by a particular business activity, the method comprising, in sequence, the steps of:
  • the process of the present invention is organized in a computational hierarchy that first collects cost, production and sales data and organizes these data in a common format, then computes, in a sequential manner, manufacturing costs, then manufacturing contribution, then ATOI, and finally computes economic value added for a selected business activity, such as manufacturing and selling a particular product. Data may be checked for discrepancies immediately after entry, so that erroneous calculation results are not created.
  • the cost, production, and sales information is extracted from various data sources and then loaded into tables or predefined fields in a single database in a common format.
  • a program module successively calculates, in a hierarchical manner, manufacturing cost, manufacturing contribution, ATOI and finally computes economic value added (EVA) in accordance with the equations set forth above.
  • the user defines the results to be presented by entering parameters into an electronic "form", such as a spreadsheet or a spreadsheet pivot table.
  • the program module presents the results to the user in a user-selectable graphical format, such as those available within spreadsheet software packages.
  • the graphical presentation enables a user, such as a business manager, to visualize the calculated results make decisions.
  • the process of the present invention requires an ongoing periodic (typically monthly) update of relatively few changes per time period to reflect new sales and newly introduced products.
  • the data may be extracted from the data source and loaded into one or more spreadsheet tables in a standardized format. Costs that fluctuate frequently, such as raw materials costs, can be input as each change occurs. Other more routine fixed costs that fluctuate infrequently, such as on a year to year basis, are therefore not updated as frequently.
  • the process of the present invention can calculate the EVA report as often as desired, fTM- example on a monthly basis, instead of once every several years.
  • the present process can identify which sales are contributing to economic value added on a month to month and year to year basis, as needed.
  • the full implementation of this process creates new "pivot tables" and "waterfall” charts for the Market Segment managers. See Figures 23 and 24. These charts present a tabular and graphical representation of results of EVA in comparison to the selected parameter (market segment, customer, etc.).
  • the pivot tables and waterfall charts help a business manager to define which sales are driving economic value added, and assist in developing pricing strategies and determining how to allocate sales efforts and other efforts which lead to long term profitable growth of a business.
  • Historical data may be used to visualize growth trends of a business by market, by region, by segment, by customer, by product type, even by product grade. From this historical data business management can determine the source of growth or decline, and define where the business needs to focus its resources further to drive earnings growth.
  • the present invention is a business management tool that defines the impact that a sale or group of sales has ultimately on the company's inherent value. Knowing this, business management can then more effectively manage business activities associated with such sales in a way the will increase the company's inherent value and ultimately the price of a company's stock.
  • the impact that economic value added has on the price of a company's inherent value is typically termed shareholder value added in the prior art and is abbreviated as "SVA".
  • SAP shareholder value added
  • the present invention is believed to provide higher quality information than that obtained from more expensive integrated software systems (i.e. SAP), and does so at a dramatically lower cost.
  • This dramatically lower cost is achieved by use of a software module that is programmed in Visual basic and is built onto a relational database.
  • the relational database accepts tabulated data from existing non-integrated databases (such as a GFDB and ⁇ DB), and calculates economic value added (EVA).
  • the present invention requires only about 200 megabytes of data storage on a personal computer, thus requiring no new equipment for a typical user.
  • it can be updated and maintained by anyone that is trained to use the particular relational database and spreadsheet software in which the invention is implemented.
  • SAP and SAP system upgrade require expertly trained and experienced programmers.
  • the present invention achieves higher quality data than integrated software systems, such as SAP, because it provides the flexibility to distribute costs across families of products based upon shared use of assets, rather than penalizing the product being manufactured at the time an unexpected cost occurs.
  • the present invention is able to accept tabulated data from any source, thus allowing the use of data from previously incompatible computer systems to be merged for the EVA calculation.
  • the present invention has a multiple calculation staging process that allows it to pull and calculate large amounts of data from multiple tables. Without the sequential calculation method of the present invention, normal query operations with large amounts of data typically would cause operability problems, such as crashes, of the relational database software.
  • the present invention comprises error logic that is critical for trouble shooting.
  • An error report is.compiled thataids in identifying missing or erroneous information.
  • the present invention has the ability to archive the relational database (e.g. Access®) data files within security protocols. 5. The present invention has the ability to reconcile the cost of manufacture of internally produced grades with the raw materials list.
  • relational database e.g. Access®
  • the present invention does all of the above loaded onto inexpensive desktop relational database software (e.g., Microsoft Access®).
  • the system may be implemented in a single computer or multiple computers linked by a system network, requiring only about 200 megabytes of storage per computer.
  • the present invention was created for and has been tested using production data for an extremely complex business that manufactures a highly diverse family of products produced in multiple facilities and sells those products in a wide range of markets and applications. It is believed that the present invention may be adapted to any particular business activity, either simple or complex, thus providing business value that extends beyond a purely manufacturing environment.
  • Figure 1 is a block diagram showing a manual prior art calculation method
  • FIG. 2 is a block diagram showing the process flow of the present invention
  • Figure 2A is a block diagram showing the process flow of the present invention for a process having multiple manufacturing units
  • Figure 2B is a block diagram showing the process flow of cost data for a process having multiple manufacturing units
  • Figure 3 shows a "Main View” form for selecting information management options
  • Figure 3A shows an annotated version of the view of Figure 3 showing icons for selection of type of infocma*"-"-: management desired;
  • Figure 4 shows a form for selecting global databases icon for entry and updating of cost data has been selected;
  • Figure 4A shows a form for inputting cost data for each manufacturing unit;
  • Figure 5 shows the form for selecting global databases where the icon for entry of raw materials cost has been selected;
  • Figure 5A shows a form for inputting raw materials cost for each ingredient on each production unit;
  • Figure 6 shows an annotated version of the view of Figure 3 where the icon for the "Cost by type" has been selected
  • Figure 6A shows a form for adding or editing grades to cost by product type
  • Figure 7 shows an annotated version of the view of Figure 3 where the icon for the "volume of each grade per unit" has been selected
  • Figure 7A shows a format for loading volumes of product volume by manufacturing unit
  • Figure 8 shows a format for loading sales data from another database and identifying market segment for each customer, region and product grade;
  • Figure 9 shows a form for selecting input of sales data
  • Figure 9A shows a typical listing of entries of sales data arranged by product
  • Figure 9B shows a typical listing of entries of market and segment arranged by customer and product
  • Figure 10 shows a form for selecting entry of rebates or discounts
  • Figure 10A shows a typical listing of rebates or discounts by customer arranged by region and product type
  • Figure 10B shows a typical listing of entries of rebates or discounts by customer arranged by product grade
  • Figure 11 shows a form for selecting input of freight and duty by product for each, region; -- ⁇ . . • , ⁇ - ⁇ ..,-,* ⁇ , Figure 11 A shows a format for loading freight and duty from a
  • Figure 12 shows a form for selecting input of R&D and other overhead expenses by product
  • Figure 13 shows a form for selecting input of R&D and other overhead expenses by product
  • Figure 14 shows a form for loading overhead expenses from a
  • Figure 15 shows a form for selecting input of sales expense, warehousing expense and tax rates
  • Figure 16 shows a form for selecting input of sales expense, warehousing expense and tax rates
  • Figure 16A shows a form showing entries of selling expense, warehousing expense, and tax rates by region;
  • Figure 17 shows a form for allocating regional sales effort per market segment;
  • Figure 17A shows a form for selecting the input of sales expense effort;
  • Figure 17B shows a form for selecting the input of sales expense effort
  • Figure 17C shows a form for selecting the input of sales expense effort as a percentage of total region sales effort
  • Figure 18 shows a form for selecting the calculation of gross contribution, ATOI and EVA
  • Figure 19 shows a form for selecting the report options desired
  • Figure 20 shows an example of a report in a table format that can be loaded into a pivot table for graphical presentation
  • Figure 21 shows an example of a report in a table format reporting the economic value added (EVA) for a given month in a particular segment of a market.
  • EVA economic value added
  • Figure 22 shows an example of a numeric table output in pivot table , format
  • Figure 23 shows an example of a waterfall chart
  • Figure 24 shows an iterative process for reconciling the aggregate cost of manufacture of internally produced grades of product consumed in subsequent manufacturing steps with the raw materials list.
  • Figure 2 is a block diagram showing the process flow of the present invention.
  • Three main groups of data are required to calculate the economic value added of a business activity.
  • the legend at the bottom of Figure 2 shows three methods used to acquire the data: spreadsheet format from existing database (rectangular boxes 10), existing data loaded into a Form View (rectangular boxes 20), new process collects data into spreadsheet format (octagonal boxes 30); and the values calculated by the method (hexagonal boxes 40).
  • the top row of boxes in Figure 2 illustrate a method of calculating an aggregate cost of a product manufacture or acquisition activity 201.
  • Cost data for each manufacturing unit is input 101
  • raw material costs for each ingredient of each unit is input 102
  • productivity, composition, and packaging data for each product grade is input 103
  • volume by grade of each manufacturing unit is input 104.
  • the middle row of boxes in Figure 2 illustrate a method of calculating a sales volume and a net price 202. These calculations are related to one or more parameters selected by the user, the parameters comprising a customer, a sales region, a product grade and a market segment, as will be discussed in conjunction with Figure 18. Sales data by customer, region and grade is input 111 , market segment is identified for each customer, region and grade 112, rebates or discounts a>-e input . ⁇ ; . .. by customer, region and grade 113. Once a market segment has been initially entered for each customer region and grade 112, subsequent sales to that customer are automatically identified 112A.
  • the bottom row of boxes in Figure 2 illustrate a method of calculating a manufacturing contribution related to the one or more parameters 205, calculating an after tax operating income related to the one or more parameters 206 and calculating an economic value added for 5 the one or more parameters 207.
  • Freight and duty is input for each product in each region 121
  • R& D costs, other overhead expenses, and total capital investment is input 122
  • sales expense, warehousing expense and tax rates are input by region 123
  • sales expense effort is identified by product, by region and by market segments 124.
  • Figure 2A is a block diagram showing the process flow of the present invention for a process having multiple manufacturing units. Each horizontal row of boxes in Figure 2A generally correspond to the top row of boxes in Figure 2. Three manufacturing units are shown (Units 1 , 2, and 3). Cost data for manufacturing unit 1 is input 101-1 , raw material cost for
  • each ingredient of unitl is input 102-1 , productivity, composition, and packaging data for each product grade is input 103-1 , and volume by grade of manufacturing unit 1 is input 104-1. Aggregate cost of manufacture for each grade is calculated in box 201-1. In a similar manner manufacturing unit 2 has cost data 101-2, raw material cost 102-2,
  • 20 productivity, composition, and packaging data for each product grade is input 103-2, and volume by grade 104-2. Aggregate cost of manufacture for each grade is calculated in box 201-2.
  • Manufacturing unit 3 has corresponding inputs designated by suffix -3 (i.e., 101-3, 102-3, 103-3, 104-3). The particular process illustrated has three manufacturing units,
  • units 1 and 2 are manufacturing products that are consumed by manufacturing units 1 , 2, and 3.
  • the process of calculating aggregate cost of manufacture for each grade is discussed below in conjunction with Figure 25.
  • Figure 9B shows an alternate method for identifying market and segment for each customer, region and grade using a form view within the relational database (e.g., Access ®).
  • Figure 2B is a block diagram showing the flow of cost data in the present invention for a process having multiple manufacturing units. The process of calculating aggregate cost of manufacture for each grade is discussed below in conjunction with Figure 25.
  • Figures 3 through 19 illustrate forms used by the user to interact with the functional boxes shown in Figure 2.
  • Figure 3 shows a "Main View” form 300 for selecting information management options.
  • Two main options “cost-by-type” 301 and “Manufacturing Contribution /ATOI /SVA” 302 are provided.
  • Icons within the "cost-by-type” option 301 are "product grade enter/edit 310, "mass data entry” 320, “report options” 330, and “global entries 340.
  • Within the "cost-by-type” option 301 is a pull down menu of manufacturing units to choose 303.
  • Icons within the "Manufacturing Contribution /ATOI /SVA” 302 are "report options" 350 and "mass data entry” 360.
  • Figure 3A shows a form 350, which is an annotated version of the view of Figure 3 showing icons for selection of type of information management desired.
  • Figure 3A implements the functions of boxes 101 , 102,103, and104 of Figure 2. Arrows connect the boxes 101 , 102, 103, and 104 of figure 2 to the corresponding icons 320, 320, 310, and 360.
  • Figure 4 shows a form 400, which is presented to the user when the "global databases" icon 320 of Figure 3 is selected.
  • the form 400 is used for entry and updating of cost data.
  • Implementation of the function of box 101 is shown by an arrow connecting box 101 to the icon "unit specific”.
  • Figure 4A shows a form 450 for inputting cost data for each manufacturing unit which is presented to the user when the "unit specific" icon of Figure 4 is selected.
  • Entries are made in a tabular format, identif y ing (from left to right): the production unit (labeled as 1 ,2,3,4;,., NOCBT, CMBW, and OP), the unit type (autoclave or cont.mfg.), the number of individual scheduled production runs, standard product production volume (year to date in pounds YTDIbs), second quality production volume, reject production volume, average scheduled shutdown hours, variable utilities costs per unit of production (year to date in dollars per pound), variable waste and other cost per unit of production, etc.
  • the triangles to the right of certain fields indicate that a pull down menu of the available selections should be used.
  • Figure 5 shows a form 500, which is presented to the user when the "global entries" icon 340 of Figure 3 is selected. Implementation of the function of box 102 is shown by an arrow connecting box 102 of Figure 2 to the icon "ingredients by unit”.
  • Figure 5A shows a form 550 for inputting data from selected global databases when the icon "ingredients by unit” of Figure 5 has been selected. Entries in form 550 are made in a tabular format, identifying (from left to right): production unit, material name material yield in percent, price conversion, fixed cost, variable cost, and comments.
  • Figure 6 shows a form 600, which is presented to the user when the
  • Figure 6A shows a form 650 for inputting the form for selecting global databases when the icon "ingredients by unit” of Figure 6 has been selected. Entries are made in a tabular format, identifying (from left to right): production unit, product family, unit production capability, etc.
  • Figure 7 shows a form 700, which is presented to the user when the "mass data entry" 360 of Figure 3 is selected.
  • Figure 7A shows a form 750 for inputting the form for selecting global databases when the icon "segment splits" icon of Figure 7 has been selected. Entries are made in a tabular format, identifying (from left to right): production unit, product grade and volume.
  • Figure 8 shows a form 800 which is presented to the user for input of sales data by customer, region and grade (implementing box 111 of Figure 2) and inputof market segment bv customer, region and grade (implementing box 112 of Figure 2).
  • Figure 9 shows a form 900 which is presented to the user when the user for input of sales data by customer, region and grade (implementing box 111 of Figure 2).
  • Figure 9A shows form 950 for tabular entry of sales data.
  • Figure 9B shows a form 900, an overlaid form 920 and a second overlaid form 940.
  • Form 900 has "Customer Profile List", and "Customer Profile Entry” buttons that facilitate the present invention to assign the segment and market to a sale rather than entering this information from a spreadsheet on a periodic basis. Once the "customer profile entry" button has been selected, an alphabetical list will appear showing sales data that does NOT have a customer profile. This situation occurs when a sale is made to a new customer for the first time. This feature facilitates editing customer profiles since missing profiles are automatically identified.
  • Figure 10 shows a form 1000 (essentially the same as form 700 of
  • Figures 10A and 10B show two different data entry tables 1050 and 1070 respectively.
  • Figure 11 shows a form 1100 (essentially the same as form 700 of
  • Figure 11A shows a table 1150 for entering freight and duty.
  • Figure 12 shows a form 1200 (essentially the same as form 700 of Figure 7) which is presented to the user for selection of the "ATOI and
  • Figure 13 shows a form 1300, which is presented to the user when the "ATOI and SVA Data Tables" icon of Figure 12 is selected.
  • FIG. 1 "Product Entries” icon of Figure 1 is selected form 1400 of Figure 14 is presented to the user for entry of R&D expense and other overhead expenses, thus implementing box 122 of Figure 2.
  • Figure 15 shows a form 1500 (essentially the same as form 700 of Figure 7) which is presented to the user for selection of the "variable FPDE” icon (implementing box 123 of Figure 2).
  • form 1600 of Figure 16 is presented to the user.
  • form 1650 of Figure 16A is presented to the user for entry of data.
  • Figures 17, 17A, 17B and 17C implement box 124 of Figure 2).
  • Figure 17 shows a form 1700 (essentially the same as form 700 of Figure 7) which is presented to the user.
  • form 1720 of Figure 17A is presented.
  • spreadsheet data of sales effort of Figure 17B can be copied into Form 1760 of Figure 17C which comprises the input of sales expense effort as a percentage of total region sales effort;
  • Figure 18 shows a form 1800 (essentially the same as form 600 of Figure 6) which is presented to the user for selection of the "report options" icon (implementing box 205 of Figure 2).
  • form 1900 of Figure 19 is presented to the user for selection of report options.
  • Figures 20 through 23 are examples of outputs created by the present invention.
  • Figures 20, 20A and 21 show tables to be loaded into pivot tables and charts for tabular and graphical presentation (implementing box 206 of Figure 2).
  • Figure 22 is an example of a pivot table.
  • Figure 23 is an example of a well-known "waterfall table" produced from a pivot table.
  • Figure 24 shows a method of reconciling the cost of manufacture of an internally produced grade with the raw materials list.
  • This reconciliation method is an iterative process.
  • a predetermined threshold for the difference between the entered (or previously calculated) ingredient cost and the aggregate Cost of Manufacture is selected to determine when the iterative process should terminate.
  • a maximum number of repetitions is also specified to stop the iterative process in case an erroneous value is entered or a calculation error occurs.
  • the Ingredients List for all Production Units is compared to the Cost of Manufacture for each product Grade to determine each affected ingredient.
  • the aggregate Cost of Manufacture is a value based upon the production mix entered for each Production Unit.
  • the difference between the existing (entered or previously calculated) ingredient costs and the aggregate Cost of Manufacture is calculated, the fixed cost and the variable cost being calculated independently. If the difference between the existing (entered or previously calculated) ingredient cost and the aggregate Cost of Manufacture exceeds the predetermined threshold, the ingredient cost is updated (i.e., replaced) with the aggregate cost of manufacture. Then a recalculation of all aggregate Cost of Manufacture values for all affected grades is initiated. This process is repeated until the difference between all existing (entered or previously calculated) ingredient costs and the aggregate Costs of Manufacture is less than or equal to the predetermined threshold or until a predetermined number of repetitions has been reached.
  • Figure 24 shows a diagram of product flow in a typical manufacturing processieomprisedOff PrcH '.-iion Units 1 , 2 n, and n+ ⁇ , It should be noted that products produced in each Production Units can flow to a subsequent Production Unit as well as to one or more previous Production Units.
  • Production Unit 1 produces grade X1 by consuming raw material Y1 as well as Grade X2 and Grade Xn+1 (box A). If the cost of raw material Y 1 changes (e.g., increases) the cost of the grade X1 increases.
  • Production Unit 2 produces grade X2 by consuming grade X1 , grade X3, and grade Xn+1 (box B).
  • Production Unit n produces grade Xn by consuming grade X2 and grade Xn-1 (box C).
  • Production Unit n+1 produces grade Xn+1 by consuming grade Xn (box D).
  • a system for computing an economic value created by a particular business activity may be implemented in accordance with the method of the present invention.
  • the system may comprise a single computer or may be implemented in a network, the system comprising: a server node having a memory therein, and at least one user node.
  • the memory of the server node may have a user-interface section, a custodian-accessible section, a data interface section, and a repository section.
  • the user-interface section may have at least one predetermined user-accessible form for entering data and at least one predetermined graphical format for viewing data and results.
  • the custodian-accessible section may have privileged access to the user-interface section, to the data interface section and to the repository section.

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

Un processus commercial collecte des données pour des activités commerciales multiples dans diverses sources, et facilite le calcul de la valeur économique ajoutée pour ces activités commerciales spécifiques. La valeur économique ajoutée d'une activité commerciale spécifique peut être calculée de manière hiérarchisée, par rapport à un produit, à un client, à une zone géographique, à un marché, à un segment de marché ou à une application de produit. Ledit processus ne requiert que des ordinateurs de bureau bon marché et un logiciel de bureau classique connecté à un serveur commun possédant une base de données relationnelle.
EP03763134A 2002-07-03 2003-06-30 Procede de calcul de la valeur economique creee par une activite commerciale Withdrawn EP1518203A4 (fr)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US39367802P 2002-07-03 2002-07-03
US393678P 2002-07-03
US10/609,389 US7444307B2 (en) 2003-06-26 2003-06-26 Process for calculating the economic value created by a business activity
PCT/US2003/020892 WO2004006056A2 (fr) 2002-07-03 2003-06-30 Procede de calcul de la valeur economique creee par une activite commerciale
2003-07-18

Publications (2)

Publication Number Publication Date
EP1518203A2 EP1518203A2 (fr) 2005-03-30
EP1518203A4 true EP1518203A4 (fr) 2006-09-06

Family

ID=36999192

Family Applications (1)

Application Number Title Priority Date Filing Date
EP03763134A Withdrawn EP1518203A4 (fr) 2002-07-03 2003-06-30 Procede de calcul de la valeur economique creee par une activite commerciale

Country Status (1)

Country Link
EP (1) EP1518203A4 (fr)

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
No Search *

Also Published As

Publication number Publication date
EP1518203A2 (fr) 2005-03-30

Similar Documents

Publication Publication Date Title
US9740992B2 (en) Data warehouse system
US7444307B2 (en) Process for calculating the economic value created by a business activity
US5799286A (en) Automated activity-based management system
US7822654B2 (en) Business analysis tool
Oulton ICT and productivity growth in the United Kingdom
US6337901B1 (en) Customer billing relationships software
US7805497B2 (en) Method and product for calculating a net operating income audit and for enabling substantially identical audit practices among a plurality of audit firms
US20020133368A1 (en) Data warehouse model and methodology
US20080319811A1 (en) System and method for modeling an asset-based business
EP0770967A2 (fr) Système d'aide de décision pour la gestion d'une chaîne de l'alimentation agile
CA2394227A1 (fr) Systeme et methode informatiques de controle de la rentabilite d'une usine de fabrication
Baldenius et al. Cost allocation for capital budgeting decisions
CA2562717A1 (fr) Procedes d'evaluation de la sante financiere d'un holding par rapport a d'autres holdings
WO2010019897A1 (fr) Prescription automatique d'un budget total pour des ressources de marketing et de vente, et allocation de ressources entre des catégories de coûts
Haffar “SPAM”: a computer model for management of spare-parts inventories in agricultural machinery dealerships
EP1225528A2 (fr) Système d'entrepôt de données
US20040143488A1 (en) System and method for integration of actual product costs
US20040139035A1 (en) System and method for integration of value-added product costs
Stevens Activity‐based planning and budgeting: The coming of age of the “consumption‐based” approach
WO2004006056A2 (fr) Procede de calcul de la valeur economique creee par une activite commerciale
EP1518203A2 (fr) Procede de calcul de la valeur economique creee par une activite commerciale
JP2006514346A (ja) 企業活動により生じた経済価値を計算するプロセス
Lowry Incentive Regulation for Hydro One Transmission
Altink Cost allocation and customer profitability at TKF, from ABC to CPA
CA2363167A1 (fr) Systeme d'entreposage de donnees

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: 20041216

AK Designated contracting states

Kind code of ref document: A2

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

AX Request for extension of the european patent

Extension state: AL LT LV MK

DAX Request for extension of the european patent (deleted)
RBV Designated contracting states (corrected)

Designated state(s): DE FR GB

A4 Supplementary search report drawn up and despatched

Effective date: 20060804

RIN1 Information on inventor provided before grant (corrected)

Inventor name: GUCKENBERGER, JARED, R.

Inventor name: HEIRES, NEAL, T.

17Q First examination report despatched

Effective date: 20080902

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

Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN

18D Application deemed to be withdrawn

Effective date: 20090113