JP2013105216A - Purchase history analysis system of indirect material - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a purchase history analysis system of indirect material for supporting procurement purchase of the indirect material where estimation is acquired each time.SOLUTION: A purchase history analysis system comprises: a vendor database 2; a project database 3; an item database 4; and a specification database 5. Data to be registered in each database are standardized. The purchase history analysis system comprises various functions such as a corporate information registration function, a communication function, a supplier registration function, a purchase application function, a contract management function, and an estimate request function.

Description

  The present invention relates to a support system for purchasing and purchasing indirect materials, and more particularly, to a system that supports business by performing purchase history analysis.

  Conventionally, the systematization of companies involved in the procurement of goods and services has been completed by mechanisms such as purchasing, logistics, delivery, inspection, payment, and inventory management. However, systematization has not progressed from the stage of considering purchases in front of this area to the stage of negotiations.

  In other words, at present, indirect materials are purchased independently for each department, and estimates are made independently on site and ordered individually. Since indirect materials have a wide variety of items, estimation and inquiries are complicated, and purchasing them is a troublesome task. Therefore, if there is no purchasing experience and know-how for each item, the efficiency is not improved and the purchase is high. Such a situation is shown in FIG.

  However, indirect materials have few procurement companies compared to direct materials, and few companies tackle purchasing systematization directly because the cost reduction range is small. In the procurement goods meeting, it is repeatedly pointed out that there is a shortage of information that the administrator wants to suppress in response to the explanation of the person in charge, and the time and man-hours of the person in charge, the administrator, and the settler are wasted. In response to the indication of missing information, there is no information in the company as a whole, and the people in charge at each location keep it in various forms. It takes time and man-hours to contact a person, request information, and have them look for it.

  That is, in the current situation of the purchasing department of Japanese companies, there are three purchasing methods: distributed purchasing, centralized purchasing, and centralized purchasing. Distributed purchasing refers to a purchasing format in which prices, delivery dates, and procurement conditions are set with the supplier's sales staff via the responsible buyer, and ordering is performed individually. On the other hand, the purchase status in each department is aggregated, and the purchase is a collective purchase in which the scale is collected and contracts are made at a low unit price, and the central purchase in which the purchasing department intensively purchases goods procured by the company. Indirect materials purchasing in companies is performed by placing an estimate individually with the sales representative of the supplier via the responsible buyer, concurrent staff, part, etc., setting the price, delivery date, procurement conditions, and placing an order. Are stored individually by the person in charge at each office and department, and are not centralized as a whole company.

  In addition, even if the buyer in charge acquires multiple specifications and estimates, the activities and information are buried, not the knowledge of the organization, when the purchase is completed. When considering purchasing a similar item in another department, the buyer in charge of the other department examines specifications, prices, delivery dates, and procurement conditions from the beginning, and negotiates with the sales person in charge of the supplier. In this case, there is a problem that the information obtained from the activities of the person in charge cannot be used as organizational knowledge because the person in charge of the information is stored and discarded.

  In view of the above problems, an object of the present invention is to provide a system for supporting procurement purchase of indirect materials for which an estimate is obtained each time.

  In order to achieve the above object, the indirect purchase history analysis system of the present invention includes a vendor database, a project database, an item database, and a specification database. In addition, the data registered in each database is standardized, and the company information registration function, communication function, supplier registration function, purchase application function, contract management function, quotation request function, priority supplier / normal supplier function, supplier company transaction Prohibition function, estimate decline function, estimate reply, notice function by receiving email of supplier's estimate decline, estimate time stamp function, information bulletin board alert mail function, supplier contact person registration function, contact person entry / exit prohibition function or trade prohibition function , Buyer Evaluation Function, Quotation Cancellation / Re-estimation Aggregation Function, Supplier Recommendation Reason Function, and Web Purchasing Cooperation Function.

  According to the present invention, the purchasing history of each department is changed by changing the experience and know-how of purchasing personnel in each department from tacit knowledge of personal management to formal knowledge that can be used by the organization, and having various functions. Analyzes can be effectively constructed to reduce the cost of the entire company, and an indirect purchase history analysis system can be provided.

