JP2007102433A - Vehicle repair work management device, vehicle repair work management method, vehicle repair work management program, computer-readable recording medium and equipment performing storage - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To unitarily perform order reception, process management and business management in a repair factory. <P>SOLUTION: This vehicle repair work management device has: an index determination part 22 for determining a work index corresponding to a work type inputted by a work type input part 12 in reference to a work index table 32; a standard work fee calculation part 24 for multiplying the work index determined by the index determination part 22 by a price per the work index to calculate a standard work fee; a unit time work fee designation part 16 designating a work fee per unit time of a worker; an actual work time input part 18 inputting identification information of the worker performing work and an actual work time performed by the worker in each the work kind; an actual work fee calculation part 26 for multiplying the work fee per the unit time by the actual work time inputted by the actual work time input part 18 to calculate an actually required actual work fee; and a profit and loss calculation part 28 calculating a difference between the standard work fee calculated by the standard work fee calculation part 24 and the actual work fee calculated by the actual work fee calculation part 26. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a vehicle repair work management apparatus, a vehicle repair work management method, a vehicle repair work management program, a computer-readable recording medium, and a storage medium for a repair shop of an automobile or the like to manage the process and management of repair work. Regarding equipment.

Traditionally, repair shops such as repair shops and sheet metal painters that repair damaged cars caused by accidents caused by automobile accidents have collaborated with insurance companies in charge of automobile damage insurance, etc. Work such as creation, order receipt and delivery. Since such work is usually performed by telephone or the like, it is difficult to grasp the progress of the work one by one. On the other hand, a repair situation management device for an accident vehicle has been developed in which an automobile insurance company can cooperate with a repair shop using a computer (see Patent Document 1). As shown in FIG. 1, the apparatus 300 includes a first processing apparatus 301 in an automobile insurance company, a second processing apparatus 302 in an accident car repair shop, and the first and second processing apparatuses 302 are public telephones. It is connected to the third processing device 303 via the lines 311 and 312, and the user can communicate with the third processing device 303 via a telephone or a mobile phone. Based on information on various vehicle repairs stored in the third processing device 303, the first processing device 301 can perform an accident vehicle repair management table, in-house settlement progress management, factory search, and the like. The two processing device 302 can create an estimate, progress management table, designated factory contract, and the like. The user can obtain the repair progress information by using the fourth processing device 304 and can search for a repair shop. The third processing device 303 can manage the estimation system, perform estimation analysis, and analyze plant management. As a result, the user who is the owner of the car insurance company, the repair shop, and the accident car can always grasp the repair situation of the accident car and improve the convenience.
JP 2001-229238 A

  However, this accident car repair status management device is mainly focused on managing the exchanges with the repair shop that repairs the accident car by the car insurance company. In other words, the management from the repair shop side not enough. In other words, the car insurance company can only search for and designate a repair factory that is the nearest designated factory from the accident site, and it cannot be managed until the repair factory receives an order from another car insurance company. In particular, unlike auto insurance companies, there are many small and medium-sized companies in repair shops, so in many cases computerization has not progressed so much, and it is quite difficult to introduce such a highly computerized system. . On the other hand, there is no system specialized in process management and business management of such small and medium-sized repair shops. Therefore, a management support system that is easy to introduce and has a low maintenance burden has been desired. In particular, it is possible to create an estimate using the work index in the existing system, but a system using this for process management and business management has not been realized.

  The present invention has been made in view of such a situation. A main object of the present invention is a vehicle repair work management apparatus, a vehicle repair work management method, and a vehicle repair work management program that can be easily introduced and that can realize ordering, process management, and business management from a repair shop in an integrated manner. Another object of the present invention is to provide a computer-readable recording medium and a stored device.

In order to achieve the above object, a vehicle repair work management device according to a first aspect of the present invention is a vehicle repair work management device for managing a repair work of a vehicle ordered by a vehicle repair contractor. Work index table for storing unit work necessary for possible work and work index defined in advance according to the unit work , index price designation unit for designating the price per work index, and target work a work type input unit of the type for inputting a unit operation that constitute the work type work index corresponding to the unit operations which constitute the to work type input by the input unit, to determine with reference to the working index tables Standard work for calculating the standard work fee for each unit work by multiplying the work index determined by the index determination part and the work index determined by the index determination part by the price per work index specified by the index consideration specification part Charge calculator and Input unit time working fee designating section for designating the work rates per person unit time for each unit operation constituting a work type, the identification information of the operator who has performed the work, the actual operation time of the person went Multiply the actual work time entered in the actual work time input unit by the work fee per unit time specified in the unit work fee designation part for each unit work that constitutes the work type. The actual work fee calculation unit for calculating the actual work fee for each unit work actually required, the standard work fee calculated by the standard work fee calculation unit, and the actual work calculated by the actual work fee calculation unit A profit / loss calculating unit for calculating a difference from the fee and a display unit for displaying the difference calculated by the profit / loss calculating unit as profit / loss. As a result, the work content and the standard work fee determined according to the work index assigned to the work content can be compared with the actual work fee actually required. It can contribute to the analysis of the management situation of repairers.

  The vehicle repair work management device according to the second aspect of the present invention is based on progress information input by the actual work time input unit for each work type input by the work type input unit. A progress management table creating unit for creating a progress management table for displaying the status is provided. Thereby, the progress status of each work can be confirmed and managed in the progress management table.

Furthermore, in the vehicle repair work management device according to the third aspect of the present invention, the work index table further defines a standard work time of unit work necessary for work that can be a target, and the progress management table creation unit further includes With respect to the unit work constituting the work type input by the work type input unit, the work progress schedule based on the standard work time can be displayed on the display unit as a progress schedule table graphed in time series. Thereby, the progress schedule of each work can be confirmed and managed in the progress schedule, and the progress can be confirmed in comparison with the progress management table that displays the progress of actual work.

  Still further, in the vehicle repair work management device according to the fourth aspect of the present invention, the actual work time input unit allows each worker to scan his / her own barcode scanner for each unit work constituting each work type. The identification information, the work start time, and the work end time are input. As a result, by scanning the barcode installed at the work site, the worker and the actual work time are surely entered for each unit work, and the work time and unit cost required for each work can be accurately grasped. Achievement management is also possible, and the system can be operated accurately.

  Furthermore, in the vehicle repair work management device according to the fifth aspect of the present invention, the work type input unit further includes, as order information related to the input work type, an order received date, a vehicle warehousing date, and a work end. The planned date can be entered, and the vehicle repair work management device further receives an order master information holding unit for holding the information entered in the work type input unit as order master information, and a warehousing that manages the warehousing date of the warehousing vehicle. A vehicle management unit.

