The present invention relates generally to the field of systems for and methods of processing purchase orders. More particularly, the present invention relates to systems for and methods of controlling a budget for purchase orders by allowing for different budget definitions for different processes.
One particular business that processes purchase orders is the retail business. Operations for a business often include purchasing merchandise from a supplier for sale to customers or for use in the processes and products for the business. Generally, purchasing merchandise or supplies from the supplier involves sending a purchase order to the supplier requesting a specific number of items for a specific price. The number of items multiplied by the price of the items provides a total cost associated with the purchase order. Prior to sending the purchase order, the purchase order may need to be approved by an entity, such as a budgeting department. The entity may apply one or more rules, or checks, to the purchase order in determining whether to approve the purchase order. For example, a rule may dictate that the approval is granted or denied based on whether incurring the total cost of the purchase order is acceptable in view of budget constraints. Accordingly, the purchase order is approved or rejected based on budget constraints prior to being sent to the supplier.
In retail selling, budgets are typically allocated according to a predetermined criteria, such as a year. In this regard, a budget may be allocated according to a particular category of products, for example. However, such an allocation may be inappropriate for other users.
An advantageous purchase order system should provide increased flexibility to allow users to develop budgets according to specific needs.
One embodiment of the invention relates to a method of budgeting in a purchase order system. The method includes allocating a budget according to one or more planning levels and selecting or defining one or more keys, each key corresponding to one or more planning levels.
Another embodiment of the invention relates to a program product for budgeting in a purchase order system comprising machine-readable program code for causing, when executed, one or more machines to perform the following method steps: allocating a budget according to one or more planning levels, and selecting or defining one or more keys, each key corresponding to one or more planning levels.
Other features and advantages of the present invention will become apparent to those skilled in the art from the following detailed description and accompanying drawings. It should be understood, however, that the detailed description and specific examples, while indicating preferred embodiments of the present invention, are given by way of illustration and not limitation. Many modifications and changes within the scope of the present invention may be made without departing from the spirit thereof, and the invention includes all such modifications.
The exemplary embodiments will hereafter be described with reference to the accompanying drawings, wherein like numerals depict like elements, and:
In the following description, for the purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be evident to one skilled in the art, however, that the exemplary embodiments may be practiced without these specific details. In other instances, structures and device are shown in diagram form in order to facilitate description of the exemplary embodiments.
The disclosed embodiments provide systems and methods for providing increased flexibility in the allocation, use and tracking of a budget in a purchase order system. In the disclosed embodiments, budget rules allow allocation of budget into a plurality of buckets. Each bucket may be identified by one or more planning levels corresponding to, for example, a year, a season, a delivery period, an order period, a merchandise category, a specific article, a buyer or a vendor. Such allocation may be implemented during the planning of the budget, implementation of the budget, checking of the budget to map a purchase order to the appropriate bucket or buckets, and identifying the proper bucket or buckets during procurement, for example. In this regard, a bucket may correspond to one or more of a year, a season, an order period, a delivery period, merchandise category, a specific article, a buyer or a vendor, for example.
Thus, the budget may be allocated into buckets according to a plurality of planning levels. At various phases of the purchase order system, it may be desirable to define the budget according to a different set or a subset of the planning levels. In this regard, embodiments of the invention allow for the use of different keys for one or more processes or phases of the purchase order system. Each key corresponds to a set of planning levels. In one embodiment, the key for a specific process may be selected from a list of predefined keys. In another embodiment, the key may be defined by a user by, for example, selecting one or more planning levels from a list.
In at least one exemplary embodiment illustrated below, a computer system is described which has a central processing unit (CPU) that executes sequences of instructions contained in a memory. More specifically, execution of the sequences of instructions causes the CPU to perform steps, which are described below. The instructions may be loaded into a random access memory (RAM) for execution by the CPU from a read-only memory (ROM), a mass storage device, or some other persistent storage. In other embodiments, multiple workstations, databases, process, or computers can be utilized. In yet other embodiments, hardwired circuitry may be used in place of, or in combination with, software instructions to implement the functions described. Thus, the embodiments described herein are not limited to any particular source for the instructions executed by the computer system.
Referring now to
The OTB system 100 may be implemented as a workbench that may be a data processing system or software configured to control, display, interface with operators, or perform other operations to manage purchase orders. The OTB control system 130 is preferably implemented in an SAP-based workbench, interface, and architecture, but any other systems may be utilized.
The OTB system 100 may be implemented as a single system, a distributed system, or any combination thereof. The OTB system 100 may be implemented using a single computing system, a plurality of computing systems, software, hardware, or any other system or combination of systems to perform the functions described herein.
Data warehouse 120 is a data repository configured to receive, sort, and process information related to retail operations and planning. The data warehouse 120 may also be implemented as using a single or multiple systems. The data warehouse 120 may further include one or more functions associated with it to permit a user to efficiently organize and retrieve stored data. The OTB system 100 is sufficiently flexible to accommodate any of a variety of types of data warehouses 120, such as databases, for example.
In certain embodiments, the data warehouse 120 may be adapted to generate rules or checks to be used in the processing of purchase orders. In other embodiments, a planning system 160 may be provided to generate planning data, rules, checks and budgets, and to provide such information to the data warehouse 120. In this regard, the rules or checks may include a planning data or planning budgets including budget buckets corresponding to delivery periods, order periods, products or product categories, for example. As described below, the budget planning, budget transfer, budget rule checks and procurement may each include use of budget keys associated with planning levels, along with appropriate mapping, to ensure application of the appropriate budget bucket or buckets. The keys may be selectable or definable by a user to satisfy specific requirements or desires for various processes in the purchase order system, for example. The planning data or budgets are provided by the data warehouse 120 to the OTB control system 130, which may be included in a purchase order workbench.
The purchase order workbench may be a data processing system configured to allow a user to create, monitor, and receive approval for purchase orders for obtaining products or other supplies from a supplier. According to an exemplary embodiment, the purchase order creator 132, the purchase order control system 134, and the open-to-buy control system 130 are included in the workbench.
Purchase order creator 132 may be any system or method for creating electronic purchase orders. An electronic purchase order may be any type of purchase order in an electronic format. Purchase order creator 132 may include one or more functions to facilitate creation of the electronic purchase order. For example, purchase order creator 132 may include an auto fill function to automatically populate an electronic purchase order with previously stored data. Additionally, purchase order creator 132 may include a user interface configured to receive and display purchase order information with a user. Upon creation of a purchase order, the purchase order creator 132 provides the purchase order information to the data warehouse 120 for use in future planning or recalculation of planning data or budget. The purchase order information is also provided to the purchase order control system 134. An event manager system 170 may be provided to facilitate communication between the purchase order creator 132 and the purchase order control system 134. The event manager system 170 may receive commands from the purchase order control system 134 to, for example, initiate the creation of a purchase order and may process that command by issuing a command to the purchase order creator 132.
Purchase order control system 134 may be any system for controlling and monitoring electronic purchase orders. Purchase order control system 134 includes one or more functions configured to allow a user to manipulate or receive information related to any existing purchase order. For example, a user may utilize purchase order control system 134 to retrieve information related to a specific purchase order and modify one or more attributes of the retrieved purchase order.
The purchase order control system 134 provides purchase order information to the OTB control system 130, which is configured to facilitate automated approval or rejection of electronic purchase orders including both procurement and budget check functions. The OTB control system 130 receives an electronic purchase order as input and applies one or more rules to the electronic purchase order to determine whether the electronic purchase order should be approved or rejected. The rules, or checks, are based on the planning budget which is based on the planning data received from the data warehouse 120. Planning budgets or buckets may be generated from the planning data at either the data warehouse 120, the OTB control system 130 or in another module lying between the two. According to an exemplary embodiment, the one or more rules includes at least one budget rule. A budget rule may define the amount of money that is available for a purchase order based on information contained in the purchase order. For example, a purchase order may include a time frame for the purchase order, and the rule may be used to define the amount of money that is available in that time frame. According to alternative embodiments, the one or more rules may also include rules directed to the timing during which purchase orders may be requested. In other embodiments, other types of rules may be incorporated into the OTB system 100. The OTB control system 130 will be further discussed below with reference to
According to alternative embodiments, a purchase order workbench may further include more, fewer, or different systems to facilitate creation, processing, and maintenance of purchase orders. Further, functions associated with one or more systems may alternatively be associated with one or more alternative systems. For example, purchase order creator 132 may be implemented as a component of purchase order control system 134.
Referring now to
Open to buy system 136 includes a front-end system 210 configured to provide an interface between one or more users and a back-end system 230, according to an exemplary embodiment. Although shown as separate components, front-end system 210 and back-end system 230 may alternatively be implemented as a single system. Yet further, open to buy system 136 may include a plurality of either front-end systems 210 or back-end systems 230. For example, open to buy system 136 may include a plurality of front-end systems 210 to allow multiple users in distributed locations to access uniform and synchronized information stored on backend system 230.
Further, each of the front-end system 210 and the back-end system 230 may further be configured to each include lower-level front-end and back-end systems. In this regard, one or both of the front-end system 210 and the back-end system 230 may include components which allow user interaction and components which interface with other modules.
Front-end system 210 is configured to allow one or more users to perform functions implemented using open to buy system 136. In the illustrated exemplary embodiment, the front-end system 210 includes a planning-data transfer module 212 adapted to receive data from the back-end system 230. The data received may include, for example, planned budget buckets, sales and budgeting information based on prior experience, current market conditions, and other factors. Additional detail relating to the planning data and its generation is provided below with reference to the description of the back-end system 230.
The planning-data transfer module 212 may generate a budget or a set of budget buckets, or budget portions, based on the planning data received from the back-end system 230. The budget information generated can then be stored in a planned budget module 214. In other embodiments, the planning-data transfer module 212 may receive and transfer raw planning data, and the planned budget module 214 may generated the budget information. In still further embodiments, the budget information may be generated within the back-end system 230 and forwarded to the planned budget module 214 through the planning data transfer module 212.
When a purchase order is received or submitted for processing, the front-end system 210 applies a set of checks or rules to determine whether the order should be processed as submitted. In this regard, the front-end system 210 is provided with an order check module 218. The order check module 218 accesses budget information from the planned budget module 214 to perform the necessary checks.
The order check module 218 may be configured to apply one or more open to buy rules to an electronic purchase order to determine whether the electronic purchase order should be accepted or rejected. A budget rule may be a type of open to buy rule. The order check module 218 may include a currency translation function configured to convert generic financial information to specific financial information relevant to the current user of front-end system 210. Status processing function 218 may be any function configured to determine whether no check was performed, a positive check result was received or a negative check result was received.
If the order check module 218 determines that the purchase order can be processed, the order is forwarded to a procurement module 220, which may communicate, directly or indirectly, over an interface with a user, such as a supplier or a vendor, to place the order. The procurement module 220 may be configured to receive and process information related to the creation, modification, or cancellation of an electronic purchase order.
If, on the other hand, the order check module 218 determines that the rules do not allow the purchase order to be processed as submitted, the order, the rules, the budget or a combination thereof may be modified to allow the processing of the purchase order. In this regard, the procurement module 220 may be configured to procure necessary additional budget (e.g., changing the value, delivery period, etc.) with the support of the purchasing documents creation module 222 or by requesting for a special release of additional budget that allows to overbook the corresponding budget bucket. If enough budget can be obtained within the procurement module 220, the order check module 218 can determine that the order can be processed. The front-end system 210 may be provided with a used budget module 216 to store budget information that is exhausted by existing purchase orders which may have been updated or revised by the order check module 218.
Once the order has been placed by the purchasing documents creation module 222, a confirmation may be received from the supplier or vendor. The information relating to the placement of the order may be generated by a purchasing documents creation module 222. In this regard, the information may include any revisions to the purchase order required by the order check module 218. The information generated by the purchasing documents creation module 222 may then be stored in a purchasing documents data store 224. In certain embodiments, an actual data transfer module 226 may be provided to supply the actual order and budget information to the back-end system for planning purposes.
According to alternative embodiments, front-end system 210 may include more, fewer, and/or different functions to provide a user interface and perform calculations related to purchase order processing. The described functions may be implemented using hardware, software, integrated circuits or any system configured to perform the functions described herein.
Back-end system 230 is configured to process data, store data, facilitate planning, provide reporting, and provide other functions associated with purchase order management using one or more functions and/or components. The back-end system 230 includes a planning data module 232 adapted to generate a merchandise ordering plan including all planned data (e.g., planned sales, planned margin, planned inventory, planned receipts and planned budget buckets). The merchandise ordering plan may include information relevant to, for example, order scheduling and budgeting. The planning data module 232 may be configured to receive information from at least an order forecasting system and an actual inventory reporting system 234. The order forecasting system (not shown) may include information from various sources, such as industry outlook reports, relating to expected market conditions, for example, The actual inventory reporting system 234 provides information to the planning data module 232 relevant to the actual inventory currently-available, which may include expected deliveries. In this regard, the actual inventory reporting system 234 may include information received from the front-end system 210, through the actual data transfer module 226, relating to purchase orders already placed.
In certain embodiments, the planning data module 232 may be adapted to generate budget information. The budget information may be stored within the back-end system 230 in a transferred budget module 236. The transferred budget module 236 may be used to store planned budget buckets that have been released and/or transferred to the planned budget module 214. This may be used to reduce data traffic by requiring transfer of only the changed and new buckets from the planning data module 232 and the transferred budget module 235 to the planned budget module 214.
As noted above, the generation of the budget information from the planning information may be accomplished by either the planning-data module 232, the planning data transfer module 212 or the planned budget module 214 or the transferred budget module 236. In this regard, the budget information may include a budget allocation into a plurality of budget portions, or buckets, according to various planning levels, each planning level corresponding to, for example, a year, a season, a delivery period, an order period, a product, a product or merchandise category, a buyer, a vendor or a combination thereof.
In embodiments of the invention, the budget information generated by either the planning data module 232, the planning data transfer module 212, the planned budget module 214 or the transferred budget module 236 may be generated, organized or allocated according to one or more keys selected by the user. The same or different key may be used at various processes within the purchase order system. In this regard, the user may select a key for each process from a pre-existing list of keys, or the user may define a key by selecting from a list of planning levels. In other embodiments, the open-to-buy system 136 may be selectively adapted by a specific user to generate, organize or allocate a budget according to a user-defined set of keys at various processes. This allows a user to customize the budgeting in a purchase order system for the specific requirements or desires of the user or the system.
Thus, as illustrated in
The selection of a key for each process may be performed in any practical manner. In one embodiment, a user interface may be provided to allow the user to select from a pre-existing set of keys from a menu. The user may also be provided with the option of defining a key not included in the menu using the same or a different user interface. In this regard, the user may select a series of planning levels from a list to form a key, for example.
When the planned budget data is transferred to the front-end system 210, a mapping of the keys defining the budget may also be transferred, as illustrated in
According to other embodiments, backend system 230 may include more, fewer, and/or different functions to provide information and perform calculations related to purchase order processing.
Calculate open to buy rule transferred budget module 236 may be a function configured to generate one or more rules or functions to be applied to an electronic purchase order to determine whether the electronic purchase order should be accepted or rejected. The generation of the one or more rules and their application to electronic purchase orders are further discussed below with reference to
In the case of budget rules, the generation of the rules may include a mapping of the keys used for planning, organizing or allocating the budget, as described above with reference to
Front-end system 210 and backend system 230 may be associated with one or more interface calls. An interface call is a message sent between front-end system 210 and back end system 230 or within either system. The interface call may be a request for information, a request for processing, and/or a communication of data. Each interface call may be associated with one or more functions or components within open to buy system 136.
A purchase order processing interface call is a communication from front-end system 210 to back-end system 230 communicating a request for the creation, modification, and/or cancellation of a purchase order. Modifications may include changes to amounts, changes to timing information, or any other modification. Based upon receipt of an interface call, the back-end system 230 is configured to create, modify, and/or cancel a purchase order.
A calculate open to buy rule interface call is a communication from back-end system 230 to front-end system 210 including an open to buy rule to be applied to electronic purchase orders. Based upon receipt of the open to buy rule, is the front-end system 210 can be configured to store the open to buy rule for application to future electronic purchase order requests in, for example, the order check module 218, which may further be configured to perform a validation check on the open to buy rule upon receipt as further described below with reference to
Further, as illustrated in
An open to buy interface call is a communication from planned budget module 214 to the order check module 218 within the back-end system 230 including planning information to be used in the generation of open to buy rules. The planning budget information may include at least planned receipts, pending purchase orders, open purchase orders, order forecasts, receipts, and the change in end of planning period inventory. Interface call may further include a transfer from order check module 218 to the used budget module 216. The transferred information may include used budget information according to existing purchase orders.
Referring now to
According to an exemplary embodiment, system 300 may be implemented using a single computing system. Accordingly, system 300 may be any type of computing device, including work stations, laptops, notebooks, personal digital assistants (PDAs), or other equipment configured to receive input, store data in a memory, execute a series of instructions, and provide an output. System 300 may include a processor configured to execute a set instructions or computer program, such as an IntelĀ® PENTIUMĀ® processor sold by Intel Corp. of Santa Clara, Calif.
According to an alternative embodiment, system 300 may be implemented using computing systems in a networked environment. System 300 may include a first computing system implementing user computing system 310, a communication network, and a second computing system implementing data processing system 320. The first and second computing systems may be any type of computer system, such as the computer system described above. The first and second computing systems further include devices for communicating over the communication network.
According to an exemplary embodiment, the communication network may be the Internet. According to alternative embodiments, the communication network may be any other type of network, such as a virtual private network (VPN), an Ethernet, or a Netware network. Further, the network can include a configuration, such as, a wide area network (WAN) or a local area network (LAN).
According to an alternative embodiment, system 300 may include a plurality of user computing systems 310: For example, wherein system 300 is configured to operate in a networked environment, system 300 may include multiple user computing systems 310 configured to communicate with data processing system 320 over the communication network. System 300 may further include a plurality of data processing systems 320. The data processing systems 320 may be in communication with each other such that uniform rules are provided to the user computing system 310, further discussed below with reference to
User computing system 310 may be any type of system configured to allow a user to enter and receive data related to electronic purchase order processing. For example, user computing system 310 may include a user interface configured to allow a user to input details related to a purchase order request. The details may include an item to be purchased, a number of items to be purchased, a total cost of items to be purchased, a time frame for delivery of items to be purchased, a payment due date for items to be purchased, etc. An exemplary user interface 312 is further described below.
User computing system 310 may further be configured to generate or receive an electronic purchase order. An electronic purchase order may be any type of purchase order stored in an electronic format.
User computing system 310 may further be configured to provide a user with the results of an electronic purchase order processing. For example, wherein an electronic purchase order is approved, user computing system 310 may be configured to display the approval to the user. User computing system 310 may further be configured to perform additional tasks related to the approval, such as, printing out the approved purchase order, forwarding the purchase order to the target supplier, updating pending order values, modifying rules, etc. These additional tasks are discussed in further detail below with reference to
Alternatively, wherein an electronic purchase order is rejected, user computing system 310 may be configured to display the rejection to a user and present the user with choices for remedial actions based on the rejection. For example, user computing system 310 may redisplay the rejected purchase order such that the user can modify one or more attributes of the rejected purchase order and resubmit the purchase order. User computing system 310 may further provide the user with feedback based on the rejection to advise the user in making amendments to the rejected purchase order. Exemplary advice can include limitations on the number of items that can be ordered, limitations on the total cost for the purchase order, limitations on the time frame for the order, description of other pending orders, etc.
Alternatively, where a purchase order is rejected, certain classes of users may be allowed to modify the budget rules such that the purchase order will be allowed. For example, a class of users may have approval to override normal budget rules in special circumstances, as will be further discussed below with reference to
User computing system 310 includes a user interface 312, a purchase order approval system 314, a goods receipt logging system 316, and a budget rules verification system 318. User computing system 310 may further include additional, different, and/or fewer components and/or subsystems configured to facilitate purchase order processing.
User interface 312 may be any type of user interface configured to facilitate interaction between a user and user computing system 310 and/or data processing system 320. According to an exemplary embodiment, user interface 312 may include a plurality of selectable links configured to allow the user to access functionality provided by or through user computing system 310. User interface 312 further includes a plurality of input and output fields, the input fields configured to receive information from the user and the output fields configured to display information to the user.
Purchase order request processing system 314 is a system configured to receive purchase order information from a user through user interface 312 or another source, generate an electronic purchase order, apply at least one rule to the electronic purchase order, and provide an acceptance or rejection of the electronic purchase order to the user through user interface 312 based on the application of the rule. Accordingly, purchase order request processing system 314 may include one or more of purchase order creator 132, purchase order control system 134, and/or OTB control system 130, as discussed above with reference to
Goods receipt processing system 316 is a system for processing information related to the receipt of goods for an existing electronic purchase order. According to an exemplary embodiment, goods receipt processing system 316 is configured to receive goods receipt information from a user through user interface 312 and provide the information to data processing system 320.
Budget rules verification system 318 is a system configured to receive at least one budget rule from data processing system 320 and perform a verification check on the at least one budget rules.
Data processing system 320 may be any type of system configured to generate and maintain budget rules and associated data. Data processing system 320 includes a planning system 322 and a budget rules generation system 326.
Planning system 322 is a system configured to generate and provide planning data to the budget rules verification system 318 of the user computing system 310. The planning data may be data that is generated by planning system 322 or data that is received as an input to planning system 322. For example, planning system 322 is configured to receive at least order forecast information and actual inventory information as inputs. The order forecast information is a projection predicting information related to orders to be placed in the future. The actual inventory information contains the actual inventory for the user for which the budget rules are being generated. The input information may be received in real time, periodically, based on events, and/or manually entered as needed. The planning data may be relevant to the generation of a planning budget, including buckets associated with each delivery period and order period. The planning budget and the buckets can be generated by the budget rules generating logic 326 using the planning data, as described below.
Planning system 322 may be further configured to generate budget rules reports. Budget rules reports contain a variety of information related to the creation and maintenance of the budget rules. Reports may be generated and customized for a variety of uses including strategic financial planning, store planning, merchandise planning, roll-out planning, etc. The planning system 322 may be adapted to re-calculate a planned budget either manually or automatically. The recalculation may be based on actual data received, for example, from previous planning cycles.
The planning system 322 may be configured to receive and store all of the information from various sources needed to generate the budget rules. The planning system 322 may further store additional information such as information used in generating budget rules reports.
Exemplary information stored in the planning system 322 may include planned receipts, pending purchase orders, open purchase orders, order forecast, receipts, and the difference between the planned inventory at the end of the planning period and the forecast inventory at the end of the planning period. The data may be stored and searchable according to a variety of key fields such as client name, week, month, delivery period, purchasing period, season type, season year, merchandise category, rollout date, season level, assortment level, organizational level, etc. Key fields may include any data category and can be used as a filtering criteria for the data. Thus, a customer or user may filter, sort, organize or retrieve the data based on any such key fields.
According to an exemplary embodiment, data stored in the planning system 322 may be stored in a planning currency. Advantageously, utilizing a planning currency allows budget rules to be created independent of volatility or differences in currency. By removing currency differences and volatility, budget rules may be more uniformly and effectively applied.
Budget rules generating logic 326 is configured to access data stored in the planning system 322 to generate at least one rule. According to an exemplary embodiment, the rule may be a budget rule. As noted above, the rule, or check, may be expressed in the form of one or more budget buckets. According to an exemplary embodiment, the at least one budget rule is a limit based on the amount of money available to purchase merchandise for a given time period. The creation of the at least one budget rule is further discussed below with reference to
Data processing system 320 may further include more, fewer, or different configurations of subsystems and/or functions to perform the functions described herein. For example, data processing system 320 may include an inventory tracking system to facilitate generation of budget rules. Further, systems or function described as associated with a particular system or subsystem of system 100 may alternatively be associated with any other system within system 100. For example, budget rule calculations may alternatively be performed within data processing system 320.
Referring now to
In a step 405, a specific contract is selected to be associated with the generated set of business rules. The specific contract may be directed to a particular retailer, a particular supplier, a particular merchandise line, etc. The budget rule will be generated based upon data associated with the specific contract.
In a step 410, a determination is made whether the budget rule is to be created to apply to purchase orders received during a planning and buying phase or to purchase orders received during an in-season or selling phase. According to alternative embodiment, further alternatives may be provided to modify the scope and/or focus of the budget rule to be created. For example, budget rules may also be created to apply to specific stores, specific merchandise, etc.
In a step 415, a budget rule is calculated for a period within a planning period. A period may be a week, a month, a year or any other time period within a planning period. The period may correspond to a single delivery period, for example. Alternatively, budget rules may be calculated to apply to the entire period.
According to an exemplary embodiment, the budget rule is a limit equal to the values of planned receipts minus pending purchase orders minus open purchase orders minus forecasted purchase orders minus receipts. The values are generally obtained by accessing data stored in the planning system 322. The budget rule may be roughly equivalent to the inflows minus all outflows for a period. The amount remaining is the amount that is available to purchase merchandise for the sub-period. The appropriate keys from the mapping of keys may be associated with the budget rule to ensure application to the proper bucket.
Following calculation of the budget rule for the period, the period may be incremented to create a budget rule for the next period within the planning period and step 415 may be repeated. This iterative step may be repeated for each sub-period within the planning period to create a set of budget rules.
Alternatively, wherein the created budget rule is to be applied to purchase orders received during an in-season or selling phase in step 410, a budget rule is calculated for a period within a selling period in a step 420. The calculated budget rules is similar to the budget rule in step 415 in that the budget rule starts with planned receipts minus pending purchase orders minus open purchase orders minus forecasted orders minus receipts. However, a change in the end of period inventory is added to this calculation. The change in the end of period inventory is based on the planned end of planned inventory minus the forecasted end of planned inventory. The forecasted end of planned inventory is created based on actual inventory, received by planning system 322 as an input. The amount remaining is the amount that is available to purchase merchandise for the period.
Following generation of the one or more budget rules, the rule or set of rules, along with the mapping of the keys, may be transferred from data processing system 320 to user computing system 310 in a step 425. The budget rules may be transferred periodically, based upon receipt of a purchase order, based on a detected change in one or more budget rules, based on manual inputs, etc. In some embodiments, the budget rules for one or more delivery periods may be calculated even though some of the delivery periods may occur well into the future. As noted above, the system allows for recalculation of the planned budget either manually or automatically.
In certain embodiments, the calculation or recalculation of the budget rules are allocated to delivery periods. In some embodiments, a delivery period may correspond to one or more order periods. In this regard, in certain embodiments, the results of the calculation or recalculation may be allocated to the order periods corresponding to the delivery periods. Thus, a budget bucket may form a budget rule at the intersection of a delivery period and an order period.
Referring now to
In a step 510, an electronic purchase order is received. The electronic purchase order for a sub-period may be received based upon user input through user interface 312 as described above. Alternatively, the electronic purchase order may be automatically generated. For example, the method for processing purchase orders may be used in conjunction with an inventory management system configured to automatically create purchase orders based on levels of inventory, changes in inventory, etc.
In a step 515, one or more budget rules are applied to the purchase order. Applying one or more budget rules to the purchase order may include subtracting the total cost under the purchase order from the amount of money available for purchasing to determine whether the total cost is less than the amount of money available. In this regard, the appropriate rule or check, such as the bucket corresponding to the current period, may be accessed.
As noted above and illustrated in
In the case of OTB allocation of planned budgets, the order period and the delivery period may be accessed. Following application of the one or more rules, a determination is made in step 520 whether the total cost of the purchase order is less than the amount of money available.
If the total cost of the purchase order is less than the amount of money available, the purchase order is approved in a step 525. Approval of the purchase order includes displaying an indicia to the user through user interface 222 to indicate that the purchase order is approved. Following approval of the purchase order, it may be necessary to update used budget module 216 in a step 530. In particular, the pending orders for the particular sub-period described in the purchase order are increased by an amount equal to the total cost of the purchase order.
Approval of the order may also include providing the user with the option to take one or more additional steps. For example, the user may be provided with an option to automatically forward the approved purchase order to the supplier for which the purchase was generated.
If the total cost of the purchase order is more than the amount of money available, the purchase order is rejected in a step 535. Rejection of the purchase order includes displaying an indicia to the user through user interface 222 to indicate that the purchase order is rejected and is generally accompanied for the reason for the rejection. For example, in some embodiments, the placement of a purchase order may require the existence of a budget bucket for the corresponding delivery period and order period. If no such bucket exists or the bucket has insufficient funds, the indicia may include a message such as āNO BUCKET FOR REQUESTED ORDER.ā
Following rejection of the purchase order, the user may be provided with one or more options based upon the rejection in a step 540. For example, the user may be provided with an opportunity to amend the purchase order such that the purchase order will be accepted with procurement module 220. Further, system 210 may be configured to provide the user with feedback indicating an allowable purchase order amount.
Alternatively, wherein a user has permission to modify the budget rules, the user may be provided with an option to modify one or more of the rules such that the purchase order will be allowed with procurement module 220. System 210 may further include constraints on a user's ability to modify the rules. For example, system 210 may include logic dictating that the user will only be allowed to modify rules for a first sub-period based upon a correlating change to a second sub-period. For example, a user may be able to increase the amount of money available in the first sub-period by decreasing the amount available in the second sub-period.
Purchase order processing may further include processing modifications and/or cancellations of existing purchase orders. Modifications that increase existing purchase order amounts may be processed as described above with the amount of the increase in the existing purchase order being treated as a new purchase order for that amount. Modifications to existing purchase order and/or cancellations of existing purchase orders may be processed without requiring approval or rejection. The budget rules may be modified to increase the amount of money available based upon a decrease or cancellation.
Although described in the context of purchase order processing for retail operations, system 210 may alternatively be applied to any system for processing electronic purchase orders by applying one or more rules to an electronic purchase order.
Thus, the disclosed system can accommodate budgeting using keys specifically defined or selected by a user. The planning, transfer, checking and application of the budget to procurement can be based on a budget customized for the specific requirements or desires of the user. The resulting flexibility in budgeting allows users to budget for purchase order systems in a customized manner, rather than relying upon or having to adapt to a standard budgeting system.
Many other changes and modifications may be made to the present invention without departing from the spirit thereof. The scope of these and other changes will become apparent from the appended claims.
This application claims the benefit of U.S. Provisional Application No. 60/551,221, filed Mar. 8, 2004 and entitled āInventory Management,ā and U.S. Provisional Application No. 60/563,284, filed Apr. 16, 2004 and entitled āInventory Management,ā both of which are hereby incorporated by reference.
Number | Name | Date | Kind |
---|---|---|---|
4750119 | Cohen et al. | Jun 1988 | A |
4752877 | Roberts et al. | Jun 1988 | A |
5297250 | Leroy et al. | Mar 1994 | A |
5315508 | Bain et al. | May 1994 | A |
5325304 | Aoki | Jun 1994 | A |
5400253 | O'Connor | Mar 1995 | A |
5500513 | Langhans et al. | Mar 1996 | A |
5615109 | Eder | Mar 1997 | A |
5621201 | Langhans et al. | Apr 1997 | A |
5710578 | Beauregard et al. | Jan 1998 | A |
5758327 | Gardner et al. | May 1998 | A |
H1743 | Graves et al. | Aug 1998 | H |
5796614 | Yamada | Aug 1998 | A |
5832496 | Anand et al. | Nov 1998 | A |
5870716 | Sugiyama et al. | Feb 1999 | A |
5878400 | Carter, III | Mar 1999 | A |
5920846 | Storch et al. | Jul 1999 | A |
5930769 | Rosengard | Jul 1999 | A |
5930771 | Stapp | Jul 1999 | A |
5943652 | Sisley et al. | Aug 1999 | A |
5953707 | Huang et al. | Sep 1999 | A |
5999914 | Blinn et al. | Dec 1999 | A |
6014648 | Brennan | Jan 2000 | A |
6029139 | Cunningham et al. | Feb 2000 | A |
6064984 | Ferguson et al. | May 2000 | A |
6115690 | Wong | Sep 2000 | A |
6151588 | Tozzoli et al. | Nov 2000 | A |
6185550 | Snow et al. | Feb 2001 | B1 |
6260024 | Shkedy | Jul 2001 | B1 |
6285916 | Kadaba et al. | Sep 2001 | B1 |
6341351 | Muralidhran et al. | Jan 2002 | B1 |
6366890 | Usrey | Apr 2002 | B1 |
6473794 | Guheen et al. | Oct 2002 | B1 |
6484149 | Jammes et al. | Nov 2002 | B1 |
6505093 | Thatcher et al. | Jan 2003 | B1 |
6507851 | Fujiwara et al. | Jan 2003 | B1 |
6647380 | Yotsukura | Nov 2003 | B1 |
6671676 | Shacham | Dec 2003 | B1 |
6701299 | Kraisser et al. | Mar 2004 | B2 |
6721715 | Nemzow | Apr 2004 | B2 |
6725204 | Gusley | Apr 2004 | B1 |
6868528 | Roberts | Mar 2005 | B2 |
6910017 | Woo et al. | Jun 2005 | B1 |
6980966 | Sobrado et al. | Dec 2005 | B1 |
7016859 | Whitesage | Mar 2006 | B2 |
7080030 | Eglen et al. | Jul 2006 | B2 |
7082408 | Baumann et al. | Jul 2006 | B1 |
7082426 | Musgrove et al. | Jul 2006 | B2 |
7092929 | Dvorak et al. | Aug 2006 | B1 |
7096189 | Srinivasan | Aug 2006 | B1 |
7107268 | Zawadzki et al. | Sep 2006 | B1 |
7117165 | Adam et al. | Oct 2006 | B1 |
7124098 | Hopson et al. | Oct 2006 | B2 |
7124984 | Yokouchi et al. | Oct 2006 | B2 |
7139731 | Alvin | Nov 2006 | B1 |
7188080 | Walker et al. | Mar 2007 | B1 |
7216086 | Grosvenor et al. | May 2007 | B1 |
7283975 | Broughton | Oct 2007 | B2 |
7343315 | Wittmer et al. | Mar 2008 | B2 |
7346656 | Worthen | Mar 2008 | B2 |
7363253 | Forbis et al. | Apr 2008 | B2 |
7499877 | Carr et al. | Mar 2009 | B2 |
7516083 | Dvorak et al. | Apr 2009 | B1 |
7523048 | Dvorka | Apr 2009 | B1 |
20010011295 | Kobayashi et al. | Aug 2001 | A1 |
20010013731 | Shinohara et al. | Aug 2001 | A1 |
20010019332 | Fisher | Sep 2001 | A1 |
20010019778 | Gardaz et al. | Sep 2001 | A1 |
20010032130 | Gabos et al. | Oct 2001 | A1 |
20010034673 | Yang et al. | Oct 2001 | A1 |
20010039517 | Kawakatsu | Nov 2001 | A1 |
20010049634 | Stewart | Dec 2001 | A1 |
20020012390 | Kim | Jan 2002 | A1 |
20020013731 | Bright et al. | Jan 2002 | A1 |
20020019778 | Isaacson et al. | Feb 2002 | A1 |
20020023500 | Chikuan et al. | Feb 2002 | A1 |
20020026368 | Carter, III | Feb 2002 | A1 |
20020048369 | Ginter et al. | Apr 2002 | A1 |
20020059108 | Okura et al. | May 2002 | A1 |
20020059122 | Inoue et al. | May 2002 | A1 |
20020062314 | Hisasue et al. | May 2002 | A1 |
20020072986 | Aram | Jun 2002 | A1 |
20020073114 | Nicastro et al. | Jun 2002 | A1 |
20020078159 | Petrogiannis et al. | Jun 2002 | A1 |
20020099563 | Adendorff et al. | Jul 2002 | A1 |
20020099579 | Stowell et al. | Jul 2002 | A1 |
20020107713 | Hawkins | Aug 2002 | A1 |
20020116241 | Sandhu et al. | Aug 2002 | A1 |
20020120523 | Yang | Aug 2002 | A1 |
20020120533 | Wiesenmaier | Aug 2002 | A1 |
20020123930 | Boyd et al. | Sep 2002 | A1 |
20020128938 | Schofield et al. | Sep 2002 | A1 |
20020128946 | Chehade et al. | Sep 2002 | A1 |
20020138290 | Metcalfe et al. | Sep 2002 | A1 |
20020138360 | Inoue et al. | Sep 2002 | A1 |
20020143644 | Tosun et al. | Oct 2002 | A1 |
20020143690 | Mahajan et al. | Oct 2002 | A1 |
20020147622 | Drolet et al. | Oct 2002 | A1 |
20020147668 | Smith et al. | Oct 2002 | A1 |
20020152128 | Walch et al. | Oct 2002 | A1 |
20020156858 | Hunter | Oct 2002 | A1 |
20020165782 | Falkenstein et al. | Nov 2002 | A1 |
20020184116 | Tam et al. | Dec 2002 | A1 |
20020188524 | Shimizu | Dec 2002 | A1 |
20030023500 | Boies et al. | Jan 2003 | A1 |
20030028393 | Coulston et al. | Feb 2003 | A1 |
20030028437 | Grant et al. | Feb 2003 | A1 |
20030033231 | Turner et al. | Feb 2003 | A1 |
20030046120 | Hoffman et al. | Mar 2003 | A1 |
20030046195 | Mao | Mar 2003 | A1 |
20030050852 | Liao et al. | Mar 2003 | A1 |
20030065574 | Lawrence | Apr 2003 | A1 |
20030074269 | Viswanath | Apr 2003 | A1 |
20030074302 | Cope | Apr 2003 | A1 |
20030083961 | Bezos et al. | May 2003 | A1 |
20030120528 | Kruk et al. | Jun 2003 | A1 |
20030126024 | Crampton et al. | Jul 2003 | A1 |
20030128392 | O'Brien et al. | Jul 2003 | A1 |
20030144916 | Mumm et al. | Jul 2003 | A1 |
20030149631 | Crampton et al. | Aug 2003 | A1 |
20030149674 | Good et al. | Aug 2003 | A1 |
20030158791 | Gilberto et al. | Aug 2003 | A1 |
20030171998 | Pujar et al. | Sep 2003 | A1 |
20030172007 | Helmolt et al. | Sep 2003 | A1 |
20030187767 | Crites et al. | Oct 2003 | A1 |
20030200150 | Westcott et al. | Oct 2003 | A1 |
20030200156 | Roseman et al. | Oct 2003 | A1 |
20030200168 | Cullen, III et al. | Oct 2003 | A1 |
20030208365 | Avery et al. | Nov 2003 | A1 |
20030229502 | Woo | Dec 2003 | A1 |
20030236721 | Plumer et al. | Dec 2003 | A1 |
20040006522 | Keane et al. | Jan 2004 | A1 |
20040010463 | Hahn-Carlson et al. | Jan 2004 | A1 |
20040015367 | Nicastro et al. | Jan 2004 | A1 |
20040019528 | Broussard et al. | Jan 2004 | A1 |
20040098358 | Roediger | May 2004 | A1 |
20040122689 | Dailey et al. | Jun 2004 | A1 |
20040158507 | Meek et al. | Aug 2004 | A1 |
20040162763 | Hoskin et al. | Aug 2004 | A1 |
20040172321 | Vemula et al. | Sep 2004 | A1 |
20040186763 | Smith | Sep 2004 | A1 |
20040186765 | Kataoka | Sep 2004 | A1 |
20040186783 | Knight et al. | Sep 2004 | A1 |
20040210489 | Jackson et al. | Oct 2004 | A1 |
20040220861 | Morciniec et al. | Nov 2004 | A1 |
20040249722 | Sugamura et al. | Dec 2004 | A1 |
20040267674 | Feng et al. | Dec 2004 | A1 |
20050015303 | Dubin et al. | Jan 2005 | A1 |
20050055283 | Zarovinsky | Mar 2005 | A1 |
20050060270 | Ramakrishnan | Mar 2005 | A1 |
20050075915 | Clarkson | Apr 2005 | A1 |
20050075941 | Jetter et al. | Apr 2005 | A1 |
20050086122 | Cirulli et al. | Apr 2005 | A1 |
20050086125 | Cirulli et al. | Apr 2005 | A1 |
20050096122 | Nireki et al. | May 2005 | A1 |
20050096125 | LeMay et al. | May 2005 | A1 |
20050096963 | Myr et al. | May 2005 | A1 |
20050102175 | Dudat et al. | May 2005 | A1 |
20050102192 | Gerrits et al. | May 2005 | A1 |
20050102227 | Solonchev | May 2005 | A1 |
20050131807 | Schaefer et al. | Jun 2005 | A1 |
20050165659 | Gruber | Jul 2005 | A1 |
20050171825 | Denton et al. | Aug 2005 | A1 |
20050197912 | Wittmer et al. | Sep 2005 | A1 |
20050197913 | Grendel et al. | Sep 2005 | A1 |
20050197914 | Welter et al. | Sep 2005 | A1 |
20050197915 | Biwer et al. | Sep 2005 | A1 |
20050197918 | Wittmer et al. | Sep 2005 | A1 |
20050197921 | Abo-Hasna et al. | Sep 2005 | A1 |
20050197949 | Welter et al. | Sep 2005 | A1 |
20050203813 | Welter et al. | Sep 2005 | A1 |
20050216325 | Ziad et al. | Sep 2005 | A1 |
20050216357 | Wittmer et al. | Sep 2005 | A1 |
20050216359 | Welter et al. | Sep 2005 | A1 |
20050216375 | Grendel et al. | Sep 2005 | A1 |
20050235020 | Gabelmann et al. | Oct 2005 | A1 |
20050240488 | Grendel et al. | Oct 2005 | A1 |
20050240493 | Johnson et al. | Oct 2005 | A1 |
20050240524 | Van De Van et al. | Oct 2005 | A1 |
20050243792 | Simon et al. | Nov 2005 | A1 |
20050246482 | Gabelmann et al. | Nov 2005 | A1 |
20050251734 | Gabelmann et al. | Nov 2005 | A1 |
20060020512 | Lucas et al. | Jan 2006 | A1 |
20060036507 | Pujar et al. | Feb 2006 | A1 |
20060074746 | Kline et al. | Apr 2006 | A1 |
20060074747 | Kline et al. | Apr 2006 | A1 |
20060074748 | Kline et al. | Apr 2006 | A1 |
20060074749 | Kline et al. | Apr 2006 | A1 |
20060074751 | Kline et al. | Apr 2006 | A1 |
20060112099 | Musgrove et al. | May 2006 | A1 |
20060184401 | DelGaudio et al. | Aug 2006 | A1 |
20070050272 | Godlewski et al. | Mar 2007 | A1 |
Number | Date | Country |
---|---|---|
2004-030343 | Jan 2004 | JP |
WO 9945450 | Sep 1999 | WO |
WO 0171635 | Sep 2001 | WO |
Number | Date | Country | |
---|---|---|---|
20050216375 A1 | Sep 2005 | US |
Number | Date | Country | |
---|---|---|---|
60551221 | Mar 2004 | US | |
60563284 | Apr 2004 | US |