It is a block diagram which shows embodiment of the purchase log | history analysis system of the indirect material of this invention. It is a block diagram which shows the utilization procedure of the purchase history analysis system of the indirect material of FIG. It is a block diagram which shows the utilization procedure of the purchase history analysis system of the indirect material of FIG. It is a block diagram which shows the utilization procedure of the purchase history analysis system of the indirect material of FIG. It is a figure which shows an estimate explanatory sheet. It is a figure which shows a specification, a quotation specification, a quotation detail, and a link portal. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a buyer screen. It is a figure which shows an estimate request screen. It is a figure which shows an estimate request screen. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows a series of data collection and taking-in mechanism. It is a figure which shows the form of the procurement of the conventional indirect material. It is a figure which shows the specific example of a company information registration function. It is a figure which shows the specific example of a company information registration function. It is a figure which shows the specific example of a company information registration function. It is a figure which shows the specific example of a company information registration function. It is a figure which shows the specific example of a communication function. It is a figure which shows the specific example of a communication function. It is a figure which shows the specific example of a supplier registration function. It is a figure which shows the specific example of a supplier registration function. It is a figure which shows the specific example of a supplier registration function. It is a figure which shows the specific example of a purchase application function. It is a figure which shows the specific example of a purchase application function. It is a figure which shows the specific example of a purchase application function. It is a figure which shows the specific example of a contract management function. It is a figure which shows the specific example of a contract management function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of an estimate request function. It is a figure which shows the specific example of the selection function of an important supplier and a normal supplier. It is a figure which shows the specific example of an identification function of an important supplier and a normal supplier. It is a figure which shows the specific example of a supplier company transaction prohibition function. It is a figure which shows the specific example of the estimate decline function by the non-participation button of a supplier. It is a figure which shows the specific example of a decline reason input screen in the case of non-participation of a supplier. It is a figure which shows the specific example of the function of noticing by the mail reception of a supplier's estimate decline. It is a figure which shows the specific example of the function of awareness by the mail reception of an estimate reply. It is a figure which shows the specific example of an estimated time stamp function. It is a figure which shows the specific example of an information bulletin board function. It is a figure which shows the specific example of the alert mail function sent to a related person. It is a figure which shows the specific example of a supplier person-in-charge registration function, a person-in-charge entry / exit prohibition function, or a transaction prohibition function. It is a figure which shows the specific example of a buyer evaluation function. It is a figure which shows the specific example of an estimate cancellation / re-estimation totalization function. It is a figure which shows the specific example of a supplier recommendation reason function. It is a figure which shows the specific example of a web purchasing cooperation function. It is a figure which shows the specific example of an Excel input workflow in WEB purchasing cooperation. It is a figure which shows the specific example of one screen workflow management. It is a figure which shows the specific example of the transaction confirmation sheet | seat for new business inventory. It is a figure which shows the example of entry of specification content.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing an embodiment of an indirect purchase history analysis system of the present invention. The indirect purchase history analysis system 1 includes a vendor database 2, a project database 3, an item database 4, and a specification database 5. The role of the indirect purchase history analysis system 1 is to provide the system with easy information for the purpose of distributed purchase management, and to assist the manager in making a quick decision in the examination process. And supporting decentralized purchasing. In addition, decentralized purchasing management means that in order to achieve the company's business plan, the materials required for the business are appropriately supplied from the appropriate business partners, in an appropriate quantity, at the appropriate time, while ensuring the appropriate quality. Means management activities to obtain at a reasonable price.

  Vendor database 2 includes the supplier name, supplier code, address, telephone number, performance, authentication, contact name, e-mail address, mobile phone number, account, delivery record, blacklist management, account acquisition process for each supplier.・ Information such as opening an account is stored.

  The project database 3 stores information such as a business department name and code number, a requested department name and code number, a delivery place code, a project name, a project description, a project leader name, and a date.

  Item database 4 includes procurement item classification code, manufacturer name / code, product name / code, supplier name / code, delivery location code, unit, unit price, quantity, amount, specifications (size, etc.), date, requested department name / Stores information such as codes, business division names and codes.

  The spec database 5 stores information such as product names / project names, product specifications, business specifications, proposals, and contracts.

  2, 3 and 4 are block diagrams showing a procedure for using the indirect purchase history analysis system of FIG. First, purchase items and usage purposes are registered in the indirect purchase history analysis system 1. Subsequently, information such as when (recruitment time), where (recruitment location), who (the person in charge of the trader), what (specification content), and how much (contract price) is registered in the indirect purchase history analysis system 1. And according to this, the examination material of purchase goods is created and it is useful for selecting an estimate company. Here, at the estimation stage, a purchased article examination explanation sheet as shown in FIG. 5 is used.

  If approval is obtained, request a quote. Thereafter, quotes are collected from each company, estimate comparison data is also created before the negotiation, is used for the negotiation, and is registered in the indirect purchase history analysis system 1. In parallel with this, electronic business negotiations and successful business negotiations are held. When the negotiation is decided, the contract is made directly or after approval. This is registered in the indirect material purchase history analysis system 1. Additional orders are also registered in the indirect purchase history analysis system 1. At the same time, when data in a CSV format that can be registered is transferred to a product database in another system and an order is registered in the product database, the order is actually placed, and finally inspection and delivery are performed.

  FIG. 6 is a diagram showing a specification, an estimate specification, an estimate detail, and a link portal. In other words, this is because the basic form data (specifications / quotation specifications / quotation details / link portal) for each item is stored in the repository when requesting a quote. Use the corresponding data from the repository.

  FIG. 7 is a diagram showing a series of data collection and capture mechanisms. When requesting a quote, the buyer notifies the supplier of the data of the target item from the repository. The supplier opens a link in the notification, inputs estimate data, confirms (sends), and stores it as data and outputs it as a quote. Next, the buyer confirms the sent estimate data and stores it in the estimate database. After price negotiation and decision, data entry, contract conclusion, delivery and inspection are performed.

  More specifically, as shown in FIG. 8, the system creates a folder for each case for each buyer's request for quotation, and sends it by e-mail together with the case registration information. On the other hand, the supplier logs in ID, confirms the specifications / drawings on the net, expands the estimate form (quote / quote details) by item, inputs the estimate information, and confirms (sends) and outputs it. The output is submitted to the buyer company as an estimate by pressing the company seal.

  FIG. 9 shows a buyer screen. The estimate arrives by confirming the supplier's estimate, and the buyer confirms the situation on such a screen, confirms the estimated arrival situation, and after all arrives, compares and displays it. This document makes it possible to carry out negotiations effectively because the attitudes and conditions of each company can be confirmed before the negotiations that take place after the arrival of all estimates.

  FIG. 10 shows a registration screen for requesting a quote among the buyer screens. The project name is written below the input box on the screen so that the naming rules can be understood (year / month / location / procurement etc.). In addition, in-house classification codes and UNSPSC candidates can be displayed and selected by free word search. After selecting the company classification code and UNSPSC code, the target quotation manual, quotation form, and basic form of the specification are set.

  FIG. 11 shows an estimate request setting screen in the buyer screen. The data is sent with the send button after confirming the data of the estimate item and the supplier of the destination.

  FIG. 12 is a supplier portal screen for receiving data of an estimate form / specification / drawing and performing an estimate operation (link portal). Here, the request for quotation is received.

  FIG. 13 is a supplier portal screen for performing operations (estimate data, specifications, drawings) such as estimate data input. Enter the estimate here.

  FIG. 14 is a buyer screen, which is a screen for receiving an estimate received screen (data reception status confirmation, data expansion) sent from a supplier. Data is now reflected in the database.

  FIG. 15 is a buyer screen for comparing estimates. Here, a comparison table is created from the data expanded.

  FIG. 16 is a supplier screen for referring to submitted past data. The estimate information entered by the supplier can be viewed by the supplier himself / herself, and he / she can talk while looking at the same file at the telephone meeting with the buyer.

