US20080027861A1 - System and method for automatic financial project management - Google Patents

Abstract

A system and method for providing project management tools to support construction, renovations, maintenance and other projects. The system automates the creation, processing and approval cycles of the numerous documents involved with each project. The system provides standardized work processes through processing templates. The system provides automated control and management of the process. The system allows project initiation and funding approval by clients throughout the corporation via a desktop browser coupled to a corporate Intranet. A software application embodying the present invention and its underlying technology are appropriate for a paper intensive area. It reduces the approval cycle of projects. It automates the creation, processing and approval cycle of documents by routing documents electronically for on-line approval.

Description

• The present invention is related to and claims priority to U.S. Provisional Patent Application No. 60/163,506 entitled AUTOMATED FINANCIAL PROJECT MANAGEMENT SYSTEM, filed Nov. 4, 1999, the contents of which are incorporated herein by reference.
FIELD OF THE INVENTIONBackground of the Invention
• Project management, especially in the area of corporate real estate project management, is traditionally a process which is driven by paper forms and documents. These paper documents include for example, purchase orders, work orders, contracts, Requests for Assistance (RFA), Requests for Proposals (RFPs), commitments, bids, invoices, messages (generic correspondence), meeting announcements and minutes, project close outs, complete punch lists, project evaluations, and departmental statistics.
• The processing of all of these various documents is very labor intensive, error prone and subjects the proposed projects to needless delays. For example, if the manager in charge of approving commitments is on a business trip for two weeks, a commitment requiring his or her signature might be delayed for an additional six weeks, which in turn delays another vendor's initiation of work and so on.
• Furthermore, an increase in the number of requests for new construction or engineering projects increases the volume of documents that are processed by the project administration group and the accounting operations group. This in turn requires an increase in processing capacity through an increase in staff levels or overtime. Conversely, a decrease in volume of requests lowers the productivity of the groups, as the staff levels are maintained to support the processing at the peak operations volume.
SUMMARY OF THE INVENTION
• The present invention was originally designed to automate the project management process for the Corporate Real Estate and Facilities Department of the assignee of the present invention. Although originally designed for this type of real estate and facilities department, it is readily seen that the project management method and system of the present invention has wide applicability to most types of project management.
• The system is a collection of process and business objects that provide project management tools to support construction, renovations, maintenance and other projects. One primary function of the system is to automate the creation, processing and approval cycles of the numerous documents involved with each project. The system and method of the present invention provides automation to support the following business processes.
• Strategic Space Planning. This function is responsible for determining how much space is required, demographic and market analysis of locations, and owned versus leased funding strategies.
• Client Management. The system allows project initiation and funding approval by clients throughout the corporation via a desktop browser coupled to the system via a corporate intranet. This concept facilitates self-service delivery. The request component allows clients to specific requirements for construction, renovation, relocation or office furniture.
• Project Support. The system assists the real estate department staff in creating budgets and controlling how budgets are dispensed though purchase orders, work orders and contracts. This includes the table maintenance involved in vendor authorization, workload, reassignment of tasks, security access and security registration, and changes to processes. Project support is provided for the administrative processes such as administering roles and responsibilities, which includes signing authority.
• Project Management. The business objects of the system of the present invention assist a project manager in creating a project budget and controlling how that budget is dispensed through purchase orders, work orders and contracts. Invoices are processed against the commitments and are paid through an electronic accounts payable interface. The underlying system structure provides standardized work processes through processing templates. The system provides automated control and management of the process. This methodology is expandable because it is template based, thereby providing an environment for financial based project management. Additionally, Project Management includes phases of project initiation, predesign, schematic design, design development, construction documents, procurement, preconstruction, construction, and post construction. The system includes project management functionality to assist in: Tracking Project Milestones; Corporate Cost Center Allocations for identifing how project expenses should be charged; Messages which are generic correspondence; Meeting Announcements and Minutes; Creation and approval of commitments; Approval of invoices; Project Close Outs; Complete Punch Lists; Project Evaluations; and Departmental Statistics.
• Vendor Management. The system allows direct access via the Internet to provide extensive functionality for managing approved vendors in relationship to specific projects. This functionality allows an approved vendor to author Bids, Requests for Quotes (RFQs), Invoices, Punch Lists, Lien Waivers and Messages. Other documents can be received and processed with more limited functionality. These documents include Request for Proposals, Contracts, Work/Purchase Orders, Change Orders, Payment Confirmations and Meeting notices. In addition, an in-box allows for timely communications of messages and documents.
• The present invention automates the creation, processing and approval cycles of numerous documents involved in project management. It allows project initiation and funding approval by clients throughout the corporation via a desktop browser coupled to a corporate Intranet. A software application embodying the present invention and its underlying technology are appropriate for a paper intensive area. It reduces the approval cycle of projects. It automates the creation, processing and approval cycle of documents by routing documents electronically for on-line approval.
• Other objects, features, and advantages of the present invention will be apparent to one skilled in the art from the following description of the invention with reference to the accompanying drawing.
BRIEF DESCRIPTION OF THE DRAWING
• For the purposes of illustrating the present invention, there is shown in the drawings a form which is presently preferred, it being understood however, that the invention is not limited to the precise form shown by the drawing in which:
• FIG. 1 is an illustration of the structure of the system of the present invention;
• FIG. 2 depicts the process flow of the present invention;
• FIG. 3 illustrates the tree structure organization of project management data;
• FIG. 4 depicts a user interface input screen for inputting a Request for Assistance;
• FIG. 5 shows an approval hierarchy structure according to the present invention;
• FIG. 6 illustrates a budget template and an example budget;
• FIG. 7 depicts an On-call commitment to a vendor;
• FIG. 8 shows a Purchase Order commitment;
• FIG. 9 illustrates the creation of a bid package;
• FIG. 10 illustrates the bid opening processing;
• FIG. 11 depicts the processing of bid responses from vendors;
• FIG. 12 shows the processing of a vendor invoice;
• FIG. 13 illustrates a funding document generated by the system of the present invention;
• FIG. 14 depicts the close out information available to a project manager;
• FIG. 15 illustrates a close out ledger; and
• FIG. 16 depicts a partial closeout.
DESCRIPTION OF THE PREFERRED EMBODIMENT
• FIG. 1 illustrates thesystem100 of the present invention. The various parties to the project managed by thesystem100 communicate via a corporate Local Area Network (LAN)105. Connected to theLAN105 are various servers110-120 on which reside the applications and databases supporting thesystem100.Server115 contains the applications that enable the clients to initiate and approve project requests and approve funding for such projects.Work flow server110 contains the applications which enable the project staff to create and route project documents and manage information. In a preferred embodiment, theworkplace server110 is accessed through an icon on the staffs'work stations120 which operates in a windows environment. The applications can be developed using C, Powerbuilder™, SQL, Cold Fusions™, or other similar software development languages and tools.
• Database server120 provides access todatabase122 that contains the various databases housing the details of all of the projects under management. In a preferred embodiment, the databases onserver110 are relational database such as is available from the Oracle™ corporation. Illustrated inFIG. 1 is awork station125, such as a personal computer (PC), laptop computer or other such workstations for use by project managers. Clients (employees of the corporation initiating projects)access system100 through acorporate intranet130 andclient work stations135.Vendors access system100 using a vendor Inworkstation140 connect to thecorporate LAN105 preferably through theInternet145 using a browser. Thevendor workstation140 uses a “thin” client technology meaning that the majority of the software for the vendor access resides on LAN105 (servers110,115). The firewall150 provides all of the requisite security such as password protection, authentication and encryption (if necessary).
• System100 provides security functions based on roles, signing authority and access rights. Security access is defined through a Role-Business Object-Function relationship. In addition, the ability to perform a function on an object (e.g., a document to be approved) depends on the state of the object. For example, as further described below, if a document has been approved, that document can no longer be modified so as to protect the integrity of the approval.
• Database122 contains various tables that support the security function and allow definitions such as: Roles to Person table that identifies all the roles a person can perform; a Functions to Business Object table that identify all the functions and menu items available to a Business Object; a Tree-views to Role table that identifies all the tree views (described below) available for a role; a Functions to Role table used to classify the functions and menu items as enabled or disabled for each business object within a role; a Function Exceptions table that overrides the classification for functions and menu items for each business object within a role identified at the person level (in other words, include or exclude a specific function in this business object for a person playing this role). A further table contains the state of all of the objects being managed by the system. A history of the revisions to an object (e.g., the changes in state during the approval process of a document) is maintained for auditing purposes. An object in the present invention can have multiple documents associated therewith. For example, if the object is a bid, some of the documents associated with the bid could be a list of vendors (requiring approval) and a commitment (requiring its own separate approval).
• FIG. 2 illustrates a overview of the project process managed by the present invention. The process begins with aclient160 determining that there is a need for the creation of a project. In the preferred embodiment the project is a construction project. Theclient160 initiate the project by generating a Request for Assistance (RFA). The Request For Assistance is typically generated by theclient160 with the assistance of aproject manager170. The process of generating an RFA with the aid of aproject manager170 is an iterative one that involves preparation, negotiation, performance and acceptance. The RFA contains the nature and scope of the project, the funding available for and required by the project, and the schedule by which the project must be complete. Although the RFA can be communicated by telephone call or e-mail, in a preferred embodiment of the present invention, the RFA is generated by theclient160 usingsystem100. Specifically, the client uses itsworkstation135 to connect toLAN105 through the corporate intranet130 (FIG. 1). The applications onweb server115 prompt theclient160 for all of the necessary information required to complete the RFA165. The data contained in the RFA165 is stored indatabase122 in separate files associated with the project.
• After theclient160 and the andproject manager170 have finalized the RFA, it goes through an approval process (described below) within theclient management chain162. Once the RFA has been approved byclient management162 is it automatically forwarded tofacilities management172 for approval and assignment of aproject manager170. Once theproject manager170 has been assigned and receives the approved RFA, theproject manager170 uses the RFA as a blueprint. As shown in loop173, theproject manager170 can typically delegate portions of the project to other groups (e.g., design work and its management can be delegated to a design group within the organization). As will be further described below, theproject manager170 creates bid packages, purchase orders and orcontracts175 which are used to solicit the work fromvendors180. Typicallyproject managers170 work with thevarious vendors180 in refining the nature and scope of the project. Theproject managers170 receive proposals from thevendors180 who are bidding on the whole or pieces of the project under consideration. The communication between theproject managers170 and the vendors can occur using the telephone or e-mail, but preferably thevendors180 communicate with the project managers using theirworkstations140 through theInternet145 and firewall150.
• For larger projects, the result of the bidding and proposal process is acontract175 which defines, in detail, the tasks to be preformed by thevendors180 in completing the projects. The specific tasks to be accomplished can be defined via a Purchase Order, a facilities agreement or a service agreement. Typically,contract175 is a master contract which defines the general nature of the project as well as the general nature of the relationship between the corporation and thevendors180. Pursuant to thecontract175, theproject manager170 will generate specific commitments tovendors180 to pay for specific tasks performed by thevendors180. Thecontract175 further provides for the ability of theproject managers170 to issue change orders to thevendors180 as the scope of the project changes during the evolution of the project.
• Upon completion of a task, thevendors180 issue aninvoice185 to the corporation. Theinvoice185 can be transmitted to the corporation via tradition paper method, but preferably is transmitted in an electronic form compatible withsystem100. If received in paper form, aninvoice185 is scanned so that it is rendered in electronic form which can be incorporated intosystem100 indatabase122. Theinvoice185 is reviewed by aproject analyst190 for comparison with the contract and the commitment to thevendor180. Theinvoice185 then goes through an approval process by theproject manager195 according to the business rules for the project as further described below. Once approved, the payment on the invoice goes through anaccounting process200 in which the payment is validated and charged against the appropriate portions of the contract. The payment is then remitted205 to the vendor either through a credit to the vendor's Demand Deposit Account (DDA), via check or via Electronic Data Interchange (EDI) remittance.
• FIG. 2 has depicted the general process of how a project is initiated and managed. The remainder of the Figures will illustrate howsystem100 facilitates the initiation management and closure of the project process. As previously described, the workstations for managing the project process (120,125 inFIG. 1) operate in a windows environment although any other suitable network operating system (e.g., Unix) can be employed.System100 includes security procedures, such as sign-on procedures, as known by those skilled in the art.FIG. 3 illustrates a typicaluser interface screen250 which will help explain the structure and functions ofsystem100.
• Information concerning projects managed bysystem100 are preferably organized infolders255 by projects. In a preferred embodiment, thefolders255 are organized in atree structure260.User interface250 illustrates onetree structure260 of a particular project270.System100 contains various predefined tree views offolders255 which are selected usinglist box265. Specifically illustrated inFIG. 3 is a tree view entitled “My Projects” inlist box265. The tree view of “My Projects” illustrated inFIG. 3 is the standard default view ofsystem100. The “My Projects” tree view is most frequently used by project managers and other support staff. Other tree views access information in a variety of ways. Other tree views include: a close out master view that lists all of the closed projects; a major expenditure plan view that lists all of the major projects; “my” major expenditure plan view which lists the major projects which a particular project manager is managing; a personal view that is an information folder for use by the user to store data for activities not related to specific projects; a projects by business sector view that lists all of the projects, sorted by major business division; a project by facilities division view that lists all projects sorted by a specific facilities department within the corporation; a view of projects by location that lists all of the projects sorted by location; a view of projects by project manager that lists all of the projects sorted by the project manager managing the project; a projects being supervised view that lists all of the projects being managed by the staff of a manager within the corporation; a view of recently approved documents that lists all of the documents that a user has approved within a predetermined period of time (e.g., two weeks); a view of system tables that lists various categories of system data such as roles, user profiles, and signing authorities; and a vendor view that lists all of the vendors sorted by several categories. Although the above is not an exhausted list of all of the views capable of creation in thesystem100 of the present invention, it is a preferred list of the views.
• Each of the user interface screens of thesystem100 includetoolbars275,280 containing icons that provide short cuts to the functionality ofsystem100. In a preferred embodiment, the icons ontoolbar275 are consistent across the user interface screens ofsystem100. These icons provide basic functionality to all screens such as a button for returning the user to default tree view, a print button which prints the screens, a close button which closes a screen in which the user is currently operating, a tile up button that returns the screen to the standard screen format with thetree view260 on the left hand portion of the screen and the selected item on the right hand portion of the screen, and an exit button that is used to exit the system.
• The icons ontoolbar280 change from screen to screen, depending on the function being performed by the user. Some of thetoolbar280 icons illustrated inFIG. 3 include anew document icon281 that produces a new document menu; a view notes button that produces a list of all notes created using the notebook feature of the present invention as further described below; a refresh button that renews and updates the tree view after completing an activity; a toggle tree button that toggles between the tree view and a full screen view of the selected item on the right hand portion of the screen; and a create note button that activates the notebook feature of the present invention. The icons ontoolbars275,280 and other functions of the present invention are accessed using a standard input device of the user's workstation such as a mouse. The mouse is used to click on a button to activate a specific function, to select an item and to drag and drop items of information.
• As previously described, information is preferably presented to the user in atree view260. The specific tree view illustrated inFIG. 3 illustrates thefolders255 associated with the project270. The user illustrated inFIG. 3 only has a single project270, otherwise the other projects associated with the user would be illustrated in the tree view area.
• Elevenfolders255 are shown as being associated with the project270. The project directory folder282 contains a listing of all of the project team members as well as the project vendors. The list is populated from database122 (FIG. 1) as individuals or vendors are identified on the project. The Request For Assistance folder284 contains the approved RFA form as described above. The budget and funding folder286 contains all budget worksheets and funding documents. These documents include a preliminary funding document, a supplemental funding document and surrogate funding documents. Project task folder288 contains the project tasks that are set up to assign portions of the approved budget to specific trades (e.g., plumbing) in preparation for creating commitments to vendors. Commitments bytrade folder290 lists all of the commitments that have been prepared for a project (including draft, unapproved and approved commitments). The approved commitments folder292 contains all of the approved commitments. The payments folder294 contains all approved invoices from vendors for which payment has been made. The bid documents folder296 contains all information related to bids and bid waivers. Each bid listed in this folder is assigned a unique number for accounting tracking purposes. Reports folder298 contains a tracking report with respect to the project which lists all commitments and payments. This folder can also be used to store copies of other reports.Projects attachment folder300 contains sub-folders for storing scan documents or electronic files of plans, specifications, correspondence, schedules and furniture/finishes information for example. The close outfolder302 contains partial and final close out information with respect to the project. Again, the above list of folders282-302 is not exhaustive and any folders can be created which suit the needs of the particular project being undertaken or the corporate system in which the system of the present invention operates.
• The right hand portion ofscreen250 depicts the information associated with the folder selected on the left hand portion of the screen. In this particular example, the project270 has been selected and accordingly, aprofile304 of the project is displayed on the right hand portion ofscreen250. Theproject profile304 contains information related to the category of the project, the project number, the project name, the location of the project, the division for which the project is being conducted and the cost center associated with that division as well as the current phase of the project. The project profile further includes abrief project description306 as well as anarea308 for the project status.
• Although not specifically illustrated inFIG. 3, every document withinsystem100 has its own notebook in which is recorded comments, issues or status information associated with the project. The notebook feature can be activated at any time, such as while preparing a document, during the approval process, or even after final approval. Notes can be saved generally in three different categories. A first category is a comment which includes general notes for the facility staff. A second category of notes is the status of the project which contains on going project status information. This status information from the notebook is displayed in thestatus area308 in the project profile area. The final general category of notes contains specific notes to be published to other members of the team such as the clients. The published notes are available to the clients as previously described through thecorporate intranet130.
• As previously described, the project management process initiated by a Request for Assistance (RFA).FIG. 4 illustrates an initial user interface screen350 for creating an RFA. The RFA is prepared either directly by a requestor or by a coordinator within the business unit requiring the project. There are generally two types of information required on an RFA, requestor information352 and information related to the project requested354. The input screen350 allows the user to input all of the required information into an electronic RFA form. In a preferred embodiment, the electronic form is used for projects over a predetermined dollar amount (e.g., $10,000). If the project total is less than the predetermined amount, the user can e-mail the project and requestor information to the facility staff. The facility staff can then prepare an internal RFA on behalf of the requester so that the request can be inputted and managed within thesystem100 of the present invention.
• Once the RFA has been completed, the user saves the document and clicks on a button (not shown) to send the RFA for approval. This action brings up aclient hierarchy screen360 illustrated inFIG. 5. This screen represents one of the unique features of the present invention. Onscreen360, the user is able to identify the proper personnel required to approve the RFA. In the specific example depicted inFIG. 5, three separate approvals are required for the RFA. The first approval is abusiness unit manager362, the second approval by a business unit controller364 and the final approval by a business executive366. Different rules are capable of being set in thedatabase122 ofsystem100 such that depending on the scope of the project (typically the total dollar amount) the number of approvals will change. For example, for larger projects (e.g., above $100,000) a business unit executive366 will be required to approve the RFA. Inarea368, the user is able to select the actual person who is fulfilling the role required for approval. The database ofsystem100 contains all of the relevant information with respect to each person in each business unit that can fulfill each role (e.g., name, e-mail address, title, etc.). The user can select the appropriate person from a drop down menu by selecting the down arrow on each box inarea368.
• Once the appropriate people have been selected for the approval roles with respect to the RFA, the user clicks on the submitbutton370. This action automatically forwards the electronic RFA to the person fulfilling the role of the first level of approval required for the RFA. A notice of the pending RFA requiring approval is added to the workflow list of pending tasks of the approver. This workflow list is accessed by theapprover using button375. When activated, this button provides a list of all of the documents requiring the persons' approval. The approver is then able to click on the notice which will bring up the actual electronic RFA document for review by the approver. After the review is complete, the reviewer is able to type any notes into a comment area of the RFA document and select one of several actions. If the approver approves the RFA, the electronic RFA is sent to the next individual in the approval hierarchy.System100 enables electronic signatures as is well known to those skilled in the art. The approver can also return the RFA for clarifications to the previous approver or to the requester. Such an action should be accompanied by the approver including notes in the comment area which further define the clarifications required. The approver can also disapprove the RFA which sends the form directly back to the requestor or client coordinator. Again, if the RFA is disapproved, the approver should include notes in the comment area including reasons for the disapproval. Finally, the approver can discontinue the review of the RFA and come back to complete the review at a later time. In this action, the notice of the pending RFA will remain in the approver's work list. If the RFA is approved by the final approver in the client hierarchy, the form is automatically routed to a dispatcher in the project management staff. At this point, the approved RFA is assigned a project number and a project manager.
• The automatic approval process of the present invention has several distinct advantages. First, the process is instantaneous. Once a document has been submitted for approval, notice of the receipt of the document for approval is immediately sent to the approver and the document is immediately available for review. This is in sharp contrast to the prior art method of approval in which documents typically were rerouted using interoffice mail. Apart from the delay associated with such a mail system, documents were often lost or misplaced. Tracking the status of approvals using the present invention is as simple as clicking on a button on the user's screen. The prior art required someone to conduct a series of phone calls, e-mails and personal visits to the approvers. Another advantage of the approval hierarchy of the present invention is that it recognized the corporate reality that people often change jobs, responsibilities, and locations. If such a change occurs, thedatabase122 ofsystem100 is easily modified to reflect the change. For example, if someone having the role of an approver is promoted and another person takes over the role, the database can be easily modified to replace the promoted person with the successor. Any subsequent approvals will then be automatically forwarded to the successor. Similarly, if someone having a role is on a temporary leave or absence, any task assigned to that person (e.g., approvals) can be easily and temporarily reassigned to a substitute person.
• Additional functionality provided to the clients ofsystem100 is the ability to view a list of RFAs for its business unit by clickingbutton378. This button will bring up a window containing all of the RFAs of the business unit. The list will include the project name, the date prepared, the status of the RFA and the status of the funding of the project. In a similar manner, a client is able to view a list of all of the finding documents by clicking onbutton380. The finding list will display all of the funding documents for projects on which the user is involved. Once a list is displayed in thesystem100 of the present invention, the user is able to view the actual documents associated with the item by selecting the particular item.
• After the approved RFA has been received by the project staff, one of the first tasks for the project staff is to create a budget and funding documents for the project.FIG. 6 illustrates auser input screen400 for creating budgets and funding documents. In a preferred embodiment, budgets are created using predefined templates.Area402 allows the user to view a list of all of the budget templates available withinsystem100. These templates can either be global (general formats available to all personnel) or private (i.e., templates that the user has personally created for his or her own use). Once a template is selected, the template is displayed inarea403 on the left hand portion ofscreen400. In the preferred construction embodiment of the present invention, the templates contain three levels of project information, including individual trades (e.g., lighting fixtures), trade categories (e.g., electrical) and summary categories (e.g., construction,404 inFIG. 6). The templates inarea403 can be viewed in the standard view as illustrated inFIG. 6, or a tree view as previously described, that shows summary categories in expandable folders.
• Once the template is displayed, the user is able to create the unique budget for the project in area406 by dragging and dropping the items from thetemplate area403 into the budget area406. For each item in the budget, the user is required to input theunit408,quantity410 andprice412. Once these items408-412 have been input by the user,system100 automatically calculates the cost of theitem414. Additionally,system100 allocates the cost as acapital item416 or anexpense item418.System100 additionally calculates an allowed contingency amount420 which can be set in the system as a percentage of the cost (e.g., 10% of the capital cost). The user is able to increase or decrease this contingency amount inarea422.
• If the creation of the budget document lasts longer than the user session, the user can save the budget as a worksheet and come back at a later time and complete the budget. Once the budget has been finalized, it is saved in a final form. The budget is then used to create a funding document that requires approval. The budget is a very complex and detailed document(s) that potentially includes hundreds of trades, capital items, expense items, etc. Rather than have the client and facilities management approve the very detailed budget, the system of the present invention generates a funding document for approval. An example of a funding document is depicted inFIG. 13. The funding document ofFIG. 13 was generated by a template accessing data from the database containing the budget. It is appreciated that any template can be used to generate any type or form of funding document desired. As seen in this Figure, the funding document summarizes the capital items for theproject700 as well as theexpense items705. Thesesummaries700,705 provide the approvers with an overview of the total spending for the project without the complexity of the details of the entire budget. Further shown inFIG. 13 are the names of the approvers of the funding document as well as the dates of the approval. The funding document indicates approval by both the facilities department710 as well as the management of thebusiness unit715.
• As previously described with the approval process for an RFA, the project staff member submits the funding document for approval which is automatically forwarded to the facilities hierarchy for approval. Again, the first person in the facilities hierarchy receives a notice in his or her work list regarding the funding document to be approved. The same automatic forwarding of approved documents is follows as described above with respect to an RFA. Again, if at any level of the approval process the reviewer denies approval or requests further clarification, the funding document is automatically returned to the previous approver with notes in the comments section providing reasons for the disapproval or the required clarification. Once the funding document has been approved by all levels of the facilities hierarchy, it is automatically forwarded to the client hierarchy for its approval. In a preferred embodiment, the client business unit has a similar level hierarchy for approvals, depending on the scope and size of the project. The same approval process is repeated within the client business unit including automatic forwarding of approved funding documents. Once the funding document has received final approval from the client hierarchy, it is automatically forwarded to the assigned project manager who acknowledges the approved funding document. The funds are now available for commitments and the process of managing the project begins.
• With the approved RFA and budget in place, the project manager is able to begin the actual project management. This process starts with the project manager generating commitments to vendors for various aspects of the projects. In the preferred construction embodiment of the present invention, the commitments include: architectural/engineering on calls; Purchase Orders; bids; bid waivers; contracts; change orders; and work orders. Architectural/engineering on-calls are commitments for on-call consultant services which typically result in the generation of a purchase order. A Purchase Order is a commitment for goods, materials, equipment or services, typically up to a predetermined dollar amount (e.g., $25,000). In the preferred embodiment, commitments over the predetermined amount (e.g., $25,000), require competitive bids. Again, these bids result in purchase orders for goods, materials and equipment or contracts for the provision of services. Alternatively, for commitments over the predetermined dollar amount, biding can be waived pursuant to a special bid waiver approval process. Work orders are commitments made against a master contract with a vendor for certain services of any dollar amount and for other trade services up to a predetermined amount (e.g., $10,000). Change orders are amendments to previously approved purchase orders or contracts, either increasing or decreasing the dollar amount. The change order results in a revised purchase order or a revised contract.
• The commitments are created against the previously approved funding and begin with the creation of a project task that assigns a portion of the approved budget to a specific trade. In order to create a project task for a commitment, the project manager selects the new document icon (281 inFIG. 3) to create the task. Activation of thisicon281 displays a document selection menu which includes the various documents which the project manager is able to create. A selection exists for each of the above-identified types of commitments (e.g., an on-call commitment). By selecting one of the items, the project manager is required to complete a description of the project task including the trade, the protocol for the commitment (e.g., source, bid, waived bid, negotiated, national contract), the type of commitment (e.g., purchase order, contract, work order) the tax status of the commitment (e.g., taxable, nontaxable) and a detailed description of the scope of work to perform pursuant to the commitment.
• The project manager is further required to complete a trade code details section. All of the trade codes that are contained within the approved budget are displayed (e.g., electrical). The project manager is able to drag and drop the applicable trades from the project budget to the trade code portion of the project task. The project manager then types in the dollar amount for each applicable trade for the commitment. Once the project manager has completed the above, the project manager saves the project task and is then able to generate the actual commitment.
• FIG. 7 illustrates acomplete commitment request450 for an architectural/engineering on-call. In creating thiscommitment450, the project manager was prompted to enter information related to theproject455, information related to the consultant (vendor)460, the scope of the job and the square footage affected and the fees associated therewith465, as well as a summary of the funding andfinancial commitments470, both with respect to this particular commitments and the project in total. Many of the items found on this on-call commitment were obtained from pull down menus (not shown) such as the consultant. Other items such as the cost center to be changed for work performed are provided bysystem100 as a default once the project number is inputted by the project manager. Once the on-call commitment has been completed by the project manager, the project manager submits the commitment for approval to the project staff. As previously described, the approval process is automatic, with each level of approval being able to approve the document, disapprove the document or return the document for clarification.
• In addition to the electronic commitment,system100 provides the project manager with the capability of scanning in additional documents that are associated with the commitment or creating any attachment such as spreadsheets, JPEG files, drawings. In the preferred embodiment, such attachments are created using Object Linking and Embedding (OLE) compliant software. Additional documents attached to a commitment may include proposals from the consultant or vendor. These attachments are available for review by the approvers at their work stations by selecting a view menu and selecting the attachments choice on the view menu (not shown).
• Once an on-call commitment request has received final approval,system100 automatically generates a purchase order number and notifies the project manager (electronically) of the purchase order number. A hard copy of the purchase order is issued by the project staff to the vendor. Preferably, the vendor is also able to obtain an electronic copy of the purchase order through the Internet interface previously described with respect toFIG. 1. The purchase order contains all of the basic information contained in the on-call commitment request as illustrated inFIG. 7. In the preferred embodiment, when the vendor opens the electronic purchase order (or other document such as a contract or a change order), the vendor is presented with a set of appropriate functions. For example, for contracts, a command button will be provided to Agree to the terms or Not Agree with an opportunity to comment or create addendum. The Agree function invokes an electronic signature process. Some functionality may not be available based on the stage of a particular process. For example, invoices cannot be created until a work document has been accepted.
• In the preferred embodiment, records relating to a vendor remain available insystem100 for a period of at least one year following the job's completion. Documents the vendor can author include Bids, RFQs, Invoices, Punch Lists, Lien Waivers and Messages. Documents the vendor can receive and process with limited functionality are Request for Proposals, Contracts, Work/Purchase Orders, Change Orders, Payment Confirmations and Meeting notices. In this preferred embodiment, the vendor is only allowed to view documents they authored or documents intended for them. The ability to delete documents are limited from a vendor's perspective and may only be allowed depending on the state of a document. This will provide for a document draft feature prior to posting to the workflow.
• The generation of a project task for purchase orders is the same as described above with respect to on-call commitments.FIG. 8 illustrates a request for apurchase order commitment475 generated bysystem100 of the present invention. Theproject profile information455 is the same as described above with respect to the on-call commitment. Thecommitment information480 includes the trade involved, the type of commitment (a purchase order in this example) and the protocol for the commitment. The vendor information485 describes the vendor to which the Purchase Order is to be issued. Again, this information can be input by the project manager using drag and drop methods previously described from a master list of vendors for the selected trade. The selection of vendors can either by from all of the vendors contained in the system or from vendors with which the corporation has a master contract. The cost associated with the purchase order is entered in area490 and the summary of the financial commitments is again listed inarea470. As with the on-call commitment described above, the project manager is able to scan non-electronic documents into the system for attachment to the purchase order. Once the purchase order request has been saved, it can be submitted for approval and proceeds through the approval hierarchy as previously described. Upon final approval, the purchase order is issued to the vendor with notification being made to the project manager electronically.
• A project task for a bid is again created as described above. Once the project task has been created, the project manager is then able to create a bid package500 as illustrated inFIG. 9.System100 automatically assigns abid number502 to the bid package as well as assigning thebid status504 of “initialization”. As previously described, a bid is an object that can have many documents associated therewith. Each document can have a separate approval process as described above. There is not necessarily a one to one relationship between documents and the object with which they are associated. Thetrade506 is obtained by the system from the information provided by the project manager in the creation of the project task. The project manager then inputs the invitation and bid due dates508 and510 as required by the project. The contract type512 is selected by the project manager from a pull down menu (not shown). The project manager further inputs any special instruction inarea514. Thebid package total518 is automatically calculated by the system as the sum of the tasks520. The tasks520 are initially populated bysystem100 from the entries input the project manager when creating the project task. The project manager can add additional tasks in area520 that he or she desires to be bid upon. The task can relate to the same project number or be associated with different projects, Theprice options522 defaults to a base price, but the project manager can select alternative pricing options from a pull down menu (not shown). The documents supporting the bid are listed inarea524 and include such documents as architectural or engineering drawings as well as equipment specifications.
• Once the bid package has been saved. The project manger is provided with a bid package vendor selection screen that allows the project manger to choose the vendors from which bids will be requested. Again, the project manager is able to select the vendors from a list complied from thedatabase122 insystem100. Once the project manager has finished selecting the vendors from which bids will be requested, the list is saved and submitted for automatic approval as described above. Once the list of proposed bidders has been approved, the bid package is sent to each of the bidders in hard copy form and preferably in electronic form.
• Prior to the bid due date, the bidders submit their bid proposals in response to the bid package. Due to legal concerns, it its preferable that the bids be opened and witnessed by two and preferably three witnesses.FIG. 10 illustrates an input screen550 used for conducting the bid opening. As illustrated in this Figure, threewitnesses552 are provided.System100 requires thesewitnesses552 to input their IDs and passwords when conducting the bid opening. As each bid is open, the information from each vendor is input intoarea554. The vendor name and the price options are defaulted by thesystem100 from the approved proposed bidder list previously described. Theamount556 is obtained from the vendors bid and is input into the system by the project staff. Additionally, the actual bid documents are scanned intosystem100 and linked as attachment to the project. Once all of the bids from the selected bidders have been entered, the bid responses on screen550 is saved and the bid opening is officially closed. The project manager is now able to perform an evaluation of the bids.
• In performing the bid evaluation, the project manager selects the bid documents folder (296 inFIG. 3) to view the various bids. The bid documents folder contains all of the bids associated with the selected project. Selecting a modify button (not shown) activates abid evaluation screen560 as illustrated inFIG. 1l. As seen inscreen560, each of the bidding vendors is displayed. The project manager is able to enter aqualified price562 which is either the bid amount submitted by the vendor during the bidding process or an adjusted amount due to clarifications with the vendor after the bid has been opened. The project manager is additionally able to enter any comments on the pricing inarea564 with respect to each of the vendors. The project manger is then required to rank the vendors inarea566 and provide a reason for selecting a particular vendor inarea568. If addition documents have been submitted by the vendors, they can be scanned in and attached to the data for project as well as other attachment such as drawings. Once the project manager has completed his or herranking556, the bid evaluation is saved and submitted for approval. The automatic approval process proceeds as described above with respect to the approval hierarchy.
• The above has described a process for creating and approving three types of commitments, namely architecture/engineering on calls, purchase orders and bids. Similar processes are performed for the creation and approval of bid waivers, work orders and change orders. These processes shall not be specifically described herein, those skilled in the art appreciated how such processes are accomplished.
• After the commitments have been made to the various vendors and the work has been completed, the vendors submitted invoices for the services and materials provided pursuant to the commitments. In a preferred embodiment of the present invention, the invoices are electronically transmitted from a vendor workstation140 (FIG. 1) through theInternet145 and the firewall150 for receipt bysystem100. Alternatively, paper invoices may be submitted, scanned and the data entered into the system either manually or through drag and drop methods. The project manager reviews the invoice data contained insystem100 against the scanned copy and makes any necessary adjustments in the payment amount, retainage, freight/delivery or tax, based on the actual goods or services provided.
• FIG. 12 illustrates an example of an invoicedata entry screen600. After an invoice has been received, thepurchase order number602, theinvoice number604 and theinvoice date606 are entered.System100, using thepurchase order number602, automatically fills in the commitment information608 as well as thevendor information610. The amount of the invoice including the material amount, the freight amount and the taxable amount are entered in area612. Once the data has been entered on invoicedata entry screen600, the data is saved and submitted for approval. The invoice approval process follows the approval hierarchy described above with respect to the other documents generated by the system. In a preferred embodiment, if the invoice amount does not exceed the commitment amount, the project manager alone can approve the invoice. If the invoice amount does exceed the commitment amount, the project manager can prepare a change order. The change order requires approval through the hierarchy and the issuance of a revised purchase order reflecting the adjusted commitment amount. Once the invoice has been approved, the payment can be made to the vendor either through the issuance as by check, crediting of the vendors demand deposit account, or through other EDI means.
• One further advantage of the present invention is the automatic nature of the tracking of the accounting information. A general rule is that any required accounting information (e.g., the business unit to which items will be charged) is captured by the system as soon as possible and thereafter carried through throughout the project. For example, once the client identifies the business unit to be charged, this identification is automatically carried into the templates for the project, commitments and invoices. All documents created from these templates will therefore automatically carry the identification of the business unit to be charged.
• As briefly described above, one of the features of the present invention is the ability to automate the close out process. The process of closing out a project has historically been an arduous and manually intensive process. As previously described, the preferred embodiment of the present invention relates to construction projects, and the close out process will be described in terms of this embodiment. The closeout procedures of the present invention automate the financial transactions associated with the following two processes: handling of a project's CIP (construction-in-progress) account balance; and the final closing of a project.
• The CIP account is a holding account that captures a construction project's capital expenditures. At the end of the project, the balance in the CIP account is passed to a fixed asset (F/A) account for depreciation. Until the asset has been thus transferred, it cannot be depreciated. After the balance is passed to a fixed account it starts depreciating thus creating depreciation expenses for portion of the corporation that is benefitting from the project. There is no hard requirement for the construction project to be 100% complete in order to commence depreciation. Depreciation can start with the payment of the first invoice with respect to the project. Typically, financial accounting rules governing construction projects employ an 80% threshold for commencing depreciation (i.e., 80% of the project must be complete before depreciation is started). The specifics of a project might require for the depreciation to be started both before or after an 80% threshold is reached.
• As previously described, many of the processes of the method and system of the present invention are driven by the documents related to the project. The final closing of a project in the system of the present invention is a system controlled procedure that starts with automatic examination of various states of the project documents. As a result of this thorough examination, the system produces an on-line diagnostics which highlights all inconsistencies detected by the process. The problems are categorized and displayed for the project manager.
• The system performs several types functions related to close outs, including a partial close out, a full close out, abort a close out and cancel a close out. A partial closeout is a type of closeout that is done when there is a need to move a portion of CIP balance to a F/A account. On larger projects, either in terms of funds and or the period of time for completing the entire project, having multiple partial closeouts is a very useful function practical. A full closeout is a type of closeout that is performed by the project manager only once. After successful completion of full closeout the project is closed to any further activity (including commitments and payments). A Cancel closeout is a type of closeout that is performed by the project manager in a case where a project was initiated in the system of the present invention but, before any commitments were issued to the vendors or any invoices were paid, the decision was made to stop it. An abort closeout is a type of closeout that is performed by a project manager when the client requested to stop the project after the funding was approved, commitments were issued and/or invoices were paid.
• A trigger built in the system initiates the first partial closeout for a project when the payment of a particular invoice meets the 80% threshold. The 80% threshold is with respect to the entire project. This trigger for a partial close out can be set to occur with respect to any event that is kept track of in the system. For example if there are several phases of a project, the trigger can cause a partial closeout at the completion of a particular phase. The trigger initiates a workflow process gets started that opens a closeout session. The system automatically links all of the paid invoices for the project to the closeout session created by the trigger. The system also generates a substantial number (sometimes hundreds) of financial transactions that will be sent to the General Ledger (G/L).
• The work flow process sends the generated transactions to an analyst in the financial area. After reviewing the transactions, the analyst approves the session. This single automated procedure alone replaces a substantial manual effort (document collection, data entry, data validation, etc.,) which would take weeks or even months to complete. The financial analyst can request that the system start a partial closeout if needed. In the preferred embodiment, there is no system-imposed limit on the number of partial closeouts that can be processed by the system.
• FIG. 14 illustrates the close out information that the system makes available to the project manager. As previously described with respect toFIG. 3, the tree structure of folders in the project manager's directory includes a close outfolder800. Opening the close out folder brings up thescreen802 seen in the left hand portion ofFIG. 14. Close outscreen802 contains six tabs805-830 for viewing further information with respect to the status of the various close outs with respect to a project.
• As illustrated inscreen802 inFIG. 14, theFinancial Summary tab805 displays a summary of the overall financial status of the project. Information in area835 provides identification of the project, while the information in area840 summarized the actual financials. The financial information in area840 includes the budget for the project, the amount of the budget that has been committed, the amount of the commitments that have been paid, the percentage of the budget that has been paid, the retainage held and the retainage paid. On thissingle summary screen802, the project manager is quickly able to obtain a summary of the progress, from the financial point of view, of the project.
• Each of the other tabs,commitments810,unapproved budget815,unapproved commitments820,change orders825 andinvoices830 respectively bring up screen that detail the status of the subject matter related to the items associated with the tab. For example, thecommitments tab820 brings up a screen (not shown) that shows in detail all of the commitments that were created in the system. For each commitment, the screen shows the vendor to which the commitment has made, the category (e.g., construction, move) the amount of the commitment, the amount paid to date and the remaining balance of the commitment. The remainder of the tabs810-830 bring up similar screens that list all of the items associated with the tab.
• Thefolders Closeout Ledger850 and Partial860 in the project manager's tree directory contain further information related to the closeout status. Thecloseout ledger folder850 bring up ascreen900 as illustrated inFIG. 15. Thisledger screen900 includes a summary are905 and adetailed area910. Within thedetailed area910, there is an entry for each of the closeouts associated with the project. In the particular example depicted in this Figure, only a single partial closeout has been executed with respect to the project.FIG. 16 illustrates the details associated with a partial closeout. Area950 lists the project information and the project details are listed in area955.Area960 contains the details as to the G/L accounts to which the items in the partial closeout were assigned.Area970 details the different G/L accounts to which items were posted as well as the depreciation schedule that is assigned to the items.
• When a project has been completed, the project manager initiates a final closeout. Again, the full level of automation associated with the partial closeout as described above is applied to the full close out. In contrast to a partial closeout though, additional tests are performed to make sure that no unfinished business associated with the project is left unattended. For example, one test is performed to expose any unpaid invoices. Another test is performed to identify any commitment that is not fully paid. A further test is performed to identify any credit from a third party (e.g. a real estate) due to the project that is not collected. And so on. A full diagnostic of the state of the project is presented to the project manager in a manner of seconds and a list of actions required is fully identified. In the prior art manual process, this undertaking would have required days if not weeks to complete.
• To close projects that were canceled before they were started and those that were stopped after they were started, two other types of closeout processing are performed as previously described, Cancel closeouts and Abort closeouts. Various tests are performed by the system to help the project manager to handle these exceptional conditions correctly.
• Although the present invention has been described in relation to particular embodiments thereof, many other variations and other uses will be apparent to those skilled in the art. It is preferred, therefore, that the present invention be limited not by the specific disclosure herein, but only by the appended claims.

