Patent Application
20150088584
The present invention relates generally to computer automated activity based budget modeling, forecasting and cost accounting, and more particularly, but not exclusively to generating improved object allocation rates.
Businesses that strive to remain viable and successful in today's competitive commercial environment are required to adopt accurate and responsive budgeting practices. To improve efficiency, businesses use financial models that apply modern budgeting, forecasting and cost accounting techniques. For some accounting techniques, the complexity of the financial allocation model may increase as the number of tracked activities and elements increases. Therefore, for larger enterprises, sophisticated computer programs and computers are often required to assist in generating useful and relevant budgets based on financial allocation models.
In some cases, the large number of items and entities required for financial modeling can make development of modeling applications difficult. Further, the size and complexity of modern financial allocation models can make it difficult to design allocation rules for the cost allocations between groups and/or items within the model. Historically, the size and complexity of these financial allocation models have made it difficult to accurately ascertain a total cost of ownership for an offering such as a product and/or service. Thus, it is with respect to these considerations and others that the invention has been made.
Non-limiting and non-exhaustive embodiments of the present invention are described with reference to the following drawings. In the drawings, like reference numerals refer to like parts throughout the various figures unless otherwise specified. For a better understanding of the present invention, reference will be made to the following Description of the Various Embodiments, which is to be read in association with the accompanying drawings, wherein:
The present invention now will be described more fully hereinafter with reference to the accompanying drawings, which form a part hereof, and which show, by way of illustration, specific embodiments by which the invention may be practiced. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art. Among other things, the present invention may be embodied as methods, computers, or devices. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or m embodiment combining software and hardware aspects. The following/detailed description is, therefore, not to betaken in a limiting sense.
Throughout the specification and claims, the following terms take the meanings explicitly associated herein, unless the context clearly dictates otherwise. The phrase “In one of the embodiments” or “in at least one of the various embodiments” as used herein does not necessarily refer to the same embodiment, though it may. Furthermore, the phrase “in another embodiment” as used herein does not necessarily refer to a different embodiment, although it may. Thus, as described below, various embodiments of the invention may be readily combined, without departing from the scope or spirit of the invention.
In addition, as used herein, the term “or” is an inclusive “or” operator, and is equivalent to the term “and/or,” unless the context clearly dictates otherwise. The, term “based on” is not exclusive and allows for being based on additional factors not described, unless the context clearly dictates otherwise. In addition, throughout the specification, the meaning of “a,” “an,” and “the” include plural references. The meaning of “in” includes “in” and “on.”
As used herein, the terms “Financial allocation model,” “data model”, and “cost model” refers to a graph based representation of a system of financial allocation rules that can be used for costing actual expenditures (for management accounting) or budgeting future expenditures. Nodes in the model may represent classes of items that may be associated with costs and/or expenses. The edges of the graph may represent how the costs and/or expenses may be allocated between the nodes. A financial allocation model may be a visual rendering of a graph showing the nodes and the edges connecting the nodes.
As used herein, the terms “Cost line item,” and “line item” refer to a single line item in a budget (or finance allocation model) and its associated cost/expense. For example, the costs associated with a particular computer that is an email server maybe a single item having a particular cost (e.g., the email server may correspond to a cost line item).
As used herein, the term “Category,” refers to a set and/or class of cost line items that may be grouped together. Also, dataset information in fields of a dataset template may be mapped to one or more categories in a category template. For example, a collection of computers performing services such as email, web serving, enterprise resource planning, may represent separate cost line items and they may be grouped into the Servers category.
As used herein, the terms “Allocation rules,” “entity propagation rules,” or “propagation rules” refer to rules in the financial data model that determine how the costs/expenses from a category are allocated between/among other categories. Also, such rules may be assigned to individual cost line items. For example, if an email server cost line item has a value of $1000 an allocation or entity propagation rule may be defined such that 50% of the expense may be allocated to the Marketing department and 50% may be allocated to the Engineering department. Also, allocation rules may be applied at the category as well as the cost line item level.
As used herein, the term “Assignment ratios,” refers to an allocation rule, or the results of applying one or more rules, of the distribution ratio of costs to cost line items or categories. For example, if $1000 may be allocated to Servers category, and the cost line item Email Server is allocated $800 and the cost line item FTP Server is allocation $200, the assignment ratios may be determined to 80% to budget item line Email Server and 20% to cost line item FTP Server. Assignment ratios may be explicitly defined by allocation rules. Or they may be derived from the allocation tables by converting the values into ratios of the total allocation to the category.
As used herein, the terms “business system” and/or “generated business system” refers to a system that has been generated using the budget and forecasting platform. Various embodiments disclosed herein may be related to financial applications. But, one of ordinary skill the art will appreciate that generated business systems are not limited to financial applications.
As used herein, the term “external data source” refers to any separately located system that may enable and/or provide access to one or more datasets of information.
As used herein, the term “dataset” refers to a collection of data, usually presented in tabular form. Each column may represent a particular variable. Each row may represent a given member of the dataset. Also, it may list values for fields for each of the variables, such as name, location, cost, owner, manufacturer, serial number, or the like. Non-tabular datasets can also take the form of marked up strings of characters, such, as an XML file.
As used herein, the term “offering” refers to any service, product, or combination of service(s) and/or product(s) that may be provided by a system.
As used herein, the term “total cost value” refers to a value that is determined for providing at least one offering. A model for determining the total cost value of the at least one offering is based at least on an allocation of cost data to at least one category in a category template.
As used herein, the term “data object” refers to an object in a financial data model that may be providing values (e.g., costs/expenses) that may be allocated to one or more other data objects. In at least one of the various embodiments, data objects may be used to represent one or more categories in a data model in some embodiments, data objects depending on the context, data objects may be source objects, target objects, heritage objects, or the like.
As used herein, the term “source object” refers to an object in a financial data model that may be providing values (e.g., costs/expenses) that may be allocated to one or more other objects (target objects). In at least one of the various embodiments, source objects may be used to represent one or more categories in a data model.
As used herein, the term “target object” refers to an object in a financial data model that may be allocated values (e.g., costs/expenses) from one or more other objects (source objects). In at least one of the various embodiments, target objects may be used to represent one or more categories in a data model.
As used herein, the term “heritage information,” and “heritage costs” refer to allocation information that is associated with one or more data model objects that are below a source object. In at least one of the various embodiments, heritage information that is exposed in a source object is information from one or more of the data objects that may contribute cost information to the source object. Heritage information exposed in a source object may be incorporated in the allocation rules and/or assignment ratios for a target object.
As used herein, the term “heritage object” refers to an object in a financial data model that may be providing and/or exposing heritage information (e.g., costs/expenses) to one or more other objects in the data model.
As used herein, the term “heritage object line item,” refers to a single line item in a heritage object in at least one of the various embodiments, heritage object line items may be selectively exposed/designated to provide heritage information to data model objects.
The following briefly describes the embodiments of the invention in order to provide a basic understanding of some aspects of the invention. This brief description is not intended as an extensive overview. It is not intended to identify key or critical elements, or to delineate or otherwise narrow the scope. Its purpose is merely to present some concepts in a simplified form as a prelude to the more detailed description that is presented later.
Briefly stated, various embodiments are directed towards allocating costs for a plurality of cost objects. In at least one of the various embodiments, a target object, a source object and one or more heritage objects may be determined based on a data model such that the heritage objects may be associated with the source object. In at least one of the various embodiments, at least one line item in the source object may be generated based in part on allocating costs from the heritage objects with the generated source object line items include assignment ratio data from line items from the heritage object.
In at least one of the various embodiments, at least one line item in the target object may be generated based in part on allocating costs from the source object. And, in at least one of the various embodiments, at least one generated target object line item may be based on at least one the generated source object line item and the assignment ratio data. In at least one of the various embodiments, a final cost value for the target object may be generated based on a sum of each target object line item and displayed in the data model.
In at least one of the various embodiments, allocating costs from the source object may further include determining a target object assignment ratio based on a combination of the source object line assignment ratio and the heritage object line item assignment ratio.
In at least one of the various embodiments, a portion of the cost of a target object line item that is contributed from at least one heritage object line item may be displayed as on the data model. In at least one of the various embodiments, heritage objects in the data model may be determined such that heritage information may be propagated to each intervening data object between the source object and the heritage object.
In at least one of the various embodiments, a list of potential heritage objects associated with source object may be displayed such that each potential heritage object may be located (in the model) below the source object. Also, in at least one of the various embodiments, one or more filters may be included in the allocation rules to determine the source object line items and the heritage object line items.
In at least one of the various embodiments, generating at least one line item in the target object, may also include, computing a cost allocated to the generated target object line items may be based on a combination of a heritage information ratio value and a source object line item ratio value, wherein the heritage information ratio value may correspond to the assignment ratio data from a line item of the heritage object.
Generally, client computers 102-104 may include virtually any portable computer capable of receiving and sending a message over a network, such as network 111, wireless network 110, or the like. Client computers 102-104 may also be described generally as client computers that are configured to be portable. Thus, client computers 102-104 may include virtually any portable computer capable of connecting to another computer and receiving information. Such devices include portable devices such as, cellular telephones, smart phones, display pagers, radio frequency (RF) devices, infrared (IR) devices, Personal Digital Assistants (PDA's), handheld computers, laptop computers, wearable computers, tablet computers, integrated devices combining one or more of the preceding devices, computer, or the like. As such, client computers 102-104 typically range widely in terms of capabilities and features. For example, a cell phone may have a numeric keypad and a few lines of monochrome Liquid Crystal Display (LCD) on which only text may be displayed. In another example, a web-enabled mobile computer may have a touch sensitive screen, a stylus, and several lines of color LCD in which both text and graphics may be displayed.
Client computer 101 may include virtually any computer capable of communicating over a network to send and receive information, including messaging, performing various online actions, or the like. The set of such computers may include computers that typically connect using a wired or wireless communications medium such as personal computers, tablet computers, .multiprocessor systems, microprocessor-based or programmable consumer electronics, network Personal Computers (PCs), or the like. In at least one of the various embodiments, at least some of client computers 102-104 may operate over wired and/or wireless network. Today, many of these computers include a capability to access and/or otherwise communicate over a network such as network 111 and/or wireless network 110. Moreover, client-computers 102-104 may access various computing applications, including a browser, or other web-based application.
In at least one of the various embodiments, one or more of client computers 101-104 may be configured to operate within a business or other entity to perform a variety of services for the business or other entity. For example, client computers 101-104 may be configured to operate as a web server, an accounting server, a production server, an email server, video game server, an inventory server, or the like. However, client computers 101-104 are not constrained to these services and may also be employed, for example, as an end-user computing node, in other embodiments. Further, it should be recognized that more or less client computers may be included within a system such as described herein, and embodiments are therefore not constrained by the number or type of client computers employed.
A web-enabled client computer may include a browser application that is configured to receive and to send web pages, web-based messages, or the like. The browser application may be configured to receive and display graphics, text, multimedia, or the like, employing virtually any web-based language. Including a wireless application protocol messages (WAP), or the like. In at least one of the various embodiments, the browser application is enabled to employ Handheld Device Markup Language (HDML), Wireless Markup Language (WML), WMLScript, JavaScript, Standard Generalized Markup Language (SGML), HyperText Markup Language (HTML), extensible Markup Language (XML), HTML5, or the like, to display and send a message. In at least one of the various embodiments, a user of the client computer may employ the browser application to perform various actions over a network.
Client computers 101-104 also may include at least one other client application that is configured to receive and/or send data, including budgeting and forecasting information, between another computer. Client applications may include a capability to provide requests and/or receive data relating to the cost models, budget reports, budget project information, allocation rules, or the like. The client application may provide data representing assignment and/or allocation changes, selecting templates, editing cost allocations between or among categories, activating heritage information, or the like. In at least one of the various embodiments, client applications may receive and/or generate data related to budgeting and financial models and may generate tables and relationships between and among the data. In at least one of the various embodiments, client computers 101-104 may view and/or modify generated data models.
Wireless network 110 is configured to couple client computers 102-104 and its components with network 111. Wireless network 110 may include any of a variety of wireless sub-networks that may further overlay stand-alone ad-hoc networks, or the like, to provide an infrastructure-oriented connection for client computers 102-104. Such sub-networks may include mesh networks, Wireless LAN (WLAN) networks, cellular networks, or the like.
Wireless network 110 may further include an autonomous system of terminals, gateways, routers, or the like connected by wireless radio links, or the like. These connectors may be configured to move freely and randomly and organize themselves arbitrarily, such that the topology of wireless network 110 may change rapidly.
Wireless network 110 may further employ a plurality of access technologies including 2nd (2G), 3rd (3G), 4th (4G), 5th (5G) generation radio access for cellular systems, WLAN, Wireless Router (WR) mesh, or the like. Access technologies such as 2G, 3G, 4G, 5G, and future access networks may enable wide area coverage for mobile computers, such as client computers 102-104 with various degrees of mobility. For example, wireless network 110 may enable a radio connection through a radio network access such as Global System for Mobil communication (GSM), General Packet Radio Services (GPRS), Enhanced Data GSM Environment (EDGE), Wideband Code Division Multiple Access (WCDMA), High Speed Downlink Packet Access (HSDPA), Long Term Evolution (LIE), or the like. In essence, wireless network 110 may include virtually any wireless communication mechanism by which information may travel between client computers 102-104 and another computer, network, or the like.
Network 111 is configured to couple network computers with other computers, including, BFP 107, client computer(s) 101, and through wireless network 110 to client computers 102-104. Network 111 is enabled to employ any form of computer readable media for communicating information from one electronic device to another. Also, network 111 can include the Internet in addition to local area networks (LANs), wide area networks (WANs), direct connections, such as through a universal serial bus (USB) port, other forms of computer-readable media, or any combination thereof. On an interconnected set of LANs, including those based on differing architectures and protocols, a router acts as a link between LANs, enabling messages to be sent from one to another. In addition, communication links within LANs typically include twisted wire pair or coaxial cable, while communication links between networks may utilize analog telephone lines, foil or fractional dedicated digital lines including T1, T2S T3, and T4, Integrated Services Digital Networks (ISDNs), Digital Subscriber Lines (DSLs), wireless links including satellite links, or other communications links known to those skilled in the art. For example, various Internet Protocols (IP), Open Systems Interconnection (OSI) architectures, and/or other communication protocols, architectures, models, and/or standards, may also be employed within network 111 and wireless network 110. Furthermore, remote computers and other related electronic devices could be remotely connected to either LANs or WANs via a modem and temporary telephone link. In essence, network 111 includes any communication method by which information may travel between computers.
Additionally, communication media typically embodies computer-readable instructions, data structures, program modules, or other transport mechanism and includes any information delivery media. By way of example, communication media includes wired media such as twisted pair, coaxial cable, fiber optics, wave guides, and other wired media and wireless media such as acoustic, RF, infrared, and other wireless media. Such communication media is distinct from, however, processor-readable storage devices described in more detail below.
BFP 107 may include virtually any network computer usable to perform data processing operation that may be used for generating cost models, data models, allocation rules, recursive allocation rules, cost allocations, heritage information, total cost values for offerings, displays and/or reports thereof such as network computer 200 of
Computers that may operate as BFP 10 include various network computers, including, but not limited to personal computers, desktop computers, multiprocessor systems, microprocessor-based or programmable consumer electronics, network PCs, server computers, tablet computers, network, appliances, or the like. It should be noted that while BFP 107 is illustrated as a single network computer, the invention is not so limited. Thus, in another embodiment, BFP 107 may represent a plurality of network computers. For example, in at least one of the various embodiments, BFP 107 may be distributed over a plurality of network computers and/or implemented using cloud architecture.
Moreover, BFP 107 is not limited to a particular configuration. Rather, BFP 107 may operate using a controller/worker approach over a plurality of network computers, within a cluster, a peer-to-peer architecture, cloud-based architecture (e.g., virtual machines), and/or any of a variety of other architectures. Thus, BFP 107 is not to be construed as being limited to a single environment, and other configurations, and architectures are also envisaged. BFP 107 may employ processes and such as described below in conjunction with
As shown in the figure, client computer 200 includes a central processing unit (“CPU”) 202 in communication with a mass memory 226 via a bus 234. Client computer 200 also includes a power supply 228, one or more network interfaces 236, an audio interface 238, a display 240, a keypad 242, and an input/output interface 248. Power supply 228 provides power to client computer 200. A rechargeable or non-rechargeable battery may be used to provide power. The power may also be provided by an external power source, such as an AC adapter or a powered docking cradle that supplements and/or recharges a battery.
Client computer 200 may optionally communicate with a base station (not shown), or directly with another computer. Network interface 236 includes circuitry for coupling client computer 200 to one or more networks, and is constructed for use with one or more communication protocols and technologies, including, but not limited to, global system for mobile communication (“GSM”), code division multiple access (“CDMA”), time division multiple access (“TDMA”), LTE, HSDPA, user datagram protocol (“UDP”), transmission control protocol/internet protocol (“TCP/IP”), short message service (“SMS”), general packet radio service (“GPRS”), WAP, ultra wide band (“UWB”), IEEE 802.16 Worldwide Interoperability for Microwave Access (“WiMax”), session initiated protocol/real-time transport protocol (“SIP/RTP”), or any of a variety of other wireless communication protocols. Network interface 236 is sometimes known as a transceiver, transceiving device, or network interface card (“NIC”).
Audio interface 238 may be arranged to produce and receive audio signals such as the sound of a human voice. For example, audio interface 238 may be coupled to a speaker and microphone (not shown) to enable, telecommunication with others and/or generate an audio acknowledgement for some action. Display 240 may be a liquid crystal display (“LCD”), gas plasma, light emitting diode (“LED”), organic LED, electronic ink, or any other type of display used with a computer. Display 240 may also include a touch sensitive screen arranged to receive input from an object such as a stylus or a digit from a human hand.
Keypad 242 may comprise any input device arranged to receive input from a user. For example, keypad 242 may include a push button numeric dial, or a keyboard. Keypad 242 may also include command buttons that are associated with selecting and sending images.
Client computer 200 also comprises input/output interface 248 for communicating with external devices, such as a headset, or other input or output devices not shown in
Mass memory 226 includes a Random Access Memory (“RAM”) 204, a Read-only Memory (“ROM”) 222, and other storage means. Mass memory 226 illustrates an example of computer readable storage media (devices) for storage of information such as computer readable instructions, data structures, program modules or other data. Mass memory 226 stores a basic input/output system (“BIOS”) 224 for controlling low-level operation of client computer 200. The mass memory also stores an operating system 206 for controlling the operation of client computer 200. It will be appreciated that this component may include a general-purpose operating system such as a version of UNIX, or LINUX™, or a specialized client communication operating system such as Windows Mobile™, Google Android™, Apple iOS™, or the Symbian® operating system. The operating system may include, or interface with a Java virtual machine module that enables control of hardware components and/or operating system operations via Java application programs.
Mass memory 226 further includes one or more data storage 208, which can be utilized by client computer 200 to store, among other things, applications 214 and/or other data. For example, data storage 208 may also be employed to store information that describes various capabilities of client computer 200. The information may then be provided to another computer based on a variety of events, including being sent as part of a header during a communication, sent upon request, or the like. At least a portion of the information may also be stored on a disk drive or other computer-readable storage device (not shown) within client computer 200. Further, as illustrated, data storage 208 may also financial data 210. In some embodiments, financial data 210 may include a database, text, spreadsheet, folder, file, or the like, that may be configured to maintain and store various budget, data, allocation rules, recursive allocation rules, audit logs, dataset templates, category-templates, datasets, heritage information, or the like. Such financial data 210 may also be stored within any of a variety of other computer-readable storage devices, including, but not limited to a hard drive, a portable storage device, or the like, such as illustrated by non-transitory computer-readable storage device 230. In yet other embodiments, data storage 208 may also store data associated with cost data models that may be generated in part by BFP 107.
Applications 214 may include computer executable instructions which, when executed by client computer 200, transmit, receive, and/or otherwise process network data. Examples of application programs include, but are not limited to calendars, search programs, email clients, IM applications, SMS applications, voice over Internet Protocol (“VOIP”) applications, contact managers, task managers, transcoders, database programs, word processing programs, security applications, spreadsheet programs, games, search programs, and so forth. Applications 214 may include, for example, browser 218 and budget and forecasting client application 220.
Browser 218 may include virtually any application configured to receive and display graphics, text, multimedia, and the like, employing virtually any web based language. In at least one of the various embodiments, the browser application is enabled to employ HDML, WML, WMLScript, JavaScript, SGML, HTML, XML, and the like, to display and send a message. However, any of a variety of other web-based languages may be employed. In one embodiment, browser 218 may enable a user of client computer 200 to communicate with another network computer, such as BFP 107 of
In at least one of the various embodiments, a user may employ client computer 200 to manage budgeting and finance applications, and to access information stored or otherwise managed through BFP 107. Also, in at least one of the various embodiments, the user may be enabled to perform a variety of actions on the data, including, queries, comparisons, summations, analysis, or the like. Additionally, in at least one of the various embodiments, a user may employ client 200 to automate one or more processes that may be used for generating business systems, cost models, budget projects, or the like. In at least one of the various embodiments, budget and forecasting client application 220 may be arranged to enable a user to rapidly generate business systems that include allocation rules, recursive allocation rules, cost values, cost models, data models, heritage information, or the like. In at least one of the various embodiments, application 220 may be arranged to generate and render visualizations and display reports of allocation rules among cost categories in a cost model.
In any event, budget and forecasting client application 220 may employ processes similar to those described below and illustrated in
Network computer 300 includes processing unit 312, video display adapter 314, and a mass memory, all in communication with each other via bus 322. The mass memory generally includes RAM 316. ROM 332, and one or more permanent mass storage devices, such as hard disk drive 328, tape drive, optical drive, flash drive, and/or floppy disk drive that may be coupled to a processor such as CPU 312. The mass memory stores operating system 320 for controlling the operation of network computer 300. Any general-purpose operating system may be employed. Basic input/output system (“BIOS”) 318 is also provided for controlling the low-level operation of network computer 300. As illustrated in
The mass memory as described above illustrates another type of processor readable storage media. Processor-readable storage media (devices) may include volatile, nonvolatile, removable, and non-removable media implemented in any method, or technology for storage of information, such as computer readable instructions, data structures, program modules, or other data. Examples of computer readable storage media include RAM, ROM, Electronically Erasable Programmable Read-Only Memory (EEPROM), flash memory or other memory technology, Compact Disc Read-Only Memory (CD-ROM), digital versatile disks (DVD), Blu-Ray, or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other physical medium which can be used to store the desired information and which can be accessed by any computer.
As shown, data stores 352 may include a database, text, spreadsheet, folder, file, or the like, that may be configured to maintain and store various cost models, budget data, audit logs, device data, such as, allocation rules 354, data models 356, datasets 358, or the like. In at least one of the various embodiments, data stores 352 may former include program code, data, algorithms, or the like, for use by a processor, such as central processing unit (CPU) 312 to execute and perform actions. In at least one of the various embodiments, at least some of data and/or instructions stored in data stores 352 might also be stored on another computer of network computer 300, including, but not limited to cd-rom/dvd-rom 326, hard disk drive 328, or other computer-readable storage device resident on network computer 300 or accessible by network computer 300 over, for example, network interface unit 310.
The mass memory also stores program code and data. One or more applications 350 are loaded into mass memory and run on operating system 320. Examples of application programs may include transcoders, schedulers, calendars, database programs, word processing programs, Hypertext Transfer Protocol (HTTP) programs, customizable user interface programs, IPSec applications, encryption programs, security programs, SMS message servers, IM message servers, email servers, account managers, and so forth. Mass memory may also include allocation rules 354, web services 366, data models 356, datasets 358, budget and forecasting application 360, allocation application 364, heritage allocations rules 362, or the like.
Web services 366 represent any of a variety of services that may be configured to provide content, over a network to another computer. Thus, web services 366 include for example, a web server, a File Transfer Protocol (FTP) server, a database server, a content server, or the like. Web services 366 may provide the content over the network using any of a variety of formats, including, but not limited to WAP, HDML, WML, SGML, HTML, XML, compact HTML (cHTML), extensible (xHTML), or the like.
In at least one of the various embodiments, budget and forecasting application 360 may enable a user to generate budgets, allocation rules, recursive allocation, data model, cost models, total cost values for offerings, reports, heritage information, or the like. Also in at least one of the various embodiments, budget and forecasting application 360, and/or allocation application 364 may employ processes, or parts of processes, similar to those described below and shown in
In at least one of the various embodiments, in model 400, labor 404 may be allocated 39% of costs, fixed assets 28% of costs, and the remaining 33% may be allocated to a mapping component In at least one of the various embodiments, based on a selected category template, the costs allocated to mapping component 406 may be allocated to the various cost categories that may make up the business system being model.
In at least one of the various embodiments, model 400 shows that 100% of costs flow to IT resource tower 410. From IT resource tower 410 costs flow to services 412. Thus, for this business system, model 400 shows that all the costs are allocated to producing the service offerings that the modeled business organization provides.
In at least one of the various embodiments, the budget and forecasting application may further enable users to gain additional understanding of how the costs from cost source 402 flow through the entire system. Model 400 shows that storage device 414 is responsible for 2.5% for the costs coming from cost source 402. And, that 100% of the costs of storage device 414 flows into the general category of for storage, shown by the allocation trace that shows of 100% of flowing from the storage device 414 to storage component 416. Likewise, model 400 shows that physical servers 420 are burdened by 100% of the costs of storage 416. And, since the business organization modeled by model 400 includes hypervisors that run on physical servers, the costs associate with hypervisor 418 flow from physical server 420. In at least one of the various embodiments, cost for the server category, servers 422 is constituted out of physical servers 420 and hypervisors 418, thus the costs for server 422 flow from those components. Further the applications 424 component of the model may be burdened with 100% of the costs associated with servers 422. Completing the loop, allocation rule 426 shows that service component 412 may be burdened with 100% of the costs associate with applications 424.
In at least one of the various embodiments, other types of raw datasets may be provided by other external data sources to budget and forecasting platform 107. For example, datasets that include information about physical IT assets, fixed assets, software licenses, employees, labor costs, insurance records, vendor costs, utility costs (electricity, water, sewer, broadband, natural gas, oil, or the like), consulting expenses, legal fees, or the like.
In at least one of the various embodiments, the model 600 may have five categories: GL 602, Servers 604, Storage 610, Support 612, and Business Units 616. In at least one of the various embodiments, each category contains a set of cost line items. For example, GL 602 includes cost line items for Payroll, Taxes and Rent. Likewise, Support 612 includes cost line items Email, Printers, Telephone, and Parking. In at least one of the various embodiments, each cost line item has one or more associated cost values. For example, Storage 610 has two cost line items, D1, and D2 (e.g., disk drives) having associated cost values of $1000 each.
Allocation rules may used to connect categories and/or objects of model 600. In at least one of the various embodiments, allocation rules may show how costs (money) flow between the categories. Resulting in a graph where the categories may be represented as nodes and the allocation rules may be represented as edges. In at least one of the various embodiments, generally a model may be represented by a directed acyclic graph but that is not a requirement for an operative model. In at least one of the various embodiments, a model graph may contain cycles that are resolved or estimated using mathematical techniques, including but not limited to Gaussian elimination, Cholesky decomposition or Newton's method.
In at least one of the various embodiments, allocation rule 606 represents a rule allocating 20% of the money in category GL 602 (source object) to Servers category 604 (target object). In this example, GL 602 includes a total of $20,000, thus 20% of $20,000 (e.g., $4,000) flows based on allocation rule 606 to Servers 604. Likewise, allocation rule 608 may allocate $2,000 from GL 602 to Storage 610. The other allocation rules in model 600 allocate 100% of the money to the next category: allocation rule 612 directs 100% of the money (e.g., $4,000) to flow to Support 614; allocation rule 618 directs 100% of the money in Support (e.g., $4,000) to flow to Business Units 620; and allocation rule 616 directs 100% of the money from Storage 610 to flow to Business Units 620.
In at least one of the various embodiments, money that flows into the category may be allocated among the included cost line items. In at least one of the various embodiments, each category may have one or more rules that may describe the assignment ratios for how the money in a category may be-assigned to cost line items. For the categories 604, 610, 612, and 618, simple allocation rules assign the money in the category evenly among the cost line items comprising each category. GL 602 may have different assignment ratios, in this non-limiting example, the assignment ratio between the cost line items may be 50% to Payroll, 25% to Taxes, and 25% to Rent.
In at least one of the various embodiments, an assignment ratio may represent how the money in an actual budget may be assigned to the actual cost line items. In at least one of the various embodiments, rules may be applied that distribute the money based on formulas that may be defined by the users or administrators who designed the model. In at least one of the various embodiments, the assignment ratios and allocations may be modified as part of the modeling process.
The model 600 is a simplified model useful for facilitating discussion and understanding of the embodiments, since allocation rules for models of large commercial entities can be numerous and complex. However, model 600 is at least sufficient to enable one of ordinary skill in the art to practice what is claimed herein.
In at least one of the various embodiments, the details of how costs may be allocated from one object in the model to another may be encapsulated in one or more allocation rules. In at least one of the various embodiments, allocation rules may generate one or more assignment ratio tables that describe how cost values flow between the modeled objects. Allocation rules 704, 708, and 712 are illustrated in the form of assignment ratio tables. In some embodiments, the allocation rule may define how an assignment ratio table may be arranged.
In at least one of the various embodiments, an assignment ratio table may be arranged to include one or more columns of information, such as, source object line item 716, target object line item 718, assignment ratio 720, allocation value 722, source value 724, or the like. In this example, the entries in the source object line item column 716 correspond to the line items in GL object 702. Namely, A100 and A200 (e.g., representing account names from a chart-of-accounts). Also, file entries in target object line item column 718 correspond to the line items comprising server object 706 (e.g, S1, S2, and S3). The next column, assignment ratio column 720, contains a value for computing how much money flows from the source object line item to the target object line item. In this example, allocation rule 704 reflects that the money from A100 is evenly divided between servers S1 and S2. Likewise, one-third (0.33) of the money from A200 is allocated to server S1, server S2, and server S3. Column 722 in allocation rule 704 assignment ratio table shows the amount of money that flows from the source object line item to the target item. And column 724 shows the amount of money that the source object line item starts with. For example, based on GL object 702, A100 starts with $200 and A200 starts with $120. Thus, since the assignment ratio for A200 is one-third to each server, each server is allocated $40 from A200. Further, since, in this example, S3 is not allocated any money from A100, S1 and S2 split the $200 evenly. In at least one of the various embodiments, the values in server object 706 show the costs that were allocated to each server. Similarly, the remaining objects in model 700 may be allocated costs based on their respective allocation rules.
In at least one of the various embodiments, the underlying reasons for employing a particular allocation rule may depend on the objects that are being modeled. For example, in model 700, account A100 is modeled as a line item in GL object 702 and it may represent the cost of operating system software licenses. And A200, also modeled as a line item in GL object 702, may represent the cost of electricity. In this example, referring to Server object 706, it is shown that line items S1 and S2 represent servers using a commercial operating systems that are subject to license fees, while line item S3 represents a server using an open source operating system with no license fees. Thus, S1 and S2 are allocated portions of the operation system licensing fee (A100) while S3 is not. However, in this example, all three servers use electricity so the costs from A200 are spread evenly across all three servers. Likewise, in at least one of the various embodiments, the example allocation rule 708 reflects that in model 700, S1 and S2 are located in Seattle (SEA), and S3 is located in Chicago (CHI). Further, in this example, allocation rule 712 represents that the costs for product W1 and product W2 are evenly divided between Seattle and Chicago.
In at least one of the various embodiments, it may be advantageous for a data model to be arranged to report additional details regarding to origins of the money allocated to a line item. For example, model 700 shows that of the original $320 in the model $160 was allocated for producing product W1 and $160 was allocated for producing W2. (See, product object 714). However, model 700 as arranged, cannot easily answer the question of how much of the expense of product W1 may be attributed to server S1. At least one reason this may be difficulty is that product object 714 is allocated money from location object 710 yet it does not have visibility the details relating to how the server line items in server object 706 contribute money to the different location line items in location object 710.
One of ordinary skill in the art will appreciate that allocation rules 704, 708, and 712 are non-limiting examples, and that real-life data models may include arbitrarily complex allocation rules that may include arbitrarily complex formulas for generating assignment ratio tables and mapping costs and/or values between model objects. However, the allocation rules illustrated in herein are sufficient to at least describe, enable, and disclose at least the innovations contained in this application.
In at least one of the various embodiments, allocation rule 800 is an example of an allocation rule that includes an assignment ratio table that may have various columns for including heritage information. Column 802 may indicate the target object line items (by name); column 804 may indicate a heritage object line item (by name); column 806 may indicate source object line items (by name); column 808 may include assignment ratio information for the heritage information line items; column 810 may include the assignment ratio information for the target object line items; column 812 may include the value that was allocated based on the assignment ratios; column 814 may include the original cost for the heritage object line item (rather than the cost of the source object line item).
In at least one of the various embodiments, in this example, row 816 may be assignment ratio data that may be employed to determine that server S1 contributes $70 to the costs of W1, where, the product of the line 816 column 808 and line 816 column 810 and line 816 column 814 produces $70.
To further clarify using assignment ratio table row 816 of this example, the value in column HI 804 (“S1”) represents the S1 line item from server object 706 (the heritage object in this example). Likewise, the value in column Source 806 (SEA) represents the SEA line item horn location object 710 (the source object in this example); the value in column HIRV 808 represents the assignment ratio value for allocating costs from S1 in server object 706 to line item. SEA in location object 710. Here, HIRV may be determined from the assignment ratio table in Servers-to-Location allocation rule 708 where it defines that all of S1 costs are allocated to SEA ($140); column RV 810 in row 816 defines how costs from source object line item SEA are allocated to product W1. In this example, the RV is the same as it was defined in allocation rule 712 of
In this example, including the heritage information associated with location object 710 does not change to total value of costs allocation to W1, it remains $160. But it enables the data model to clearly illustrate that $70 of the total costs of W1 is coming from S1. This result would be obscured absent the heritage information being applied to model.
One of ordinary skill in the art will appreciate that allocation rule 800 is a non-limiting example, and that real-life data models may include arbitrarily complex allocation rules that may include arbitrarily complex formulas for generating assignment ratio tables and mapping costs and/or values between model objects. However, allocation rule 800 as illustrated in herein are sufficient to at least describe, enable, and disclose at least the innovations contained in this application.
At decision block 904, in at least one of the various embodiments, if heritage information is being used for fee current allocation rule, control may flow to block 906. Otherwise, in at least one of the various embodiments, control may flow block 910.
In at least one of the various embodiments, determining if heritage information may be used for a particular target object may be based on policy based rules, configuration values, or the like, some of which may comprise a business system template. Also, in at least one of the various embodiments, the use of heritage information may be determined based on direct user input.
At block 906, in at least one of the various embodiments, a list of heritage objects and/or heritage object line items may be determined from the source object. In at least one of the various embodiments, there may be one or more objects in the model that may be able to provide heritage information for a source object. In at least one of the various embodiments, objects below a source object may be indicated as having the potential to provide heritage information. In at least one of the various embodiments, objects that allocate costs to the source object may be eligible for providing heritage information for allocation rules that allocate values from the source object to the target object. In at least one of the various embodiments, heritage objects may include one or more heritage object line items that may allocate values to a source object line item.
At block 908, in at least one of the various embodiments, one or more active heritage objects may be determined. One or more objects in the model may be determined to be eligible heritage objects. However, in at least one of the various embodiments, even though an object may be eligible to provide heritage information, it may be omitted from the set of active heritage objects.
In at least one of the various embodiments, active heritage objects may be determined based on filters, policy based rules, configuration values, or the like, some of which may comprise a business system template. Also, in at least one of the various embodiments, the selection of active heritage objects may be determined based on direct user input. In at least one of the various embodiments, a list of potential heritage objects that may be associated with the source object. The list of potential heritage objects may include one or more data objects (potential heritage objects) located in the data model below the source object. For example, in at least one of the various embodiments, a user may click a user-interface button that may cause the display of selection list that may be populated with the eligible data objects.
In at least one of the various embodiments, since heritage objects may comprise one or more line items, the set of heritage object line items used for providing heritage information may be selected from among them. In at least one of the various embodiments, some or all of the heritage object line items may be selected using filters, policy based rules, configuration values, or the like.
Likewise, in at least one of the various embodiments, if a heritage object comprises more than one column, the one or more columns from the heritage object may be selectively determined to provide heritage information to the source object. In at least one of the various embodiments, the determination of heritage object line items used to provide heritage information may be based on filters, policy based rules, configuration values, or the like, some of which may comprise a business system template. Also, in at least one of the various embodiments, the selection of active heritage lines may be determined based on direct user input (e.g., a select list as described above).
At block 910, in at least one of the various embodiments, the values from the source object may be allocated to the target object based on an allocation rule between the source object and the target object. In at least one of the various embodiments. If an allocation rule that allocates values from the source object to the target object is configured to include heritage information, the assignment ratio data from data objects that are below the source object (e.g., objects in the model that allocate value to the source object) may be made available for generating reports and analysis relating to the target object. In at least one of the various embodiments, a final cost value for the target object may be generated based on a sum of each generated target object line item such that the final cost value may be included in the model and/or displayable in the model.
In at least one of the various embodiments, heritage objects further removed from the source object may be selected and/or determined such that there may be other data objects intervening between the source object and the determined heritage object. In at least one of the various embodiments, in this case, heritage information from the heritage object may be chained by propagating the heritage information to each intervening data object between the source object and the determined heritage object. In at least one of the various embodiments, the heritage information may be propagated to each chained data object by repeating the method described in
Further, in at least one of the various embodiments, identifiers and/or references to the source object and target object sufficient for locating and if necessary retrieving the data of the source object and target may be provided. In some embodiments, each objector of portion of each object may be provided directly to process 1000.
In at least one of the various embodiments, the target object and the source object may be determined based on the data model.
At block 1004, in at least one of the various embodiments, a set of line items in the target object may be determined. In at least one of the various embodiments, the target object may include one or more line items. For example, Product object 714, in
In at least one of the various embodiments, each determined target object line item may be iterated over and processed individually. Further, in at least one of the various embodiments, one or more lines items may be processed in parallel and/or concurrently.
In some embodiments, the allocation rule that is operative between the source object and the target object may include instruction that determine which of the line items in the target object may be used. This determination may be based on filters that may be included as part of the allocation rule. In at least one of the various embodiments, the filters may be employed to select and/or exclude line items based on matching rules (e.g., regular expressions), lists, value thresholds (e.g., exclude line items having values of less than a defined value), or the like, or combination thereof.
At block 1006, in at least one of the various embodiments, a set of line items in the source object may be determined. In at least one of the various embodiments, the source object may include one or more line items. For example, Location object 710, in
In at least one of the various embodiments, it may not be necessary to iterate over each line item in the source object. In some embodiments, the allocation rule that is in effect between the source object and the target object may include instructions that determine which of the line items in the source object are used. In at least one of the various embodiments, filters may be employed to determine which source object line items to include by selecting and/or excluding line items based on matching rules (e.g., regular expressions), lists, value thresholds (e.g., exclude line items having values of less than a defined value), or the like, or combination thereof.
In at least one of the various embodiments, the allocation rule may include instructions for determining if a source object line item may be employed to provide heritage information. These instructions may be filter based, or, in at least one of the various embodiments, direct user intervention may be used to select the source object line item. In any case, the allocation rule may include instructions that can be employed to determine if a particular source object line item should use heritage information and, if so, what information to use. In at least one of the various embodiments, a filter may be defined such that it excludes some heritage object line items from being provided to the source object. Filters may be employed to determine which heritage object line items to include by selecting and/or excluding line items based on matching rules (e.g., regular expressions), lists, value thresholds (e.g., exclude line items having values of less than a defined value), or the like, or combination thereof
For example, in at least one of the various embodiments, if product object 714 is the target object and location object 710 is the source object, a filter that excluded heritage assignment ratio data related to the source object line item of SEA from location object 710 would result in an allocation rule that may be similar to allocation rule 800 in
At decision block 1008, in at least one of the various embodiments, if the source object line item is associated with heritage information, control may flow to block 1012. Otherwise, in at least one of the various embodiments, control may flow to block 1010.
At block 1010, in at least one of the various embodiments, assignment ratio data for the source object line item may be generated. In at least one of the various embodiments, if, based on the allocation rule, heritage information is not indicated for the current source object line item, the source item may be processed normally. Thus, in at least one of the various embodiments, assignment ratio data for the source object to the target object (absent heritage information) may be generated and applied to the model.
At block 1012, in at least one of the various embodiments, assignment ratio data for each heritage object line item for the source item may be generated. In at least one of the various embodiments, there may be one or more heritage object line items that may be associated with single source object line item. In some embodiments, assignment ratio data for each heritage object line item may be generated and included the allocation rule for the source object.
In at least one of the various embodiments, the assignment ratio data associated with a heritage object line item may include the cost value from the heritage object and the assignment ratio value from the heritage object line item. In at least one of the various embodiments, this assignment ratio data may include assignment ratio data defining the allocation of one or more costs from the heritage object to the source object. The assignment ratio data may be carried forward from the heritage object line item so it may be combined with the assignment ratio data from the source object to the target object. (See,
In at least one of the various embodiments, generating assignment ratio data for each heritage object line item for each source object line item may generate additional records in an assignment ratio table for an allocation rule. However, these additional records may enable the data model to be employed to generate reports on how heritage information may be related to the target object and/or target object line items. In at least one of the various embodiments, a portion of a cost of the generated target object line item that is contributed from one or more heritage object line items may be displayed. Further, in at least one of the various embodiments, a final cost value for the target object may be generated based on a sum of each generated target object line item such that the final cost value may be included in the model and/or displayable in the model.
At decision block 1014, in at least one of the various embodiments, if there are more target object line items in the target object, control may loop back block 1004. Otherwise, in at least one of the various embodiments, control may be returned a calling process.
It will be understood that figures, and combinations of actions in the flowchart-like illustrations, can be implemented by computer program instructions. These program instructions may be provided to a processor to produce a machine, such that the instructions executing on the processor create a means for implementing the actions specified in the flowchart blocks. The computer program instructions may be executed by a processor to cause a series of operational actions to be performed by the processor to produce a computer implemented process for implementing the actions specified in the flowchart block or blocks. These program instructions may be stored on some type of machine readable storage media, such as processor readable non-transitive storage media, or the like.
Furthermore, in at least one of the various embodiments, the actions specified in one or more blocks may be performed concurrently if appropriate and/or if enabled by the underlying hardware and computer processor.