Next, the function of the indirect purchase history analysis system of the present invention will be described.
1: Company information registration function The handling items and classification system as buyer companies (procurement item information) can be registered in csv format. The information can be viewed when the supplier company sets its own company information by self-service, and when the supplier company registers items that have been quoted so far as target items, other item information is displayed. You can see it and register it as a handling item again. This allows existing suppliers to become new contractors for other items. With this information, buyer companies can know how many supplier companies there are for each item, and at the same time, because existing companies become new companies with other items, competition for cost reduction can be promoted.
Since the company registration function is used, the information of the person in charge who is concurrently serving can be shared throughout the company. After searching for information, you can search for consultants and people who have shared information. It is a function of know-how to find people who know know-how.
What has not been able to aggregate the actual delivery of each supplier so far can use the “transaction confirmation sheet” information of the company registration function to list the achievements of the entire company. Even if the price of the delivered indirect material is inconsistent in the department or person in charge, this function can be used to identify the data of the indirect material procured item.
Specifically, as shown in FIG. 18, the supplier checks the number of supplier companies for each item as shown in FIG. 19, and the buyer company as shown in FIG. The role etc. can be confirmed by the person in charge information. As shown in FIG. 21, it can be used for confirmation and data cleansing of whether the unit price and delivery amount of goods and services contracted with each supplier are correct.