Claims (23)

1-67. (canceled)

68. A construction payment management system comprising:

a server that stores an application, the application receiving information from a participant in a construction project; and

a database server connected to the server, the database server storing the information of the participant, the application accessing the information of the participant in order to transfer to the participant a payment associated with the construction project.

69. The construction payment management system ofclaim 68, further comprising a notification module.

70. The construction payment management systemclaim 69, wherein the notification module is an inbox for timely communications of messages and documents to the participant.

71. The construction payment management system ofclaim 68, wherein the participant is a vendor.

72. The construction payment management system ofclaim 71, wherein the vendor is a construction entity.

73. The construction payment management system ofclaim 68, wherein the information is an invoice relating to the construction project.

74. The construction payment management system ofclaim 68, further comprising a web server, wherein the participant accesses the construction project through the web server.

75. The construction payment management system ofclaim 68, wherein the construction project is associated with a document collection and the document collection is maintained in the database server.

76. The construction payment management system ofclaim 75, wherein the document collection has a plurality of documents, each of the plurality of documents in the document collection being associated with a respective electronic notebook, the documents in the document collection being electronic documents, each electronic notebook including associated categories, for each electronic notebook the categories provided including:

a comment category that includes general notes;

a status category that includes a status of the construction project ; and

a published notes category, the method including publishing notes in the published notes category to a team working on the construction project.

