WO1997028506A1 - Custom product estimating and order processing system - Google Patents

Custom product estimating and order processing system Download PDF

Info

Publication number
WO1997028506A1
WO1997028506A1 PCT/US1996/001429 US9601429W WO9728506A1 WO 1997028506 A1 WO1997028506 A1 WO 1997028506A1 US 9601429 W US9601429 W US 9601429W WO 9728506 A1 WO9728506 A1 WO 9728506A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
computer
estimate
item
ordering
Prior art date
Application number
PCT/US1996/001429
Other languages
French (fr)
Inventor
James Dudle
Michael Leatherman
Michael Morison
Waldo Schnell
Original Assignee
Wallace Computer Services, Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Wallace Computer Services, Inc. filed Critical Wallace Computer Services, Inc.
Priority to AU48626/96A priority Critical patent/AU4862696A/en
Priority to PCT/US1996/001429 priority patent/WO1997028506A1/en
Publication of WO1997028506A1 publication Critical patent/WO1997028506A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/80Management or planning
    • Y02P90/84Greenhouse gas [GHG] management systems

Definitions

  • the invention relates to a computer-based system and method for estimating and ordering the custom manufacture of an item such as a business form.
  • Manufacturers of business information products such as forms and labels generally employ a number of sales representatives located both at the corporate office(s) and offices remotely located therefrom.
  • the sales representatives interact with customers, that is, businesses requiring office supplies such as forms and other products for recording and distributing business- related data, to determine the format and content of a form, label or other product which best suits the customers' data collection and management needs.
  • the sales representative Following form design, the sales representative generates an order to specify the number of forms to be printed, form size, paper quality, ink color, print type, number of plies, requested shipping dates, and fastener type, among other information. Order generation is typically a manual process for the sales representative.
  • the customer interaction process can be arduous and time-consuming because of the multitude of options that are considered when designing and ordering a form.
  • a sales representative After a detailed order is created, a sales representative typically forwards the order electronically or by regular mail to a plant. If the order is large, it can be processed at the manufacturer's corporate office to select, from among a number of manufacturing plants co- located with or remotely located from the corporate office, the best equipped plant to fulfill the order. The order is then forwarded to the selected plant, which manufactures and ships the product in accordance with the specifications in the order.
  • the corporate office generally also performs accounting functions to bill the customer for the manufactured products.
  • the manner in which an order is generated and processed can vary depending on the business forms manufacturing system.
  • the form design and ordering process is done manually by a sales representative, that is, the content of the form and the order are written by the sales representative or customer on paper or electronic forms designed for these processes.
  • the sales representative typically determines the sale price based on data in a pricing manual or available in the memory of a computer. After the representative enters the sell price onto the ordering form, the representative submits the form and the completed order to the manufacturer's order receiving office by facsimile or mail.
  • Another type of business forms manufacturing system automates the design and ordering of forms by the remotely located customer or sales representative.
  • the system is organized in essentially the same manner described above. It comprises a manufacturer's computer at a central corporate office which communicates with several remote customers' or sales representatives* personal computers (PCs), and computers at the production facilities or plants.
  • the form is designed on a remote PC using a form design software program.
  • the form parameters are automatically transferred to a second software program for ordering, which permits a user to enter additional parameters such as order quantity and delivery information.
  • the PC proceeds to complete the order by automatically calculating price in accordance with the entered parameters and the ordering software.
  • the form and the completed order are subsequently simultaneously transmitted in machine format (i.e., electronically or on disk by mail) to the manufacturer's computer, which confirms the order and determines the best printing facility or plant.
  • the order and form are finally transferred electronically to the selected printing facility.
  • manufacturers seek to improve their form design and ordering systems and therefore their sales transactions with customers by improving the accuracy of cost and/or list price calculations, and reducing the paperwork and the time spent by sales representatives when performing price estimation and order entry.
  • one way manufacturers seek to improve their ordering systems is to automate the ordering process by including automatic price calculations at the sales representative's remote computer.
  • These price estimates are problematic because the sales representatives' computers may not be equipped with the most recent pricing data. Pricing data changes frequently due to a variety of factors such as variable material and labor costs. These changes need to be downloaded regularly to the sales site computers. This can result in inconsistencies in the price estimates calculated by different sales representatives.
  • the centralized storage of information also allows for flexibility in pricing to reflect, for example, pricing agreements between certain customers and the manufacturer.
  • the stored pricing data can be continuously updated with data received from different sources, such as manufacturing plants, which can monitor and report actual job and material costs to the manufacturer. Consultation with the corporate office for centralized storage of cost data eliminates the problem of having to continuously update the data at the sales representative's site in order to keep all representatives apprised of the same pricing information.
  • a disadvantage to calculating price entirely at the sales site is the lack of corporate office control over the list price offered by the sales representative to the customer.
  • Such control may be desirable for a number of reasons.
  • simple forms such as one-sided, single-ply, carbonless forms can be priced in a relatively straightforward manner at the sales site, provided the material and form feature cost tables consulted by most forms manufacturers for pricing are updated.
  • the equipment set-up time, run speeds and labor required for these types of manufacturing jobs are generally known and factored into the tables.
  • Complicated forms e.g., multi-ply forms with carbon papers and various perforations and fasteners or hole punching requirements
  • Complicated forms are more likely to be underpriced because slower equipment run speeds, longer set-up times and other factors were not taken into consideration when generating the tables.
  • These other factors can include, for example, the ability of different plants to perform the desired manufacturing processes, and customer and/or manufacturer item-specific contract data. By involving the corporate office in the estimation process, these factors can be taken into account when appropriate. Even when complex forms are not involved, the corporation may simply wish to have corporate office personnel review a sales representative's estimate, for example, because a proposed job exceeds a certain sell price, or involves a new or highly valued customer.
  • previous estimates that are stored at the corporate office can be used for operations and sales administration purposes. For example, previous estimates can be analyzed to locate which potential customers have been approached by a sales representative, to perform analysis such as determining how many estimates mature into product orders, and to determine which sales representatives deserve rewards for their successful endeavors or require additional training and incentives to improve their performance.
  • a sales site computer is programmed to facilitate the entry of design parameters for creating a form and estimate parameters to obtain estimate data from a manufacturer's corporate office, and to store these parameters for later use in a production order.
  • Computers at the sales site, plant and corporate office locations are networked and are programmed in a manner which maximizes the integration of different software systems and therefore the ability to share data (e.g., parameters relating to an item specification, and data relating to the customer) between the various components of the system of the present invention.
  • the amount of information the sales representative or customer re-enters during the creation of a production order is therefore minimized.
  • specifications for an item order are captured in a memory device and can be used for repeat orders.
  • a computer and a database are provided at the manufacturer's corporate office for storing standard cost tables and calculating cost and/or list price estimates based on the tables and the item specifications and estimate parameters, which were entered by a sales representative or customer at a remote sales site and transmitted, preferably electronically, to the corporate office.
  • custom price matrices are created to generate customer-specific estimates in accordance with a contract agreement between the manufacturer and the customer.
  • the corporate office computer and database are configured to manage contract information by maintaining contract parameters on-line, and monitoring contract performance and compliance using system analysis and reporting.
  • Fig. 1 is a schematic block diagram depicting corporate office, sales and plant hardware subsystems in a product specification, estimating and order processing system constructed in accordance with an embodiment of the present invention
  • Fig. 2 is a functional block diagram depicting software subsystems associated with the corporate office, sales site and plant depicted in Fig. 1;
  • Fig. 3 depicts a computer monitor screen generated by the sales information network software employed at the sales site of Fig. 1;
  • Fig. 4 is a flow chart illustrating the process of creating an item specification, obtaining an estimate, converting the item specification into a production order, and forwarding the order to a plant in accordance with the present invention
  • Figs. 5 through 31 depict computer monitor screens which are generated to prompt a sales representative or other user to enter item specification information
  • Figs. 32 and 33 depict computer monitor screens which are generated to prompt a sales representative or other user to enter information to obtain an estimate
  • Fig. 34 depicts a computer monitor screen which is generated to provide a sales representative or other user with estimate data
  • Fig. 35 depicts a computer monitor screen which is generated to prompt a sales representative or other user to calculate sell price using estimate data
  • Figs. 36 through 40 depict computer monitor screens which are generated to prompt a sales representative or other user to enter item usage information
  • Figs. 41 through 44 depict computer monitor screens which are generated to prompt a sales representative or other user to enter information for generating a production order
  • Figs. 45 through 53 depict computer monitor screens for prompting a user to enter information used for the generation of a contract price matrix.
  • Fig. 1 depicts a product or item specification, estimating and order processing system 10 constructed in accordance with the present invention.
  • the system 10 will be described for specifying, estimating and ordering the manufacture of custom business products such as business forms, promotional graphics, labels, mailers and envelopes, as well as commercial printing on paper, containers and other surfaces. It is to be understood, however, that the system 10 can be used to specify, estimate and order the manufacture of other types of items.
  • the order processing system 10 comprises one or more sales offices or sites 12 (which may be dedicated offices or simply desk top computers operated by sales representatives at the customers' offices), and one or more manufacturing plants 14, which are both connected to at least one corporate office 16 by communication links as described below. In general, the sales offices and plants are remote, although they can be co-located with the corporate office.
  • the computer-based systems at the corporate office 16, the sales site 12 and the plant 14 and their interconnecting communication links collectively form a wide area network (WAN) .
  • WAN wide area network
  • the corporate office 16 comprises at least one computer for performing a number of processes, and coordinating the activities of other computers located at the corporate office and remote locations (e.g., the sales sites and plants) in performing these processes.
  • the processes include, but are not limited to, tracking inventory at both a corporate storage site and a customer storage site, accounting, purchasing, managing customer contracts, and determining labor and actual material costs to produce orders.
  • the corporate office 16 can comprise an IBM 3090 mainframe computer 18 connected to a number of mainframe computer terminals 20, which communicate with the mainframe computer over dedicated digital lines via a communication controller 22.
  • the communication controller 22 also connects the mainframe computer and the mainframe terminals to a data communications network 24 such as a local area network (LAN).
  • Another communication controller 26 can also be provided to connect leased telephone lines from terminals (not shown) through the mainframe computer to the LAN via a router 52.
  • LAN local area network
  • a minicomputer 30 and a number of associated minicomputer terminals 32 are connected to the LAN 24 for corporate development purposes.
  • An electronic mail server (e.g.. E-mail) 34 supports messaging within the corporate office, as well as with terminals and computers at sales sites and plants.
  • At least one data server 36 is provided to support estimation and order entry applications by allowing remote computers to access a database of shared data and program files which is maintained at the corporate offices and described in further detail below.
  • a Remote Local Area Network (LAN) Access gateway 40 or RLA gateway is provided to permit X.25 communication protocol dial-up connections between sales representatives conducting business outside of a sales office (e.g., on a desk top computer) and the LAN 24.
  • Other communication links and protocols e.g., a dial-up frame relay, and ISDN, however, can be supported via the router 52.
  • the plants 14 are each preferably provided with a LAN 44, as shown in Fig. 1, to support users working on a number of PCs 46 to provide data to the corporate office data server or database 36, as well as to send messages via the electronic mail server 34.
  • Other processes performed at a plant can include, but are not limited to, managing raw material inventory, scheduling and tracking jobs, shop floor data collection, production reporting and job planning, and providing the corporate office with data concerning the planned use of materials, materials requisitions, and the actual consumption of materials and labor during job execution for comparison with the corresponding job estimate.
  • each plant is preferably provided with a communication controller 48 to connect mainframe computer terminals 50 located at plant sites 14 to the mainframe computer 18 at the corporate office 16 over the LAN 24 via routers 52 and 54.
  • a minicomputer 56 such as the IBM minicomputer AS/400 and associated AS/400 terminals 58 are connected to the LAN 44.
  • the sales offices each preferably comprise a LAN 60 to interconnect a number of PCs 62 and/or docked laptop or portable computers 64.
  • a file server 66 can be connected to the LAN 60 to support shared data between multiple PC users.
  • a router 68 is connected to the LAN 60 to interconnect the sales office 12 with the corporate office 16 with dial backup capabilities. Sales representatives can also access the corporate office 16 using, for example, their portable computers via the RLA 40 gateway or the router 52.
  • the system hardware architecture described in connection with Fig. 1 facilitates maintenance of remote systems such as the sales office and plant subsystems, and the distribution of software to these subsystems by allowing for the sharing of data between the platforms e.g., of the mainframe computer 18, the minicomputers 30 and 56 and the personal computers 29, 41, 46 and 62.
  • the corporate office LAN 24 supports a number of applications, which can also be supported by the LANs at the sales office and plant sites, such as word processing, data analysis, ad-hoc reporting, among other office administrative functions.
  • the networking of the PCs at the sales offices and plants facilitates order estimation and entry, as well as the electronic transmission, of production orders and copy folder information to the plants from the corporate office LAN.
  • Copy folder information generally includes specifications for manufacturing, packaging and shipping, and form usage data such as the type of printer to be used. While forms usage information is not necessary for an estimate, it is useful for plant quality control.
  • the sales offices send orders to the plants via the WAN.
  • the WAN also allows a form design to be transmitted directly to a plant for pre-processing.
  • printing at a plant 14 is intended to encompass any and all processes and/or the use of any type of machines or other equipment which can be employed for or utilized when preparing or producing imaging on a substrate that is to be read by machine or a human being, including, but not limited to, letter press, intaglio, gravure, lithographic, electrophotographic, xerographic, electrostatic, magnetic, flexographic, ink jet, laser, thermographic and offset lithographic printing processes. It will be appreciated by those skilled in the art that the present invention is not limited to a particular type of computer, data storage device or communications hardware such as the above- described components.
  • the hardware, and the transmission paths and networks can vary depending on a variety of factors such as the number of users accessing the system and the desired data transmission speed.
  • electronic transmission of data such as a business form image can include, but is not limited to, transmission via modem, facsimile and electronic data interchange (EDI), among other data transmission techniques.
  • EDI electronic data interchange
  • the corporate office, sales site and plant personal computers preferably operate in accordance with Microsoft WINDOWSTM, although other similar windowing environment and application user interfaces can be used.
  • the software associated with the corporate office 16, the plant 14 and the sales site 12 will now be described in connection with Fig. 2.
  • the corporate office computer subsystems depicted in Fig. 2 comprise an Order Entry and Inventory subsystem 88 which receives release orders from a sales representative computer (e.g., computer 62), as well as from mainframe terminals located at plants and other order entry offices. Release orders are generated by sales representatives to order the release of finished goods inventory stored at any corporate storage facility through electronic ordering.
  • This inventory includes, for example, forms that have already been produced for the customer and are warehoused at a plant or distribution facility in accordance with a warehousing agreement, and ready-made office supplies such as staplers and telephone message pads.
  • a release order from the Order Entry and Inventory subsystem 88 or from the sales site via the Sales Information Network 86 is sent to a Distribution subsystem 80.
  • the Distribution subsystem 80 generally operates in a warehouse remotely located from the corporate office 16. The Distribution subsystem determines where to store goods within the warehouse, retrieves and ships goods in accordance with release orders, and transmits data to the Order Entry and Inventory subsystem 88 for invoicing.
  • a sales representative can also generate production orders for the manufacture of a custom item such as a business form designed only for use by a particular customer.
  • the generation of a production order for a custom item generally involves the transmission of item specifications for a production order to an Estimating subsystem 90.
  • the Estimating subsystem 90 is used to generate estimate data using at least one of a number of methods described below.
  • the estimate data is transmitted from the Estimating subsystem 90 to the sales site 12.
  • the estimate data can be used in conjunction with other data such as the data in a copy folder to generate a production order which is sent to a plant.
  • the corporate office comprises a Contract Management subsystem 92 for storing customer-specific contract terms and conditions in order to resolve inquiries regarding this information made by sales representatives and customers, and to determine the degree to which customers have complied with their contracts, among other uses.
  • the contract data can include a customer/item relationship comprising contract pricing information for customer contract items.
  • the corporate office 16 further comprises a Labor and Material subsystem 94, a General Ledger subsystem 96, an Accounts Payable subsystem 98, a Purchasing subsystem 84 and an Advanced Shipping Notice (ASN) Data Feed module 82.
  • the ASN module 82 interfaces with the Purchasing subsystem 84, which in turn transmits data to the various plants comprising paper roll identification numbers.
  • a Raw Material Inventory Control subsystem 104 and a Data Collection subsystem 108 monitor the materials used in the plants for fulfilling customer orders.
  • the plant 14 provides data from the Data Collection subsystem 108 to the Labor and Material subsystem 94 and to the Estimating subsystem 90 relating to the materials and equipment used, as well as the labor required, to fulfill a particular order.
  • the data from the Data Collection subsystem 108 is used for performing actual cost analysis at the corporate office 16, for job planning at the plant 14 and, once the actual materials used to complete an order have been determined, for updating a Planning Bill of Materials subsystem 102 and the Raw Material Inventory Control subsystem 104.
  • the plant 14 can therefore provide data to a sales site regarding the status of an order for improved customer service.
  • the Purchasing subsystem 84 and the Raw Material Inventory Control subsystem 104 or the Labor and Material subsystem 94 provides the Estimating subsystem 90 with information concerning material attributes such as weight, paper grade, paper or ink color, material codes and material quote information (e.g., quote number, effective date, and material price) and therefore facilitates the process of determining more accurate estimates for the cost of fulfilling a customer order.
  • the Labor and Material subsystem 94 provides the Estimating subsystem 90 with standard material cost information, actual job information received from the Job Scheduling and Tracking subsystem 100 in the various plants, as well as actual production information such as waste percentages, feet per run hour and actual material usage.
  • Information from the plant is also used by the General Ledger subsystem 96 to generate accounting journal entries.
  • the Raw Material Inventory Control subsystem 104 and the Data Collection subsystem 108 monitor the materials used in the plants for fulfilling customer orders.
  • the Purchasing subsystem 84 receives requisitions from the Raw Material Inventory Control subsystem 104. When the material receipt is received, it Is used to update the Raw Material Inventory Control subsystem via the Receiving System 106. This information is provided to an Accounts Payable subsystem 98 for automatically tracking the accounts payable to the various vendors of these supplies.
  • the Accounts Payable data is also provided to the General Ledger subsystem 96.
  • MIPS 89 is used by a manufacturing plant 14 to manage jobs for cost efficiency and can, for example, be stored in the memory of the plant minicomputer 56.
  • MIPS comprises a plurality of software subsystems which are shown in Fig. 2.
  • the Planning Bill of Materials subsystem 102 determines the materials, shop equipment, and processing time required to fulfill an order based on item specifications in a production order.
  • An advantage of the system 10 of the present invention is that the item specifications are stored in a memory device after they are transmitted to and received at a plant and therefore do not have to be re- entered in the plant or the corporate office computer systems.
  • the Job Scheduling and Tracking subsystem 100 can schedule the completion of jobs in a manner which improves plant efficiency.
  • the MIPS 89 can schedule several jobs for different customers to be processed at the same time because the jobs reguire the same color ink or the same number of plies.
  • the Shop Floor Control subsystem 110 monitors where a product is located at a given point in time during the plant manufacturing process and provides this data to the Job Scheduling and Tracking subsystem 100.
  • MIPS 89 further comprises a Raw Materials Inventory Control subsystem 104 for monitoring supplies (e.g., paper, ink), and informing the Purchasing subsystem 84 when raw materials are needed.
  • a Receiving subsystem 106 monitors the receipt of raw materials for custom product manufacturing, as well as receipt of finished goods, e.g., release order forms that have already been produced and are being warehoused, and office supplies such as staplers that are offered for resale in a catalogue along with the release forms.
  • a Data Collection subsystem 108 collects data relating to materials and labor used per job, per customer and per plant. This data can be used for internally monitoring the performance of the plant. This data can also used by the Labor and Materials subsystem 94 for cost accounting.
  • the subsystems of the sales representative system or Sales Information Network (SIN) 86 will now be described in connection with Fig. 3.
  • the SIN software is preferably stored in the memory of the personal computers 41, 62 and 64 used by the sales representatives. SIN software can also be provided on terminals for use by customers.
  • Fig. 3 depicts a screen which is generated on a sales representative's computer monitor, for example, in accordance with the SIN software and a WINDOWSTM or equivalent software application.
  • the user can access a subsystem by selecting the corresponding button or menu option on the screen using a mouse, a key pad, a touch screen or other input device. After a button is selected, the computer initiates execution of a program for generating additional screens. A number of these screens (e.g., screens depicted in Figs. 5 through 44) are described with reference to Fig. 4.
  • the sales representative can begin entering item specifications for producing, for example, a custom business form by selecting the button 115 corresponding to a Custom Order subsystem.
  • the computer in turn generates the screen depicted in Fig. 5, that is, a Login screen which requests a login name to begin the process of entering a form specification, as described below.
  • This specification is used in conjunction with data at the corporate office to generate an estimate for manufacturing the form.
  • Item specifications entered using the Customer Order subsystem generally do not need to be as comprehensive as completed item specifications used for generating production orders.
  • the information needed to obtain estimate data is typically less than that required to Instruct a plant on how to manufacture a custom item.
  • the computer 62, 64 or 41 can generate estimating screens (e.g.. Figs. 32 through 35) following the item specification screens (e.g., Figs. 5 through 31).
  • the sales representative can retrieve a previously-stored item specification and/or estimate. Item specifications can be retrieved from memory by entering an item number in the "Search" screen depicted in Fig. 8, for example, or selecting the button 124 (Fig. 3) to access a Forms Management subsystem. If the customer finds the estimate to be agreeable, the sales representative can invoke the Custom Order subsystem via button 115 (Fig. 3) to begin entering additional information that is useful to generate a production order such as shipping information (e.g., see Figs. 41 through 44). The production order is then preferably electronically transmitted to a plant.
  • buttons 114, 116, 118, 120 and 126 are activated to enter queries, generate reports and perform a number of inventory management functions available in the SIN 86.
  • the screens generated in response to activating the Custom Order button 115 each include a button, drop ⁇ down menu or tool bar option (e.g., "File") that can be selected to return from the specification, estimating and order screens (e.g., the screens in Figs. 5 through 28) to the screen in Fig. 3 in a conventional manner.
  • a Release Order Processing subsystem permits a sales representative to enter release orders to order the release of inventory stored at any corporate storage facility, preferably via electronic data interchange (EDI) ordering.
  • EDI electronic data interchange
  • the EDI orders can be electronically transmitted throughout the WAN and ultimately to a plant or distribution facility 12, which is preferably the facility that is located closest to the destination point of the ordered goods. This reduces freight cost for the customers, as well as expedites delivery.
  • the sales representative can create a new release order or open a file to an existing release order by highlighting the proper menu option on a main release order screen (not shown) and striking the enter button on the key pad or clicking a mouse.
  • the sales representative can transmit release orders to the Order Entry and Inventory subsystem 88 at the corporate office, as well as receive release order acknowledgments. To save time, information that is frequently used by a customer to order the release of goods from inventory can be entered into a template.
  • information from the corporate office e.g., from the data server 36
  • information from the corporate office e.g., from the data server 36
  • the template-based system improves accuracy and speed.
  • Button 116 (Fig. 3) is used to invoke the Order Inquiry subsystem, which permits a representative to access information electronically regarding the status of a release or production order.
  • a query function is provided to allow the sales representative to find any order by searching the database for such references as user location, production order number, item number, or other criteria that the representative defines in a previously placed order.
  • an order status code is presented by the computer 41, 62 or 64 in accordance with the subsystem to Inform the representative if all items in an order were shipped or, in the case of a release order, if a back-order was required.
  • Order Entry and Inventory subsystem 88 which can be used to track the completion of a production order as explained above in connection with Fig. 2.
  • Button 118 (Fig. 3) is used to select the Customer Inventory subsystem, which allows either the customer or the sales representative to track inventory at the customer location.
  • Two methods are provided for tracking inventory.
  • the first method employs inventory counts, that is, counting receipt, on-order, and ending inventory amounts and entering them into the system at the end of the month.
  • the second method employs bar codes for perpetual inventory monitoring, that is, scanning bar codes on inventory items indicating receipt, on-order, usage and transfer transactions on a daily basis or as they occur.
  • This subsystem offers the customer valuable information to prevent stock-out situations, as well as useful trend usage analysis. If the inventory database is kept up-to-date, the customer inventory subsystem can offer additional benefits such as ad-hoc query creation and reports, which helps users to track inventory and overall usage of their products.
  • button 124 (Fig. 3) is used to select the Forms Management subsystem, which allows either the customer or the sales representative to maintain items such as forms and labels and their associated specifications electronically.
  • the subsystem is generally an electronic database of item specifications and copy folder information.
  • the sales representative or customer can create a form, as explained in further detail below, or scan an existing form into the SIN 86, and then match the on-screen image of the newly created or scanned document to a computer file.
  • the sales representative or customer can subsequently organize, sort and manipulate the specification and corresponding copy folder information that defines every form and label within the database electronically.
  • An exemplary item or form specification sheet is shown in Appendix A.
  • the specification sheet comprises an area for general information such as customer number and product type, an area for usage information such as storage terms and numbering, an area for construction Information such as the number of plies, the paper weight, width and color and grade, an area for fastening information such as location and the type of fastener, as well as for the color of inks used on the form.
  • a menu option within the Forms Management subsystem permits a representative to create an on-screen form using a form design software such as the Perform Pro Plus Forms design software developed by Delrina Technology, Inc. of Canada.
  • a sales representative or customer has the convenience of on-site laser proofs of newly created forms and therefore fast response to user requests.
  • the Forms Management subsystem permits a customer or sales representative to eliminate and consolidate forms, reduce procurement costs and build a foundation for forms automation. For example, a number of fields within the forms specification sheet or within the forms design itself can be stored as a template and used in later specification sheets, forms and labels, thereby reducing the need to re- enter data.
  • the information in the Forms Management subsystem can be integrated with the information of other subsystems to essentially instantaneously determine inventory values, usage trends and to generate custom reports.
  • the Sales Information Network (SIN) 86 comprises a Report Writer subsystem corresponding to button 126 (Fig. 3) which allows for the generation of custom reports using the query tool to access data residing in any of the six subsystems. For example, reports can combine ordering, shipment trend and specification information.
  • Each of the subsystems is designed with an open systems architecture so that each subsystem can work in conjunction with the a query tool and the Custom Report subsystem, as well as with the corporate office information systems (Fig. 2).
  • the information within the network can be exported to other WINDOWSTM compatible programs.
  • the data server 36 at the corporate office 16 maintains the following types of data in the database: item specifications (e.g., for production orders that have been submitted or for estimates that have been generated and require review by corporate office personnel) ; cost data for generating an estimate; contract data; production orders or order-specific information shared between sales sites and plant; and estimate information (i.e, information that is not contained in an item specification, such as the number of printings requested and storage information) .
  • the file server(s) can be configured using, for example, a PC file server, a minicomputer or a mainframe computer. Further, other types of memory devices can be used.
  • the data server 36 is preferably provided with information that can be downloaded to sales sites or plants through, for example, batch processes. This downloadable information can include, but is not limited to, order status, inventory information and validation data.
  • a computer e.g., a personal computer 29 at the corporate office 16 is programmed to operate as or in conjunction with the data server 36 to do the following types of information processing: maintaining cost data and material quotes; reviewing and maintaining estimate matrices; maintaining estimates and item specifications; validating estimates and specification sheets; manipulating and transmitting estimate cost and list price information to sales representatives; producing order entries and maintaining them; conducting profitability analysis, as well as other types of analyses; re-routing production orders on an exception basis; and messaging.
  • information processing maintaining cost data and material quotes; reviewing and maintaining estimate matrices; maintaining estimates and item specifications; validating estimates and specification sheets; manipulating and transmitting estimate cost and list price information to sales representatives; producing order entries and maintaining them; conducting profitability analysis, as well as other types of analyses; re-routing production orders on an exception basis; and messaging.
  • the memory storage device(s) at the sales office 12 preferably store information that is needed only at the local levels such as user information and modem numbers, as well as information that is generated at the local level such as item specification information.
  • the item specification can be for both items that have and have not been transmitted to the data server 36 at the corporate office 16.
  • These sales site memory device( ⁇ ) can also contain information that has been downloaded from the corporate office data server 36.
  • the sales office computers are programmed to generate release orders, to generate and transmit item specifications and requests for estimates, to receive estimate data and convert estimates into production orders, to generate and transmit production orders and to perform messaging.
  • Item specifications, estimates and orders are preferably maintained at the corporate office, as opposed to the sales sites.
  • a sales representative can access the data server 36 to retrieve an existing item specification and corresponding estimates for different quantities and prices of the manufactured item, and to store the data at least temporarily in a local memory, e.g., the file server 66 or in the memory of a laptop computer.
  • the sales representative is no longer working with the data, the data is transmitted to the corporate office for updating existing records or creating new records in the database.
  • the predominantly centralized storage of item specification, estimate and order data is advantageous for the reasons stated above, that is, sales representatives have access to essentially the same data for consistent price quotations. It is also easier to back up data at the corporate office than at each of several distributed sites.
  • the integrity and security of the corporate office data is therefore greater than if the data were stored among several sites without any centralized storage.
  • the corporate office can receive data from several sources (e.g., SIN and MIPS).
  • the estimate data received at each sales representatives' computer can reflect contractual agreements between the manufacturer and a customer.
  • customer data and other data from the corporate office database can be recaptured at the sales representatives' computers to minimize the amount of data that needs to be manually entered when creating an item specification, production order or requesting an estimate.
  • the sales representative can access customer item data stored at the sales site 12. Item specifications, cost data, order data and other information, however, is preferably stored at the corporate office 16 and not at one or more sales sites 12.
  • This arrangement allows for greater visibility of sales representatives' performance than an arrangement wherein sales representatives have cost data necessary to generate an estimate at the sales site and did not have to consult with personnel or use data stored at the corporate office.
  • sales management personnel can use the Report Writer subsystem (i.e., button 126 in Fig. 3) or other system to generate reports indicating estimate and order trends for a particular sales representative using data that is essentially continuously maintained at the corporate office.
  • the system 10 can be configured to do price- based analysis at the sales sites 12.
  • Price-based estimates generally involve adjusting a list price for a base product in accordance with characteristics and features of a custom item to be manufactured.
  • Cost-based estimates are generally more comprehensive because a manufacturing standard cost (e.g., hours of labor, materials cost and other direct manufacturing costs) is increased to compensate for administrative and sales expenses, as well as contingencies and margins.
  • Sales representatives for example, can generate price-based estimates for items that are valued under a predetermined amount using data obtained from the corporate office data server 36, but without having to consult with personnel at the corporate office.
  • the sales representatives can be required to send item specifications for custom items valued over the predetermined amount to personnel at an Estimating department at the corporate office for review and to obtain estimate data therefrom using, for example, cost-based analysis.
  • Each plant 14 can use, for example, a minicomputer 56 to store data that is generally only needed by the plant. A significant amount of this data is generated locally, and some data is transmitted to the plant by a sales site or the corporate office. For example, actual job and production data is generated at the plant and sent to the Labor and Material and Estimating subsystems. Other data at the plant can include, but is not limited to, estimate data, validated item specifications and MIPS planning specifications. Using this data, each plant can maintain productions orders transmitted thereto, validate order specifications, and perform messaging.
  • One or more messaging servers are provided in the WAN to store and forward messages to sales sites 12, the plants 14 and the corporate office 16. Two kinds of messages can be sent via these message servers: (1) free form messages that are human readable; and (2) program interpretable messages.
  • a sales representative typically determines customer requirements for a product such as a business form during, for example, a meeting with the customer, and begins to enter a new item specification into a PC 62 or other computer, or to modify an existing item specification.
  • the PC 62 generates a Login screen (Fig. 5) which permits a sales representative to enter his or her name.
  • the PC 62 is programmed to generate another screen (Fig. 6) which lists the names of that sales representative's customers.
  • the screen in Fig. 5 can be configured with a password to restrict access to customers' records to certain persons.
  • the sales representative can highlight the name of an existing customer (Fig. 6) and access their files using a mouse or a key pad.
  • An “Account Information” screen (Fig. 7) is generated which contains account number, customer address and other Information relating to the account of an existing customer.
  • the sales representative can modify and update this information. If the customer is new, the sales representative can request a blank "Account Information” screen on which to manually enter this information using, for example, the "File” option in the menu pad 117. If the account information is correct, the sales representative can activate the "Ok” button on the screen in Fig. 7 to view the next screen (Fig. 9). Alternatively, the sales representative can select the "Tools" option from the menu pad 117.
  • the sales representative's computer is programmed in accordance with the SIN software to generate a pop-up menu (not shown) listing various tools such as a search or query function.
  • the screen depicted in Fig. 8 allows a sales representative to search the database or data server 36 for a particular specification, proposal, estimate or order by number, name and other attributes.
  • the "Customer" screen in Fig. 9 lists the names of item specifications for custom products which have been designed and produced to date for that customer.
  • the sales representative can activate the "New” button to commence entering a new item specification, or highlight the name of an existing item specification and retrieve it by activating (e.g., using a mouse or a touch pad) the "Open” button.
  • the "New” button is activated, the PC 62 generates the screen depicted in Fig. 10. This screen permits the sales representative to select from two types of product categories, that is, custom products and stock products. If the stock product option is selected, the PC 62 generates one or more screens (not shown) for guiding the sales representative to select type and quantity of stock products and order them for delivery to the customer.
  • the PC 62 If the custom product option is selected, the PC 62 generates a "Custom Product Selection” screen, as shown in Fig. 11, which lists a number of product categories, e.g., business forms, mailers and labels.
  • the "Customer” screen provides the sales representative with a number of options besides "Specs” for entering item specifications, such as “Estimates”, “Proposals”, “Orders” and “Reports”. These options can be selected by activating the corresponding button using a mouse or other input device.
  • Exemplary screens for guiding the sales representative to create a specification for a custom product such as a business form are shown in Figs. 12 through 31.
  • the sales representative's computer (e.g., a PC 62, docked laptop computer 64 or laptop computer 41) initially generates one or more screens entitled "Business Form Base Specification" which prompt the representative to enter the base specifications, that is, the minimum information required to specify the item to be manufactured.
  • the base specification for a business form comprises stub size, overall width, number of plies and an indication of whether the form will be composed of bond and carbon paper or will be carbonless. These fields are preferably blank until the sales representative enters the requested parameters.
  • the representative's computer can be configured, however, to automatically provide default values for these parameters which appear in the fields. The representative can then enter different values in lieu of these default values if desired.
  • the base specifications for other items are different than that of a business form.
  • the base specification screens for these items are therefore different because they prompt the representative to enter information relating to other parameters.
  • the computer After the representative clicks the "Finish” button on the screen in Fig. 12, the computer generates the screen in Fig. 13, which prompts the representative to enter customer item name, number, and revision number if the item is being altered from an existing specification.
  • the sales representative clicks the "Finish” button on the screen depicted in Fig. 13, the computer is programmed to generate the "Specification Summary" screen depicted in Fig. 14.
  • the representative can double click that item in the left column of the screen using a mouse. For example, the representative can double click "Material.”
  • the computer in turn, generates the "Material Base Specification" screen depicted in Fig. 15. The data shown in the screen is automatically provided based on the base specification. The representative can change any of these values as needed by highlighting the "Paper” or “Carbon” in the "type” cell 119 for one of the plies.
  • the computer subsequently generates the "Materials: Paper/Carbon” screen depicted in Fig. 16.
  • the sales representative can enter paper properties or click the tab 121 labeled "Carbon” to enter carbon paper properties on the screen depicted in Fig. 17.
  • the screens are provided with "Ok”, “Cancel” and “Help” buttons 133, 135 and 137, respectively.
  • the "Ok” button be clicked, for example, to return to the screen in Fig. 14.
  • the representative can double click "Composition” in the left column of the screen using a mouse.
  • the computer in turn generates the "Composition Simple” screen depicted in Fig. 18.
  • This screen indicates specifications that can be selected by the sales representative by simply clicking the desired specifications with a mouse, as opposed to entering alphanumerical values with a key pad. If the sales representative wishes to enter more detailed information relating to the composition of the form, he or she can click the tab 123 labeled "Composition Detail".
  • the computer subsequently generates the "Composition Detail” screen depicted in Fig. 19. The representative can then change data in the grid shown using a mouse and key pad.
  • the sales representative can double click "Fastening" in the left column of the screen depicted in Fig. 14.
  • the computer in turn, generates a simple specification screen for fastening entitled “Fastening", as shown in Fig. 20.
  • the representative can enter type and location of the desired fastener simply by clicking a mouse, for example.
  • the representative can also click the tab 125 labeled "Fastening-Detail" to enter more information relating to fastening into the "Fastening and Pocket Detail" screen (Fig. 21) which is subsequently generated by the computer.
  • the SIN software provides a hierarchy of screen formats, that is, base specification screens (e.g., the screens in Figs. 15-17), simple specification screens (e.g., the screens in Figs.
  • Figs. 22 through 31 are exemplary screens for entering specifications for other types of items such as labels, envelopes, roll-type products and items requiring perforations, hole punches or electronic printing.
  • the item type is selected using the screen depicted in Fig. 11.
  • the computer 62 or 64, or laptop computer 41 is programmed in accordance with the SIN software to generate base specification screens (not shown) corresponding to the type of item selected for manufacturing.
  • the screens indicate the minimum specification data required to generate a specification for requesting an estimate for and ordering manufacture of a product.
  • the representative's computer subsequently generates a screen similar to the "Specification Summary" screen depicted in Fig. 14, but corresponding to the type of item selected in the screen in Fig. 11.
  • the computer For example, if a specification for a label is being generated and the representative double clicks "Materials" in the left column of the "Specification Summary” screen (not shown) for a label, the computer generates the screen depicted in Fig. 22, which is analogous to the screen for a business form depicted in Fig. 15. The representative can double click "Printing" in the "Specification Summary” screen for a label in the same manner he can for a business form (Fig. 14). The computer generates the "Ink Detail" screen depicted in Fig. 23 to prompt the representative to enter information relating to ink color and type for each ply.
  • the label specified in the screen depicted in Fig. 22 has two plies.
  • the "Ink Detail" screen depicted in Fig. 23 comprises two columns in which to enter information for the two plies, respectively.
  • a similar "Ink Detail” screen (not shown) can be generated for the exemplary business form described above.
  • the computer generates this screen with three columns in which to enter ink color and type for the three paper plies specified for the business form, respectively.
  • Figs. 24 and 25 illustrate simple and detail specification screens, respectively, for entering information regarding punching, drilling and perforations that may be desired for a custom business form, for example. Accordingly, "Punching" and/or “Perforation” appears in the left column of the "Specification Summary" screen (Fig. 14) for those business forms having these features.
  • Fig. 26 illustrates a review screen for an envelope that is analogous to the screen depicted in Fig. 15 for a business form.
  • the screens depicted in Figs. 27 and 28 are exemplary simple specification screens for an envelope.
  • Fig. 29 illustrates a detail specification screen corresponding to a roll-type item.
  • Figs. 30 and 31 illustrate, respectively, simple and detail specification screens for electronic printing.
  • data is entered into the fields of screens (e.g., the white boxes appearing in the screens depicted in Figs. 15-17) automatically by the computer, which retrieves data from local memory or from the data server 36, or manually by the sales representative using conventional data input devices such as a keyboard or a mouse.
  • screens e.g., the white boxes appearing in the screens depicted in Figs. 15-17
  • Exemplary data has been provided in the screens depicted in Figs. 14 through 21 which also appears in the exemplary item specification in Appendix A.
  • the above- described screens are designed to highlight and/or restrict the user to only those menu options that are available based on previous inputs.
  • the sales site computer preferably validates an item specification being transmitted for an estimate.
  • the validation process prevents the sales representative from selecting features for a custom item that cannot be priced or manufactured. For example, if the sales representative selects a type of item such as a mailer, the screens generated by the PC prompt the sales representative to select features that are valid for mailers, and prevents user selection of features not permitted for this product type.
  • the validation logic for item specifications is preferably controlled at the corporate office.
  • a sales representative can generate several item specifications for the same product. For example, several item specifications can be generated which specify different materials to manufacture the desired product for price comparison purposes. These item specifications are then used generate a number of estimates. The sales representative can select a subset of these item specifications and their corresponding estimates and store them as proposals using the "Proposal" option in Fig. 9. These proposals contain the estimates that the sales representative wishes to present to the customer.
  • Sales management personnel at the corporate office 16 or a sales site 12 or other authorized personnel can calculate an estimate conversion ratio, that is, the number of proposals submitted to a customer that are eventually transformed into an order, or download proposal and order data to a corporate office computer 29 to calculate the estimate conversion ratio. This data is useful to monitor sales representatives' performance and to identify products which have a poor or low estimate conversion ratio, among other uses.
  • the simple and detail specification screens are * provided with "Ok" buttons 133 such as those on the screens depicted in Figs. 28 and 30 which return the representative to the "Specification Summary” screen when clicked using a mouse, for example.
  • a sales representative has finished reviewing a simple or detail specification screen (e.g., the simple and detail specification screens depicted in Figs. 18 and 19)
  • he or she can return to the "Specification Summary” screen (e.g., the screen depicted In Fig. 14) by clicking a button 131 on the screen.
  • the computer is programmed to generate a drop- down menu (not shown) in a manner conventional to WINDOWSTM applications, which provides the option of closing the screen to return to the "Specification Summary” screen.
  • the sales representative need not create or modify an item specification and then activate the "Estimate" icon 127 for the purposes of obtaining an estimate. He can select one of the "Estimate", “Proposals", “Orders” or “Reports” buttons without first entering data Into specification screens (e.g., Figs. 10 through 31). For example, the sales representative can highlight the name of an existing item specification from among those listed in Fig. 9 and activate the button corresponding to the "Proposals" option to retrieve a corresponding proposal from a memory device (e.g., file server 66).
  • a memory device e.g., file server 66.
  • the sales representative can activate the button for the "Estimates” option.
  • the PC 62 or laptop computer 64 or 41 is programmed to generate the screens depicted in Figs. 32 through 35.
  • items for which specifications have been created and stored for a particular customer appear on the screen, along with other information retrieved preferably from the database by the data server 36 such as contract number and zip code.
  • a sales representative selects the item for which an estimate is desired by highlighting the appropriate item and clicking a mouse, for example, or depressing a key on a keyboard.
  • the sales representative's computer generates an "Estimate Detail" screen, as depicted in Fig. 33, which displays at least one column of information.
  • the column comprises values for a number of parameters which can affect a cost estimate for a particular item such as item number 123456. Two or more columns can be entered by the representative to determine how cost is affected when different parameters are considered.
  • a sales representative can determine how much of a concession (i.e., price reduction), if any, he or she can offer a customer as the result of increasing the quantity of the item ordered or changing terms for storage, for example.
  • a "Transmit” option can be provided in the drop-down menu (not shown) corresponding to the "Tools” option in the menu pad 117 of Fig. 14.
  • the item specification, estimate header and estimate detail information is transmitted via the WAN (e.g., routers 68 and 52, or the X.25 communication line and the RLA Gateway 40) to the corporate office to obtain estimate data.
  • the corporate office computer system is programmed to validate the item specification.
  • the corporate office maintains various types of data such as material costs, pricing factors, estimate data, contract data, and valid specification data, as well as specification costs and parameters.
  • Material costs and specification costs are generally updated and maintained by the Purchasing and Industrial Engineering departments of a manufacturing plant. For example, personnel in these departments are generally responsible for supplying data relating to material costs, material quotes, labor and burden costs to the data server 36.
  • a Estimating or Industrial Engineering department is preferably used to maintain estimate parameters such as the pricing parameters and valid specifications.
  • an Estimating department and an Operations and Sales department can be used to obtain and enter into the data server 36 data such as price inflators and deflators, mark-ups, and contingency factors which can affect specification values and pricing parameters.
  • the validation process, block 144 involves cross- validating a selected item-type such as a business form against an item specification to ensure, for example, that a fastener was not ordered for a single ply-type business form.
  • the selected item-type can be validated against an item specification to ensure that the appropriate materials were selected and that the correct die information was entered.
  • Validation of the specification can comprise field-level edits and cross-validation.
  • item specifications sent to the corporate office to obtain estimate data can also be validated or reviewed because they are for a particular customer, are estimated to cost more than a predetermined amount (as described below in connection with block 150) or are for a particular type of product that is not selling well, for example.
  • Software for the corporate office computers can be created to automatically review incoming item specifications to identify item specifications meeting certain search criteria such as customer name and cost and/or list prices within certain ranges of values.
  • the item specifications and/or estimates meeting these criteria can be required to undergo review by a person. This is advantageous when customer relations require application of concessions to cost, or extra precautions to minimize estimate amounts or production mistakes. Estimates above a certain amount can also require review to ensure that the cost of an item that is complicated and therefore more difficult to manufacture is not underestimated.
  • estimate generation incorporates data relating to the number of manufacturing processes of a job (e.g., imaging for producing color forms), waste matrices, effectivity dates for list price, set-up burden rates by a logical machine type within a division, material charges, among other data.
  • the estimating data is maintained by the Estimating subsystem 90 (Fig. 2).
  • an estimate can be prepared using one or more tables or matrices which can be generated, for example, using a spreadsheet-type software program (e.g., LOTUS or EXCEL or custom developed software), and which use the product type, different form features, and quantity indicated in the item specification, among other data, to generate cost and list pricing information.
  • a spreadsheet-type software program e.g., LOTUS or EXCEL or custom developed software
  • These matrices preferably reside in the Estimating subsystem 90.
  • the sales representative uses cost and list pricing information to determine a sell price for the manufacture of a custom form. Pricing information for stock items (e.g., telephone message pads or pads of lined paper that can be used by anyone) can also be generated using price matrices.
  • the matrices preferably comprise standard cost Information which can be generated using the Labor and Material subsystem 94 or the Estimating subsystem 90.
  • the Estimating subsystem 90 can be used to do some calculations using the matrices, or the matrix information can be transmitted to the sales site where calculations are executed. In either case, important pricing information is first obtained from the Estimating subsystem 90 before a sell price is determined therefrom and presented to a customer, in accordance with the present invention.
  • This realizes a number of advantages for the present invention. This provides corporate office personnel some control over sales representatives' sell price quotations to ensure that products are not undervalued, that estimates for similar products are consistent and that estimates reflect concessions made to customers. As stated previously, the integrity of the pricing information is ensured when it is updated in a central location; otherwise, pricing information distributed among several sales sites may not be updated consistently. Sales sites would therefore be determining price from different matrices.
  • the Estimating subsystem 90 can generate an estimate for an item that is to be priced in accordance with a contractual agreement between the customer and the corporation.
  • contract price matrices can be generated to reflect contractual terms.
  • Contract price matrices can be created as a subset of the standard or generic price matrices used to generate estimates for non-contract items.
  • the generic price matrices can be used for estimating any customers' orders.
  • the generic price matrices are generally based upon raw material prices, equipment and other factors that affect actual cost to fulfill an order.
  • a custom price matrix can include contractual concessions between the forms manufacturer and the customer resulting in prices below, for example, the standard prices, i.e., discounts for the volume of business the customer brings to the manufacturer.
  • contract price matrices support contract proposal generation by corporate personnel in, for example, a Contract Administration department of the corporation by developing matrices of multiple items. This is particularly useful when the corporation is offering concessions to a customer with a large number of existing forms.
  • the contract matrices eliminate the need to perform an estimate for each form for contract proposal purposes. Since contract terms are stored at the corporate office, corporate personnel can perform contract profit and other types of analysis, and provide contract customers with a common reference for pricing.
  • the present invention provides for the review and maintenance of estimates based on user-defined parameters, for the generation of list price promptly after a request for an estimate is made (provided the estimate does not require review), for the generation of a new list price and a repeat list price for estimates of new items, and for messaging back to the sales representative to inform him to which department an estimate is being routed should the estimate require review by corporate personnel.
  • Batch validation of an item specification and estimate for the mailer allows corporate office personnel to review the estimate and make changes as needed. Batch validation also allows estimates for strategic customers or which exceed a predetermined dollar amount to be identified for review. Following estimate review, the corporate office personnel responsible for reviewing estimates can enter and maintain notes on estimate and production orders and maintain item specifications. These corporate office personnel have the advantage of being able to maintain contingency and mark-up factors on an individual estimate basis, as well as being able to devise flexible exception criteria for estimate review notification. In addition, corporate office personnel can enter recommended and/or minimum sell prices. With continued reference to block 150, review of an estimate is an iterative process. If the corporate office determines that an estimate is unacceptable, item specifications can be changed, as indicated by the affirmative branch of decision block 151 and block 152. For example, a less expensive grade of paper can be used or a larger quantity of forms can be ordered. An audit trail can be created for revised estimates to document changes.
  • an estimate that does not require review, or a validated estimate is transmitted back to the sales representative via the WAN connecting the sales office to the corporate office.
  • the estimate information is recaptured by the computer (e.g., PC 62 or 64, or laptop computer 41). At least part of the recaptured information is automatically displayed on the computer monitor in the format of the "List Price Summary Recapture" screen (Fig. 34).
  • the estimate information recaptured at the sales site preferably comprises cost and list price, recommended or minimum sell price where appropriate, order quantity, item specifications, and freight and storage information.
  • the "List Price Recapture" screen provides list price information for the first order of the desired custom product and the list price information for repeat orders, which are generally subject to discount pricing.
  • the list price is preferably broken down to separate elements such as specifications and materials.
  • the sales representative has access to alternate information such as price and quantity breaks, alternate materials, alternate specifications and minimum material requirements.
  • the sales representative also has the ability to print out the estimate.
  • the sales representative has the option of revising the estimate or simply obtaining multiple versions using different materials, quantities, and so on.
  • a parameter filter is provided for changed or revised estimates for a parameter-controlled filtering of changed or revised specifications.
  • a sales representative can activate the "Ok” button 133 to close the screen.
  • the computer then generates a "Sell Price Calculator" screen, as depicted in Fig. 35.
  • the sales representative uses the list price from the screen depicted in Fig. 34 to determine a sell price, taking into account other factors such as concessions, as shown in block 158. Once the sell price is determined, the sales representative can close the screen depicted in Fig.
  • the PC 62 is programmed to display the screen depicted in Fig. 9.
  • the sales representative Before generating a production order, the sales representative preferably enters information regarding usage of the item to be manufactured into usage screens (e.g., screens depicted in Figs. 36 through 40).
  • the usage screens are generated by the PC 62 or laptop computer 41 or 64 following selection of a "Usage” option in the drop-down menu associated with the "Tools" option in the menu pad 117 of Fig. 14.
  • the usage screens are advantageous because they allow some degree of validation of the manufacturability of the ordered item before the order is sent to the plant. Usage screens vary depending on the type of item for which they are used. For illustrative purposes, the usage screens depicted in Figs. 36 through 40 are for a business form.
  • the screens comprise different types of processes and after-handling equipment that a customer uses on or with the ordered product once it is shipped and received.
  • the sales representative can enter the type of burster or printer used with a form or indicate that the form is to be written on using a No. 2 lead pencil for computerized tabulation. By viewing this screen, the sales representative can review the order for quality control.
  • the selected paper type may contain a coating that cannot be satisfactorily used with No. 2 lead pencils or the customer's printer. The sales representative can therefore recognize potential problems with the order before it is sent to the plant, thereby eliminating time wasted because the plant has rejected an order.
  • the sales representative determines sell price from the estimate data and reviews the proposal with the customer.
  • the customer can request a production order from an estimate which is found to be acceptable.
  • the sales representative can use the PC 62 to automatically extract information from the estimate and add detail to generate a production order.
  • the conversion of an item specification and estimate data into a production order minimizes the re- entering of previously captured information.
  • the sales representative can also enter sell price (or reference contract pricing matrices, if appropriate), ship date, the production plant, as well as the identification of any supporting documentation.
  • the production plant can be automatically selected by the mainframe computer 18 or selected by corporate office or sales office personnel.
  • the sales representative's computer is programmed to generate a number of screens for generating an order such as those screens depicted in Figs. 41 through 44.
  • "Order" icon can be provided in the tool bar 129 in Fig. 14 or an "Order” option can be provided in the drop-down menu associated with the "Tools" option in the menu pad 117.
  • the first screen generated by the PC 62 or laptop computer 64 or 41 is preferably the "Sales Order Header" screen depicted in Fig. 41.
  • the sales representative can provide the shipping information.
  • the customer information is preferably automatically provided by the computer, which retrieved the data from local memory or from the data server 36.
  • the sales representative's computer is programmed to generate the "Production Order Detail" screen depicted in Fig. 42 after the "Ok" button 133 is activated on the "Sales Order Header” screen.
  • the "Production Order Detail” screen is configured to automatically display a number of list and sell prices in respective columns for the customer item number selected using the screen depicted in Fig. 9. For illustrative purposes, only one sell and list price is shown for the item number 123456 displayed in Fig. 42.
  • the identification numbers of the proposal and estimate used to calculate the displayed list price are automatically provided by the computer.
  • the sales representative can enter another item number, proposal number or estimate number using a keyboard. The sales representative selects one of the columns in
  • Fig. 42 by highlighting the desired column and activating the "Select Item” button.
  • the PC 62 is programmed to generate a number of screens for guiding the sales representative to enter additional information in the item specification that was not required to be entered previously for the purposes of obtaining an estimate. Thus, the amount of information the sales representative needs to enter to generate proposals and ultimately orders is minimized.
  • these screens can include a "Marginal Words” screen (Fig. 43) and a "Concessions Approval” screen (Fig. 44).
  • each computer at the sales office and each laptop computer 41 preferably operates in accordance with the SIN 86 to validate production order details, as well as cross-validate selected items with reference to the production order details.
  • the sales representatives' computers are also programmed to determine whether or not a customer has a contract with the manufacturer, to ensure the customer has a favorable credit status and to check for a concession percentage.
  • the SIN 86 also stores in memory a version of the estimate used to produce the production order as part of an audit trail.
  • the sales representatives' computers are further programmed to prevent expired estimates from being converted into production orders, to ensure that each production order is linked to a particular estimate unless the order is the result of an outside purchase, as well as to check for concession percentage level. The latter feature enables sales management to be notified when acceptable concession levels are disregarded.
  • the validated production order is preferably sent electronically to the corporate office, along with copy folder information comprising the image of the form or label via the WAN (e.g., the routers 68 and 52, or the RLA Gateway 40), as shown in block 168.
  • This is done using, for example, a "Confirm” button (not shown) on the screen in Fig. 41 or a "Transmit Order” option In a drop-down menu associated with the "Tools" option in the menu pad 117 (Fig. 9).
  • These items can also be sent via regular mail, or by facsimile or other digital data transmission technique.
  • the SIN is configured to provide the sales representative with a message (e.g., in a pop-up box or status window on the sales representative's monitor) confirming that the order was sent and the name of the destination plant.
  • plant computers are configured to transmit a message via the WAN acknowledging that the order was received. Similar messaging occurs at the corporate office when, for example, an estimate cannot be generated immediately. The sales representative is notified that estimate review is required and given the option to proceed with the review or to cancel the request for estimate data using a button generated within the status window or message pop-up box.
  • the sales representative can use the Forms Management subsystem 124 to design a new form in addition to entering information for an item specification.
  • This form can be electronically transmitted along with the item specification and a request for an estimate to the corporate office. While transmission of this data is preferably downloaded from a PC 62 or laptop computer 41 or 64 onto a digital communication line, the data can also be printed on a laser printer connected to the network 60 and transmitted via regular mail or by facsimile.
  • production orders can be reviewed by production management personnel who review plant and equipment utilization and have the option to override the plant entered by the sales representative, as well as enter an override reason. Thus, inquiries on production orders can be made on an exception basis.
  • a production order which does not require review, or which has been found acceptable upon review by production management personnel is subsequently transmitted electronically to the plant.
  • the MIPS at the selected plant In turn places the production order in a queue for planning purposes by the Planning Bill of Materials subsystem 102.
  • the Planning Bill of Materials subsystem 102 audits the estimate, that is, checks item specifications.
  • the plant personnel can make the changes and notify the sales representative, as shown in blocks 182 and 184. If the plant does not require changes in the production order, the order is manufactured, as shown in block 186. As indicated in block 188, the completion of the job is reported to the Labor and Material subsystem 94 and the Estimating subsystem 90 for actual cost analysis and reporting, as well as to the sales site to keep the sales representative apprised of the status of the order.
  • the screens in Figs. 45 through 53 can be generated on a mainframe terminal, for example, to guide contract management personnel at the corporate office when entering information for the creation of contract price matrices and generating a hard copy of a custom price matrix.
  • Exemplary custom price matrices are depicted in Appendices B and C.
  • the contract information entered using the screens is processed to extract a subset of the generic price matrices which are pertinent to a particular customer, as indicated in Appendix C.
  • a user is prompted to enter general information in the following, correspondingly named fields: ACTION, PRODUCT TYPE, STANDARD CONTRACT SCHEDULE,
  • a first menu 252 is provided at the top of the screen for generally editing and making inquiries as to a particular contract or a particular contract price matrix.
  • Another menu 254 is provided at the bottom of the screen which comprises such functions as viewing the next page of a screen, viewing the next screen or printing a particular contract price matrix.
  • the menu 252 at the top of the screen is hierarchical in nature because it provides the same options to make inquiries about ("I"), change ("C") or delete (“D”) a currently stored contract, contract price matrix, or a particular entry within the contract or matrix. Further, the user can add (“A") a new contract, contract price matrix or entry within the contract or contract matrix.
  • the user can depress a key on the keyboard to: (1) display a table menu on the screen; (2) advance to the next screen; (3) return to a prior screen; (4) move forward or (5) backward among the multiple pages that compose a screen; (6) specify more widths; and (7) print a schedule, among other functions.
  • the functions assigned to keys on a keyboard can vary depending on the screen.
  • the STANDARD CONTRACT SCHEDULE field is automatically filled with a unique identification number when using the ADD or "A" menu option.
  • the contract schedule number along with the customer's name and the product type, appear at the top of the exemplary matrix (Appendix C) .
  • the STANDARD CONTRACT SCHEDULE field refers to the standard price-based schedule used as the basis for selection for the contract price matrix being created. This field defaults to the current price schedule being used unless the user enters the number of another prior price-based schedule. The value in this field is the default value for the same field in subsequent screens.
  • the PRICING FACTOR and the EFFICIENCY FACTOR fields are provided with values by the user which also serve as default values for subsequent screens.
  • the PRODUCT TYPE field is provided with one or more values that is obtained from the corporate office.
  • the data server 36 maintains a look-up table of unique identification numbers for each product offered for sale to customers, including forms, labels and other items produced at the plants, and ready-made items offered for resale. This value is a default value in subsequent screens.
  • the screen depicted in Fig. 46 prompts the user to enter one or more desired widths for each product type that can be priced using the contract price matrix being created.
  • composition pricing such as ACTION, STUB LENGTH, and PLY NUMBER.
  • the standard base composition charge is retrieved from one of the generic price matrices.
  • the exception base composition charge is calculated by multiplying the PRICE and/or the EFFICIENCY FACTOR, if previously entered, by the standard base composition charge.
  • the base composition charge is shown at the top of the exemplary matrix in Appendix C. Prices for additional charges and rules, set-up and run charges, and other factors can be added to this base, pre-press price.
  • the user also has the option of entering special composition rules to retrieve selected prices from a database of general price-based rules maintained at the corporate office. As shown in the exemplary matrix in Appendix B, these rules can include, for example, pricing variances due to changes in the composition, heading changes, and printing on the back of a form.
  • Fig. 48 depicts a RULES SELECTION screen generated by the mainframe computer to prompt a user to invoke or delete a rule.
  • the rules aid in the process of selecting data from the general price matrices that best suits a particular customer and contract terms.
  • the rules can be stored in a look-up table in the database at the corporate office in accordance with their numbers and corresponding reference names. Rules are entered on the screen in Fig. 48 by their number and reference name, or another name assigned by the user. The screen thereafter serves as a reference or list of rules indicating the rules employed for that particular custom price matrix.
  • An initial rule selection using the RULES screen allows the user to operate at the rule level, that is, the user is provided with a complete list of rules from which the user can select a list of potentially applicable rules by typing a "H" or a "D", respectively, in the left margin of the rule entry line.
  • the second selection process using the RULES screen is at the sub-rule level of the rules selected initially.
  • rules selected from the list of potentially applicable rules are transferred to the rule entry screen through which the RULES screen was invoked, i.e., the COMPOSITION PRICING, SET-UP PRICING and ADDITIONAL CHARGES screens.
  • the RULES screen need not be invoked If the user already knows the subrule numbers needed to prepare the contract pricing matrix. With reference the screen depicted in Fig. 49, the
  • Set-up prices cover the cost of preparing plant equipment to complete a particular job. For example, special equipment or equipment configurations may be required to create a form that has perforations and requires printing on both sides thereof.
  • the standard base set-up charge is retrieved from a generic priced-based matrix.
  • the exception base set-up charge is calculated based on the standard base set-up charge and the PRICING and/or EFFICIENCY factors.
  • Set-up rules can also be used to retrieve prices from the general price base rules database using the RULES SELECTION screen depicted in Fig. 48. As shown in the exemplary matrix of Appendix B, these rules can include additional colors, back printing, copy and color ink or paper changes, perforations, and hole punching and collating charges.
  • a RUN CHARGES screen (Fig. 50) is generated for the user to enter general information for developing run charges.
  • Run or running charges comprise charges for running or processing paper through a press for printing, hole punching, or folding, for example, collating the various plies of multiple ply forms together, packaging, and otherwise preparing the forms for shipment.
  • Running charges can also include charges for materials such as paper, carbon, ink, and cartons.
  • Running charges are generally expressed in terms of multiples of forms, i.e., "per 1,000" or "per M”.
  • the values in the CONTRACT SCHEDULE, STUB LENGTH, PRODUCT TYPE, PLY NUMBER, PRICE FACTOR, EFFICIENCY FACTOR AND WIDTH fields are carried over from previous screens.
  • Standard run charges are retrieved from the general price matrices and can be multiplied by PRICE and/or the EFFICIENCY factors to calculate exception run charges.
  • the ADDITIONAL CHARGES screen depicted in Fig. 51 prompt a user to enter general information for developing additional charges to be reflected in a contract price matrix.
  • Standard flat charges and run charges are retrieved from the generic price rules database and are used with the PRICE and/or EFFICIENCY factors to calculate exception flat and run charges.
  • Rules can also be used to retrieve prices from the general price base rules database using the RULES SELECTION screen depicted in Fig. 48. As shown in the exemplary matrix of Appendix B, these rules can modify prices in order to charge for ink matching, shrink wrapping and trimming.
  • the VOLUME DISCOUNTS screen prompts a user to enter general Information for establishing volume discounts in the contract price matrix under development.
  • the user can create discounts based in dollar value and quantities of items ordered.
  • the exemplary matrices of Appendices B and C show pricing discounts based on the quantities ordered.
  • the MATERIAL UPCHARGES screen prompts a user to enter general information for establishing material upcharges in the contract price matrix under development in fields such as the ACTION, WEIGHT, COLOR, GRADE and IMAGE fields. The remaining fields contain values carried over from previous screens.
  • the standard upcharges are retrieved from a general price- based matrix and used with the PRICE and/or the EFFICIENCY factors to calculate exception upcharges.
  • the standard contract schedule specified in the first screen which is maintained by the Estimating subsystem 90, has information selected therefrom in accordance with the parameters defined by the fields in each of the above screens.
  • the selected data for a contract matrix is subsequently stored in the database as a contract schedule or matrix, which is similar to the standard price matrices, and maintained by the Estimating subsystem 90.
  • the contract pricing matrix can be condensed and printed on both sides of a form preferably using a laser printer connected to the corporate office PC network or LAN.
  • a number of Estimating offices can be connected to the corporate office network 24 using a router in much the same way as the sales offices and plants.
  • These Estimating offices can use an on-line system via the LAN 24 to receive estimates from sales offices and to review and revise them.
  • the Estimating offices provide for more timely responses to requests for estimates from sales offices than the corporate office because they are dedicated to this purpose.
  • the Estimating offices store in computer memory the following types of information: estimating logic information, estimate specifications and valid specifications.
  • the Estimating offices can perform a "help desk" role in that they can focus on larger and more unusual estimates than the corporate offices handle. In general.
  • Estimating offices maintain estimates and specifications, valid estimate specifications, transmit specifications to the corporate office and to the sales offices, receive price information from the corporate office database, review and maintain an estimate filter and perform messaging. While certain advantageous embodiments have been chosen to illustrate the invention, it will be understood by those skilled in the art that various changes and modifications can be made herein without departing from the scope of the invention as defined in the appended claims.
  • WIDTHS r? -C-r11' » (i 1/8 — * f-_7- — 1-1-5/-- 240.00 240.00 265 * 00 240*00
  • PRODUCT TYPE CUSTOM CONTINUOUS
  • PRODUCT TYPE CUSTOM CONTINUOUS
  • PRODUCT TYPE CUSTOM CONTINUOUS

Abstract

A system and method for generating specifications, estimates and orders for the manufacture of custom items such as business forms is provided which stores estimate data at a central location, e.g., a corporate office (10), for access by sales representatives at remote sales sites (12). A sales representative creates an item specification for a form to be manufactured and electronically transmits it to the corporate office to obtain estimate data. Data relating to the cost and list price to produce the form based on the item specification is transmitted to the sales representative. The sales representative determines a sell price from the pricing data, and generates a production order using the item specification and the estimate data, among other data. The production order is transmitted to a manufacturing plant (14) for job execution. The system manages a centralized repository of item specification, estimate and customer contract data, among other types of data, for analysis and reporting which can be accessed by computers at the corporate office(s) and different manufacturing plants and sales sites.

Description

CUSTOM PRODUCT ESTIMATING AND ORDER PROCESSING SYSTEM
This application is a continuation-in-part of U.S.
Patent Application Serial No. 08/298,274, filed August 31, 1994, which is a continuation-in-part of U.S. Patent Application Serial No. 08/295,385, filed August 24, 1994. The entire subject matter of both of these patent applications is hereby Incorporated herein by reference for all purposes.
Field of the Invention
The invention relates to a computer-based system and method for estimating and ordering the custom manufacture of an item such as a business form.
Background of the Invention
Most businesses and other types of organizations rely on a large variety of consumable products such as forms, labels, diskettes, computer paper and computer supplies to collect, store and distribute important information. These organizations can benefit from a comprehensive management system for these information-processing products which can include on-screen form and label design, database management, inventory management, and automated entry of orders and other types of data.
Manufacturers of business information products such as forms and labels generally employ a number of sales representatives located both at the corporate office(s) and offices remotely located therefrom. The sales representatives interact with customers, that is, businesses requiring office supplies such as forms and other products for recording and distributing business- related data, to determine the format and content of a form, label or other product which best suits the customers' data collection and management needs. Following form design, the sales representative generates an order to specify the number of forms to be printed, form size, paper quality, ink color, print type, number of plies, requested shipping dates, and fastener type, among other information. Order generation is typically a manual process for the sales representative. Thus, the customer interaction process can be arduous and time-consuming because of the multitude of options that are considered when designing and ordering a form. After a detailed order is created, a sales representative typically forwards the order electronically or by regular mail to a plant. If the order is large, it can be processed at the manufacturer's corporate office to select, from among a number of manufacturing plants co- located with or remotely located from the corporate office, the best equipped plant to fulfill the order. The order is then forwarded to the selected plant, which manufactures and ships the product in accordance with the specifications in the order. The corporate office generally also performs accounting functions to bill the customer for the manufactured products.
The manner in which an order is generated and processed can vary depending on the business forms manufacturing system. In some systems, the form design and ordering process is done manually by a sales representative, that is, the content of the form and the order are written by the sales representative or customer on paper or electronic forms designed for these processes. The sales representative typically determines the sale price based on data in a pricing manual or available in the memory of a computer. After the representative enters the sell price onto the ordering form, the representative submits the form and the completed order to the manufacturer's order receiving office by facsimile or mail.
Another type of business forms manufacturing system automates the design and ordering of forms by the remotely located customer or sales representative. The system is organized in essentially the same manner described above. It comprises a manufacturer's computer at a central corporate office which communicates with several remote customers' or sales representatives* personal computers (PCs), and computers at the production facilities or plants. The form is designed on a remote PC using a form design software program. The form parameters are automatically transferred to a second software program for ordering, which permits a user to enter additional parameters such as order quantity and delivery information. The PC proceeds to complete the order by automatically calculating price in accordance with the entered parameters and the ordering software. The form and the completed order are subsequently simultaneously transmitted in machine format (i.e., electronically or on disk by mail) to the manufacturer's computer, which confirms the order and determines the best printing facility or plant. The order and form are finally transferred electronically to the selected printing facility.
To compete with other manufacturers of paper and electronic business forms, manufacturers seek to improve their form design and ordering systems and therefore their sales transactions with customers by improving the accuracy of cost and/or list price calculations, and reducing the paperwork and the time spent by sales representatives when performing price estimation and order entry. As explained above, one way manufacturers seek to improve their ordering systems is to automate the ordering process by including automatic price calculations at the sales representative's remote computer. These price estimates, however, are problematic because the sales representatives' computers may not be equipped with the most recent pricing data. Pricing data changes frequently due to a variety of factors such as variable material and labor costs. These changes need to be downloaded regularly to the sales site computers. This can result in inconsistencies in the price estimates calculated by different sales representatives.
For the above reason, among others, predominantly centralized storage of pricing information and consultation between a remote sales site and the manufacturer's corporate office during cost estimation is advantageous. The centralized storage of information also allows for flexibility in pricing to reflect, for example, pricing agreements between certain customers and the manufacturer. Further, the stored pricing data can be continuously updated with data received from different sources, such as manufacturing plants, which can monitor and report actual job and material costs to the manufacturer. Consultation with the corporate office for centralized storage of cost data eliminates the problem of having to continuously update the data at the sales representative's site in order to keep all representatives apprised of the same pricing information.
While it is possible for the remote computer to access the central database information in order to perform the estimate calculation itself, it is more advantageous for estimate calculation to be performed at the headquarters and then forwarded to the sales site because pricing data and algorithms can be proprietary and, therefore, are best kept for security reasons at a central location for security reasons. Further, centralized storage of price data preserves the integrity of data better than if it were distributed to each of the remote sales computers. Accordingly, a centralized storage system for price data requiring consultation between the different sales representatives and the corporate office system promotes more consistent estimates from the sales representatives.
A disadvantage to calculating price entirely at the sales site, that is, without requiring the exchange of any pricing data with the corporate office during the estimation process, is the lack of corporate office control over the list price offered by the sales representative to the customer. Such control may be desirable for a number of reasons. For example, simple forms such as one-sided, single-ply, carbonless forms can be priced in a relatively straightforward manner at the sales site, provided the material and form feature cost tables consulted by most forms manufacturers for pricing are updated. The equipment set-up time, run speeds and labor required for these types of manufacturing jobs are generally known and factored into the tables. Complicated forms (e.g., multi-ply forms with carbon papers and various perforations and fasteners or hole punching requirements) that are priced using these tables, however, are more likely to be underpriced because slower equipment run speeds, longer set-up times and other factors were not taken into consideration when generating the tables. These other factors can include, for example, the ability of different plants to perform the desired manufacturing processes, and customer and/or manufacturer item-specific contract data. By involving the corporate office in the estimation process, these factors can be taken into account when appropriate. Even when complex forms are not involved, the corporation may simply wish to have corporate office personnel review a sales representative's estimate, for example, because a proposed job exceeds a certain sell price, or involves a new or highly valued customer. Further, previous estimates that are stored at the corporate office can be used for operations and sales administration purposes. For example, previous estimates can be analyzed to locate which potential customers have been approached by a sales representative, to perform analysis such as determining how many estimates mature into product orders, and to determine which sales representatives deserve rewards for their successful endeavors or require additional training and incentives to improve their performance.
Another disadvantage to a number of existing business form manufacturing systems is that a sales representative is required to enter certain information twice, that is, once to specify an item to be manufactured and to get an estimate, and a second time to place an order. Summary of the Invention
The order processing system of the present invention overcomes many of the limitations of known business form manufacturing systems, while also realizing a number of advantages over such systems. In accordance with one aspect of the invention, a sales site computer is programmed to facilitate the entry of design parameters for creating a form and estimate parameters to obtain estimate data from a manufacturer's corporate office, and to store these parameters for later use in a production order. Computers at the sales site, plant and corporate office locations are networked and are programmed in a manner which maximizes the integration of different software systems and therefore the ability to share data (e.g., parameters relating to an item specification, and data relating to the customer) between the various components of the system of the present invention. The amount of information the sales representative or customer re-enters during the creation of a production order is therefore minimized. Further, specifications for an item order are captured in a memory device and can be used for repeat orders.
In accordance with another aspect of the present invention, a computer and a database are provided at the manufacturer's corporate office for storing standard cost tables and calculating cost and/or list price estimates based on the tables and the item specifications and estimate parameters, which were entered by a sales representative or customer at a remote sales site and transmitted, preferably electronically, to the corporate office.
In accordance with still another aspect of the present invention, custom price matrices are created to generate customer-specific estimates in accordance with a contract agreement between the manufacturer and the customer. Further, the corporate office computer and database are configured to manage contract information by maintaining contract parameters on-line, and monitoring contract performance and compliance using system analysis and reporting.
Brief Description of the Drawings
These and other features and advantages of the present invention will be more readily apprehended from the following detailed description when read in connection with the appended drawings, in which:
Fig. 1 is a schematic block diagram depicting corporate office, sales and plant hardware subsystems in a product specification, estimating and order processing system constructed in accordance with an embodiment of the present invention;
Fig. 2 is a functional block diagram depicting software subsystems associated with the corporate office, sales site and plant depicted in Fig. 1;
Fig. 3 depicts a computer monitor screen generated by the sales information network software employed at the sales site of Fig. 1;
Fig. 4 is a flow chart illustrating the process of creating an item specification, obtaining an estimate, converting the item specification into a production order, and forwarding the order to a plant in accordance with the present invention;
Figs. 5 through 31 depict computer monitor screens which are generated to prompt a sales representative or other user to enter item specification information;
Figs. 32 and 33 depict computer monitor screens which are generated to prompt a sales representative or other user to enter information to obtain an estimate; Fig. 34 depicts a computer monitor screen which is generated to provide a sales representative or other user with estimate data;
Fig. 35 depicts a computer monitor screen which is generated to prompt a sales representative or other user to calculate sell price using estimate data;
Figs. 36 through 40 depict computer monitor screens which are generated to prompt a sales representative or other user to enter item usage information; Figs. 41 through 44 depict computer monitor screens which are generated to prompt a sales representative or other user to enter information for generating a production order; and
Figs. 45 through 53 depict computer monitor screens for prompting a user to enter information used for the generation of a contract price matrix.
Detailed Description of the Preferred Embodiment
Fig. 1 depicts a product or item specification, estimating and order processing system 10 constructed in accordance with the present invention. For illustrative purposes, the system 10 will be described for specifying, estimating and ordering the manufacture of custom business products such as business forms, promotional graphics, labels, mailers and envelopes, as well as commercial printing on paper, containers and other surfaces. It is to be understood, however, that the system 10 can be used to specify, estimate and order the manufacture of other types of items. The order processing system 10 comprises one or more sales offices or sites 12 (which may be dedicated offices or simply desk top computers operated by sales representatives at the customers' offices), and one or more manufacturing plants 14, which are both connected to at least one corporate office 16 by communication links as described below. In general, the sales offices and plants are remote, although they can be co-located with the corporate office. The computer-based systems at the corporate office 16, the sales site 12 and the plant 14 and their interconnecting communication links collectively form a wide area network (WAN) .
The corporate office 16 comprises at least one computer for performing a number of processes, and coordinating the activities of other computers located at the corporate office and remote locations (e.g., the sales sites and plants) in performing these processes. The processes include, but are not limited to, tracking inventory at both a corporate storage site and a customer storage site, accounting, purchasing, managing customer contracts, and determining labor and actual material costs to produce orders. For illustrative purposes, the corporate office 16 can comprise an IBM 3090 mainframe computer 18 connected to a number of mainframe computer terminals 20, which communicate with the mainframe computer over dedicated digital lines via a communication controller 22. The communication controller 22 also connects the mainframe computer and the mainframe terminals to a data communications network 24 such as a local area network (LAN). Another communication controller 26 can also be provided to connect leased telephone lines from terminals (not shown) through the mainframe computer to the LAN via a router 52.
A minicomputer 30 and a number of associated minicomputer terminals 32 are connected to the LAN 24 for corporate development purposes. An electronic mail server (e.g.. E-mail) 34 supports messaging within the corporate office, as well as with terminals and computers at sales sites and plants. At least one data server 36 is provided to support estimation and order entry applications by allowing remote computers to access a database of shared data and program files which is maintained at the corporate offices and described in further detail below. A Remote Local Area Network (LAN) Access gateway 40 or RLA gateway is provided to permit X.25 communication protocol dial-up connections between sales representatives conducting business outside of a sales office (e.g., on a desk top computer) and the LAN 24. Other communication links and protocols (e.g., a dial-up frame relay, and ISDN), however, can be supported via the router 52.
The plants 14 are each preferably provided with a LAN 44, as shown in Fig. 1, to support users working on a number of PCs 46 to provide data to the corporate office data server or database 36, as well as to send messages via the electronic mail server 34. Other processes performed at a plant can include, but are not limited to, managing raw material inventory, scheduling and tracking jobs, shop floor data collection, production reporting and job planning, and providing the corporate office with data concerning the planned use of materials, materials requisitions, and the actual consumption of materials and labor during job execution for comparison with the corresponding job estimate. As described in connection with the corporate office, each plant is preferably provided with a communication controller 48 to connect mainframe computer terminals 50 located at plant sites 14 to the mainframe computer 18 at the corporate office 16 over the LAN 24 via routers 52 and 54. A minicomputer 56 such as the IBM minicomputer AS/400 and associated AS/400 terminals 58 are connected to the LAN 44.
As shown in Fig. 1, the sales offices each preferably comprise a LAN 60 to interconnect a number of PCs 62 and/or docked laptop or portable computers 64. A file server 66 can be connected to the LAN 60 to support shared data between multiple PC users. A router 68 is connected to the LAN 60 to interconnect the sales office 12 with the corporate office 16 with dial backup capabilities. Sales representatives can also access the corporate office 16 using, for example, their portable computers via the RLA 40 gateway or the router 52.
The system hardware architecture described in connection with Fig. 1 facilitates maintenance of remote systems such as the sales office and plant subsystems, and the distribution of software to these subsystems by allowing for the sharing of data between the platforms e.g., of the mainframe computer 18, the minicomputers 30 and 56 and the personal computers 29, 41, 46 and 62. In addition to messaging, the corporate office LAN 24 supports a number of applications, which can also be supported by the LANs at the sales office and plant sites, such as word processing, data analysis, ad-hoc reporting, among other office administrative functions. Further, the networking of the PCs at the sales offices and plants facilitates order estimation and entry, as well as the electronic transmission, of production orders and copy folder information to the plants from the corporate office LAN. Copy folder information generally includes specifications for manufacturing, packaging and shipping, and form usage data such as the type of printer to be used. While forms usage information is not necessary for an estimate, it is useful for plant quality control. In accordance with one embodiment, the sales offices send orders to the plants via the WAN. The WAN also allows a form design to be transmitted directly to a plant for pre-processing.
In connection with the present embodiment, printing at a plant 14 is intended to encompass any and all processes and/or the use of any type of machines or other equipment which can be employed for or utilized when preparing or producing imaging on a substrate that is to be read by machine or a human being, including, but not limited to, letter press, intaglio, gravure, lithographic, electrophotographic, xerographic, electrostatic, magnetic, flexographic, ink jet, laser, thermographic and offset lithographic printing processes. It will be appreciated by those skilled in the art that the present invention is not limited to a particular type of computer, data storage device or communications hardware such as the above- described components. Further, the hardware, and the transmission paths and networks can vary depending on a variety of factors such as the number of users accessing the system and the desired data transmission speed. For the purposes of this invention, electronic transmission of data such as a business form image can include, but is not limited to, transmission via modem, facsimile and electronic data interchange (EDI), among other data transmission techniques. The corporate office, sales site and plant personal computers preferably operate in accordance with Microsoft WINDOWS™, although other similar windowing environment and application user interfaces can be used.
The software associated with the corporate office 16, the plant 14 and the sales site 12 will now be described in connection with Fig. 2. The corporate office computer subsystems depicted in Fig. 2 comprise an Order Entry and Inventory subsystem 88 which receives release orders from a sales representative computer (e.g., computer 62), as well as from mainframe terminals located at plants and other order entry offices. Release orders are generated by sales representatives to order the release of finished goods inventory stored at any corporate storage facility through electronic ordering. This inventory includes, for example, forms that have already been produced for the customer and are warehoused at a plant or distribution facility in accordance with a warehousing agreement, and ready-made office supplies such as staplers and telephone message pads. A release order from the Order Entry and Inventory subsystem 88 or from the sales site via the Sales Information Network 86 is sent to a Distribution subsystem 80. The Distribution subsystem 80 generally operates in a warehouse remotely located from the corporate office 16. The Distribution subsystem determines where to store goods within the warehouse, retrieves and ships goods in accordance with release orders, and transmits data to the Order Entry and Inventory subsystem 88 for invoicing.
A sales representative can also generate production orders for the manufacture of a custom item such as a business form designed only for use by a particular customer. The generation of a production order for a custom item generally involves the transmission of item specifications for a production order to an Estimating subsystem 90. The Estimating subsystem 90 is used to generate estimate data using at least one of a number of methods described below. The estimate data is transmitted from the Estimating subsystem 90 to the sales site 12. The estimate data can be used in conjunction with other data such as the data in a copy folder to generate a production order which is sent to a plant.
With continued reference to Fig. 2, the corporate office comprises a Contract Management subsystem 92 for storing customer-specific contract terms and conditions in order to resolve inquiries regarding this information made by sales representatives and customers, and to determine the degree to which customers have complied with their contracts, among other uses. The contract data can include a customer/item relationship comprising contract pricing information for customer contract items. The corporate office 16 further comprises a Labor and Material subsystem 94, a General Ledger subsystem 96, an Accounts Payable subsystem 98, a Purchasing subsystem 84 and an Advanced Shipping Notice (ASN) Data Feed module 82. The ASN module 82 interfaces with the Purchasing subsystem 84, which in turn transmits data to the various plants comprising paper roll identification numbers.
As will be described below in connection with the Manufacturing Information Processing System (MIPS), a Raw Material Inventory Control subsystem 104 and a Data Collection subsystem 108 monitor the materials used in the plants for fulfilling customer orders. The plant 14 provides data from the Data Collection subsystem 108 to the Labor and Material subsystem 94 and to the Estimating subsystem 90 relating to the materials and equipment used, as well as the labor required, to fulfill a particular order. The data from the Data Collection subsystem 108 is used for performing actual cost analysis at the corporate office 16, for job planning at the plant 14 and, once the actual materials used to complete an order have been determined, for updating a Planning Bill of Materials subsystem 102 and the Raw Material Inventory Control subsystem 104. The plant 14 can therefore provide data to a sales site regarding the status of an order for improved customer service. Further, the Purchasing subsystem 84 and the Raw Material Inventory Control subsystem 104 or the Labor and Material subsystem 94 provides the Estimating subsystem 90 with information concerning material attributes such as weight, paper grade, paper or ink color, material codes and material quote information (e.g., quote number, effective date, and material price) and therefore facilitates the process of determining more accurate estimates for the cost of fulfilling a customer order. Similarly, the Labor and Material subsystem 94 provides the Estimating subsystem 90 with standard material cost information, actual job information received from the Job Scheduling and Tracking subsystem 100 in the various plants, as well as actual production information such as waste percentages, feet per run hour and actual material usage.
Information from the plant is also used by the General Ledger subsystem 96 to generate accounting journal entries. As stated previously, the Raw Material Inventory Control subsystem 104 and the Data Collection subsystem 108 monitor the materials used in the plants for fulfilling customer orders. The Purchasing subsystem 84 receives requisitions from the Raw Material Inventory Control subsystem 104. When the material receipt is received, it Is used to update the Raw Material Inventory Control subsystem via the Receiving System 106. This information is provided to an Accounts Payable subsystem 98 for automatically tracking the accounts payable to the various vendors of these supplies. The Accounts Payable data is also provided to the General Ledger subsystem 96.
MIPS 89 is used by a manufacturing plant 14 to manage jobs for cost efficiency and can, for example, be stored in the memory of the plant minicomputer 56. MIPS comprises a plurality of software subsystems which are shown in Fig. 2. The Planning Bill of Materials subsystem 102 determines the materials, shop equipment, and processing time required to fulfill an order based on item specifications in a production order. An advantage of the system 10 of the present invention is that the item specifications are stored in a memory device after they are transmitted to and received at a plant and therefore do not have to be re- entered in the plant or the corporate office computer systems. The Job Scheduling and Tracking subsystem 100 can schedule the completion of jobs in a manner which improves plant efficiency. For example, the MIPS 89 can schedule several jobs for different customers to be processed at the same time because the jobs reguire the same color ink or the same number of plies. The Shop Floor Control subsystem 110 monitors where a product is located at a given point in time during the plant manufacturing process and provides this data to the Job Scheduling and Tracking subsystem 100. MIPS 89 further comprises a Raw Materials Inventory Control subsystem 104 for monitoring supplies (e.g., paper, ink), and informing the Purchasing subsystem 84 when raw materials are needed. A Receiving subsystem 106 monitors the receipt of raw materials for custom product manufacturing, as well as receipt of finished goods, e.g., release order forms that have already been produced and are being warehoused, and office supplies such as staplers that are offered for resale in a catalogue along with the release forms. A Data Collection subsystem 108 collects data relating to materials and labor used per job, per customer and per plant. This data can be used for internally monitoring the performance of the plant. This data can also used by the Labor and Materials subsystem 94 for cost accounting.
The subsystems of the sales representative system or Sales Information Network (SIN) 86 will now be described in connection with Fig. 3. The SIN software is preferably stored in the memory of the personal computers 41, 62 and 64 used by the sales representatives. SIN software can also be provided on terminals for use by customers. Fig. 3 depicts a screen which is generated on a sales representative's computer monitor, for example, in accordance with the SIN software and a WINDOWS™ or equivalent software application. The user can access a subsystem by selecting the corresponding button or menu option on the screen using a mouse, a key pad, a touch screen or other input device. After a button is selected, the computer initiates execution of a program for generating additional screens. A number of these screens (e.g., screens depicted in Figs. 5 through 44) are described with reference to Fig. 4.
With reference to Fig. 3, the sales representative can begin entering item specifications for producing, for example, a custom business form by selecting the button 115 corresponding to a Custom Order subsystem. The computer in turn generates the screen depicted in Fig. 5, that is, a Login screen which requests a login name to begin the process of entering a form specification, as described below. This specification is used in conjunction with data at the corporate office to generate an estimate for manufacturing the form. Item specifications entered using the Customer Order subsystem generally do not need to be as comprehensive as completed item specifications used for generating production orders. The information needed to obtain estimate data is typically less than that required to Instruct a plant on how to manufacture a custom item.
The computer 62, 64 or 41 can generate estimating screens (e.g.. Figs. 32 through 35) following the item specification screens (e.g., Figs. 5 through 31). Alternatively, the sales representative can retrieve a previously-stored item specification and/or estimate. Item specifications can be retrieved from memory by entering an item number in the "Search" screen depicted in Fig. 8, for example, or selecting the button 124 (Fig. 3) to access a Forms Management subsystem. If the customer finds the estimate to be agreeable, the sales representative can invoke the Custom Order subsystem via button 115 (Fig. 3) to begin entering additional information that is useful to generate a production order such as shipping information (e.g., see Figs. 41 through 44). The production order is then preferably electronically transmitted to a plant.
The remaining buttons on the screen depicted in Fig. 3, that is, buttons 114, 116, 118, 120 and 126 are activated to enter queries, generate reports and perform a number of inventory management functions available in the SIN 86. The screens generated in response to activating the Custom Order button 115 each include a button, drop¬ down menu or tool bar option (e.g., "File") that can be selected to return from the specification, estimating and order screens (e.g., the screens in Figs. 5 through 28) to the screen in Fig. 3 in a conventional manner. Upon activation of the button 114, a Release Order Processing subsystem permits a sales representative to enter release orders to order the release of inventory stored at any corporate storage facility, preferably via electronic data interchange (EDI) ordering. The EDI orders can be electronically transmitted throughout the WAN and ultimately to a plant or distribution facility 12, which is preferably the facility that is located closest to the destination point of the ordered goods. This reduces freight cost for the customers, as well as expedites delivery. The sales representative can create a new release order or open a file to an existing release order by highlighting the proper menu option on a main release order screen (not shown) and striking the enter button on the key pad or clicking a mouse. In addition to creating new release orders, editing existing release orders, and saving and printing release orders, the sales representative can transmit release orders to the Order Entry and Inventory subsystem 88 at the corporate office, as well as receive release order acknowledgments. To save time, information that is frequently used by a customer to order the release of goods from inventory can be entered into a template. For example, information from the corporate office (e.g., from the data server 36) relating to a customers ship-to and sold-to addresses can be entered once into a template for subsequent uses, eliminating the need to enter these addresses at a later time. Thus, the template-based system improves accuracy and speed.
Button 116 (Fig. 3) is used to invoke the Order Inquiry subsystem, which permits a representative to access information electronically regarding the status of a release or production order. A query function is provided to allow the sales representative to find any order by searching the database for such references as user location, production order number, item number, or other criteria that the representative defines in a previously placed order. When a particular order is found in the database, an order status code is presented by the computer 41, 62 or 64 in accordance with the subsystem to Inform the representative if all items in an order were shipped or, in the case of a release order, if a back-order was required. Additional information regarding release orders is provided to inform the representative of the originating warehouse location, the shipping date, the shipping carrier, as well as coding for orders supplied from more than one warehouse. Data from the different plants is provided to the Order Entry and Inventory subsystem 88, which can be used to track the completion of a production order as explained above in connection with Fig. 2.
Button 118 (Fig. 3) is used to select the Customer Inventory subsystem, which allows either the customer or the sales representative to track inventory at the customer location. Two methods are provided for tracking inventory. The first method employs inventory counts, that is, counting receipt, on-order, and ending inventory amounts and entering them into the system at the end of the month. The second method employs bar codes for perpetual inventory monitoring, that is, scanning bar codes on inventory items indicating receipt, on-order, usage and transfer transactions on a daily basis or as they occur. This subsystem offers the customer valuable information to prevent stock-out situations, as well as useful trend usage analysis. If the inventory database is kept up-to-date, the customer inventory subsystem can offer additional benefits such as ad-hoc query creation and reports, which helps users to track inventory and overall usage of their products.
As stated previously, button 124 (Fig. 3) is used to select the Forms Management subsystem, which allows either the customer or the sales representative to maintain items such as forms and labels and their associated specifications electronically. The subsystem is generally an electronic database of item specifications and copy folder information. The sales representative or customer can create a form, as explained in further detail below, or scan an existing form into the SIN 86, and then match the on-screen image of the newly created or scanned document to a computer file. The sales representative or customer can subsequently organize, sort and manipulate the specification and corresponding copy folder information that defines every form and label within the database electronically. An exemplary item or form specification sheet is shown in Appendix A. The specification sheet comprises an area for general information such as customer number and product type, an area for usage information such as storage terms and numbering, an area for construction Information such as the number of plies, the paper weight, width and color and grade, an area for fastening information such as location and the type of fastener, as well as for the color of inks used on the form. A menu option within the Forms Management subsystem permits a representative to create an on-screen form using a form design software such as the Perform Pro Plus Forms design software developed by Delrina Technology, Inc. of Canada. Thus, a sales representative or customer has the convenience of on-site laser proofs of newly created forms and therefore fast response to user requests. The Forms Management subsystem permits a customer or sales representative to eliminate and consolidate forms, reduce procurement costs and build a foundation for forms automation. For example, a number of fields within the forms specification sheet or within the forms design itself can be stored as a template and used in later specification sheets, forms and labels, thereby reducing the need to re- enter data.
The information in the Forms Management subsystem can be integrated with the information of other subsystems to essentially instantaneously determine inventory values, usage trends and to generate custom reports. The Sales Information Network (SIN) 86 comprises a Report Writer subsystem corresponding to button 126 (Fig. 3) which allows for the generation of custom reports using the query tool to access data residing in any of the six subsystems. For example, reports can combine ordering, shipment trend and specification information. Each of the subsystems is designed with an open systems architecture so that each subsystem can work in conjunction with the a query tool and the Custom Report subsystem, as well as with the corporate office information systems (Fig. 2). The information within the network can be exported to other WINDOWS™ compatible programs.
The data stored at the corporate office 16, the plant 14, and the sales site 12 (Fig. 1) will now be described. In accordance with an embodiment of the present invention. the data server 36 at the corporate office 16 maintains the following types of data in the database: item specifications (e.g., for production orders that have been submitted or for estimates that have been generated and require review by corporate office personnel) ; cost data for generating an estimate; contract data; production orders or order-specific information shared between sales sites and plant; and estimate information (i.e, information that is not contained in an item specification, such as the number of printings requested and storage information) . The file server(s) can be configured using, for example, a PC file server, a minicomputer or a mainframe computer. Further, other types of memory devices can be used. Finally, the data server 36 is preferably provided with information that can be downloaded to sales sites or plants through, for example, batch processes. This downloadable information can include, but is not limited to, order status, inventory information and validation data.
A computer (e.g., a personal computer 29) at the corporate office 16 is programmed to operate as or in conjunction with the data server 36 to do the following types of information processing: maintaining cost data and material quotes; reviewing and maintaining estimate matrices; maintaining estimates and item specifications; validating estimates and specification sheets; manipulating and transmitting estimate cost and list price information to sales representatives; producing order entries and maintaining them; conducting profitability analysis, as well as other types of analyses; re-routing production orders on an exception basis; and messaging.
The memory storage device(s) at the sales office 12 (e.g., the file server 66 and the laptop computer 41) preferably store information that is needed only at the local levels such as user information and modem numbers, as well as information that is generated at the local level such as item specification information. The item specification can be for both items that have and have not been transmitted to the data server 36 at the corporate office 16. These sales site memory device(ε) can also contain information that has been downloaded from the corporate office data server 36. As will be described in further detail below in connection with Fig. 4, the sales office computers (whether located at a customer site or corporate sales site) are programmed to generate release orders, to generate and transmit item specifications and requests for estimates, to receive estimate data and convert estimates into production orders, to generate and transmit production orders and to perform messaging. Item specifications, estimates and orders are preferably maintained at the corporate office, as opposed to the sales sites. A sales representative can access the data server 36 to retrieve an existing item specification and corresponding estimates for different quantities and prices of the manufactured item, and to store the data at least temporarily in a local memory, e.g., the file server 66 or in the memory of a laptop computer. When the sales representative is no longer working with the data, the data is transmitted to the corporate office for updating existing records or creating new records in the database. The predominantly centralized storage of item specification, estimate and order data is advantageous for the reasons stated above, that is, sales representatives have access to essentially the same data for consistent price quotations. It is also easier to back up data at the corporate office than at each of several distributed sites. The integrity and security of the corporate office data is therefore greater than if the data were stored among several sites without any centralized storage. The corporate office can receive data from several sources (e.g., SIN and MIPS). The estimate data received at each sales representatives' computer can reflect contractual agreements between the manufacturer and a customer. Further, customer data and other data from the corporate office database can be recaptured at the sales representatives' computers to minimize the amount of data that needs to be manually entered when creating an item specification, production order or requesting an estimate. In accordance with an embodiment of the invention, the sales representative can access customer item data stored at the sales site 12. Item specifications, cost data, order data and other information, however, is preferably stored at the corporate office 16 and not at one or more sales sites 12. This arrangement allows for greater visibility of sales representatives' performance than an arrangement wherein sales representatives have cost data necessary to generate an estimate at the sales site and did not have to consult with personnel or use data stored at the corporate office. As stated above, sales management personnel can use the Report Writer subsystem (i.e., button 126 in Fig. 3) or other system to generate reports indicating estimate and order trends for a particular sales representative using data that is essentially continuously maintained at the corporate office.
In accordance with another embodiment of the invention, the system 10 can be configured to do price- based analysis at the sales sites 12. Price-based estimates generally involve adjusting a list price for a base product in accordance with characteristics and features of a custom item to be manufactured. Cost-based estimates are generally more comprehensive because a manufacturing standard cost (e.g., hours of labor, materials cost and other direct manufacturing costs) is increased to compensate for administrative and sales expenses, as well as contingencies and margins. Sales representatives, for example, can generate price-based estimates for items that are valued under a predetermined amount using data obtained from the corporate office data server 36, but without having to consult with personnel at the corporate office. The sales representatives can be required to send item specifications for custom items valued over the predetermined amount to personnel at an Estimating department at the corporate office for review and to obtain estimate data therefrom using, for example, cost-based analysis.
Each plant 14 can use, for example, a minicomputer 56 to store data that is generally only needed by the plant. A significant amount of this data is generated locally, and some data is transmitted to the plant by a sales site or the corporate office. For example, actual job and production data is generated at the plant and sent to the Labor and Material and Estimating subsystems. Other data at the plant can include, but is not limited to, estimate data, validated item specifications and MIPS planning specifications. Using this data, each plant can maintain productions orders transmitted thereto, validate order specifications, and perform messaging. One or more messaging servers are provided in the WAN to store and forward messages to sales sites 12, the plants 14 and the corporate office 16. Two kinds of messages can be sent via these message servers: (1) free form messages that are human readable; and (2) program interpretable messages.
The process of generating an item specification for a business form, for example, at a sales site 12, obtaining estimate data from a corporate office 16, and ultimately forwarding a production order for the custom manufacture of the form to a plant 14 is described in connection with the flow chart depicted in Fig. 4. For illustrative purposes, the following discussion will reference several screens depicted in Figs. 5 through 21 and Figs. 32 through 44. These screens depict specification, estimate request, pricing and product order entry screens for ordering a business form. These screens are a subset of the total number of screens that can be generated by a computer 62, 64 or 41 in the SIN. For example, different screens such as those depicted in Figs. 22 through 31 can be generated for specifying other types of custom products such as Wal- labels, envelopes and labels.
With reference to block 140 in Fig. 4, a sales representative typically determines customer requirements for a product such as a business form during, for example, a meeting with the customer, and begins to enter a new item specification into a PC 62 or other computer, or to modify an existing item specification. As stated previously, the PC 62 generates a Login screen (Fig. 5) which permits a sales representative to enter his or her name. The PC 62 is programmed to generate another screen (Fig. 6) which lists the names of that sales representative's customers. The screen in Fig. 5 can be configured with a password to restrict access to customers' records to certain persons. The sales representative can highlight the name of an existing customer (Fig. 6) and access their files using a mouse or a key pad. An "Account Information" screen (Fig. 7) is generated which contains account number, customer address and other Information relating to the account of an existing customer. The sales representative can modify and update this information. If the customer is new, the sales representative can request a blank "Account Information" screen on which to manually enter this information using, for example, the "File" option in the menu pad 117. If the account information is correct, the sales representative can activate the "Ok" button on the screen in Fig. 7 to view the next screen (Fig. 9). Alternatively, the sales representative can select the "Tools" option from the menu pad 117. The sales representative's computer is programmed in accordance with the SIN software to generate a pop-up menu (not shown) listing various tools such as a search or query function. The screen depicted in Fig. 8 allows a sales representative to search the database or data server 36 for a particular specification, proposal, estimate or order by number, name and other attributes.
If the customer is an existing customer, the "Customer" screen in Fig. 9 lists the names of item specifications for custom products which have been designed and produced to date for that customer. The sales representative can activate the "New" button to commence entering a new item specification, or highlight the name of an existing item specification and retrieve it by activating (e.g., using a mouse or a touch pad) the "Open" button. If the "New" button is activated, the PC 62 generates the screen depicted in Fig. 10. This screen permits the sales representative to select from two types of product categories, that is, custom products and stock products. If the stock product option is selected, the PC 62 generates one or more screens (not shown) for guiding the sales representative to select type and quantity of stock products and order them for delivery to the customer. If the custom product option is selected, the PC 62 generates a "Custom Product Selection" screen, as shown in Fig. 11, which lists a number of product categories, e.g., business forms, mailers and labels. With continued reference to Fig. 9, the "Customer" screen provides the sales representative with a number of options besides "Specs" for entering item specifications, such as "Estimates", "Proposals", "Orders" and "Reports". These options can be selected by activating the corresponding button using a mouse or other input device. Exemplary screens for guiding the sales representative to create a specification for a custom product such as a business form are shown in Figs. 12 through 31. In accordance with the SIN software, the sales representative's computer (e.g., a PC 62, docked laptop computer 64 or laptop computer 41) initially generates one or more screens entitled "Business Form Base Specification" which prompt the representative to enter the base specifications, that is, the minimum information required to specify the item to be manufactured. As shown in Fig. 12, the base specification for a business form comprises stub size, overall width, number of plies and an indication of whether the form will be composed of bond and carbon paper or will be carbonless. These fields are preferably blank until the sales representative enters the requested parameters. The representative's computer can be configured, however, to automatically provide default values for these parameters which appear in the fields. The representative can then enter different values in lieu of these default values if desired. The base specifications for other items such as envelopes, labels and mailers are different than that of a business form. The base specification screens for these items (not shown) are therefore different because they prompt the representative to enter information relating to other parameters. After the representative clicks the "Finish" button on the screen in Fig. 12, the computer generates the screen in Fig. 13, which prompts the representative to enter customer item name, number, and revision number if the item is being altered from an existing specification. After the sales representative clicks the "Finish" button on the screen depicted in Fig. 13, the computer is programmed to generate the "Specification Summary" screen depicted in Fig. 14. If the sales representative wishes to review and modify other specification parameters relating to, for example, materials used, composition, printing, packing or fastening, the representative can double click that item in the left column of the screen using a mouse. For example, the representative can double click "Material." The computer, in turn, generates the "Material Base Specification" screen depicted in Fig. 15. The data shown in the screen is automatically provided based on the base specification. The representative can change any of these values as needed by highlighting the "Paper" or "Carbon" in the "type" cell 119 for one of the plies. The computer subsequently generates the "Materials: Paper/Carbon" screen depicted in Fig. 16. The sales representative can enter paper properties or click the tab 121 labeled "Carbon" to enter carbon paper properties on the screen depicted in Fig. 17. The screens are provided with "Ok", "Cancel" and "Help" buttons 133, 135 and 137, respectively. The "Ok" button be clicked, for example, to return to the screen in Fig. 14.
With continued reference to Fig. 14, the representative can double click "Composition" in the left column of the screen using a mouse. The computer in turn generates the "Composition Simple" screen depicted in Fig. 18. This screen indicates specifications that can be selected by the sales representative by simply clicking the desired specifications with a mouse, as opposed to entering alphanumerical values with a key pad. If the sales representative wishes to enter more detailed information relating to the composition of the form, he or she can click the tab 123 labeled "Composition Detail". The computer subsequently generates the "Composition Detail" screen depicted in Fig. 19. The representative can then change data in the grid shown using a mouse and key pad. Similarly, the sales representative can double click "Fastening" in the left column of the screen depicted in Fig. 14. The computer, in turn, generates a simple specification screen for fastening entitled "Fastening", as shown in Fig. 20. The representative can enter type and location of the desired fastener simply by clicking a mouse, for example. The representative can also click the tab 125 labeled "Fastening-Detail" to enter more information relating to fastening into the "Fastening and Pocket Detail" screen (Fig. 21) which is subsequently generated by the computer. The SIN software provides a hierarchy of screen formats, that is, base specification screens (e.g., the screens in Figs. 15-17), simple specification screens (e.g., the screens in Figs. 18 and 20) and detail specification screens (e.g., the screens in Figs. 19 and 21) to reduce the amount of data a sales representative needs to enter manually when creating a specification for an item which suits the customer's requirements, as well as the number of screens he needs to actually review. For example, it is possible to create a specification for an item such as a business form by reviewing only the base specification screens for that item without having to review the simple and detail specification screens. The representative can, for example, click the icon 127 provided in the tool bar 129 on the "Specification Summary" screen (Fig. 14) for requesting screens to generate an estimate. The representative's computer is programmed in accordance with the SIN software to generate the screens depicted in Figs. 32 through 35 and described below. Alternatively, the sales representative can review only the base and simple specifications screens without having to review and use any of the detail specification screens for a particular custom item to be manufactured.
Figs. 22 through 31 are exemplary screens for entering specifications for other types of items such as labels, envelopes, roll-type products and items requiring perforations, hole punches or electronic printing. As stated above, the item type is selected using the screen depicted in Fig. 11. The computer 62 or 64, or laptop computer 41 is programmed in accordance with the SIN software to generate base specification screens (not shown) corresponding to the type of item selected for manufacturing. The screens indicate the minimum specification data required to generate a specification for requesting an estimate for and ordering manufacture of a product. The representative's computer subsequently generates a screen similar to the "Specification Summary" screen depicted in Fig. 14, but corresponding to the type of item selected in the screen in Fig. 11. For example, if a specification for a label is being generated and the representative double clicks "Materials" in the left column of the "Specification Summary" screen (not shown) for a label, the computer generates the screen depicted in Fig. 22, which is analogous to the screen for a business form depicted in Fig. 15. The representative can double click "Printing" in the "Specification Summary" screen for a label in the same manner he can for a business form (Fig. 14). The computer generates the "Ink Detail" screen depicted in Fig. 23 to prompt the representative to enter information relating to ink color and type for each ply. The label specified in the screen depicted in Fig. 22 has two plies. Accordingly, the "Ink Detail" screen depicted in Fig. 23 comprises two columns in which to enter information for the two plies, respectively. A similar "Ink Detail" screen (not shown) can be generated for the exemplary business form described above. The computer generates this screen with three columns in which to enter ink color and type for the three paper plies specified for the business form, respectively.
The screens depicted in Figs. 24 and 25 illustrate simple and detail specification screens, respectively, for entering information regarding punching, drilling and perforations that may be desired for a custom business form, for example. Accordingly, "Punching" and/or "Perforation" appears in the left column of the "Specification Summary" screen (Fig. 14) for those business forms having these features. Fig. 26 illustrates a review screen for an envelope that is analogous to the screen depicted in Fig. 15 for a business form. The screens depicted in Figs. 27 and 28 are exemplary simple specification screens for an envelope. Fig. 29 illustrates a detail specification screen corresponding to a roll-type item. Figs. 30 and 31 illustrate, respectively, simple and detail specification screens for electronic printing.
As stated previously, data is entered into the fields of screens (e.g., the white boxes appearing in the screens depicted in Figs. 15-17) automatically by the computer, which retrieves data from local memory or from the data server 36, or manually by the sales representative using conventional data input devices such as a keyboard or a mouse. Exemplary data has been provided in the screens depicted in Figs. 14 through 21 which also appears in the exemplary item specification in Appendix A. The above- described screens are designed to highlight and/or restrict the user to only those menu options that are available based on previous inputs.
As shown in Block 141 of Fig. 4, the sales site computer preferably validates an item specification being transmitted for an estimate. The validation process prevents the sales representative from selecting features for a custom item that cannot be priced or manufactured. For example, if the sales representative selects a type of item such as a mailer, the screens generated by the PC prompt the sales representative to select features that are valid for mailers, and prevents user selection of features not permitted for this product type. The validation logic for item specifications is preferably controlled at the corporate office.
Because the sales office computers 41, 62 and _4 are networked to each other and to the corporate office computers 29 and the plant computers 46, it is possible to copy most of the information that is needed for an estimate and item specification from data entered from a previous order for that customer, thereby eliminating the need to re-enter redundant information. In addition, a sales representative can generate several item specifications for the same product. For example, several item specifications can be generated which specify different materials to manufacture the desired product for price comparison purposes. These item specifications are then used generate a number of estimates. The sales representative can select a subset of these item specifications and their corresponding estimates and store them as proposals using the "Proposal" option in Fig. 9. These proposals contain the estimates that the sales representative wishes to present to the customer. Sales management personnel at the corporate office 16 or a sales site 12 or other authorized personnel can calculate an estimate conversion ratio, that is, the number of proposals submitted to a customer that are eventually transformed into an order, or download proposal and order data to a corporate office computer 29 to calculate the estimate conversion ratio. This data is useful to monitor sales representatives' performance and to identify products which have a poor or low estimate conversion ratio, among other uses.
The simple and detail specification screens are * provided with "Ok" buttons 133 such as those on the screens depicted in Figs. 28 and 30 which return the representative to the "Specification Summary" screen when clicked using a mouse, for example. Alternatively, after a sales representative has finished reviewing a simple or detail specification screen (e.g., the simple and detail specification screens depicted in Figs. 18 and 19), he or she can return to the "Specification Summary" screen (e.g., the screen depicted In Fig. 14) by clicking a button 131 on the screen. The computer is programmed to generate a drop- down menu (not shown) in a manner conventional to WINDOWS™ applications, which provides the option of closing the screen to return to the "Specification Summary" screen. Once the representative has completed entering a specification, at least insofar as providing sufficient information for obtaining an estimate, the representative can click the icon 127 representing an estimate in the tool bar 129 of the "Specification Summary" screen for the item to be manufactured.
With reference to Fig. 9, the sales representative need not create or modify an item specification and then activate the "Estimate" icon 127 for the purposes of obtaining an estimate. He can select one of the "Estimate", "Proposals", "Orders" or "Reports" buttons without first entering data Into specification screens (e.g., Figs. 10 through 31). For example, the sales representative can highlight the name of an existing item specification from among those listed in Fig. 9 and activate the button corresponding to the "Proposals" option to retrieve a corresponding proposal from a memory device (e.g., file server 66). Similarly, if the item specification for a custom product has already been stored but, due to a change in paper prices, the estimate needs to be updated or otherwise generated, the sales representative can activate the button for the "Estimates" option. Regardless of whether the "Estimates" button in Fig. 9 is used, or the "Estimates" icon 127 is selected, the PC 62 or laptop computer 64 or 41 is programmed to generate the screens depicted in Figs. 32 through 35. With reference to Fig. 32, items for which specifications have been created and stored for a particular customer appear on the screen, along with other information retrieved preferably from the database by the data server 36 such as contract number and zip code. A sales representative selects the item for which an estimate is desired by highlighting the appropriate item and clicking a mouse, for example, or depressing a key on a keyboard. The sales representative's computer generates an "Estimate Detail" screen, as depicted in Fig. 33, which displays at least one column of information. The column comprises values for a number of parameters which can affect a cost estimate for a particular item such as item number 123456. Two or more columns can be entered by the representative to determine how cost is affected when different parameters are considered. Thus, a sales representative can determine how much of a concession (i.e., price reduction), if any, he or she can offer a customer as the result of increasing the quantity of the item ordered or changing terms for storage, for example. The screen is then closed and a data transmit function initiated by clicking the "Ok" button 133. Alternatively, a "Transmit" option can be provided in the drop-down menu (not shown) corresponding to the "Tools" option in the menu pad 117 of Fig. 14. As shown in block 142 of Fig. 4, the item specification, estimate header and estimate detail information is transmitted via the WAN (e.g., routers 68 and 52, or the X.25 communication line and the RLA Gateway 40) to the corporate office to obtain estimate data. With reference to block 144 of Fig. 4, the corporate office computer system is programmed to validate the item specification. As described above, the corporate office maintains various types of data such as material costs, pricing factors, estimate data, contract data, and valid specification data, as well as specification costs and parameters. Material costs and specification costs are generally updated and maintained by the Purchasing and Industrial Engineering departments of a manufacturing plant. For example, personnel in these departments are generally responsible for supplying data relating to material costs, material quotes, labor and burden costs to the data server 36. A Estimating or Industrial Engineering department is preferably used to maintain estimate parameters such as the pricing parameters and valid specifications. For example, an Estimating department and an Operations and Sales department can be used to obtain and enter into the data server 36 data such as price inflators and deflators, mark-ups, and contingency factors which can affect specification values and pricing parameters.
The validation process, block 144, involves cross- validating a selected item-type such as a business form against an item specification to ensure, for example, that a fastener was not ordered for a single ply-type business form. The selected item-type can be validated against an item specification to ensure that the appropriate materials were selected and that the correct die information was entered. Validation of the specification can comprise field-level edits and cross-validation. In addition to production constraints, item specifications sent to the corporate office to obtain estimate data can also be validated or reviewed because they are for a particular customer, are estimated to cost more than a predetermined amount (as described below in connection with block 150) or are for a particular type of product that is not selling well, for example. Software for the corporate office computers can be created to automatically review incoming item specifications to identify item specifications meeting certain search criteria such as customer name and cost and/or list prices within certain ranges of values. The item specifications and/or estimates meeting these criteria can be required to undergo review by a person. This is advantageous when customer relations require application of concessions to cost, or extra precautions to minimize estimate amounts or production mistakes. Estimates above a certain amount can also require review to ensure that the cost of an item that is complicated and therefore more difficult to manufacture is not underestimated. With reference to the negative branch of decision block 145 and block 146, estimate generation incorporates data relating to the number of manufacturing processes of a job (e.g., imaging for producing color forms), waste matrices, effectivity dates for list price, set-up burden rates by a logical machine type within a division, material charges, among other data. The estimating data is maintained by the Estimating subsystem 90 (Fig. 2). In accordance with an embodiment of the invention, an estimate can be prepared using one or more tables or matrices which can be generated, for example, using a spreadsheet-type software program (e.g., LOTUS or EXCEL or custom developed software), and which use the product type, different form features, and quantity indicated in the item specification, among other data, to generate cost and list pricing information. These matrices preferably reside in the Estimating subsystem 90. As will be described below in connection with block 158, the sales representative uses cost and list pricing information to determine a sell price for the manufacture of a custom form. Pricing information for stock items (e.g., telephone message pads or pads of lined paper that can be used by anyone) can also be generated using price matrices. The matrices preferably comprise standard cost Information which can be generated using the Labor and Material subsystem 94 or the Estimating subsystem 90.
The Estimating subsystem 90 can be used to do some calculations using the matrices, or the matrix information can be transmitted to the sales site where calculations are executed. In either case, important pricing information is first obtained from the Estimating subsystem 90 before a sell price is determined therefrom and presented to a customer, in accordance with the present invention. This realizes a number of advantages for the present invention. This provides corporate office personnel some control over sales representatives' sell price quotations to ensure that products are not undervalued, that estimates for similar products are consistent and that estimates reflect concessions made to customers. As stated previously, the integrity of the pricing information is ensured when it is updated in a central location; otherwise, pricing information distributed among several sales sites may not be updated consistently. Sales sites would therefore be determining price from different matrices. Further, proprietary pricing data and algorithms are best kept at a central storage location for security reasons rather than being distributed to sales sites. Also, corporate office personnel realize a number of competitive advantages by maintaining a central repository of pricing and estimate data at the corporate office. Statistical analysis can be performed on the data to gain greater market visibility. For example, information such as the number of estimates that evolve into production orders can be used to ascertain which customers have not been approached by a sales representative or bring a large volume of business. The data can reflect a need to reward or further train sales representatives, or to offer a customer a pricing discount. With reference to the affirmative branch of decision block 145 and block 147, the Estimating subsystem 90 can generate an estimate for an item that is to be priced in accordance with a contractual agreement between the customer and the corporation. As will be described below in connection with Figs. 45 through 53, contract price matrices can be generated to reflect contractual terms. Contract price matrices can be created as a subset of the standard or generic price matrices used to generate estimates for non-contract items. The generic price matrices can be used for estimating any customers' orders. The generic price matrices are generally based upon raw material prices, equipment and other factors that affect actual cost to fulfill an order. A custom price matrix, on the other hand, can include contractual concessions between the forms manufacturer and the customer resulting in prices below, for example, the standard prices, i.e., discounts for the volume of business the customer brings to the manufacturer. An advantage of using contract price matrices is that they support contract proposal generation by corporate personnel in, for example, a Contract Administration department of the corporation by developing matrices of multiple items. This is particularly useful when the corporation is offering concessions to a customer with a large number of existing forms. The contract matrices eliminate the need to perform an estimate for each form for contract proposal purposes. Since contract terms are stored at the corporate office, corporate personnel can perform contract profit and other types of analysis, and provide contract customers with a common reference for pricing.
With reference to decision block 148, the present invention provides for the review and maintenance of estimates based on user-defined parameters, for the generation of list price promptly after a request for an estimate is made (provided the estimate does not require review), for the generation of a new list price and a repeat list price for estimates of new items, and for messaging back to the sales representative to inform him to which department an estimate is being routed should the estimate require review by corporate personnel.
With reference to the affirmative branch of decision block 148 and block 150, review of an estimate, for example, by an Estimating department or Operations and Sales Management department is advantageous for a number of reasons. As stated previously, a corporate office computer or Operations and Sales Management personnel can review estimates using various criteria when the estimates require use of a special material, a particularly large volume of material, or require complex construction or a new or special specification. Estimates which involve a particularly high dollar value or a particular customer can also necessitate review by corporate office personnel. This gives corporate office personnel an opportunity to use pricing information for processes that is external to the Estimating subsystem 90. For example, while a mailer product with six plies can be priced by the Estimating subsystem 90, the item can present difficulties to the plants. Batch validation of an item specification and estimate for the mailer allows corporate office personnel to review the estimate and make changes as needed. Batch validation also allows estimates for strategic customers or which exceed a predetermined dollar amount to be identified for review. Following estimate review, the corporate office personnel responsible for reviewing estimates can enter and maintain notes on estimate and production orders and maintain item specifications. These corporate office personnel have the advantage of being able to maintain contingency and mark-up factors on an individual estimate basis, as well as being able to devise flexible exception criteria for estimate review notification. In addition, corporate office personnel can enter recommended and/or minimum sell prices. With continued reference to block 150, review of an estimate is an iterative process. If the corporate office determines that an estimate is unacceptable, item specifications can be changed, as indicated by the affirmative branch of decision block 151 and block 152. For example, a less expensive grade of paper can be used or a larger quantity of forms can be ordered. An audit trail can be created for revised estimates to document changes.
With reference to block 153 of Fig. 4, an estimate that does not require review, or a validated estimate, is transmitted back to the sales representative via the WAN connecting the sales office to the corporate office. With reference to block 154, the estimate information is recaptured by the computer (e.g., PC 62 or 64, or laptop computer 41). At least part of the recaptured information is automatically displayed on the computer monitor in the format of the "List Price Summary Recapture" screen (Fig. 34). The estimate information recaptured at the sales site preferably comprises cost and list price, recommended or minimum sell price where appropriate, order quantity, item specifications, and freight and storage information. The "List Price Recapture" screen provides list price information for the first order of the desired custom product and the list price information for repeat orders, which are generally subject to discount pricing. The list price is preferably broken down to separate elements such as specifications and materials. The sales representative has access to alternate information such as price and quantity breaks, alternate materials, alternate specifications and minimum material requirements. The sales representative also has the ability to print out the estimate.
With reference to the affirmative branch of decision block 156, the sales representative has the option of revising the estimate or simply obtaining multiple versions using different materials, quantities, and so on. A parameter filter is provided for changed or revised estimates for a parameter-controlled filtering of changed or revised specifications. A sales representative can activate the "Ok" button 133 to close the screen. The computer then generates a "Sell Price Calculator" screen, as depicted in Fig. 35. The sales representative uses the list price from the screen depicted in Fig. 34 to determine a sell price, taking into account other factors such as concessions, as shown in block 158. Once the sell price is determined, the sales representative can close the screen depicted in Fig. 35 in a manner that is conventional to WINDOWS™ software (e.g., by selecting the "Ok" button 133 or the "Close" option in a drop-down menu (not shown) associated with the button 131). The PC 62 is programmed to display the screen depicted in Fig. 9.
Before generating a production order, the sales representative preferably enters information regarding usage of the item to be manufactured into usage screens (e.g., screens depicted in Figs. 36 through 40). The usage screens are generated by the PC 62 or laptop computer 41 or 64 following selection of a "Usage" option in the drop-down menu associated with the "Tools" option in the menu pad 117 of Fig. 14. The usage screens are advantageous because they allow some degree of validation of the manufacturability of the ordered item before the order is sent to the plant. Usage screens vary depending on the type of item for which they are used. For illustrative purposes, the usage screens depicted in Figs. 36 through 40 are for a business form. The screens comprise different types of processes and after-handling equipment that a customer uses on or with the ordered product once it is shipped and received. For example, the sales representative can enter the type of burster or printer used with a form or indicate that the form is to be written on using a No. 2 lead pencil for computerized tabulation. By viewing this screen, the sales representative can review the order for quality control. The selected paper type may contain a coating that cannot be satisfactorily used with No. 2 lead pencils or the customer's printer. The sales representative can therefore recognize potential problems with the order before it is sent to the plant, thereby eliminating time wasted because the plant has rejected an order.
With reference to blocks 160 and 162, the sales representative determines sell price from the estimate data and reviews the proposal with the customer. As indicated by the negative branch of decision block 162 and block 164, the customer can request a production order from an estimate which is found to be acceptable. The sales representative can use the PC 62 to automatically extract information from the estimate and add detail to generate a production order. The conversion of an item specification and estimate data into a production order minimizes the re- entering of previously captured information. The sales representative can also enter sell price (or reference contract pricing matrices, if appropriate), ship date, the production plant, as well as the identification of any supporting documentation. The production plant can be automatically selected by the mainframe computer 18 or selected by corporate office or sales office personnel.
If the "Order" button depicted in Fig. 9 is activated, the sales representative's computer is programmed to generate a number of screens for generating an order such as those screens depicted in Figs. 41 through 44. Alternatively, on "Order" icon can be provided in the tool bar 129 in Fig. 14 or an "Order" option can be provided in the drop-down menu associated with the "Tools" option in the menu pad 117. The first screen generated by the PC 62 or laptop computer 64 or 41 is preferably the "Sales Order Header" screen depicted in Fig. 41. The sales representative can provide the shipping information. The customer information, however, is preferably automatically provided by the computer, which retrieved the data from local memory or from the data server 36. Multiple shipping sites can be specified, as well as credit approval or other information from the corporate office relating to the customer. The sales representative's computer is programmed to generate the "Production Order Detail" screen depicted in Fig. 42 after the "Ok" button 133 is activated on the "Sales Order Header" screen. The "Production Order Detail" screen is configured to automatically display a number of list and sell prices in respective columns for the customer item number selected using the screen depicted in Fig. 9. For illustrative purposes, only one sell and list price is shown for the item number 123456 displayed in Fig. 42. The identification numbers of the proposal and estimate used to calculate the displayed list price are automatically provided by the computer. Alternatively, the sales representative can enter another item number, proposal number or estimate number using a keyboard. The sales representative selects one of the columns in
Fig. 42 by highlighting the desired column and activating the "Select Item" button. The PC 62 is programmed to generate a number of screens for guiding the sales representative to enter additional information in the item specification that was not required to be entered previously for the purposes of obtaining an estimate. Thus, the amount of information the sales representative needs to enter to generate proposals and ultimately orders is minimized. For ordering a custom continuous type business form product, these screens can include a "Marginal Words" screen (Fig. 43) and a "Concessions Approval" screen (Fig. 44).
As shown in block 166, each computer at the sales office and each laptop computer 41 preferably operates in accordance with the SIN 86 to validate production order details, as well as cross-validate selected items with reference to the production order details. The sales representatives' computers are also programmed to determine whether or not a customer has a contract with the manufacturer, to ensure the customer has a favorable credit status and to check for a concession percentage. The SIN 86 also stores in memory a version of the estimate used to produce the production order as part of an audit trail. The sales representatives' computers are further programmed to prevent expired estimates from being converted into production orders, to ensure that each production order is linked to a particular estimate unless the order is the result of an outside purchase, as well as to check for concession percentage level. The latter feature enables sales management to be notified when acceptable concession levels are disregarded.
The validated production order is preferably sent electronically to the corporate office, along with copy folder information comprising the image of the form or label via the WAN (e.g., the routers 68 and 52, or the RLA Gateway 40), as shown in block 168. This is done using, for example, a "Confirm" button (not shown) on the screen in Fig. 41 or a "Transmit Order" option In a drop-down menu associated with the "Tools" option in the menu pad 117 (Fig. 9). These items can also be sent via regular mail, or by facsimile or other digital data transmission technique. The SIN is configured to provide the sales representative with a message (e.g., in a pop-up box or status window on the sales representative's monitor) confirming that the order was sent and the name of the destination plant. In addition, plant computers are configured to transmit a message via the WAN acknowledging that the order was received. Similar messaging occurs at the corporate office when, for example, an estimate cannot be generated immediately. The sales representative is notified that estimate review is required and given the option to proceed with the review or to cancel the request for estimate data using a button generated within the status window or message pop-up box.
The sales representative can use the Forms Management subsystem 124 to design a new form in addition to entering information for an item specification. This form can be electronically transmitted along with the item specification and a request for an estimate to the corporate office. While transmission of this data is preferably downloaded from a PC 62 or laptop computer 41 or 64 onto a digital communication line, the data can also be printed on a laser printer connected to the network 60 and transmitted via regular mail or by facsimile.
With reference to the affirmative branch of decision block 170 and block 172, production orders can be reviewed by production management personnel who review plant and equipment utilization and have the option to override the plant entered by the sales representative, as well as enter an override reason. Thus, inquiries on production orders can be made on an exception basis. With reference to block 174, a production order which does not require review, or which has been found acceptable upon review by production management personnel, is subsequently transmitted electronically to the plant. As shown in block 175, the MIPS at the selected plant In turn places the production order in a queue for planning purposes by the Planning Bill of Materials subsystem 102. The Planning Bill of Materials subsystem 102 audits the estimate, that is, checks item specifications. As shown in blocks 176 and 178, sometimes changes need to be made at the plant because of, for example, a labor shortage or mechanical problem. The plant can communicate these changes in the production order via, for example, the minicomputer 56, to the sales representative or customer via the LAN and routers 52, 54, and 68 or the RLA Gateway 40 (Fig. 1), as indicated by the affirmative branches of the decision blocks 178 and 180. Changes to the production order generally require changes in the item specification. Thus, the revised Item specification is validated and then transmitted to the corporate office for another estimate, as shown in blocks 140, 141 and 142. If the item specification changes are minor (e.g., are not likely to affect the previously generated estimate), the plant personnel can make the changes and notify the sales representative, as shown in blocks 182 and 184. If the plant does not require changes in the production order, the order is manufactured, as shown in block 186. As indicated in block 188, the completion of the job is reported to the Labor and Material subsystem 94 and the Estimating subsystem 90 for actual cost analysis and reporting, as well as to the sales site to keep the sales representative apprised of the status of the order.
The screens in Figs. 45 through 53 can be generated on a mainframe terminal, for example, to guide contract management personnel at the corporate office when entering information for the creation of contract price matrices and generating a hard copy of a custom price matrix. Exemplary custom price matrices are depicted in Appendices B and C. The contract information entered using the screens is processed to extract a subset of the generic price matrices which are pertinent to a particular customer, as indicated in Appendix C.
With reference to Fig. 45, a user is prompted to enter general information in the following, correspondingly named fields: ACTION, PRODUCT TYPE, STANDARD CONTRACT SCHEDULE,
CUSTOMER NAME, and NEW/REPEAT. The screen shown in Fig. 45, as well as the subsequent screens used for contract set-up, provide the user with at least two menus. A first menu 252 is provided at the top of the screen for generally editing and making inquiries as to a particular contract or a particular contract price matrix. Another menu 254 is provided at the bottom of the screen which comprises such functions as viewing the next page of a screen, viewing the next screen or printing a particular contract price matrix. The menu 252 at the top of the screen is hierarchical in nature because it provides the same options to make inquiries about ("I"), change ("C") or delete ("D") a currently stored contract, contract price matrix, or a particular entry within the contract or matrix. Further, the user can add ("A") a new contract, contract price matrix or entry within the contract or contract matrix.
Regarding the menu 254 at the bottom of the screen, the user can depress a key on the keyboard to: (1) display a table menu on the screen; (2) advance to the next screen; (3) return to a prior screen; (4) move forward or (5) backward among the multiple pages that compose a screen; (6) specify more widths; and (7) print a schedule, among other functions. The functions assigned to keys on a keyboard can vary depending on the screen.
With continued reference Fig. 45, most of the fields in the screen and the following screens are self- explanatory. The STANDARD CONTRACT SCHEDULE field is automatically filled with a unique identification number when using the ADD or "A" menu option. The contract schedule number, along with the customer's name and the product type, appear at the top of the exemplary matrix (Appendix C) . The STANDARD CONTRACT SCHEDULE field refers to the standard price-based schedule used as the basis for selection for the contract price matrix being created. This field defaults to the current price schedule being used unless the user enters the number of another prior price-based schedule. The value in this field is the default value for the same field in subsequent screens. The PRICING FACTOR and the EFFICIENCY FACTOR fields are provided with values by the user which also serve as default values for subsequent screens. The PRODUCT TYPE field is provided with one or more values that is obtained from the corporate office. The data server 36, for example, maintains a look-up table of unique identification numbers for each product offered for sale to customers, including forms, labels and other items produced at the plants, and ready-made items offered for resale. This value is a default value in subsequent screens. The screen depicted in Fig. 46 prompts the user to enter one or more desired widths for each product type that can be priced using the contract price matrix being created. The screen depicted in Fig. 47 prompts the user to enter general information for developing composition pricing such as ACTION, STUB LENGTH, and PLY NUMBER. The standard base composition charge is retrieved from one of the generic price matrices. The exception base composition charge is calculated by multiplying the PRICE and/or the EFFICIENCY FACTOR, if previously entered, by the standard base composition charge. The base composition charge, whether it is a standard or exceptional one, is shown at the top of the exemplary matrix in Appendix C. Prices for additional charges and rules, set-up and run charges, and other factors can be added to this base, pre-press price. The user also has the option of entering special composition rules to retrieve selected prices from a database of general price-based rules maintained at the corporate office. As shown in the exemplary matrix in Appendix B, these rules can include, for example, pricing variances due to changes in the composition, heading changes, and printing on the back of a form.
Fig. 48 depicts a RULES SELECTION screen generated by the mainframe computer to prompt a user to invoke or delete a rule. The rules aid in the process of selecting data from the general price matrices that best suits a particular customer and contract terms. The rules can be stored in a look-up table in the database at the corporate office in accordance with their numbers and corresponding reference names. Rules are entered on the screen in Fig. 48 by their number and reference name, or another name assigned by the user. The screen thereafter serves as a reference or list of rules indicating the rules employed for that particular custom price matrix. An initial rule selection using the RULES screen allows the user to operate at the rule level, that is, the user is provided with a complete list of rules from which the user can select a list of potentially applicable rules by typing a "H" or a "D", respectively, in the left margin of the rule entry line. The second selection process using the RULES screen is at the sub-rule level of the rules selected initially. In other words, rules selected from the list of potentially applicable rules are transferred to the rule entry screen through which the RULES screen was invoked, i.e., the COMPOSITION PRICING, SET-UP PRICING and ADDITIONAL CHARGES screens. The RULES screen need not be invoked If the user already knows the subrule numbers needed to prepare the contract pricing matrix. With reference the screen depicted in Fig. 49, the
SET-UP PRICING screen is similar to the composition pricing screen in Fig. 11. Set-up prices cover the cost of preparing plant equipment to complete a particular job. For example, special equipment or equipment configurations may be required to create a form that has perforations and requires printing on both sides thereof. The standard base set-up charge is retrieved from a generic priced-based matrix. The exception base set-up charge is calculated based on the standard base set-up charge and the PRICING and/or EFFICIENCY factors. Set-up rules can also be used to retrieve prices from the general price base rules database using the RULES SELECTION screen depicted in Fig. 48. As shown in the exemplary matrix of Appendix B, these rules can include additional colors, back printing, copy and color ink or paper changes, perforations, and hole punching and collating charges.
A RUN CHARGES screen (Fig. 50) is generated for the user to enter general information for developing run charges. Run or running charges comprise charges for running or processing paper through a press for printing, hole punching, or folding, for example, collating the various plies of multiple ply forms together, packaging, and otherwise preparing the forms for shipment. Running charges can also include charges for materials such as paper, carbon, ink, and cartons. Running charges are generally expressed in terms of multiples of forms, i.e., "per 1,000" or "per M". The values in the CONTRACT SCHEDULE, STUB LENGTH, PRODUCT TYPE, PLY NUMBER, PRICE FACTOR, EFFICIENCY FACTOR AND WIDTH fields are carried over from previous screens. Standard run charges are retrieved from the general price matrices and can be multiplied by PRICE and/or the EFFICIENCY factors to calculate exception run charges. The ADDITIONAL CHARGES screen depicted in Fig. 51 prompt a user to enter general information for developing additional charges to be reflected in a contract price matrix. Standard flat charges and run charges are retrieved from the generic price rules database and are used with the PRICE and/or EFFICIENCY factors to calculate exception flat and run charges. Rules can also be used to retrieve prices from the general price base rules database using the RULES SELECTION screen depicted in Fig. 48. As shown in the exemplary matrix of Appendix B, these rules can modify prices in order to charge for ink matching, shrink wrapping and trimming.
With reference to Fig. 52, the VOLUME DISCOUNTS screen prompts a user to enter general Information for establishing volume discounts in the contract price matrix under development. The user can create discounts based in dollar value and quantities of items ordered. The exemplary matrices of Appendices B and C show pricing discounts based on the quantities ordered. As indicated Fig. 53, the MATERIAL UPCHARGES screen prompts a user to enter general information for establishing material upcharges in the contract price matrix under development in fields such as the ACTION, WEIGHT, COLOR, GRADE and IMAGE fields. The remaining fields contain values carried over from previous screens. The standard upcharges are retrieved from a general price- based matrix and used with the PRICE and/or the EFFICIENCY factors to calculate exception upcharges. After the user makes entries in each of the above screens, the standard contract schedule specified in the first screen, which is maintained by the Estimating subsystem 90, has information selected therefrom in accordance with the parameters defined by the fields in each of the above screens. The selected data for a contract matrix is subsequently stored in the database as a contract schedule or matrix, which is similar to the standard price matrices, and maintained by the Estimating subsystem 90. The contract pricing matrix can be condensed and printed on both sides of a form preferably using a laser printer connected to the corporate office PC network or LAN.
In accordance with another embodiment of the present invention, a number of Estimating offices (not shown) can be connected to the corporate office network 24 using a router in much the same way as the sales offices and plants. These Estimating offices can use an on-line system via the LAN 24 to receive estimates from sales offices and to review and revise them. The Estimating offices provide for more timely responses to requests for estimates from sales offices than the corporate office because they are dedicated to this purpose. The Estimating offices store in computer memory the following types of information: estimating logic information, estimate specifications and valid specifications. The Estimating offices can perform a "help desk" role in that they can focus on larger and more unusual estimates than the corporate offices handle. In general. Estimating offices maintain estimates and specifications, valid estimate specifications, transmit specifications to the corporate office and to the sales offices, receive price information from the corporate office database, review and maintain an estimate filter and perform messaging. While certain advantageous embodiments have been chosen to illustrate the invention, it will be understood by those skilled in the art that various changes and modifications can be made herein without departing from the scope of the invention as defined in the appended claims.
56 -
Page 1 of
APPENDIX A
FORM SPECIFICATION
Figure imgf000058_0001
PCT/US96/01429
Page 2 of
APPENDIX A
123456 FORM SPECIFICATION
RECYCLED PAPER
PUNCHING •«*<-» 3 TVPe 9/32" Round Hole PLACEMENT Para|le|
PERFORATIONS • PERFS ., TYPE vertical
BACK PRINTING
NUMBERING *« 7 Digit Jumbo Numbering
MICR NUMBER SPECIFICATIONS:
1 ! 1 I I ! I I I ! i I i I I I I 1 i 1 I I ! ! I i ' ! I I I 1 I L < ' I I I I I i 1 ~ I I ! i i i l ; 1
DIE CUT
HOT MELT CARBON COATING
AREA COATED CARBONLESS AL-IABEL m Wal-Labl ll
BOOKBINDING
TRANSFER TAPE
WAL-SPOT
MYLAR PATCH OR STRIP
POCKET FO«M
ACCESS SET
PLOW FOLDING'.")
MAILER
ENVELOPE.
Figure imgf000059_0001
Page 3 of 3
APPENDIX A
FORM SPECIFICATION
INKS
FRONT
PLY INK COLO R 1 INK COLOR 2 INK COLOR 3 INK COLOR 4 INK COLOR 5 INK COLOR 1 INK COLOR 2 INK COLOR 3 INK COLOR 4 INK COLOR 5
Black Blue
Black
Black Black
10
MULTIPLE COLORS PRINTING
ROLL LABEL
Figure imgf000060_0001
59
APPENDf*** fi
CUSTOMER NAME: T-R.G. PRODUCT TYPE: UNIT SET CONTRACT SCHEDULE : OlOOl
»♦. P R E . P R STUD SIZE: 0 1/2
WIDTHS r? -C-r11' » (i 1/8 — *f-_7- — 1-1-5/-- 240.00 240.00 265*00 240*00
Figure imgf000061_0001
•• V O L U M E D I S C. STUD SIZE: 8 1/2
WIDTHS
BASE SETUP 6 1/0" 7 5/8 11.5/8 14 5/β
CUSTOMER NAME; COOPER CONTRACT SCHEDULE: 20003
PRODUCT TYPE: CUSTOM CONTINUOUS
C O M P O S I T I O N *' BASE COMPOSITION * STUB SIZE: 11'
Figure imgf000062_0001
CUSTOMER NAME: COOPER CONTRACT SCHEDULE: 20003
PRODUCT TYPE: CUSTOM CONTINUOUS
* A D D L C H A R G E S ♦• STUB SIZE: 11" WIDTH: 0" QTY: .00 * RULE DESC. * FLAT RUN/M REMARKS
PATTERN COATED 81.46 CB AND/OR CFB 5.25
Figure imgf000063_0001
33 PAPERS c: r- m 12.0 WH BOND
< ro WIDTHS > .en 8 1/2"
PAPERS
15.0 WH BOND
< WIDTHS >
8 1/2' 9 7/8" 10 5/8 12" 14 7/β"
PAPERS 18.0 WH BOND 4.04 4.59 4.89 5.45 6.60
ω
CUSTOMER NAME: COOPER CONTRACT SCHEDULE: 20003
PRODUCT TYPE: CUSTOM CONTINUOUS
Figure imgf000064_0001
' V O L U M E D I S C STUB SIZE: 11' WIDTHS
8 1/2" 9 7/8" 10 5/β" 12' 14 7/β"
DOLLAR (OR QTY)
D 20000.00 10.00 % lo.oo % 10.00 % 10.00 10.00 . % D 50000.00 1.00 % l.oo v 1.00 % 1.00 1.00 V I.OO 1.00 1.00 \ 1.00 V 1.00
30
C r— m ro .en
fl) ω O
Ml
W

Claims

What Is Claimed Is:
1. A system for ordering the manufacture of an item comprising:
a first computer comprising a monitor, a first memory device and an input device for use by an operator initiating an order, said first computer being programmable to generate a series of prompts on said monitor for guiding said operator to select the item to be manufactured from a plurality of items characterized by respective sets of parameters, at least one of said sets of parameters being different from the other said sets of parameters, to enter data relating to said set of parameters corresponding to the item to be manufactured using said input device, and to store said parameter data in said first memory device; and
a second computer comprising a second memory device for storing a database, said database comprising data relating to features of different types of items, to different manufacturing processes, and to material and labor costs for producing items, said second computer being programmable to receive from said first computer said parameter data, to generate estimate data for manufacturing said item using said parameter data and said database, and to transmit said estimate data to said first computer.
2. An ordering system as claimed in claim 1, further comprising a third computer located at a manufacturing plant, said first computer being programmable to generate a production order using said estimate data and said parameter data, and to transmit said production order to said third computer.
3. An ordering system as claimed in claim 2, wherein said first computer is operable to transmit said production order to said second computer which is operable in turn to transmit said production order to said third computer.
4. An ordering system as claimed in claim 3, wherein said second computer is programmable to receive and capture said parameter data from said first computer in said database to minimize re-entry of said parameter data using said second computer, and said first computer is programmable to receive and capture said estimate data to minimize re-entry of said estimate data when generating a production order.
5. An ordering system as claimed in claim 1, further comprising a third computer located at a manufacturing plant, said first computer being programmable to generate a production order using said estimate data and at least one of said plurality of parameters, and to transmit said production order to said third computer.
6. An ordering system as claimed in claim 1, wherein said first computer is operable to transmit said production order to said second computer, and said second computer is operable to subsequently transmit said production order to said third computer.
7. An ordering system as claimed in claim 1, further comprising a third computer located at a manufacturing plant, said first computer being programmable to generate a production order using said estimate data and at least one of said plurality of parameters, wherein said first computer, said second computer and said third computer are each connected to a communication network, said third computer being operable to receive said production order via said communication network.
8. An ordering system as claimed in claim 7, wherein said third computer is programmable to provide to said second computer at least one data type selected from the group consisting of materials, labor and equipment available in and consumed by the plant to fulfill said production order.
9. An ordering system as claimed in claim 8, wherein said second computer is programmable to use said data from said third computer to perform at least one type of analysis selected from the group consisting of estimated cost analysis, actual cost analysis, and order data analysis.
10. An ordering system as claimed in claim 8, wherein said second computer is programmable to also use said data from said third computer to generate said estimate data.
11. An ordering system as claimed in claim 1, wherein said second computer is programmable to receive data relating to purchasing of said materials and to use said purchasing data to generate said estimate data.
12. An ordering system as claimed in claim 1, wherein said database is operable to store data relating to a contract for the manufacture of items, said second computer being programmable to also use said contract data to generate said estimate data.
13. A system for ordering the manufacture of an item comprising:
a first computer comprising a monitor, a first memory device and an input device for use by an operator initiating an order to enter customer order data selected from the group consisting of customer biographical data, credit approval data, item identification data, quantity data, shipping data, handling data, storage data, item usage data, ordering data, planning data, and contract data, and specification data relating to the item to be manufactured, and to store said customer order data and said specification data in said first memory device; and a second computer comprising a second memory device for storing a database comprising data relating to features of different types of items, to different manufacturing processes, and to material and labor costs for producing the different types of items, said second computer being programmable to receive from said first computer said specification data, to generate estimate data for manufacturing said item using said specification data and said database, and to transmit said estimate data to said first computer;
said first computer being further programmable to generate a production order by retrieving said customer order data and said specification data using said first memory and automatically combining said retrieved data with said estimate data.
14. An ordering system as claimed in claim 13, further comprising a third computer located at a manufacturing plant, said first computer being programmable to transmit said production order to said third computer.
15. An ordering system as claimed in claim 13, wherein said first computer is operable to transmit said production order to said second computer, and said second computer is operable to subsequently transmit said production order to said third computer.
16. An ordering system as claimed in claim 13, further comprising a third computer located at a manufacturing plant and a communication network, said first computer, said second computer and said third computer each being connected to said communication network, said third computer being operable to receive said production order via said communication network.
17. An ordering system as claimed in claim 16, wherein said third computer is programmable to provide to said second computer at least one data type selected from the group consisting of materials, labor and equipment available in and consumed by the plant to fulfill said production order.
18. An ordering system as claimed in claim 17, wherein said second computer is programmable to use said data from said third computer to perform at least one type of analysis selected from the group consisting of estimated cost analysis, actual cost analysis, and order data analysis.
19. An ordering system as claimed in claim 17, wherein said second computer is programmable to also use said data from said third computer to generate said estimate data.
20. An ordering system as claimed in claim 13, wherein said second computer is programmable to receive data relating to purchasing of said materials and to use said purchasing data to generate said estimate data.
21. An ordering system as claimed in claim 13, wherein said database is operable to store data relating to a contract for the manufacture of items, said second computer being programmable to also use said contract data to generate said estimate data.
22. A method of ordering the manufacture of an item, comprising the steps of:
selecting the item to be manufactured from a plurality of items characterized by respective sets of parameters stored in a memory device using a first computer, at least one of said sets of parameters being different the other said sets of parameters;
generating a specification for the item using said first computer by entering data relating to said set of parameters corresponding to the item to be manufactured using a first input device;
transmitting the specification to a second computer which is configured to maintain a substantially centralized database comprising pricing data;
generating estimate data using said second computer in accordance with said specification; and
transmitting said estimate data to said first computer.
23. A method of ordering the manufacture of an item as claimed in claim 22, further comprising the step of:
generating a first production order using said first computer in accordance with said specification and said estimate data.
24. A method of ordering the manufacture of an item as claimed in claim 23, further comprising the step of:
transmitting said first production order to a third computer at a manufacturing plant.
25. A method of ordering the manufacture of an item as claimed in claim 23, further comprising the steps of:
transmitting said first production order to said second computer; and transmitting said first production order to a third computer at a manufacturing plant.
26. A method of ordering the manufacture of an item as claimed in claim 25, wherein said second computer is located at a corporate office, said first computer is located at a sales site remotely located from the corporate office, and further comprising the step of reviewing said first production order at said corporate office.
27. A method of ordering the manufacture of an item as claimed in claim 25, further comprising the steps of:
reviewing said first production order at said manufacturing plant and fulfilling said first production order if it is determined to be acceptable, and notifying said first computer if said first production order is determined to be unacceptable.
28. A method of ordering the manufacture of an item as claimed in claim 22, wherein said step of generating estimate data comprises the step of determining pricing data from at least one table of data stored in a memory device that is accessible by said second computer.
29. A method of ordering the manufacture of an item as claimed in claim 28, wherein said step of generating estimate data comprises the step of generating pricing data that is specific to a particular customer with whom a contractual agreement is established by modifying said table in accordance with the terms of the contractual agreement.
30. A method of ordering the manufacture of an item as claimed in claim 29, wherein said table is modified in accordance with at least one data type selected from the group consisting of a price factor, an efficiency factor, a pricing rule, a volume discount, a characteristic of the item to be manufactured in accordance with the contractual agreement, an equipment set-up charge, a run charge and a material upcharge.
31. A method of ordering the manufacture of an item as claimed in claim 23, further comprising the steps of:
storing said specification and said estimate data in said memory device; and
generating a second production order that is similar to said first production order by retrieving from said memory device at least part of said specification and said estimate data associated with said first production order.
32. A method of ordering the manufacture of an item as claimed in claim 31, wherein said step of generating said second production order is performed by a computer selected from the group consisting of said first computer, said second computer, and a third computer at a manufacturing plant.
33. A method of ordering the manufacture of an item as claimed in claim 22, wherein said memory device is associated with said first computer.
34. A method of ordering the manufacture of an item as claimed in claim 22, wherein said memory device is associated with said second computer.
35. A method of ordering the manufacture of an item, comprising the steps of: generating a specification for the item using a first computer, said specification being stored in a memory device and comprising customer order data selected from the group consisting of customer biographical data, credit approval data, item identification data, quantity data, shipping data, handling data, storage data, item usage data, ordering data, planning data, and contract data, and specification data relating to the item to be manufactured; transmitting the specification to a second computer which is configured to maintain a substantially centralized database comprising pricing data;
generating estimate data using said second computer in accordance with said specification;
transmitting said estimate data to said first computer; and
generating a production order using said first computer in accordance with said specification and said estimate data by retrieving said customer order data and said specification data from said memory device and automatically combining said retrieved data with said estimate data.
36. A method of ordering the manufacture of an item as claimed in claim 35, further comprising the step of:
generating a production order using said first computer in accordance with said specification and said estimate data.
37. A method of ordering the manufacture of an item as claimed in claim 36, further comprising the step of transmitting said production order to a third computer at a manufacturing plant.
38. A method of ordering the manufacture of an item as claimed in claim 36, further comprising the steps of:
transmitting said production order to said second computer; and
transmitting said production order to a third computer at a manufacturing plant.
39. A method of ordering the manufacture of an item as claimed in claim 38, wherein said second computer is located at a corporate office, said first computer is located at a sales site remotely located from the corporate office, and further comprising the step of reviewing said production order at said corporate office.
40. A method of ordering the manufacture of an item as claimed in claim 38, further comprising the steps of:
reviewing said production order at said manufacturing plant and fulfilling said production order if it is determined to be acceptable; and
notifying said first computer if said production order is determined to be unacceptable.
41. A method of ordering the manufacture of an item as claimed in claim 35, wherein said step of generating estimate data comprises the step of determining pricing data from at least one table of data stored in a memory device that is accessible by said second computer.
42. A method of ordering the manufacture of an item as claimed in claim 41, wherein said step of generating estimate data comprises the step of generating pricing data that is specific to a particular customer with whom a contractual agreement is established by modifying said table in accordance with the terms of the contractual agreement.
43. A method of ordering the manufacture of an item as claimed in claim 42, wherein said table is modified in accordance with at least one data type selected from the group consisting of a price factor, an efficiency factor, a pricing rule, a volume discount, a characteristic of the item to be manufactured in accordance with the contractual agreement, an equipment set-up charge, a run charge and a material upcharge. 44. A method of ordering the manufacture of an item as claimed in claim 36, further comprising the steps of:
storing said specification and said estimate data in a memory device; and
generating a second production order that is similar to said first production order by retrieving from the memory device at least part of said specification and said estimate data associated with said first production order.
45. A method of ordering the manufacture of an item as claimed in claim 44, wherein said memory device is associated with said first computer.
46. A method of ordering the manufacture of an item as claimed in claim 44, wherein said memory device is associated with said third computer.
AMENDED CLAIMS
[received by the International Bureau on 19 July 1996 (19.07.96); new claims 47-74 added; remaining claims unchanged (9 pages)]
43. A method of ordering the manufacture of an item as claimed in claim 42, wherein said table is modified in accordance with at least one data type selected from the group consisting of a price factor, an efficiency factor, a pricing rule, a volume discount, a characteristic of the item to be manufactured in accordance with the contractual agreement, an equipment set-up charge, a run charge and a material upcharge.
44. A method of ordering the manufacture of an item as claimed in claim 36, further comprising the steps of:
storing said specification and said estimate data in a memory device; and
generating a second production order that is similar to said first production order by retrieving from the memory device at least part of said specification and said estimate data associated with said first production order.
45. A method of ordering the manufacture of an item as claimed in claim 44, wherein said memory device is associated with said first computer.
46. A method of ordering the manufacture of an item as claimed in claim 44, wherein said memory device is associated with said third computer.
47. A system for ordering the manufacture of a product comprising:
a first computer comprising a monitor, a first memory device and an input device for use by an operator initiating an order for the manufacture of said product, said first computer being programmable to generate a plurality of prompts on said monitor for guiding said operator to make at least one of a plurality of choices regarding said product using said input device, said plurality of choices comprising which of a plurality of products is to be manufactured, which of a plurality of processes are to be used to manufacture said product and which of a plurality of materials are to be used to manufacture said product, and to generate output signals corresponding to said at least one of a plurality of choices; and
a second computer comprising a second memory device for storing a database, said database comprising data relating to said plurality of products, said plurality of processes and said plurality of materials for generating list price data, said second computer being programmable to receive said output signals from said first computer, to generate estimate data comprising list price for manufacturing said product using said database and said output signals, and to transmit said estimate data to said first computer.
48. An ordering system as claimed in claim 47, wherein said database further comprises price concession data relating to a contractual agreement with a customer, and said second computer is operable to transmit said price concession data to said operator to allow said operator to generate a sell price less than said estimate which corresponds to said price concession data.
49. A system for ordering the manufacture of a product comprising:
a first computer comprising a monitor, a first memory device and an input device for use by an operator initiating an order for the manufacture of said product, said first computer being programmable to generate a plurality of prompts on said monitor for guiding said operator to make at least one of a plurality of choices regarding said product using said input device, said plurality of choices comprising which of a plurality of products is to be manufactured, which of a plurality of processes are to be used to manufacture said product and which of a plurality of materials are to be used to manufacture said product and to generate a product specification corresponding to said at least one of a plurality of choices, said prompts comprising screens displayed on said monitor having parameters for defining each of said plurality of products, said plurality of products being characterized by respective sets of said parameters, at least two of said sets of parameters being different from one another; and
a second computer comprising a second memory device for storing a database, said database comprising data relating to said plurality of products, said plurality of processes and said plurality of materials for generating an estimate, said second computer being programmable to receive said product specification from said first computer, to generate estimate data for manufacturing said product using said database and said product specification, and to transmit said estimate data to said first computer.
50. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate selected ones of said screens in a selected order depending on said operator's responses to said prompts using said input device.
51. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate a subset of said screens in a selected order depending on which of said plurality of products said operator selects for manufacture.
52. An ordering system as claimed in claim 51, wherein said first computer is programmable to generate selected ones of said subset of screens and not other ones of said subset of said screens depending on said at least one of said plurality of choices.
53. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate at least one customer information screen comprising data relating to a customer who has previously ordered the manufacture of a number of said plurality of products, said first memory device being programmable to retrieve product specifications corresponding to said previously ordered products which are stored in said second memory device and identified by unique product specification identifiers, each of said product specifications being characterized by one of said sets of parameters, said first computer being programmed to generate a list of said product specification identifiers on said at least one customer information screen, to process an input signal generated by said input device when said operator selects one of said product specification identifiers, to retrieve said product specification corresponding to said selected product specification identifier, and to display said retrieved product specification on said monitor.
54. An ordering system as claimed in claim 53, wherein at least one estimate corresponding to at least one of said product specifications is stored in at least one of said first memory device and said second memory device, and said first computer is programmable to generate an order screen that requests a number of data relating to said customer and said product selected for manufacture, and to automatically provide at least part of said number of data by retrieving said data from said product specification and said estimate.
55. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate a screen comprising a list of names corresponding to respective ones of said plurality of products, to process input signals generated by said input device when said operator selects one of said plurality of products, and to generate at least one screen comprising said set of parameters corresponding to said selected product.
56. An ordering system as claimed in claim 55, wherein said operator uses said input device to enter parameter data for at least a subset of said set of parameters for said selected product to customize said product, and said first computer is programmable to generate an product specification for said customized product comprising said parameter data.
57. An ordering system as claimed in claim 49, wherein said plurality of products comprises a business form, a label, a mailer, commercial printing, an envelope, a padded product, an add roll, and on-demand reproduction.
58. An ordering system as claimed in claim 57, wherein said set of parameters corresponding to said business form are selected from the group consisting of number of plies, type of paper, size of paper, weight of paper, color of paper, composition on paper, type of ink, color of ink, perforation options, hole punching options, packaging options and fastening options.
59. An ordering system as claimed in claim 57, wherein said set of parameters corresponding to said label are selected from the group consisting of face type, color, adhesive, label size, liner type, die type and liner size.
60. An ordering system as claimed in claim 57, wherein said set of parameters corresponding to said envelope are selected from the group consisting of envelope size, ink color, type of printing, location of printed indicia, inside tint, tint color, barcode printing, return address printing, and postage payor permit data printing.
61. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate a predetermined number of screens to prompt said operator to view said parameters and enter parameter data via said input device for selected ones of said parameters as desired, to determine when entry of said parameter data for other ones of said parameters is not necessary, and to prevent said operator from entering said parameter data for said other ones of said parameters.
62. An ordering system as claimed in claim 49, wherein said second computer is programmable to validate said product specification by comparing said product specification with validation data stored in said second memory device, said validation data being selected from the group consisting of material code, material type, customer contract data, specification parameters, previously validated product specifications, customer identification data, and type of product ordered for manufacture.
63. An ordering system as claimed in claim 62, wherein said second computer is programmable to generate and transmit a validation signal to said first computer, said first computer being programmable to generate a prompt to indicate to said operator that one of said plurality of choices is improper if said validation signal indicates that said product specification is invalid.
64. An ordering system as claimed in claim 49, wherein first memory device stores at least one of validation data and validation rules, and said first computer is programmable to validate said product specification by comparing said product specification with at least one of said validation data and said validation rules, said validation data being selected from the group consisting of specification parameters, previously validated product specifications, customer identification data, and type of product ordered for manufacture.
65. An ordering system as claimed in claim 64, wherein said first computer is programmable to generate a prompt to indicate to said operator that one of said plurality of choices is improper if said first computer determines said product specification to be invalid.
66. An ordering system as claimed in claim 49, wherein said first computer is programmable to generate a first estimate screen comprising estimate screen data selected from the group consisting of identification of said product being ordered for manufacture, quantity of said product, storage data and shipment data.
67. An ordering system as claimed in claim 66, wherein said first computer is programmable to retrieve at least a portion of said estimate screen data and said product specification corresponding to said product specified using said estimate screen from said first memory device, and to transmit said portion of said estimate screen data and said product specification to said second computer.
68. An ordering system as claimed in claim 67, wherein said first computer is programmable to generate a second estimate screen displaying said estimate data received from said second computer.
69. An ordering system as claimed in claim 68, wherein said estimate data comprises at least one of a list price and a suggested sell price.
70. An ordering system as claimed in claim 69, wherein said first computer is programmable to receive another input signal from said input device corresponding to at least one of said estimate screen data, to transmit said input signal to said second computer, and said second computer is programmable to generate and transmit additional estimate data to said first computer comprising at least one of a list price and a suggested sell price.
71. An ordering system as claimed in claim 70, wherein said first computer is programmable to generate a third estimate screen displaying at least one of said list price and said suggested sell price from each of said estimate data and said additional estimate data.
72. An ordering system as claimed in claim 66, wherein said estimate screen data comprises identification of a plurality of said products and said second computer is programmable to generate said estimate data for each of said plurality of said products, at least one of said estimate data conferring a discount corresponding to the number of said plurality of said products being ordered.
73. An ordering system as claimed in claim 66, wherein said second computer is programmable to validate said estimate data if said estimate data satisfies at least one criterion selected from a group of criteria consisting of estimate data relating to a selected one of said plurality of materials, estimate data for a quantity of said product which exceeds a predetermined number, estimate data exceeding a selected monetary value, and estimate data for a selected customer.
74. An ordering system as claimed in claim 66, wherein said first computer is programmable to generate an order screen comprising a plurality of order data selected from the group consisting of indicia for identifying said product specification, customer information, indicia for identifying said estimate corresponding to said product specification, list prices and suggested sell prices, and to retrieve at least part of said order data from said product specification and said estimate data.
PCT/US1996/001429 1996-02-02 1996-02-02 Custom product estimating and order processing system WO1997028506A1 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
AU48626/96A AU4862696A (en) 1996-02-02 1996-02-02 Custom product estimating and order processing system
PCT/US1996/001429 WO1997028506A1 (en) 1996-02-02 1996-02-02 Custom product estimating and order processing system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/US1996/001429 WO1997028506A1 (en) 1996-02-02 1996-02-02 Custom product estimating and order processing system

Publications (1)

Publication Number Publication Date
WO1997028506A1 true WO1997028506A1 (en) 1997-08-07

Family

ID=22254679

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1996/001429 WO1997028506A1 (en) 1996-02-02 1996-02-02 Custom product estimating and order processing system

Country Status (2)

Country Link
AU (1) AU4862696A (en)
WO (1) WO1997028506A1 (en)

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000075826A1 (en) * 1999-06-09 2000-12-14 Impresse Corporation Iterative constraint collection scheme for preparation of custom manufacturing contracts
US6279009B1 (en) 1998-12-04 2001-08-21 Impresse Corporation Dynamic creation of workflows from deterministic models of real world processes
US6278901B1 (en) 1998-12-18 2001-08-21 Impresse Corporation Methods for creating aggregate plans useful in manufacturing environments
US6299063B1 (en) 1998-12-04 2001-10-09 Impresse Corporation Method and apparatus for automated data entry
US6321133B1 (en) 1998-12-04 2001-11-20 Impresse Corporation Method and apparatus for order promising
US6347256B1 (en) 1998-11-02 2002-02-12 Printcafe System, Inc. Manufacturing process modeling techniques
US6546364B1 (en) 1998-12-18 2003-04-08 Impresse Corporation Method and apparatus for creating adaptive workflows
US7047215B2 (en) * 2000-12-06 2006-05-16 International Business Machines Corporation Parts requirement planning system and method across an extended supply chain
US7359874B2 (en) * 2001-01-08 2008-04-15 International Business Machines Corporation Method and system for facilitating parts procurement and production planning across an extended supply chain
US8630910B2 (en) 2002-07-30 2014-01-14 Verso Paper Llc Multi-party, multi-tier system for managing paper purchase and distribution
CN112613910A (en) * 2020-12-24 2021-04-06 上海寻梦信息技术有限公司 Method, device and equipment for providing product subpackage information and storage medium
CN113627988A (en) * 2021-08-16 2021-11-09 深圳市云采网络科技有限公司 Charging method for processing assembled circuit board and electronic equipment
CN112613910B (en) * 2020-12-24 2024-04-26 上海寻梦信息技术有限公司 Method, apparatus, device and storage medium for providing product packaging information

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5357439A (en) * 1990-03-09 1994-10-18 Hitachi, Ltd. Custom-made manufacturing system and custom-made manufacturing method

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5357439A (en) * 1990-03-09 1994-10-18 Hitachi, Ltd. Custom-made manufacturing system and custom-made manufacturing method

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6347256B1 (en) 1998-11-02 2002-02-12 Printcafe System, Inc. Manufacturing process modeling techniques
US6279009B1 (en) 1998-12-04 2001-08-21 Impresse Corporation Dynamic creation of workflows from deterministic models of real world processes
US6299063B1 (en) 1998-12-04 2001-10-09 Impresse Corporation Method and apparatus for automated data entry
US6321133B1 (en) 1998-12-04 2001-11-20 Impresse Corporation Method and apparatus for order promising
US6278901B1 (en) 1998-12-18 2001-08-21 Impresse Corporation Methods for creating aggregate plans useful in manufacturing environments
US6546364B1 (en) 1998-12-18 2003-04-08 Impresse Corporation Method and apparatus for creating adaptive workflows
US7587336B1 (en) 1999-06-09 2009-09-08 Electronics For Imaging, Inc. Iterative constraint collection scheme for preparation of custom manufacturing contracts
WO2000075826A1 (en) * 1999-06-09 2000-12-14 Impresse Corporation Iterative constraint collection scheme for preparation of custom manufacturing contracts
US7047215B2 (en) * 2000-12-06 2006-05-16 International Business Machines Corporation Parts requirement planning system and method across an extended supply chain
US7395228B2 (en) 2000-12-06 2008-07-01 International Business Machines Corporation Parts requirement planning system across an extended supply chain
US7359874B2 (en) * 2001-01-08 2008-04-15 International Business Machines Corporation Method and system for facilitating parts procurement and production planning across an extended supply chain
US7519550B2 (en) 2001-01-08 2009-04-14 International Business Machines Corporation Storage medium for facilitating parts procurement and production planning across an extended supply chain
US8630910B2 (en) 2002-07-30 2014-01-14 Verso Paper Llc Multi-party, multi-tier system for managing paper purchase and distribution
CN112613910A (en) * 2020-12-24 2021-04-06 上海寻梦信息技术有限公司 Method, device and equipment for providing product subpackage information and storage medium
CN112613910B (en) * 2020-12-24 2024-04-26 上海寻梦信息技术有限公司 Method, apparatus, device and storage medium for providing product packaging information
CN113627988A (en) * 2021-08-16 2021-11-09 深圳市云采网络科技有限公司 Charging method for processing assembled circuit board and electronic equipment

Also Published As

Publication number Publication date
AU4862696A (en) 1997-08-22

Similar Documents

Publication Publication Date Title
US5570291A (en) Custom product estimating and order processing system
US7660721B2 (en) Apparatus, systems and methods for online, multi-parcel, multi-carrier, multi-service parcel returns shipping management
US7143051B1 (en) Method and system for quoting, issuing, and administering insurance policies including determining whether insurance policies are self bill or list bill
US6330542B1 (en) Automated internet quoting and procurement system and process for commercial printing
US7890920B2 (en) Storage medium for storing a program for executing the product purchasing method, and a server used therefor
US7225040B2 (en) Method and system for reducing lead-time in the packaging industry
US5694551A (en) Computer integration network for channeling customer orders through a centralized computer to various suppliers
US7117211B2 (en) Internet label production system
US20020010659A1 (en) Inventory management and/or control
US20020120533A1 (en) Method and system for management of ordering, production, and delivery of made-to-specification goods
WO2006014267A1 (en) Assisted electronic product design
JP2004500654A (en) Managing print jobs
WO2008054722A2 (en) Historical insurance transaction system and method
US20060200479A1 (en) Form production system
WO1997028506A1 (en) Custom product estimating and order processing system
US20010032166A1 (en) System and method for planning and tracking the manufacture of tooling for machinery
EP1298558A2 (en) Optimisation algorithm for a label printing system using plates
US20020156707A1 (en) Methods and systems for purchasing and inventory of paper and extended media products
US7076450B1 (en) Method for automated print ordering utilizing the internet
KR20000063833A (en) Method for ordering printed matter by used internet
CA2156460A1 (en) Custom product estimating and order processing system
US20050177460A1 (en) Method and system for supplying customized product catalogs
JP2002297935A (en) Trial calculation, estimate and order receiving and placing processing system for receiving and placing order for printed matter
JP2002133197A (en) Vicarious ordering system
JP2002029607A (en) Physical distribution system

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AL AM AT AU AZ BB BG BR BY CH CN CZ DE DK EE ES FI GB GE HU IS JP KE KG KP KR KZ LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK TJ TM TR TT UA UG UZ VN

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): KE LS MW SD SZ UG AT BE CH DE DK ES FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

NENP Non-entry into the national phase

Ref country code: JP

Ref document number: 97527586

Format of ref document f/p: F

122 Ep: pct application non-entry in european phase