2: Communication Function Indirect material purchase history analysis system of the present invention is often not a unified activity because indirect material purchase itself is performed separately in various places. For this reason, this function is used to provide an information notification function for communication with each department / person in charge. Since this function is also applied to the supplier company, information notification and information bulletin board functions between the buyer and the supplier can be utilized. You can select notifications only within the buyer company, notifications only to the supplier, and notifications between the supplier and the buyer company.
Specifically, the set information shown in FIG. 22 is shown, and the estimated response information is shared with the target person in charge as shown in FIG.

3: Supplier registration function In this system, the input of information is basically “supplier is primary” and “buyer company is secondary”. In other words, the buyer sets supplier information only by setting business card information such as company name, person in charge name, e-mail address, and telephone number. After that, supplier basic information (supplier negotiations) (Participation area, annual sales information, etc.) and details of the person in charge are entered.When the supplier makes additional corrections to the company's information, the manager of the buyer company is notified and a business meeting is held. Checking whether the information is correctly entered, which saves the input burden of the person in charge of the buyer company, and the supplier confirmation sheet works as part of that.
Specifically, after the supplier input as shown in FIG. 24, an email is sent to the buyer manager as shown in FIG. As shown in FIG. 26, it is also possible to manage the supplier's negotiation participation area and annual sales information.

4: Purchase application function The purchase application function is divided into buyer requesters, specification decision-makers, approvers, and purchasers in buyer companies, and it is possible to clearly separate the three powers of purchase, and the responsibilities are also clarified.
The purchase application function has a function to display the sanctuary and sanctuary period. A common example of a buyer company that has been operating for a long time is “the deal is a presidential deal”. As a result, the other person in charge may approve the transaction with “blur”. The system traces the birth of the case so that the person involved in the case becomes more active. The contract management also has the same function.
All cases are managed based on this purchase application, and all information (purchase application / estimate information / supplier information / contract information / contract / estimate / catalog / drawings etc.) under the case number / case name Can be managed. As a result, the person in charge of indirect material purchase information that was personally managed, purchase application, estimate information, supplier information, supplier salesperson information, contract information, contracts, quotations, catalogs, drawings, etc. are stored separately. All the things that could not be managed were linked to the case name and case number, and they could be centrally managed on the PC screen so that they could be used quickly in the next purchasing operation. Purchasing personnel changed personnel in two years, often changed in one week, and eliminated bad effects so far.
Has a function to publish and unpublish matters. The main purpose of the system is to share purchasing information with each person in charge within the company, but it has this function because some cases are not disclosed to the company. This also has a contract management function. The fact that it can be managed that there is a private matter is significant and it is private matter information that depends on people, so if there are no people, this information will enter a labyrinth, and good transaction conditions will not be useful in the future Prevented. Furthermore, organizing this information can be very useful from a compliance perspective.
Specifically, as shown in FIG. 27, the requester, the purchaser, and the approver can be divided into three powers, and the sanctuary level and sanctuary period of purchase can be set as shown in FIG. In addition, as shown in FIG. 29, it is possible to manage items set to be disclosed / not disclosed.

5: Contract management function Setting the sanctuary, sanctuary deadline, sanctuary background reason, etc., which is also in the purchase application function, and the procurement types of normal projects, series procurement projects, and reciprocal transaction projects can be defined. In addition, the procedure itself is displayed to indicate whether the project itself is using the normal estimation method or whether it is going to be a reverse auction. As a result, it is possible to respond according to the case, and at the same time, even if the person in charge changes as history information in the future, all information can be taken over.
Specifically, it is shown in FIGS. The terms in the drawings are explained below. Before contract execution
・ ・ ・ ・ New item registration or ongoing item registration (I want to keep the previous item registration information and include only new information).
Before the contract ends
Contract information 3 months before the contract is completed (notify the person in charge and the operation manager)
...
Items that have been declared not to be renewed after the end of the contract period (items that declare whether to continue or end one month before the end of the contract)
...
A contract that is not declared that the contract will be terminated and not renewed. This information displays the status (number and amount of each contract) on the buyer top screen, so you can see the status of the current project in charge for the entire company and for each person in charge. Since it can be grasped by clicking, it can take quick action.