Furthermore, the vehicle repair work management device according to the sixth aspect of the present invention further includes a request input unit for inputting various inquiry requests, and when an incoming vehicle inquiry request is input from the request input unit, the incoming vehicle management Warehousing vehicle list display means for displaying the status of warehousing vehicles in a list based on the management information of the department, and when the sales target inquiry request is input from the request input section, the standard work charges calculated by the standard work charge calculation section Based on the actual work fee calculated by the actual work fee calculation unit, the sales target result comparison table display means for displaying the sales target result comparison table and the profit inquiry request per order are input from the request input unit Based on the difference between the standard work fee calculated by the profit and loss calculation unit and the actual work fee, one order profit inquiry display means for displaying a profit inquiry table per order, and a work result total inquiry request from the request input unit Is entered, the actual Based on the work record information for each unit operation constituting a by work type input work time input unit, and a work record aggregation table display means for displaying the actual work schedule. As a result, various types of information necessary for the management of the vehicle repair shop can be displayed for management support.

Furthermore, a vehicle repair work management method according to a seventh aspect of the present invention is a vehicle repair work management method for managing a repair work for a vehicle ordered by a vehicle repair contractor, wherein the target work is received from a work type input unit. a step of prompting of unit operations which constitute a type, in accordance with the unit operations which constitute the objective work inputted, with reference to the working index tables stored in association with the work index and advance unit operations, index determining The standard work amount calculation unit calculates the standard work fee for each unit work by multiplying the determined work index by the price per work index specified in advance by the index price specification unit. And, on the other hand, for each unit work constituting the work type , a step of prompting input from the actual work time input unit of the identification information of the worker who performed the work and the actual work time performed by the person, unit operations that make up the work type Actual work time input and multiplies the working fee per specified unit time in a unit time working fee specified unit calculates the actual work fee per unit operation in which the actual working amount calculating section is actually required to A process, and a profit / loss calculation unit that calculates a difference between the standard work fee and the actual work fee and displays the difference as profit / loss on the display unit . As a result, the work content and the standard work fee determined according to the work index assigned to the work content can be compared with the actual work fee actually required. It can contribute to the analysis of the management situation of repairers.

Furthermore, a vehicle repair work management program according to the eighth aspect of the present invention is a vehicle repair work management program for managing a vehicle repair work ordered by a vehicle repair contractor, and is a work that can be used as a computer. Work index table storage means for associating and storing a unit work constituting a type and a work index defined in advance according to the unit work, an index price specifying means for specifying a price per work index, and a target work The work type input means for inputting the unit work constituting the type of work and the work index corresponding to the unit work constituting the work type input by the work type input means are determined with reference to the work index table storage means. The work index determined by the index determination means and the work index determined by the index determination means are multiplied by the price per work index specified by the index price specification means. Standard work charge calculation means for calculating work charges, unit time work charge specifying means for specifying work charges per unit time of workers, and workers who have performed work for each unit work constituting the work type The actual work time input means for inputting the actual work time performed by this person, and the work fee per unit time specified by the unit time work charge specifying means for each unit work constituting the work type Multiplied by the actual work time input by the actual work time input means, and is calculated by the actual work charge calculation means for calculating the actual work charge for each unit work actually required and the standard work charge calculation means. The actual work time for each unit work constituting the work type input by the work type input means and the profit and loss calculation means for calculating the difference between the standard work charge and the actual work charge calculated by the actual work charge calculation means Actual work time entered by input means Based on this, a progress management table creation means for creating a progress management table that displays the progress of each work, and a difference calculated by the profit and loss calculation means are displayed as profit and loss, and further created by the progress management table creation means as a visible display means the progress management table to function. As a result, the work content and the standard work fee determined according to the work index assigned to the work content can be compared with the actual work fee actually required. It can contribute to the analysis of the management situation of repairers. In addition, the progress of each work can be checked and managed in the progress management table.

  Furthermore, a computer-readable recording medium or a stored device according to the ninth aspect of the present invention records the vehicle repair work management program. Recording media include CD-ROM, CD-R, CD-RW, flexible disk, magnetic tape, MO, DVD-ROM, DVD-RAM, DVD-R, DVD-RW, DVD + R, DVD + RW, Blu-ray, HD A medium that can store a program such as a magnetic disk such as a DVD (AOD), an optical disk, a magneto-optical disk, a semiconductor memory, or the like is included. The program includes a program distributed in a download manner through a network line such as the Internet, in addition to a program stored and distributed in the recording medium. Furthermore, the stored devices include general-purpose or dedicated devices in which the program is implemented in a state where it can be executed in the form of software, firmware, or the like. Furthermore, each process and function included in the program may be executed by computer-executable program software, or each part of the process or hardware may be executed by hardware such as a predetermined gate array (FPGA, ASIC), or program software. And a partial hardware module that realizes a part of hardware elements may be mixed.

  As described above, according to the vehicle repair work management device, the vehicle repair work management method, the vehicle repair work management program, the computer-readable recording medium, and the stored device according to the present invention, the work content and the work content are assigned. Since the standard work fee determined according to the work index can be compared with the actual work fee actually required, it is possible to grasp the profit and loss reliably and contribute to the analysis of the business situation of the vehicle repair company.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. However, the embodiment shown below is a vehicle repair work management device, a vehicle repair work management method, a vehicle repair work management program, a computer-readable recording medium, and a stored device for embodying the technical idea of the present invention. The present invention does not specify a vehicle repair work management device, a vehicle repair work management method, a vehicle repair work management program, a computer-readable recording medium, and a stored device as follows. Moreover, the member shown by the claim is not what specifies the member of embodiment. Note that the size, positional relationship, and the like of the members shown in each drawing may be exaggerated for clarity of explanation. Furthermore, in the following description, the same name and symbol indicate the same or the same members, and detailed description thereof will be omitted as appropriate. Furthermore, each element constituting the present invention may be configured such that a plurality of elements are constituted by the same member and the plurality of elements are shared by one member, and conversely, the function of one member is constituted by a plurality of members. It can also be realized by sharing.

  In this specification, a vehicle repair work management apparatus, a vehicle repair work management method, a vehicle repair work management program, a computer-readable recording medium, and a stored device perform operations, display, and settings related to ordering and management of vehicle repair work. The present invention is not limited to the system and the apparatus and method that perform input / output, display, calculation, communication, and other processes related to the operation, display, setting, etc. of the system itself and vehicle repair work in hardware. An apparatus and method for realizing processing by software are also included in the scope of the present invention. For example, a general-purpose circuit or computer that includes software, programs, plug-ins, objects, libraries, applets, scriptlets, compilers, modules, macros that run on specific programs, etc. A general-purpose or dedicated computer, workstation, information terminal, portable electronic device or other electronic device capable of related processing is also used in the vehicle repair work management apparatus, vehicle repair work management method, vehicle repair work management program, and It is included in at least one of a computer-readable recording medium and a stored device. In addition, this program is not limited to the one used alone, but is provided as a service in an environment that functions as a part of a specific computer program, software, service, etc., an aspect that is called and functions when necessary, and an environment such as an OS. It can also be used as a mode, a mode that operates resident in the environment, a mode that operates in the background, and other support programs.

  Also, information terminals such as computers used in the embodiments of the present invention, servers, computers connected to these, computers for operation, control, input / output, display, various processing, etc., or other peripheral devices such as printers For example, IEEE1394, RS-232x, RS-422, USB, etc., serial connection, parallel connection, or 10BASE-T, 100BASE-TX, 1000BASE-T, etc. It can be performed. The connection is not limited to a physical connection using a wire, but may be a wireless connection using radio waves such as IEEE802.1x, OFDM, etc., Bluetooth (registered trademark), infrared rays, optical communication, or the like. Furthermore, a memory card, a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like can be used as a recording medium for exchanging data or storing settings.

