This invention relates generally to data modeling, and more particularly to modeling of forecasting and production planning data.
A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever. The following notice applies to the software and data as described below and in the drawings hereto: Copyright© 2001, Siebel Systems, Inc., All Rights Reserved.
Forecasts are the foundation of every company's business plans. Accurate forecasts enable a company to maintain appropriate staffing levels, set realistic sales targets, create effective marketing promotion mixes, build budgets that match operating expenses, and keep inventory at the right level to meet, but not exceed, customer demand.
Accurate forecasting must involve a range of activities across different departments within an organization and/or different organizations. For example, in a manufacturing company, the forecasting process may require collaboration among its manufacturing, sales and marketing departments, as well as outside companies such as raw material suppliers, wholesalers, etc. Typically, the approaches to forecasting may vary significantly from company-to-company and division-to-division. While forecasting may only involve a simple query in some companies or divisions, it can be an extensive planning process in other companies or divisions. Forecasting may be very high level in some organizations, and very detailed in other organizations. As a result, forecast data models maintained by different companies and divisions typically support varying levels of detail of the forecast data being stored.
Further, individual companies usually store forecast data in their own unique way. For example, a raw material supplier may organize forecast data in a way that is very different from the way that a manufacturing company may organize forecast data. Even within a single manufacturing company, that company may use many different application programs that employ very different schemas and data models. For example, a demand forecasting program may use a data model that is very different from the data model used by a supply forecasting program. The use of customized data models by a company and by internal applications has the advantage that it allows information to be modeled in a way that is appropriate for the business needs of the company. Unfortunately, because of this diversity in the data models, it is not easy for the company to share its information with other companies or for internal applications to share their information.
Various attempts have been made to define standard data models so that information can be more easily shared between different organizations and applications to allow the consolidation of their disparate forecast processes into a single, comprehensive forecast. However, these data models have not been able to achieve sufficient data integration and simplicity. As a result, existing forecasts are typically inaccurate, ineffectual and difficult to verify.
The present invention relates to various aspects for modeling forecast data.
According to one aspect of the present invention, a forecast class is defined that represents forecasts of different types and identifies relationships of a forecast with various entities related to the forecast.
The present invention will be understood more fully from the detailed description given below and from the accompanying drawings of various embodiments of the invention, which, however, should not be taken to limit the invention to the specific embodiments, but are for explanation and understanding only.
In the following description, numerous details are set forth. It will be apparent, however, to one skilled in the art, that the present invention may be practiced without these specific details. In some instances, well-known structures and devices are shown in block diagram form, rather than in detail, in order to avoid obscuring the present invention.
Some portions of the detailed descriptions which follow are presented in terms of algorithms and symbolic representations of operations on data bits within a computer memory. These algorithmic descriptions and representations are the means used by those skilled in the data processing arts to most effectively convey the substance of their work to others skilled in the art. An algorithm is here, and generally, conceived to be a self-consistent sequence of steps leading to a desired result. The steps are those requiring physical manipulations of physical quantities. Usually, though not necessarily, these quantities take the form of electrical or magnetic signals capable of being stored, transferred, combined, compared, and otherwise manipulated. It has proven convenient at times, principally for reasons of common usage, to refer to these signals as bits, values, elements, symbols, characters, terms, numbers, or the like.
It should be borne in mind, however, that all of these and similar terms are to be associated with the appropriate physical quantities and are merely convenient labels applied to these quantities. Unless specifically stated otherwise as apparent from the following discussion, it is appreciated that throughout the description, discussions utilizing terms such as “processing” or “computing” or “calculating” or “determining” or “displaying” or the like, refer to the action and processes of a computer system, or similar electronic computing device, that manipulates and transforms data represented as physical (electronic) quantities within the computer system's registers and memories into other data similarly represented as physical quantities within the computer system memories or registers or other such information storage, transmission or display devices.
The present invention also relates to apparatus for performing the operations herein. This apparatus may be specially constructed for the required purposes, or it may comprise a general purpose computer selectively activated or reconfigured by a computer program stored in the computer. Such a computer program may be stored in a computer readable storage medium, such as, but is not limited to, any type of disk including floppy disks, optical disks, CD-ROMs, and magnetic-optical disks, read-only memories (ROMs), random access memories (RAMs), EPROMs, EEPROMs, magnetic or optical cards, or any type of media suitable for storing electronic instructions, and each coupled to a computer system bus.
The algorithms and displays presented herein are not inherently related to any particular computer or other apparatus. Various general purpose systems may be used with programs in accordance with the teachings herein, or it may prove convenient to construct more specialized apparatus to perform the required method steps. The required structure for a variety of these systems will appear from the description below. In addition, the present invention is not described with reference to any particular programming language. It will be appreciated that a variety of programming languages may be used to implement the teachings of the invention as described herein.
A machine-readable medium includes any mechanism for storing or transmitting information in a form readable by a machine (e.g., a computer). For example, a machine-readable medium includes read only memory (“ROM”); random access memory (“RAM”); magnetic disk storage media; optical storage media; flash memory devices; electrical, optical, acoustical or other form of propagated signals (e.g., carrier waves, infrared signals, digital signals, etc.); etc.
A data model that provides a common data structure to represent a forecast and allows for customization of the data model in a manner that facilitates upgrading of the data model is described. The term “forecast” refers to various forecasting and planning processes within an organization or across several collaborating organizations. The information that is used in these processes or is generated during these processes is referred to herein as forecast data. The forecasting and planning processes may include, for example, demand forecasting, revenue forecasting, unit forecasting, sales volume planning, production planning, budget planning, etc.
In one embodiment, the data model defines a forecast class that represents forecasts of different types. The different types may include, for example, a demand forecast type and a supply forecast type. A demand forecast may be created by a sales division to predict the demand for a particular product or service and the resulting revenue. A supply forecast may be created by a production division to predict inventory requirements. The sales and production divisions may be parts of the same organization or different organizations. In one embodiment, the forecast class includes a designated data element to store data that indicates whether the elements of the forecast class store data of a specific forecast type (e.g., a demand forecast type or a supply forecast type).
In one embodiment, the forecast data model defines relationships of a forecast with various entities related to the forecast. These entities may include, for example, a related business unit (an organization for which the forecast is created), a forecast planner (an entity creating the forecast), a related product line (a product line or service for which the forecast is created), a related product (a product or service for which the forecast is created), a related account (an organization providing the product or service for which the forecast is created), and a related sales representative (a sales representative of the product or service for which the forecast is created).
In one embodiment, the forecast data model also defines relationships with demand sources for forecasts of the demand type. A demand source may be a business opportunity (e.g., a deal to sell a specific product) or a service request (e.g., a request to provide a specific service).
In one embodiment, the forecast data model associates the forecast with fact data. The fact data may include, for example, the number of units, the unit of measure, the unit price of the product or service for which the forecast is created, the total cost of the product or service for which the forecast is created, the total revenue that is expected to be generated by the product or service, the best case estimate of the revenue, and the worst case estimate of the revenue.
The data model models the relationships as attributes associated with forecast. In one embodiment, the forecast data model is specified using a schema language such as XML Schema.
Based on the relationships defined by the forecast data model, a revenue forecast may be reported by account, product line, product, opportunity, service request, forecast planner, or organization.
In one embodiment, the data model defines a hierarchy of the data elements for describing a forecast. The data model may define data elements that are complex. A complex data element is a data element that comprises data sub-elements. For example, an address data element may be a complex data element that includes street, city, and state data sub-elements. The data model may specify custom data elements at various places within the hierarchy of data elements. A custom data element is of a custom data element type. The custom data element type initially defines no data elements. The data model can be customized by defining custom data elements that are specific to different applications or systems. Because the custom data elements are defined at various places within the hierarchy, the customizations of the data model can be associated with related data elements within the hierarchy.
Thus, the forecast data model provides a common data structure for interfacing forecast data of various divisions within an organization and/or forecast data of an organization and collaborating third parties, while allowing for simplified customization of this data structure by individual companies in accordance with their needs. Hence, the forecast data model allows companies to maintain, support and upgrade only a single data model and facilitates efficient data transformations and mappings.
In one embodiment, the forecast data model 104 defines a hierarchical data structure representing a forecast. This hierarchical data structure includes data elements that are common to all business systems 100. In addition, the hierarchical data structure includes data custom data elements at various levels of the hierarchy to define data fields that are specific to each business system 100, thus providing for easy customization of the forecast data model 104.
In one embodiment, the universal business application network 102 uses the XML and Web services standards.
The transport layer 216 is a mechanism through which business information is exchanged between the business systems 204 and the business integration server 200. Each business system 204 may have an adapter 202 that is appropriate to the protocol of the transport layer. For example, the transport mechanism may use communications protocols such as TCP/IP. The transport layer 216 may provide a messaging service for queuing, for guaranteeing delivery of messages, and for handling both synchronous and asynchronous messaging. The adapters 202 relay events from the business systems 204 to the integration server 200 and can import configurations of the business systems 204 into the integration server 200. In addition, the universal business application network may include encryption and authentication mechanisms to ensure the security and integrity of the information. For example, authentication will help ensure that a business process is accessing the intended business system, rather than an impostor business system.
The integration server 200 stores the representation of a data model 210 (e.g., in an XML schema file) that contains the definition of a forecast class. The forecast class represents forecasts of different types (e.g., demand forecasts and supply forecasts) and defines relationships of a forecast with various related entities.
The transformation store 212 contains a model data definition tool (e.g., an XML schema definition tool) to create a definition of the data model 210 (e.g., in an XML schema file) and to customize the data model 210 when requested by adding custom data fields to the data model 210. The transformation store 212 also contains transformations for transforming information received from the business systems 204 to the format used by the data model 210, and vice versa. The transformations may be specified as a computer program, an XML Stylesheet Language Transform (XSLT), etc.
The business process store 208 contains the business processes that have been defined. A business process may be specified as a script, a process flow, an executable program, etc. In one embodiment, the business processes are defined using the Web Services Flow Language (OOWSFL). The business processes orchestrate a sequence of steps across multiple applications provided by the business systems 204 to achieve a business objective.
The business process controller 206 coordinates the execution of the business processes. The business process controller 206 may instantiate the forecast class and invoke functions of the resulting object in accordance with the various business processes. The business process controller 206 may also initiate the execution of business processes based on predefined conditions and events. For example, the business process controller 206 may launch a certain business process each time an alert is received. Although not shown, the business integration network may provide a standard library of business routines that may be invoked by the business processes. For example, a standard business routine may identify whether a product line and an account are related via a sales representative and create a relationship between the product line and the account if they are related. The integration server 200 may also include various tools to facilitate the development of business processes. These tools may aid in the development of transformations, the defining of classes, and the writing of process flows.
Referring to
Next, processing logic transforms the forecast data into a common format provided by the forecast class (processing block 304). The forecast class represents forecasts of different types (e.g., a demand forecast type and a supply forecast type) and defines relationships of a forecast with various entities related to the forecast. These entities may include, for example, a related business unit (an organization for which the forecast is created), a forecast planner (an entity creating the forecast), a related product line (a product line or service for which the forecast is created), a related product (a product or service for which the forecast is created), a related account (an organization providing the product or service for which the forecast is created), and a related sales representative (a sales representative of the product or service for which the forecast is created). In one embodiment, the forecast data model also defines relationships with demand sources for forecasts of the demand type. A demand source may be an opportunity or a service request. In one embodiment, the forecast data model associates the forecast with fact data. The fact data may include, for example, the unit price of the product or service for which the forecast is created, the total cost of the product or service for which the forecast is created, the total revenue that is expected to be generated by the product or service, the best case estimate of the revenue, and the worst case estimate of the revenue.
Further, processing logic transforms the forecast data from the common format into a format recognizable by the target system (processing block 306) and sends the resulting forecast data to the target system (processing block 308).
Thus, according to the process 300, the sharing of forecast data between two systems does not require data mapping between the data format of the source application and the data format of the target application. Instead, the mapping is performed between each system and the common data model. Furthermore, the process 300 allows various divisions and/or organizations to share the forecast data in a manner that facilitates the consolidation of their disparate forecast processes into a single, comprehensive forecast process.
An exemplary forecast process will now be described to illustrate the operation of a consolidated forecast process. In particular, a front-end forecast application may create a forecast based on revenue data provided by a customer, partner, or sales representative. Based on the forecast data model discussed herein, the revenue may have many associated dimensions, depending on the requirements of the company's forecasting methodology (e.g., the revenue data may reported by product, quantity, unit of measure, account, etc.). In addition, revenue forecasts may be created for sales representatives divisions, organizations, product lines or regions to improve management's ability to make informed business decisions via reports, charts or analysis. Executives may make revisions to the revenue forecasts and then commit the final forecast number. The revisions may be made using historical data that allows the executives to determine trends and create a reasonable projection of expected revenue. In addition, data related to the sales stage of all opportunities in the system may be evaluated to determine how close forecasted deals are to closing and to further assess pipeline coverage and the general health of the opportunity pipeline.
Further, the final forecast data may be exported to the back-end system of the manufacturing division using the process 300 discussed above. The back-end system may receive input of the supply planning team and generate a supply forecast. Then, the demand planning system of the manufacturing division may analyze the revenue forecast received from the front-end system and combine it with the supply forecast generated by the supply planning systems in order to generate the combined forecast. The combined forecast may then be transferred to the front-end system of the sales division using the process 300 discussed above.
Afterwards, the sales and operations planning meeting may be conducted, in which the executives from the sales and manufacturing divisions join together to agree upon a final product forecast, or the “consensus forecast.” This forecast may then be disaggregated by the front-end system and presented to the sales division for use in incentive compensation and quota planning. In addition, the process 300 may be utilized to transfer corresponding portions of the consensus forecast to the marketing system for use in campaign and promotion planning, to the manufacturing division for use in supply planning, and to the financial division for use in budget planning and financial planning.
As discussed above, in one embodiment, each class of the forecast data model can be customized for a specific business system or application.
At processing block 402, processing logic retrieves a data definition schema for the forecast class. The schema may be an XML schema file that include a custom data element of a type that is defined in another file.
At processing block 404, processing logic retrieves the custom data schema for the types of custom data. The schema may be stored in an XML schema file that contains the definition for each type of custom data.
Next, processing logic opens the custom data schema (processing block 406) and locates the tags relating to the custom data type of interest (processing block 408).
Further, processing logic adds the custom data elements to the located tags (processing block 410) and closes the custom data schema with the newly defined data elements (processing block 412).
One embodiment of a common data model representing a forecast will now be described in more detail in conjunction with
The id data element 502 may be a unique identifier of a forecast. The baseData data element 504 contains general information about the forecast as will be discussed in greater detail below in conjunction with
The statusData data element 506 contains information on the status of the forecast (e.g., in progress, archived, etc.). The relatedBusUnit data element 508 specifies an organization for which the forecast is created. The relatedPlanner data element 510 specifies an entity creating the forecast. This entity may be an employee creating the forecast or a division within which the forecast is created. The relatedPlanner data element 510 will be discussed in more detail below in conjunction with
The listOfForecastLineDetail data element 512 contains detail information pertaining to a product line, a product or a service for which the forecast is created, as will be discussed in more detail below in conjunction with
The customData data element 514 initially contains no data elements, but custom data elements can be added by defining data elements in the ForecastCustomDataType.
The date data element 602 specifies the date for which the forecast is created (e.g., the first day of each month or week). The startDate data element 610 specifies the beginning of the date range for the forecast (i.e., the first date for which revenue records are pulled into the forecast). The endDate data element 604 defines the last date of the date range for the forecast. The name data element 606 specifies the forecast name. The periodTypeCode data element 608 defines the periodicity by which the forecast records are totaled at a summary level (e.g., weekly totals, monthly totals or quarterly totals).
The id data element 702 may be a unique identifier of a party. The communicationData data element 704 contains general information on the communication data for a party. The listOfAddress data element 708 contains the addresses of a party. The listOfRelationship data element 710 defines relationships that a party can have with other entities. The customPartyData data element 716 initially contains no data elements, but custom data elements can be added by defining data elements in the PartyCustomData Type. The baseData data element 718 contains general information about the person.
The id data element 802 may contain a unique identifier of a product for which the forecast is created. The baseData data element 804 specifies general information for the product as will be discussed in more detail below in conjunction with
The currencyCode data element 902 specifies a forecast uniform currency code. The date 904 data element indicates the date for which the forecast associated with this product is created. The quantity data element 906 defines the quantity of the product. The unitOfMeasureCode data element 908 specifies the unit of measure for the product quantity (e.g., a uniform unit of measure or a detail unit of measure).
The revenueAmount data element 1008 specifies the total revenue that is expected to be generated by the product. The bestCaseAmount data element 1002 specifies the best case estimate of the revenue. The costAmount data element 1004 specifies the total cost of the product. The productPriceAmount data element 1006 specifies the unit price of the product. The worstCaseAmount data element 1010 specifies the worst case estimate of the revenue.
The id data element 1202 specific a unique identifier of the product. The baseData data element 1204 contains general information about the product. The salesData data element 1206 contains information pertaining to product sales. The configurationData data element 1208 contains information on product configuration. The relatedProductLine data element 1210 specifies the related product line. The listOfPriceType data element 1212 defines the collection of valid price types for this product. The listOfRelatedInvLoc data element 1214 defines a collection of inventory locations that stock this product. The locations may include warehouses or plants. The listOfRelatedProduct data element 1216 defines the list of related products. The listOfRelatedBusUnit data element 1218 contains information on organizations that are authorized to sell this product.
The id data element 1502 may contain a unique identifier of the service request. The baseData data element 1504 contains general information on the service request. The relatedParentArea data element 1506 contains information about the area that triggered the creation of the service request. The relatedRootArea data element 1508 identifies the area of the service. The relatedContract data element 1510 identifies the contract for the performance of the service. The listOfRelatedContract data element 1512 identifies a list of related contracts. The listOfRelatedAccount data element 1514 contains information on the list of related accounts. The listOfRelatedOwner data element 1516 contains information on the list of owners of the service request. The statusData data element 1518 defines the status of the service request. The relatedProduct data element 1520 contains information on the related product. The relatedInstalledProduct data element 1522 contains information on the related installed product. The relatedBusUnit data element 1524 identifies a related business unit. The listOfRelatedActivity data element 1526 contains information on the list of related activities. The customData data element 1528 initially contains no data elements, but custom data elements can be added by defining data elements in the ServiceRequestCustomData Type.
The id data element 1602 may contain a unique identifier of the opportunity. The baseData data element 1604 contains general information on the opportunity. The revenueData data element 1606 defines the revenue associated with the opportunity. The statusData data element 1608 contains information on the status of the opportunity. The listOfNotes data element 1610 specifies notes associated with the opportunity. The listOfActivity data element 1612 specifies activities associated with the opportunity. The listOfAddress data element 1614 specifies the list of addresses associated with the opportunity. The listOfRevenueItem data element 1616 identifies the list of revenue items associated with the opportunity. The relatedParent Opportunity data element 1618 contains information on the parent opportunity. The listOfRelatedContact data element 1620 contains information on the contacts associated with the opportunity. The listOfRelatedAcount data element 1622 identifies accounts (producers and customers) associated with the opportunity. The listOfRelatedSalesConsultant data element 1624 contains information on the sales employees and consultants related to the opportunity. The listOfRelatedSourcePartner data element 1626 contains information on the opportunity source partner or brand owner. The listOfRelatedDestinationPartner data element 1628 contains information on the opportunity target partner. The customData data element 1630 initially contains no data elements, but custom data elements can be added by defining data elements in the OpportunityCustomData Type.
The computer system 1700 includes a processor 1702, a main memory 1704 and a static memory 1706, which communicate with each other via a bus 1708. The computer system 1700 may further include a video display unit 1710 (e.g., a liquid crystal display (LCD) or a cathode ray tube (CRT)). The computer system 1700 also includes an alpha-numeric input device 1712 (e.g., a keyboard), a cursor control device 1714 (e.g., a mouse), a disk drive unit 1716, a signal generation device 1720 (e.g., a speaker) and a network interface device 1722.
The disk drive unit 1716 includes a computer-readable medium 1724 on which is stored a set of instructions (i.e., software) 1726 embodying any one, or all, of the methodologies described above. The software 1726 is also shown to reside, completely or at least partially, within the main memory 1704 and/or within the processor 1702. The software 1726 may further be transmitted or received via the network interface device 1722. For the purposes of this specification, the term “computer-readable medium” shall be taken to include any medium that is capable of storing or encoding a sequence of instructions for execution by the computer and that cause the computer to perform any one of the methodologies of the present invention. The term “computer-readable medium” shall accordingly be taken to included, but not be limited to, solid-state memories, optical and magnetic disks, and carrier wave signals.
Whereas many alterations and modifications of the present invention will no doubt become apparent to a person of ordinary skill in the art after having read the foregoing description, it is to be understood that any particular embodiment shown and described by way of illustration is in no way intended to be considered limiting. Therefore, references to details of various embodiments are not intended to limit the scope of the claims which in themselves recite only those features regarded as essential to the invention.