77. The construction payment management system ofclaim 68, wherein the received information is encrypted during transmission.

78. The construction payment management system ofclaim 68, wherein the construction project being a contract and the document collection including contract documents.

79. The construction payment management system ofclaim 68, wherein the construction project is engineering related.

80. The construction payment management system ofclaim 68, wherein the construction project is architectural related.

81. A method of managing a construction payment process implemented by a computer, the method comprising:

receiving by an application an invoice and a lien waiver from a participant in a construction project;

approving the invoice; and

transferring monetary funds to the participant.

82. The method ofclaim 81, further wherein transferring monetary funds to the participant is achieved by one of the following: giving a credit to the participant's Demand Deposit Account (DDA), issuing a check, or using Electronic Data Interchange (EDI) remittance.

83. The method ofclaim 81, wherein the construction project is associated with a document collection and the document collection is maintained in the database server.

84. The method ofclaim 83, wherein the document collection has a plurality of documents, each of the plurality of documents in the document collection being associated with a respective electronic notebook, the documents in the document collection being electronic documents, each electronic notebook including associated categories, for each electronic notebook the categories provided including:

a comment category that includes general notes;

a status category that includes a status of the construction project ; and

a published notes category, the method including publishing notes in the published notes category to a team working on the construction project.

85. The method ofclaim 84, wherein approving the invoice further comprising:

identifying approvers that comprises an approval hierarchy, the approval hierarchy being a series of approvers;

automatically forwarding a notice requesting approval of at least one electronic document, in the document collection, from a previous approver to a successive one of the approvers upon approval of the at least one electronic document by the previous approver in the approval hierarchy.

86. The method ofclaim 81, wherein the construction project being a contract and the document collection including contract documents.

87. The method ofclaim 81, wherein the construction project is engineering related.

88. The method ofclaim 81, wherein the construction project is architectural related.

89. A construction payment management system comprising:

a server that stores an application, the application receiving information from a participant in a construction project, wherein the information is encrypted during transmission;

an inbox allowing timely communication of messages and documents to the participant;

a web server, wherein the participant accesses the construction project through the web server; and

a database server connected to the server, the database server storing the information of the participant, the application accessing the information of the participant in order to transfer to the participant a payment associated with the construction project, wherein the construction project is associated with a document collection and the document collection is maintained in the database server, wherein the document collection has a plurality of documents, each of the plurality of documents in the document collection being associated with a respective electronic notebook, the documents in the document collection being electronic documents, each electronic notebook including associated categories, for each electronic notebook the categories provided including:

a comment category that includes general notes;

a status category that includes a status of the construction project ; and

a published notes category, the method including publishing notes in the published notes category to a team working on the construction project.

Images