FIG. 2 shows a block diagram of a vehicle repair work management apparatus according to an embodiment of the present invention. The vehicle repair work management apparatus 100 shown in this figure includes an input means 10, a calculation means 20, a storage means 30, and a display unit 40.
(Input means 10)

The input means 10 includes a work type input unit 12, an index consideration designation unit 14, a unit time work fee designation unit 16, and an actual work time input unit 18. The work type input unit 12 inputs the type of the target work. The index consideration designation unit 14 designates the consideration per work index. The unit time work charge designation unit 16 designates the work charge per unit time of the worker. The actual work time input unit 18 inputs the identification information of the worker who performed the work and the actual work time performed by the person for each work type.
(Calculation means 20)

The calculating means 20 includes an index determining unit 22, a standard work charge calculating unit 24, an actual work charge calculating unit 26, a profit / loss calculating unit 28, and a progress management table creating unit 29. The index determination unit 22 determines a work index corresponding to the work type specified by the work type input unit 12 with reference to the work index table. The standard work fee calculating unit 24 calculates the standard work fee by multiplying the work index determined by the index determining unit 22 by the price per work index specified by the index price specifying unit 14. The actual work charge calculating unit 26 multiplies the work charge per unit time specified by the unit time work charge specifying unit 16 for each work type by the actual work time input by the actual work time input unit 18 to calculate the actual work charge. Calculate the actual work fee for each unit work required for. The profit / loss calculating unit 28 calculates the difference between the standard work fee calculated by the standard work fee calculating unit 24 and the actual work fee calculated by the actual work fee calculating unit 26. The progress management table creation unit 29 displays the progress status of each work based on the progress information input by the actual work time input unit 18 for each work type input by the work type input unit 12. Is created (described later).
(Storage means 30)

  Storage means 30 further includes a work index table 32 and an order master information holding unit 34. The work index table 32 is a database that stores a work that can be a target and a work index that is defined in advance according to the target work in association with each other. The work index table 32 also stores standard work times of work that can be targeted. The index determination unit 22 can determine the index of the work type input by the work type input unit 12 by referring to the work index table 32. The order master information holding unit 34 holds information input by the work type input unit 12 as order master information.

  The display unit 40 displays various information such as calculation results calculated by the calculation unit. As the display unit 40, a liquid crystal display, a CRT, or the like can be used.