6: Estimate request function As shown in FIGS. 32 to 37, in response to a request for a quote from a buyer company, the supplier sets an estimate in the estimate response function after performing an estimate operation and at the same time provides information (catalog information and drawings). ) Can be set and sent. As a result, even when another person in charge confirms the estimate, the product and work contents can be understood by hand using information such as catalog information and drawings.
In response to quote responses from each company, this system can grasp the estimated reduction amount and the reduction amount for each department / buyer person in charge by using the “estimated performance list”. In general, indirect materials purchasing is a business that is not evaluated even if the person in charge devises or negotiates and obtains a cheap estimate, so buyers are less motivated. The current situation is that when the system collects the estimate, it is automatically tabulated, and information such as cost reductions, estimated numbers and services for each company are displayed in a comparison table, which reduces the burden on the person in charge. By seeing the contribution of the person in charge, there is an effect of increasing the motivation for the person in charge. Since the result of the estimate collection is always displayed on the top screen, it is possible to know the collection status of how many companies have responded in the projects they have done or have done. As a result, the method of submitting quotes from each company by fax, e-mail, or bringing them together is different, but the system also allows the system to centrally manage the collection status of quotes using the unified quote form of this system and the method of submission using the system. It has become. This also reduces the work burden on the person in charge.
With regard to the estimated collection status, the purchasing staff can grasp the estimated price and conditions for each company. However, this information is not displayed to users who do not have purchasing authority such as requesters until after the deadline of quotation. The reason is that a requester of a user who does not have the purchasing authority knows the estimate of each company in advance and does not leak information to a specific trader.
If the estimate collected once is not the price expected by the buyer company, the estimate may be changed again by changing the contractor or narrowing the scope. This system has a function to send by simply selecting a supplier without setting specification information again when the re-estimate button is clicked. Thereby, the request for quotation for further cost reduction can be easily performed. At the same time, version management of the estimate (primary estimate, secondary estimate, n-order estimate) can be performed, so that it is possible to plan an estimate with a free idea and to reduce the work burden and management burden of the person in charge.
In addition to previous price comparison, the estimate comparison function allows you to freely ask suppliers (for example, related to services other than prices such as warranty period, mailing service and meeting conditions). It can be managed as a target.

7: Priority Supplier / Normal Supplier Function FIG. 38 is a diagram showing a specific example of the selection function of the priority supplier / normal supplier. Collaboration with suppliers as a buyer company is an important management theme. Many buyers and buyers who deal with many items may not pay attention to the goods to be procured and do not consider whether the supplier company in procurement is a key supplier or a normal supplier for the buyer company. is there. There are times when it is too much to understand. On the other hand, if you become a large company, you will not be able to reduce costs because you are accustomed to using too much priority suppliers and make one-time quotations / special orders based on strategic cooperation.
This function enables buyer companies to identify regular suppliers in order to always maintain a competitive situation with key suppliers that cooperate strategically. Even if you are not a veteran, the system will tell you about this relationship in company policy, so when you request a quote, you can get a good balance between the key supplier and the regular supplier, so you can see it right away.
□ FIG. 39 is a diagram showing a specific example of the identification function of the priority supplier / normal supplier.
The person in charge can identify the key supplier and the normal supplier with a plug (the key supplier is identified with a flag).

8: Supplier company transaction prohibition function (enterprise entry / exit prohibition function)
FIG. 40 is a diagram illustrating a specific example of the supplier company transaction prohibition function. This function is provided in order to reduce the risk as a buyer company if the company can deal with the situation of the supplier company early, such as corporate bankruptcy or anti-social enterprise. In companies that are deployed nationwide, this prevents cases where companies that have to be careful in dealings due to information delays cannot be fully informed. This means that the purchase manager can simply set the transaction to be canceled (cancellation of use), and thereafter the transaction request from the buyers nationwide can be stopped. Further, even when the company is reinstated, if the purchase manager sets it to be usable (in use), the transaction can be started again.

9: Quote Decline Function FIG. 41 is a diagram showing a specific example of the quote decline function by the supplier non-participation button shown in the decline reason input for non-participation (supplier screen). FIG. 42 is a diagram showing a specific example of the reason for entry reason for withdrawal when the supplier does not participate. Sending a quote request to a supplier does not give a quote reply. As a function to decline the estimate, the non-participation button, the non-participation reasoning input function, the buyer's mail receiving function can be noticed, and non-participation management within the matter can be managed.