Each of the above functions can be realized in software as well as in hardware. Hereinafter, an example in which a vehicle repair work management program is installed in a general-purpose computer and functions as the vehicle repair work management apparatus 100 will be described with reference to the system diagram of FIG. In the vehicle repair work management system diagram shown in FIG. 3, the computer 50 in which the vehicle repair work management program is installed functions as the computing means 20, and the monitor 51 of the computer 50 functions as the display unit 40 and is connected to the computer 50. The storage device 52 functions as the storage unit 30, and input / output devices such as a keyboard 53 and a mouse 54 connected to the computer 50 function as the input unit 10. Further, in the input means 10, the actual work time input unit 18 is realized by a bar code scanner 55 arranged at the work site. The barcode scanner 55 and the computer 50 are network-connected by a wired LAN, a wireless LAN, or the like. In general, the computer 50 is installed in the management department, office, etc., the barcode scanner 55 is installed in the factory or work site, these are connected to the network, exchange data with each other, record the current situation, and update the information. I do.
(Actual work time input unit 18)

  In the example of FIG. 3, a barcode scanner 55 is used as an example of the actual work time input unit 18. The worker scans and records the provided barcode scanner 55 at the start and end of each unit work. Here, a bar code scanner 55 and a bar code sheet 56 corresponding to the work content are arranged for each work site where various work is performed, and the worker performs his / her identification information ( For example, the barcode of the employee number printed on the employee ID is input, and the barcode of the work in charge is selected from the barcode sheet 56 and scanned. Thereby, the information read by the barcode scanner 55 is transmitted to the computer 50, the progress status is managed by the calculation unit, and the actual work fee is calculated.

  In this way, by recording the time required for the unit work required for each work type, it is possible to grasp the detailed progress status and the required cost (mainly hourly wage basis) accurately. In addition, the working status of each employee, for example, the actual working time per day, the sales amount, the break time, etc. can be grasped, which can be used for grasping the working style and improving the work.

  In addition to preparing a general-purpose barcode sheet for each operation, the barcode sheet 56 is preferably printed by scanning a barcode for each operation type and scanning this, so that the progress of each operation can be directly grasped. An example of the barcode sheet is shown in FIG. As shown in this example, a barcode is printed for each order received, the work contents, the name of the worker in charge, and the barcode are printed in a list for each unit work. Each person in charge starts and ends his own work. Scan the appropriate bar code when doing so. Thereby, the start and end of each work are transmitted to the vehicle repair work management program and recorded. The barcode printed next to the slip number is a barcode with the slip number. For example, when entering the slip number in the vehicle repair work management program, this barcode is scanned with a barcode scanner instead of the keyboard. By doing so, the slip number can be input surely and easily.

The actual work time input unit 18 is not limited to a barcode, and a two-dimensional code (two-dimensional barcode) such as a QR code (registered trademark), an RFID (IC tag), or the like can be used. In particular, since the IC tag can be accessed in a non-contact manner, it saves the trouble of scanning one by one and is resistant to a poor ambient environment such as contamination of the label surface, and can be suitably used in the present invention.
(Automatic import of external database)

In the example of FIG. 3, the database is stored in the external storage device 52 connected to the computer 50 as the storage means 30. In addition to the work index table 32, various master information is held in the database. Master information includes order master information, system information, company information, employee information, customer information, vehicle information, work information, function information, land transportation station information, and the like. In addition to creating a dedicated database, the work index table 32 can use existing software. As existing software, there are Auda Neo II made by Audatex Japan and quotation software made by Repairtech Co., Ltd. Here, Auda Neo II is used as the estimate creation software. The Auda Neo II has a work index table 32, and the work index can be determined by inputting a work type. The vehicle repair work management program has a conversion function that converts and imports estimate data created by such third-party software. For example, estimate data created by Auda Neo II is directly or directly converted into an intermediate file format such as a text file, CSV file, html, xml, etc., and then taken into the vehicle repair work management program. Since such an estimate file stores the work type and its work index, this data can be used as input information.
(Working index)

The work index is the man-hour (index) that is standardly adopted in the industry. Moreover, it is also possible to set the work items that are lacking independently. Consideration per work index can be specified from the index consideration specifying unit 14 in FIG. 2, and is set to, for example, 6000 yen per index.
(Vehicle repair work management program)

  Next, the vehicle repair work management program will be described based on an image diagram showing a user interface screen (GUI) shown in FIGS. In the examples of user interface screens of these vehicle repair work management programs, it goes without saying that the arrangement, shape, display method, size, color scheme, pattern, etc. of each input field and button can be changed as appropriate. By changing the design, it is possible to make the display easier to view, easier to evaluate and judge, and easier to operate. For example, the detailed setting screen can be displayed as a separate window, or a plurality of screens can be displayed within the same display screen. On the user interface screens of these programs, ON / OFF operations for numerically provided buttons and input fields, designation of numerical values and command input, etc. are connected to a computer 50 incorporating a vehicle repair work management program. Perform at the input section. In this specification, “press” refers to buttons displayed on the user interface screen of the vehicle repair work management program displayed on the display screen of the display unit 40 in addition to being operated by physically touching the buttons. Are clicked or selected by an input device and are pseudo-pressed. The input device is connected to the computer 50 by wire or wireless, or is fixed to the computer 50 or the like. Examples of general input units include various pointing devices such as a mouse, keyboard, slide pad, track point, tablet, joystick, console, jog dial, digitizer, light pen, numeric keypad, touch pad, and accu point. These input devices are not limited to program operations, but can be used to operate hardware such as a vehicle repair work management apparatus. Furthermore, a touch screen or a touch panel is used for the display itself of the display unit 40 that displays the interface screen, so that the user can directly input or operate the screen by hand, or voice input or other existing input is possible. The means 10 can be used, or these can be used in combination.

  When the vehicle repair work management program is activated, a menu screen 60 shown in FIG. 5 is displayed. When the user selects an operation to be performed from this screen and presses the corresponding button, the screen shifts to each necessary setting input screen. The setting input screen is a form for realizing the input means 10. As described above, a dedicated setting input screen is provided for each work, and items to be set for each work are collected for each setting input screen, thereby enabling efficient input and display. In the example of FIG. 5, buttons are provided for each operation, and the related operations are grouped and arranged. Here, “daily processing” 61, “search” 62, “monthly processing” 63, and “form” 64 are grouped and each related item is arranged with buttons to make it easier for the user to find the target button. ing.

In the example of FIG. 5, when each button is selected or the mouse cursor is moved over, the function assigned to the button is displayed in the function description column 65. In the example of FIG. 5, when the “Vehicle Search” button is selected, an explanatory note “Search for a vehicle” is displayed in the function description column 65. This helps the user to select each function. Hereinafter, each setting input screen will be described.
(Order entry)

  When the “order” button 66 is selected from the top menu of FIG. 5, the order entry screen 70 shown in FIG. 6 is displayed. The order entry screen 70 realizes the function of the work type input unit 12 of FIG. Necessary information is input from the order entry screen 70 shown in FIG. In the upper part of the screen, a “slip No.” column 72a, an “order receiving category” column 72b, a “receipt date” column 72c, an “order date” column 72d, a “scheduled delivery date” column 72e, etc. are provided. The work type is input from the “order category” column 72b. In addition to selecting from a list-down box, the input can be directly entered. In the “receipt date” column 72c, “order received date” column 72d, and “scheduled delivery date” column 72e, the warehousing date of the customer's vehicle, the date when the order is confirmed, and the scheduled delivery date are input. As for these dates, in addition to inputting dates numerically, a desired date may be selected as a calendar-like screen. In the lower part of the input field 72, an estimate field 74 is provided, and an estimate No 74a, an estimater 74b, an estimated total amount 74c, and the like are input. Further, a customer information input field 76 is provided at the lower part of the estimate field 74, and a customer name and vehicle information are input. If a substitute vehicle is required, substitute vehicle information is also input.

  Further, a work process input field 78 is provided at the lower part of the customer information input field 76. The work process input column 78 includes a “sheet metal / painting” tab 78a, a “parts / material fee” tab 78b, an “inspection / general maintenance” tab 78c, a “car sales” tab 78d, an “insurance” tab 78e, It is organized and divided into a “cost” tab 78f and a “DM (direct mail)” tab 78g. In FIG. 6, the “sheet metal / painting” tab 78a is selected, and the unit work necessary for the work type, its index, and the name of the employee in charge are input from this column. Here, when a unit work is designated from the “work code” column 80, an index corresponding to this unit work is automatically entered in the “index” column 82, and the labor is further calculated and entered in the “work” column 84. Is done.

  The calculation of labor costs is determined by multiplying the index by the price per work index. That is, the standard work fee calculation unit 24 calculates the value per work index set by the index value specifying unit 14 described with reference to FIG.

  In addition, discounts can be applied in calculating wages. Here, the discount rate specified in the “less construction cost” column 86 is applied to discount the index and labor. In this example, since 10.0% is designated in the “less construction cost” column 86, the regular index before discount is displayed in the “index before wrestling” column 81, whereas the “index” column 82 is displayed. As shown in the “less construction cost” column 86, an index discounted by 10% is displayed, and in accordance with this, an amount discounted by 10% from the regular wage displayed in the “pre-less wage” column 83 is displayed in the “wage” column. 84. The discount rate specified in the “less construction cost” column 86 can be adjusted. For example, when a new discount rate is entered in the “less construction cost” column 86 and the “less calculation” button is pressed, recalculation is performed at the specified discount rate. Is done. However, the display in the “index” column and “wage” column can be updated in real time based on the discount rate input in the “less construction cost” column without being limited to such a form.

When the “part / material cost” tab 78b is selected in the work process input column 78, a part name and material name input / display column 79 is displayed as shown in FIG. 8 shows an “automobile inspection / general maintenance” tab 78c, FIG. 9 shows an “automobile sales” tab 78d, FIG. 10 shows an “insurance” tab 78e, FIG. 11 shows an “other expenses” tab 78f, and FIG. 12 shows a “DM” tab 78g. Each selected state is shown, and necessary items are entered for each. For example, in FIG. 12, in order to send a direct mail to a customer, a notification item and its date are set. Based on this setting, by pressing the “DM back” button 67 and the “DM address” button 68 from the menu screen 60 of FIG. 5, the text of the direct mail is automatically created on the determined date, and the address is further added. Can be printed.
(Quotation capture)

When the “estimate import” button 69 is pressed from the screen of FIG. 5, the estimate data import function is called. Here, an estimate data import dialog box created by the above-mentioned software from another company is displayed, so the data path storing the estimate data is designated. As a result, data reading, data conversion, and the like are automatically performed, and estimated data is input as an order. The estimate data is stored in advance in a data format that can be read by the vehicle repair work management program.
(Progress)

  Further, when the “progress status” button 90 is pressed from the screen of FIG. 5, a progress status inquiry screen 91 shown in FIG. 13 is displayed. On this screen, it is possible to extract a work type that matches the specified condition, create a progress management table 94 showing the progress status for each work type, and check the progress status. The progress management table 94 is created by the progress management table creation unit 29 of FIG. 2 based on the order master information updated by the input information from the work type input unit 12. In the upper part of the screen in FIG. 13, a progress status inquiry condition input field 92 is provided, and in addition to searching by date such as warehousing date or scheduled delivery date, parameters such as slip number, customer name, vehicle registration number, etc. are within a range. Alternatively, by directly designating, a work type that matches the conditions is extracted, and a progress management table 94 is created and displayed as a search result. Search results can be sorted as needed. Furthermore, not only the vehicle currently working but also the vehicle before starting and the vehicle after delivery can be displayed. This selection is performed by turning ON / OFF the check box 93.

  In the progress management table 94, the work type is displayed as slip No., and for each slip No., customer name, vehicle registration number and name, person in charge of quotation, order amount, receipt date, scheduled delivery date, presence / absence of parts waiting state, You can check the progress of work. The progress of the work can be visually grasped by the position of the car as the car icon 95 advances from the left (order received) to the right (car delivery) according to the progress of the work. The position of the car icon 95 can be moved by dragging with the mouse. When the actual progress status and the progress management table 94 do not match, the position of the car icon 95 is manually adjusted, and the contents of the order master information are updated accordingly.

  Further, the progress management table 94 can be printed. When the print button 96 is pressed from the screen of FIG. 13, the print preview screen shown in FIG. 14 is displayed, and the progress management table 94 can be confirmed and printed as a “progress status inquiry table” 97 on the screen.

You can also move from this screen to another screen. For example, when the “order input” button 98 provided at the lower left of the screen in FIG. 13 is pressed, the order input screen 70 in FIG. 6 is displayed, and when the “substitute status inquiry” button 99 is pressed, the substitute vehicle in FIG. The status inquiry screen 101 is displayed. On the substitute vehicle status inquiry screen 101, the reservation schedule can be managed and confirmed on the time table for each substitute vehicle that is held.
(Schedule input)

On the other hand, when the “schedule input” button 110 is pressed from the screen of FIG. 5, the screen shifts to a schedule input screen 111 shown in FIG. The schedule input screen 111 is a screen for directly inputting work, and it is also possible to input individual work not included in the work type in addition to the unit work constituting the work type. For example, a single sheet metal or painting operation is input. Thereby, it is possible to efficiently input and manage a single work regardless of the work type. As input items, there are a slip number, a work content, an employee name, a start date, a start time, an end date, an end time, and the like.
(Schedule inquiry)

  It is also possible to inquire about the work schedule for each employee. When the “schedule record inquiry” button 120 is pressed from the screen of FIG. 5, the schedule inquiry screen 121 of FIG. 17 is displayed. From the inquiry condition input field 122, select the work date and the content of the work you want to display (sheet metal, painting or both), and press the search button. Is displayed. The schedule inquiry screen 121 is linked to the above-described progress status inquiry screen 91, and the latest information input by the actual work time input unit 18 or the like is updated and displayed in real time.

  In the example of FIG. 17, work schedules and actual work results are displayed in different colors on the timeline, so that the work performance of each employee can be visually grasped. Further, the color may be displayed for each work content (sheet metal, painting, office accounting, etc.). In addition, displays such as visitors, business trips, meetings, and holidays can be added. In this way, by displaying the work input by the schedule input for each employee in charge, it is possible to understand the worker's operating status and results more easily.

When one of the employees is selected from the screen of FIG. 17 and the “detail” button 123 is pressed, the schedule inquiry detail screen 124 of FIG. 18 is displayed, and detailed information such as a slip No. regarding the work schedule and results of the employee is displayed. Is displayed. When the print button 125 is further pressed, a print preview screen 126 as shown in FIG. 19 is displayed, and the print state of the schedule list can be confirmed on the screen and printed.
(List of incoming vehicles)

Further, when the “stored vehicle list” button 130 is pressed from the screen of FIG. 5, a stored vehicle status list 131 shown in FIG. 20 is displayed. Also on this screen, when a query condition such as date, customer name, vehicle registration number, etc. is entered from the query condition input field 132 and the search button 133 is pressed, a list of incoming vehicles that match the query condition is displayed. From this screen, you can check the status of incoming vehicles in a list. Similarly, when the preview button 134 is pressed, a print preview screen 135 is displayed as shown in FIG.
(Batch interruption)

When the “collective interruption” button 140 is pressed from the screen of FIG. 5, a collective interruption input screen 141 shown in FIG. 22 is displayed. On this screen, a list of employees is displayed, and the operations of employees whose check boxes in the target column are turned on can be interrupted collectively. For example, it can be used when a certain employee is unable to take charge of work due to sick leave or retirement.
(Vehicle inspection reservation)

When the “vehicle inspection maintenance reservation” button 150 is pressed from the screen of FIG. 5, the vehicle inspection general maintenance reservation status screen 151 shown in FIG. 23 is displayed. When a date is selected from the calendar displayed on this screen and double-clicked, the vehicle inspection / general maintenance reservation list screen 152 for that day is divided into tabs and displayed as shown in FIG. This makes it easy to confirm that day's vehicle inspection / general maintenance reservation.
(Sales target)

When a “sales target input” button 160 is pressed from the screen of FIG. 5, a sales target result comparison table screen 161 shown in FIG. 25 is displayed. Also on this screen, an inquiry condition input field 162 is provided. When a factory / employee is selected as an aggregation target, a range to be aggregated is specified, and a search button 163 is pressed, a sales target list 164 shows sales targets that meet the conditions, Results, achievement rate, year-on-year comparison, etc. are displayed. This makes it possible to analyze sales targets and results by factory and employee, and contribute to management decisions. When the preview button 165 is pressed on the screen of FIG. 25, a print preview screen 166 is displayed as shown in FIG. In this example, other graphs are also displayed together with the list to facilitate sales changes and comparisons. In this way, it is possible to display how much (%) of the annual target and monthly target created by the sales target input are achieved. You can also output how much expenses, labor costs, etc. are spent.
(Unit price calculation)

When the “work unit price calculation” button 170 is pressed from the screen of FIG. 5, a sheet metal painting work unit price calculation screen 171 shown in FIG. 27 is displayed. On this screen, a list 172 of employees in charge of sheet metal painting work is displayed, and each direct cost, indirect cost, work time, work unit price, sales, operating rate, etc. are displayed. When the date, the number of employees (automatically input by default) and the standard work time / month are specified on this screen and the work cost calculation button 173 is pressed, the unit price is calculated and displayed. Thereby, a work unit price can be calculated according to the number of workers and ability.
(Profit per order)

When the “profit per order” button 180 is pressed from the screen of FIG. 5, a profit per order screen 181 shown in FIG. 28 is displayed. Also on this screen, an inquiry condition input field 182 is provided, and if a delivery date range, a name of a person in charge of quotation, a slip number, etc. are selected and a search button 183 is pressed, the person in charge of an order item that meets the conditions, wage, cost, etc. Is displayed, and the amount of revenue is calculated. As a result, the profit amount of each individual project can also be confirmed, which is useful for identifying problems and strengths. When the preview button 185 is pressed on the screen of FIG. 28, a print preview screen 186 is displayed as shown in FIG.
(Work performance summary)

When the “work result totaling” button 190 is pressed from the screen of FIG. 5, a sheet metal painting work result totaling table screen 191 shown in FIG. 30 is displayed. In this screen, an inquiry condition input field 192 is also provided. When a factory / employee is selected as a totaling date and a totaling target, and a search button 193 is pressed, a work result totaling table 194 showing wages, costs, etc. is displayed for each work content. And the amount of revenue is calculated. As a result, the profit amount as a whole can be confirmed, and the current state and transition of sales can be grasped. When the preview button 195 is pressed on the screen of FIG. 30, a print preview screen 196 is displayed as shown in FIG.
(Bar code input)

  The above has mainly described the operation on the computer 50 side, that is, the case where the vehicle repair work management program installed in the computer 50 installed in the office or the like as shown in FIG. 2 is operated. On the other hand, it is also possible to input to the vehicle repair work management program from the bar code scanner 55 which is the actual work time input unit 18 installed in the factory or the field. FIG. 32 shows a barcode result report input screen 201 for inputting data to the vehicle repair work management program by scanning the barcode of the specific work content of FIG. 4 with the barcode scanner 55 at the start of work on site. It is an image figure shown. For example, a monitor is connected to the barcode scanner 55 installed at the site, and when the operator scans, the barcode result report input screen 201 shown in FIG. 32 is displayed on the monitor screen. When the operator confirms that the information has been correctly input by checking the screen and presses the execution button 202, the worker is registered with the displayed contents and the order master information is updated.

  In this way, by accurately acquiring information related to actual work from the work site, accurate progress status grasping, schedule management, management prediction, and the like are possible. In addition, since the changed and updated information is immediately reflected in the order master information, it is possible to keep the latest state with an extremely small time lag.

Vehicle repair work management apparatus of the present invention, a vehicle repair work management method, readable recording medium as well as the stored equipment vehicle repair work control program and a computer can be suitably used in the management support or the like of painted sheet metal skill.

It is explanatory drawing which shows the repair condition management apparatus of the conventional accident car. It is a block diagram which shows the vehicle repair work management apparatus which concerns on one embodiment of this invention. It is explanatory drawing which shows the structure of a vehicle repair work management system. It is an image figure which shows an example of a barcode sheet. It is an image figure which shows the menu screen of the vehicle repair work management program which concerns on one embodiment of this invention. It is an image figure which shows the order entry screen of a vehicle repair work management program. It is an image figure which shows the state which selected the "parts / materials" tab on the order entry screen. It is an image figure which shows the state which selected the "vehicle inspection and general maintenance" tab on the order entry screen. It is an image figure which shows the state which selected the "car sales" tab on the order entry screen. It is an image figure which shows the state which selected the "insurance" tab on the order entry screen. It is an image figure which shows the state which selected the "various expenses" tab on the order entry screen. It is an image figure which shows the state which selected the "DM" tab on the order entry screen. It is an image figure which shows the progress condition inquiry screen of a vehicle repair work management program. It is an image figure which shows the print preview screen of FIG. It is an image figure which shows the substitute vehicle status inquiry screen of a vehicle repair work management program. It is an image figure which shows the schedule input screen of a vehicle repair work management program. It is an image figure which shows the schedule inquiry screen of a vehicle repair work management program. It is an image figure which shows the detailed screen of the schedule inquiry of FIG. FIG. 18 is an image diagram showing a print preview screen of FIG. 17. It is an image figure which shows the warehousing vehicle status table of a vehicle repair work management program. It is an image figure which shows the print preview screen of FIG. It is an image figure which shows the collective interruption input screen of a vehicle repair work management program. It is an image figure which shows the vehicle inspection general maintenance reservation status screen of a vehicle repair work management program. It is an image figure which shows the list of the vehicle inspection and general maintenance reservation in the vehicle inspection general maintenance reservation status screen of FIG. It is an image figure which shows the sales target performance comparison table of a vehicle repair work management program. FIG. 26 is an image diagram showing a print preview screen of FIG. 25. It is an image figure which shows the sheet metal painting work unit price calculation screen of a vehicle repair work management program. It is an image figure which shows the profit inquiry screen per order of a vehicle repair work management program. It is an image figure which shows the print preview screen of FIG. It is an image figure which shows the sheet metal painting work performance total table of a vehicle repair work management program. FIG. 31 is an image diagram showing a print preview screen of FIG. 30. It is an image figure which shows the barcode performance report input screen of a vehicle repair work management program.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 ... Vehicle repair work management apparatus 10 ... Input means 12 ... Work type input part 14 ... Index value designation | designated part 16 ... Unit time work charge designation | designated part 18 ... Actual work time input part 20 ... Calculation means 22 ... Index determination part 24 ... Standard Work fee calculation unit 26 ... Actual work fee calculation unit 28 ... Profit and loss calculation unit 29 ... Progress management table creation unit 30 ... Storage means 32 ... Work index table 34 ... Order master information holding unit 40 ... Display unit 50 ... Computer 51 ... Monitor 52 ... External storage device 53 ... Keyboard 54 ... Mouse 55 ... Bar code scanner 56 ... Bar code sheet 60 ... Menu screen 61 ... "Daily processing"
62 ... “Search”
63 ... "Monthly processing"
64… “Form”
65 ... Function explanation column 66 ... "Order" button 67 ... "DM back" button 68 ... "DM address" button 69 ... "Estimate import" button 70 ... Order input screen 72 ... Input column; 72a ... "Voucher No" column 72b ... "Order date"field; 72c ... "Receiving date"field; 72d ... "Order date"field; 72e ... "Scheduled delivery date" field 74 ... Estimation field; 74a ... Estimation No; 74b ... Estimator; Estimated total amount 76 ... Customer information input column 78 ... Work process input column; 78a ... "Sheet metal / paint"tab; 78b ... "Parts / material fee"tab; 78c ... "Inspection / general maintenance"tab; 78d ... "Car sales 78e ... "Insurance"tab; 78f ... "Expenses"tab; 78g ... "DM (direct mail)" tab 79 ... Input / display field 80 ... "Work code" field 81 ... "Lesson index" field 82 ... "Index" column 83 ... "Lesson wage before" column 8 ... "Wage" column 86 ... "No construction cost" column 90 ... "Progress status" button 91 ... Progress status inquiry screen 92 ... Progress status inquiry condition input column 93 ... Check box 94 ... Progress management table 95 ... Icon 96 ... Print button 97 ... "Progress status inquiry table"
98 ... "Order input" button 99 ... "Substitute vehicle status inquiry" button 101 ... Substitute vehicle status inquiry screen 110 ... "Schedule input" button 111 ... Schedule input screen 120 ... "Schedule performance inquiry" button 121 ... Schedule inquiry screen 122 ... Inquiry condition input field 123 ... "Details" button 124 ... Schedule inquiry details screen 125 ... Print button 126 ... Print preview screen 130 ... "Incoming vehicle list" button 131 ... Incoming vehicle status list 132 ... Inquiry condition input field 133 ... Search button 134 ... Preview button 135 ... Print preview screen 140 ... "Batch stop" button 141 ... Batch stop input screen 150 ... "Vehicle inspection maintenance reservation" button 151 ... Vehicle inspection general maintenance reservation status screen 152 ... Vehicle inspection / general maintenance reservation list screen 160 ... "Sales target input" button 161 ... Sales target result comparison table screen 162 ... Inquiry Item input field 163 ... Search button 164 ... Sales target list 165 ... Preview button 166 ... Print preview screen 170 ... "Unit price calculation" button 171 ... Sheet metal painting unit price calculation screen 172 ... Employee list 173 ... Cost calculation button 180 ... "Profit per order" button 181 ... Profit per order screen 182 ... Inquiry condition input field 183 ... Search button 184 ... Profit per order table 185 ... Preview button 186 ... Print preview screen 190 ... "Work result total" button 191 ... Sheet metal Painting work result summary table screen 192 ... Inquiry condition input field 193 ... Search button 194 ... Work result summary table 195 ... Preview button 196 ... Print preview screen 201 ... Barcode result report input screen 202 ... Execution button 300 ... Repair status of the accident vehicle Management device 301... First processing device 3 2 ... The second processing unit 303 ... third processing unit 304 ... fourth processing unit 311 ... public telephone line 312 ... public telephone line

Claims (9)

A vehicle repair work management device for managing vehicle repair work received by a vehicle repair contractor,
A work index table that stores a work that can be a target and a work index that is defined in advance according to the target work;
An index consideration designating unit for designating a consideration per work index;
A work type input section for inputting the type of the target work;
An index determination unit for determining a work index corresponding to the work type input in the work type input unit with reference to the work index table;
A standard work fee calculating unit for calculating a standard work fee by multiplying the work index determined by the index determining unit by a consideration per work index specified by the index consideration specifying unit;
A unit time work charge designation part for specifying a work charge per unit time of the worker;
For each work type, an identification information of the worker who performed the work, an actual work time input unit for inputting the actual work time performed by the person,
Calculates the actual work fee actually required by multiplying the work fee per unit time specified in the unit time work charge designation unit for each work type by the actual work time input in the actual work time input unit. An actual work fee calculation unit to
A profit and loss calculation unit that calculates the difference between the standard work fee calculated by the standard work fee calculation unit and the actual work fee calculated by the actual work fee calculation unit;
A display unit for displaying the difference calculated by the profit and loss calculation unit as profit and loss;
A vehicle repair work management device comprising: The vehicle repair work management device according to claim 1,
Creation of a progress management table for creating a progress management table for displaying the progress of each work based on the progress information input by the actual work time input unit for each work type input by the work type input unit And
A vehicle repair work management device comprising: The vehicle repair work management device according to claim 2,
The work index table further defines standard work hours of work that can be targeted,
The progress management table creation unit is further configured to display the work progress schedule based on the standard work time as a progress schedule table graphed in time series on the display unit with respect to the work type input by the work type input unit. A vehicle repair work management device characterized by comprising: The vehicle repair work management device according to any one of claims 1 to 3,
The actual work time input unit is configured so that each worker inputs identification information, a work start time and a work end time by scanning a barcode scanner for each unit work constituting each work type. A vehicle repair work management device characterized by comprising: The vehicle repair work management device according to any one of claims 1 to 4,
The work type input unit is further capable of inputting the received order date, the vehicle warehousing date, and the work end scheduled date as order information related to the input work type.
The vehicle repair work management device further
An order master information holding unit for holding information input in the work type input unit as order master information;
The incoming vehicle management unit that manages the incoming date of the incoming vehicle,
A vehicle repair work management device comprising: The vehicle repair work management device according to claim 5, further comprising:
A request input part for inputting various inquiry requests;
When an incoming vehicle inquiry request is input from the request input unit, an incoming vehicle list display unit that displays a list of incoming vehicle statuses based on management information of the incoming vehicle management unit;
When a sales target inquiry request is input from the request input unit, a sales target is calculated based on the standard work fee calculated by the standard work fee calculation unit and the actual work fee calculated by the actual work fee calculation unit. Sales target results comparison table display means for displaying results comparison table;
When a profit inquiry request per order is input from the request input unit, a profit inquiry table per order is displayed based on the difference between the standard work fee calculated by the profit / loss calculation unit and the actual work fee. An order profit inquiry display means;
When a work result total inquiry request is input from the request input unit, work result total table display means for displaying a work result total table based on the work result information for each work type input by the actual work time input unit When,
A vehicle repair work management device comprising: A vehicle repair work management method for managing repair work of a vehicle ordered by a vehicle repair company,
When the type of the target work is input, a process index determined in advance in the work index table according to the target work is determined with reference to the work index table;
Multiplying the determined work index by the price per work index designated in advance by the index price designation unit, and calculating a standard work fee;
On the other hand, for each work type, the step of inputting the identification information of the worker who performed the work, and the actual work time performed by this person,
Multiplying the actual work time input for each work type by the work fee per unit time specified in the unit time work charge specifying unit, and calculating the actual work fee actually required,
Calculating the difference between the standard work charge and the actual work charge and displaying it as profit or loss;
A vehicle repair work management method comprising: A vehicle repair work management program for managing vehicle repair work received by a vehicle repair company,
When the type of the target work is input, a function that the work index defined in advance in the work index table according to the target work is determined with reference to the work index table;
A function for calculating the standard work fee by multiplying the determined work index by the price per work index designated in advance by the index price designation unit;
On the other hand, for each work type, the function of inputting the identification information of the worker who performed the work, and the actual work time performed by this person,
A function for calculating the actual work fee actually required by multiplying the actual work time input for each work type by the work fee per unit time specified in the unit time work charge designation unit,
Calculate the difference between the standard work charge and the actual work charge and display it as profit and loss,
A vehicle repair work management program characterized in that a computer is realized.   A computer-readable recording medium or a device that stores the vehicle repair work management program according to claim 8.