10: Function of Recognizing by E-mail Receiving Quote Reply and Contractor's Estimate Decline FIG. 43 is a diagram showing a specific example of the function of recognizing mail received by contractor's estimated decline. FIG. 44 is a diagram showing a specific example of a function for recognizing an estimate response displayed on the estimate response column display (buyer screen) by receiving an email. When there are non-participating companies on the buyer side, this notice function can grasp the status of non-participating projects without opening the system screen. When an important project is not attended by a contractor, it is possible to conduct activities that are conscious of the estimated deadline by convincing and reviewing specifications. In addition, since the function has a function of notifying by e-mail even when there is an estimated answer, it is possible to confirm both the participation status by reply and non-participation status by e-mail. You can always take quick action.

11: Estimated Time Stamp Function FIG. 45 is a diagram showing a specific example of the estimated time stamp function. When you receive a response to a quote request, you can see the year, month, day, day of the week, and hour: minute that you received using the time stamp function. This is also displayed in the same way as the answer of non-participation (decline of estimated business negotiation decline). This ensures the credibility and evidence of information as a business transaction. Positioned as a product not found in other companies.

12: Information bulletin board alert / mail function □ FIG. 46 is a diagram showing a specific example of the information bulletin board function. FIG. 47 is a diagram showing a specific example of the alert mail function sent to the parties concerned.
When new information is communicated to the bulletin board function as a contact tool for all parties registered with the buyer company, it will be a time lag if each person in charge notices for the first time after opening the portal. In order to prevent this, when a message is written on the bulletin board, an email is sent to the subject at the same time to give notice. It is a function that systematically promotes quick actions.
□ Displayed on the portal top screen for information from buyer managers to internal purchasing personnel. An alert e-mail is sent to the related parties at the same time as the display

13: Supplier Contact Person Registration Function FIG. 48 is a diagram showing a specific example of the supplier contact person registration function and the contact person entry / exit prohibition function or the transaction prohibition function. There is this function under the supplier registration function, and the information of the person in charge of sales (name, affiliation, whether it is the main window, item in charge, self-appeal, TEL, e-mail address, etc.) is entered by the party's sales person. Yes. This information allows buyers to put sales representatives' ratings. This evaluation information can be disclosed within the buyer company. It is not open to suppliers. In addition, a sales person who is inappropriate for a buyer company can use a prohibition function. At that time, the reason for the entry and exit prohibition can be entered.

14: Buyer Evaluation Function FIG. 49 is a diagram illustrating a specific example of the buyer evaluation function.
In this system, many items such as responsible items and appeal points are handled by sales representatives. Only the buyer evaluation can be set as information that can only be seen by the buyer. The purchasing person can share the information of the sales person in charge of the supplier, so that the business negotiation can be performed advantageously. This is the function of the son-in-law's tactics, “Knowing the enemy and knowing yourself will make the war 100 dangerous”.

15: Estimation Cancellation / Reestimation Aggregation Function FIG. 50 is a diagram illustrating a specific example of the estimation cancellation / reestimation aggregation function. I requested a quote, but it was canceled. The re-estimated items are stored and aggregated. Conventional transactions do not manage projects that have been re-estimated or canceled, but this system treats this information with respect to the transparency and continuity of transactions.

16: Supplier recommendation reason function FIG. 51 is a diagram illustrating a specific example of the supplier recommendation reason function. The reason for prior contact can be entered when setting a contacted company to obtain reference information before a formal quotation from a supplier at the time of purchase request. This is useful for determining whether or not the estimate is being acquired correctly. (Normally, information that does not appear on the table even if contact is made in advance. However, it is a function that works effectively in compliance.

17: Web Purchase Cooperation Function FIG. 52 is a diagram showing a specific example of the web purchase cooperation function. After getting a quote, the final negotiation will be done in detail, and the final price and service details will be finalized. The final contract unit price is then determined and placed in the price table. The information is also sent to the catalog information database of the online purchasing system.
FIG. 52 shows a specific example of an Excel input workflow for WEB purchasing cooperation. In the previous workflow setting, system development and workflow setting adjustment were specialized work and there was no flexibility, but in this system, HR information is entered in an Excel form and linked to the system by simply setting it in the system The purchasing system workflow set is complete. In other words, this work becomes a personnel planning table if you can use this sheet in a table that is usually performed by personnel, and workflow information if you set the approval level according to the purchase amount. Simply load it into the system. Also, if this project is used for project-type budgets, purchases cannot be made if the project budget is exceeded.
Normally, the workflow only shows the information of who approved, but the function in the Web purchasing system (product name: Purchasing Pro) linked to the procurement history analysis system (product name: Sourcing Pro) The person in charge makes a request, the boss approves it, the request is sent to the person in charge of the purchase, the person in charge of the purchase approves it, and the boss approves it. When approval is given to sales departments and finally delivery is made by a supplier, approval information up to acceptance, product information, and price information can be listed on a single screen for each project, on a single form. The If you have this single piece of information (supports screens and forms), you can manage all the information. It has a function that can easily search past information.
FIG. 54 is a diagram showing a specific example of one-screen workflow management.
These functions make it possible to efficiently manage and manage purchasing relations more efficiently and at the same time to save labor in management and promote visualization of internal purchasing.

18: New Business Inventory Form FIGS. 55 and 56 are diagrams showing specific examples of transaction confirmation sheets for new business inventory. This is used by the supplier to describe past transactions and cleanse the data at the purchasing company. With this function, it is possible to find cases where the same item is delivered at a different unit price when the office is remote. Conventionally, the details of such transactions are not held by the purchasing company, so having such information is the basis of purchasing and can be used as knowledge throughout the company.
There are two forms, and Fig. 55 is a new business inventory guide. This is a document requesting cooperation from a business inventory in order to obtain data from a supplier. FIG. 56 shows a form for inputting data for new business inventory. Many suppliers fill out this form from information that keeps track of their transactions on their computers. When this form is collected by a purchasing company, details of the transaction such as the unit price and lease start date of the item loaded and procured by the sourcing pro can be grasped. It will be useful for data cleansing as well as knowledge when purchasing by companies. The data to be obtained are, for example, transaction month, delivery location, supplier CD, supplier name, product code, product name, manufacturer name, manufacturer model number, description (size, color, quantity), list price, contract unit price, quantity, Unit, list price, contract amount, account name, account code, contract start date (or lease start date), contract end date (or lease end date), and contract department name. What is shown is a new business inventory for a copier, but the same items can be used in the form even if the item changes.
FIG. 56 shows a form for collecting specifications. When an item changes, it is managed together according to the characteristics of the item.

  The present invention can be implemented in various forms without departing from the spirit of the present invention. For example, the above-described database may be stored in one server or may be distributedly stored in a plurality of servers. In this case, a plurality of servers may be connected via the Internet or an intranet.

  This system can also be used in the ASP type, but it is assumed that it can also be operated in the SaaS type using cloud computing technology. In addition, because it is possible to easily customize each industry by exchanging tabs for the models and forms required for each industry, the templates for each industry created on this base will continue to proliferate in the future. , You can easily change templates and change tabs according to customer needs. For this reason, this system can handle any item or service item, such as services, for which phase estimation is possible, so it can handle not only indirect materials but also direct materials. Both direct materials and indirect materials procured and purchased by companies are available. With this system, it is possible to centrally manage information such as purchase history, quotation acquisition, and vendors.

  As described above, the purchase history analysis system for indirect materials according to the present invention has a vendor database, a project database, an item database, and a specification database, and the data registered in each database is standardized. It is characterized by. With the present invention, cost reduction and expansion of synergy effects are achieved through the system, and conventional distributed purchasing operations in each department can achieve efficiency linked to company-wide purchasing data, and improve transparency and compliance. Providing an indirect purchasing history analysis system that reduces costs for the entire company by changing the experience and know-how of purchasing personnel in each department from tacit knowledge of personal management to formal knowledge that can be used by the organization. be able to.

1 Indirect purchase history analysis system 2 Vendor database 3 Project database 4 Item database 5 Specification database

Claims (1)

Vendor database and
A project database,
An item database;
A spec database,
The data registered in each database is standardized,
For the vendor database, company information registration function, communication function, supplier registration function, purchase application function, contract management function, quotation request function, priority supplier / normal supplier function, supplier company transaction prohibition function, quotation decline function, quotation reply , Notice function by receiving e-mail of contract decliner's estimate, estimate time stamp function, information bulletin board alert / email function, supplier contact person registration function, contact person entry / exit prohibition function or transaction prohibition function, buyer evaluation function, estimate cancellation / restart Has an estimate tabulation function, a supplier recommendation reason function, and an online purchasing cooperation function.
Indirect materials purchasing history analysis system.