JP2021189609A - Business support device, business support method, and business support program - Google Patents

Abstract

To provide a business support device that further improves efficiency of registration work on work information of a work responsible person and aggregation work of a head office.SOLUTION: A business support device includes a control unit that supports calculation of a salary payment amount to a work responsible person who performs work at a contract destination and a billing payment amount to the contract destination on the work. The control unit includes: reception means that receives daily report information on the work for the unit of a work day and the contract destination; and calculation means that calculates the salary payment amount to the work responsible person based on the daily report information and calculation standard information of the salary payment amount, and the billing payment amount to the contract destination for the unit of the work day and the contract destination based on the daily report information and calculation standard information of the billing payment amount.SELECTED DRAWING: Figure 2

Description

The present invention relates to a business support device, a business support method, and a business support program for supporting the calculation work of the salary payment amount to the person in charge who performed the work at the contractor and the billing payment amount to the contractor regarding the work. ..

In the past, the head office, which oversees business management such as maintenance of equipment for arcades and karaoke boxes, and route sales such as product replenishment for vending machines and office convenience stores, is a sales system for the number of product replenishment and sales amount. It was common to collect and aggregate and manage information as information on the above, and to separately collect and aggregate and manage information on attendance such as the work time and amount of work of the person in charge of work as management-related information.

However, since the sales-related information and the management-related information are managed separately, the amount of work increases for both the head office and the person in charge of work, which hinders the improvement of work efficiency. So far, no solution to such a problem has been known (Patent Document 1).

Japanese Unexamined Patent Publication No. 2002-92174

An object of the present invention is to provide a work support device for further improving the efficiency of work information registration work of a work person and aggregation work of a head office.

In order to solve the above-mentioned problems and achieve the object, the business support device according to the present invention calculates the salary payment amount to the person in charge who performed the work at the contractor and the bill payment amount to the contractor regarding the work. A business support device provided with a control unit for supporting business, wherein the control unit receives daily report information on work on a work day and contractor basis, and the daily report information and salary payment amount. Based on the calculation standard information, the salary payment amount to the person in charge is calculated, and the billing payment amount to the contractor is calculated for each work day and contractor based on the daily report information and the calculation standard information of the billing payment amount. It is characterized in that it is provided with a calculation means for performing.

Further, in the business support device according to the present invention, the calculation means uses the work day and the contractor unit as the salary payment amount, the work time information included in the daily report information, and the calculation standard information of the salary payment amount. Based on the information on the hourly wage unit price included in, the hourly wage payment amount to the person in charge, and / or the work amount information included in the daily report information, and the commission billing unit price of the work amount included in the calculation standard information of the salary payment amount. Based on the information in Based on the wage billing unit price information, the wage work billing amount to the contractor, and / or the sales information included in the daily report information, and the sales percentage information included in the billing payment calculation standard information. Based on this, it is characterized in that the step-back payment amount to the contractor is calculated.

Further, the business support device according to the present invention is characterized in that the calculation means calculates both the hourly wage payment amount and the commission payment amount as the salary payment amount for each work day and contractor. ..

Further, the business support device according to the present invention is characterized in that the calculation means calculates both the commission work billing amount and the step-back payment amount as the billing payment amount in units of work days and contractors. do.

Further, the business support device according to the present invention is characterized in that the information items of the daily report information received by the reception means are different for each person in charge and / or the contractor.

Further, in the business support device according to the present invention, the information that the control unit identifies the person in charge based on the salary payment amount calculated by the calculation means for each work day and contractor, the work day. Information and information for identifying the contractor based on the billing payment amount calculated by the calculation means and / or the information including the information including the information of the salary payment amount, the work. It is further provided with a data creation means for creating billing payment data that summarizes information including date information and the billing payment amount information.

Further, in the business support device according to the present invention, the control unit aggregates the total salary payment amount for the predetermined period based on the salary data for the predetermined period, and / or based on the billing payment data for the predetermined period. It is further provided with a totaling means for totaling the total amount of billing and / or payment for the predetermined period.

Further, in the business support device according to the present invention, the control unit creates a salary statement based on the salary data for a predetermined period, and / or the billing statement and / or based on the bill payment data for a predetermined period. Alternatively, it is characterized by further comprising a statement creating means for creating a payment statement.

Further, the business support method according to the present invention calculates the salary payment amount to the person in charge who performed the work at the contractor and the bill payment amount to the contractor regarding the work, which is executed in the business support device provided with the control unit. A business support method for supporting business, which is a reception step for receiving daily report information on work on a work day and contractor basis, which is executed by the control unit, and a calculation standard for the daily report information and salary payment amount. Based on the information, the salary payment amount to the person in charge is calculated, and the billing payment amount to the contractor is calculated for each work day and contractor based on the daily report information and the calculation standard information of the billing payment amount. It is characterized by including steps.

Further, in the business support program according to the present invention, the salary payment amount to the person in charge who performed the work at the contractor and the bill payment amount to the contractor regarding the work to be executed by the business support device provided with the control unit. A business support program for supporting calculation work, which is a reception step for receiving daily report information on work on a work day and contractor basis, and the daily report information and salary payment amount to be executed by the control unit. Based on the calculation standard information, the salary payment amount to the person in charge is calculated, and the billing payment amount to the contractor is calculated for each work day and contractor based on the daily report information and the calculation standard information of the billing payment amount. It is characterized by including a calculation step to be performed.

According to the present invention, it is possible to simultaneously register management-related information related to attendance such as working hours and workload as the same daily report information together with sales-related information related to bill payment to the contractor, and further, the same registered information. Since the billing payment amount and the salary payment amount can be calculated centrally based on the daily report information of the above, it is possible to improve the efficiency of the work information registration work of the work person and the aggregation work of the head office.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. FIG. 2 is a flow chart showing an example of a processing flow from receiving daily report information in the business support device to creating both salary data and billing payment data. FIG. 3A is a diagram showing an example of an input screen after inputting daily report information. (A) is an example of an input screen for accepting information specifying a work, and (b) is an example of an input screen for accepting variable information and arbitrary information. FIG. 3B is a diagram showing an example of an input screen after inputting daily report information. (A) is an example of an input screen for accepting information specifying a work, and (b) is an example of an input screen for accepting variable information and arbitrary information. FIG. 3C is a diagram showing an example of an input screen after inputting daily report information. (A) is an example of an input screen for accepting information specifying a work, and (b) is an example of an input screen for accepting variable information and arbitrary information. FIG. 4 is a diagram showing an example of a contractor master. FIG. 5 is a diagram showing an example of a person in charge master. FIG. 6 is a diagram showing an example of an item restriction master. FIG. 7 is a diagram showing an example of a list of billing payment data. (A) to (c) show an example of a list of billing payment data at different dates and times. FIG. 8 is a diagram showing an example of a salary data list. (A) and (b) show an example of a list of salary data at different dates and times. FIG. 9 is a diagram showing an example of a payment statement. FIG. 10 is a diagram showing an example of a pay slip.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. composition]
Here, an example of the configuration of the PC (personal computer) 100 according to the present embodiment including the business support device of the present invention will be described with reference to FIG. The configuration of the present embodiment is merely an example, and the present invention is not limited to the realization of the configuration of the present embodiment. In addition, duplicate description may be omitted in the following description of the configuration.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108, and is a server 200 that stores various data (for example, each data stored in the storage unit 106, which may be described later). It is communicably connected to (for example, a Web server or the like) via a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), or the like).

Each part of the PC 100 is communicably connected via an arbitrary communication path.

The PC 100 may be a stationary type such as a desktop personal computer, or a portable type such as a notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be.

The control unit 102 is a CPU or the like that comprehensively controls the PC 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally includes a reception unit 102a, a calculation unit 102b, a data creation unit 102c, an aggregation unit 102d, a detail creation unit 102e, and the like.

The reception unit 102a receives daily report information regarding work on a work day and contractor basis. The daily report information received by the reception unit 102a includes information for identifying the work and variable information for determining the salary payment amount and the billing payment amount (that is, the billing amount and / or the payment amount). The information that identifies the work may be any information that can distinguish the work, and includes, for example, information that identifies the person in charge, information that identifies the contractor, information on the work day, and the like. The variable information may include work time information, work amount information, sales information, and the like.

The information that identifies the person in charge is, in one embodiment, the identifier of the person in charge, the name of the person in charge, the employee number of the person in charge, the affiliation of the person in charge, the address of the person in charge, the telephone number of the person in charge, and the email address of the person in charge. , Information such as the type of employment contract of the person in charge. In one embodiment, the information that identifies the contractor is the identifier of the contractor, the name of the contractor, the contract number of the contractor, the address of the contractor, the telephone number of the contractor, the email address of the contractor, and the contractor. It can be information such as the type of contract. The identifier can be, for example, a number, an alphabet (including uppercase and lowercase letters) or a combination thereof. In one embodiment, the contractor may be a place unit where the work is performed, not a contract unit. The work day information may be, in one embodiment, date information of the year, month, day, and optionally time information of hours, minutes, and seconds.

The work time information may be, in one embodiment, information on the work time performed by the person in charge at the contractor. The work time information may be, in one embodiment, information on a combination of work disclosure time and work end time. The work time information is the work time information in any time unit such as 1 hour unit, 30 minute unit, 15 minute unit, 10 minute unit, 5 minute unit, 1 minute unit, 1 second unit, etc. in one embodiment. possible. Here, the work time is only the work time of the work targeted for in-house business in one embodiment, only the work time of the work targeted for outsourcing in the other embodiment, and further, in the other embodiment, the work time targeted for in-house business and It is the work time of both works subject to outsourcing.

The work amount information may be the work amount information performed by the person in charge at the contractor in one embodiment. The work amount information is, in one embodiment, the work amount information based on an arbitrary standard such as the number of products related to the work amount, the number of machines, the weight or volume of the product, the transportation distance of the product, and the score of the work level. possible. The work in the amount of work and the work in the work time may be the work of different targets or the work of the same target. In one embodiment, the work in the amount of work is the work to be outsourced, and the work in the work time is the work to be sold by the company. In another embodiment, the work in the amount of work is the work to be outsourced, and the work in the work time is both the work to be sold by the company and the work to be outsourced.

The sales information may, in one embodiment, be sales information for a fixed period determined by a contract. The sales information may be, in one embodiment, information on sales generated from the previous working day (or contract date) to a specific working day. The sales information is, in one embodiment, the sales to be outsourced.

The daily report information received by the reception unit 102a may include other optional information in addition to the information for specifying the work and the variable information for determining the salary payment amount and the billing payment amount. Other optional information may be, for example, the number of withdrawals and withdrawals of goods (or the counter value for determining it), the number of collected coins (or the counter value for determining it), and the like.

The information items of the daily report information received by the reception unit 102a may or may not differ depending on the person in charge and / or the contractor. The information item of the daily report information received by the reception unit 102a is different for each person in charge and / or the contractor based on the item restriction standard information included in the item restriction master information in one embodiment.

The information item of the daily report information received by the reception unit 102a differs for each contractor depending on the type of contract with the contractor in one embodiment.

The information item of the daily report information received by the reception unit 102a differs for each person in charge depending on the type of employment contract of the person in charge in one embodiment.

The information items of the daily report information received by the reception unit 102a differ depending on the person in charge and / or the contractor, because they are classified into acceptance items and non-acceptance items in one embodiment. The difference in the information items of the embodiment is realized by the difference in the daily report information input screen, for example, in the form of displaying the accepted items and not displaying the unaccepted items. The difference in the daily report information input screen is, for example, a form of switching to an appropriate input screen for inputting other daily report information after inputting the information of the person in charge and / or the contractor, and appropriate for inputting other daily report information. It is realized by the form of displaying various input screens.

The information items of the daily report information received by the reception unit 102a are different because, in one embodiment, they are classified into essential reception items and arbitrary reception items for each person in charge and / or the contractor. The difference in the information items of the embodiment is that, for example, if all the required acceptance items are not entered, the daily report information cannot be registered (rejection of acceptance), and the required acceptance items are not entered as necessary. Is realized by restricting the registration of daily report information, as in the form of allowing registration of daily report information when all the required acceptance items are entered.

The calculation unit 102b determines the salary payment amount to the person in charge based on the daily report information received by the reception unit 102a and the calculation standard information of the salary payment amount included in the person in charge master information. And, based on the calculation standard information of the billing payment amount included in the contractor master information, the billing payment amount to the contractor is calculated respectively. The calculation unit 102b calculates the salary payment amount and the billing payment amount in units of working days and contractors.

The salary payment calculation standard information is information included in the person in charge master information, and is a standard for determining the salary payment amount to the person in charge as a non-fixed salary. Information such as commission salary unit price may be included. From the information on the hourly wage unit price, the hourly wage payment amount to the person in charge can be calculated as the salary payment amount. From the information on the commission unit price of the amount of work, the commission payment amount to the person in charge can be calculated as the salary payment amount.

The billing payment amount calculation standard information is information included in the contractor master information, and is a standard for determining the billing amount and / or the payment amount predetermined with the contractor, for example, work. Information on the unit price for requesting a quantity, information on the rate of sales, and the like may be included. From the information on the commission unit price of the work amount, the commission work billing amount to the contractor can be calculated as the billing payment amount. From the sales step rate information, the step-back payment amount to the contractor can be calculated as the billing payment amount.

In one embodiment, the calculation unit 102b determines the hourly wage payment amount to the person in charge based on the work time information included in the daily report information and the hourly wage unit price information included in the salary payment amount calculation standard information as the salary payment amount. Is calculated. In one embodiment, the calculation unit 102b integrates the hourly wage unit price into the working hours and calculates the hourly wage payment amount.

In one embodiment, the calculation unit 102b is in charge of the salary payment amount based on the work amount information included in the daily report information and the commission unit price information of the work amount included in the salary payment amount calculation standard information. Calculate the commission payment amount for. In one embodiment, the calculation unit 102b integrates the commission unit price of the work amount into the work amount to calculate the commission payment amount.

In one embodiment, the calculation unit 102b may calculate only the hourly wage payment amount, calculate only the commission payment amount, or calculate both the hourly wage payment amount and the commission payment amount as the salary payment amount. In one embodiment, the calculation unit 102b calculates only the hourly wage payment amount, only the commission payment amount, or both the hourly wage payment amount and the commission payment amount as the salary payment amount for each person in charge. The calculation form of whether to calculate may be different. In one embodiment, the calculation form differs for each person in charge according to the type of employment contract of the person in charge included in the information for identifying the person in charge in the person in charge master information.

In one embodiment, the calculation unit 102b is a contractor based on the information on the amount of work included in the daily report information and the information on the commission unit price of the amount of work included in the calculation standard information of the billing payment amount as the billing payment amount. Calculate the commission work billing amount for. In one embodiment, the calculation unit 102b integrates the commission unit price of the work amount into the work amount to calculate the commission work request amount.

In one embodiment, the calculation unit 102b returns to the contractor as the billing payment amount based on the sales information included in the daily report information and the sales rate information included in the billing payment calculation standard information. Calculate the payment amount. In one embodiment, the calculation unit 102b integrates the sales rate with the sales to calculate the step-back payment amount.

In one embodiment, the calculation unit 102b may calculate only the commission work billing amount, calculate only the step-back payment amount, or calculate both the commission work billing amount and the step-back payment amount as the billing payment amount. In one embodiment, the calculation unit 102b calculates only the commission work billing amount or only the step-back payment amount for each contractor as the billing payment amount, or the commission work billing amount and the step-back payment amount. The calculation form of whether to calculate both may be different. In one embodiment, the calculation form differs for each contractor depending on the type of contract with the contractor included in the information for specifying the contractor in the contractor master information.

In one embodiment, the data creation unit 102c includes information for identifying the person in charge, work day information, salary payment amount information, and other optional information based on the salary payment amount calculated by the calculation unit 102b. Create salary data that summarizes information for each work day and contractor. In one embodiment, the data creation unit 102c includes information for identifying a contractor, work day information, billing payment amount information, and other optional information based on the billing payment amount calculated by the calculation unit 102b. Billing and payment data that summarizes information is created for each work day and contractor.

In one embodiment, the data creation unit 102c has information for identifying the person in charge, work day information, hourly wage payment information, and commission payment based on the hourly wage payment amount and the commission payment amount calculated by the calculation unit 102b. Create wage data that summarizes information including payment amount information and other optional information. In one embodiment, the data creation unit 102c has information for identifying a contractor, work day information, and commission work billing amount based on the commission work billing amount and the step-back payment amount calculated by the calculation unit 102b. Create billing payment data that summarizes information on step-back payments and other optional information.

In one embodiment, the aggregation unit 102d aggregates the total salary payment amount for a predetermined period based on the salary data for a predetermined period created by the data creation unit 102c. In one embodiment, the aggregation unit 102d aggregates the total amount of billing and / or payment for a predetermined period based on the billing / payment data for a predetermined period created by the data creation unit 102c.

In one embodiment, the detail creation unit 102e creates a salary statement based on the salary data for a predetermined period created by the data creation unit 102c. The salary statement created by the statement creation unit 102e includes information for identifying the person in charge, work day information, salary payment amount (including hourly wage payment amount and commission payment amount), and other optional information. It can be.

In one embodiment, the detail creation unit 102e creates a billing statement and / or a payment statement based on the billing payment data for a predetermined period created by the data creating unit 102c. The billing statement and payment statement created by the detail creation unit 102e include information for identifying the contractor, work date information, billing payment amount (including commission work billing amount or step-back payment amount), and other information. Optional information and the like may be included.

The form of issuance of pay slips, invoices, and payment statements created by the statement creation unit 102e is not limited to the form of issuance by printing the statement on a paper medium, but also an electronic statement (PDF (Portable as an example)). A form of issuance as a Document Form) format specification) may also be included.

The communication interface unit 104 connects the PC 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 conceptually includes a person in charge master information storage unit 106a, a contractor master information storage unit 106b, an item restriction master information storage unit 106c, a salary data storage unit 106d, a billing / payment data storage unit 106e, and the like. ..

The person in charge master information storage unit 106a stores the person in charge master information. In one embodiment, the person in charge master information storage unit 106a stores the person in charge master information for each person in charge. The person in charge master information includes information for identifying the person in charge and information for calculating the salary payment amount.

The contractor master information storage unit 106b stores the contractor master information. The contractor master information storage unit 106b stores the contractor master information for each contractor in one embodiment. The contractor master information includes information for identifying the contractor and information for calculating the billing payment amount.

The item restriction master information storage unit 106c stores the item restriction master information. In one embodiment, the item restriction master information storage unit 106c stores the item restriction master information for each person in charge and / or for each contractor. The item restriction master information includes information for specifying the restriction target and item restriction standard information. The information that identifies the restricted object may include information such as the type of employment contract of the person in charge or the type of contract with the contractor. The item restriction standard information includes, for example, information on classification of accepted items (items displayed on the daily report information input screen) and non-accepted items (items not displayed on the daily report information input screen), required accepted items, and optional items. Information on classification with accepted items may be included.

The salary data storage unit 106d stores salary data. In one embodiment, the salary data storage unit 106d stores salary data for each person in charge and work day. Salary data includes information that identifies the person in charge, information on work days, information on work volume, information on work hours, information on salary payments such as hourly wages, commission payments, and other optional information. It can be.

The billing payment data storage unit 106e stores billing payment data. In one embodiment, the billing / payment data storage unit 106e stores billing / payment data for each contractor and working day (billing / payment date). The billing payment data includes information for identifying the contractor, work date information, work volume information, sales information, commission work billing amount, billing payment amount information such as step-back payment amount, and other optional information. Can be included.

An input device 400 and an output device 500 are connected to the input / output interface unit 108. The output device 400 includes a display device such as a display and a projector, an acoustic device such as a speaker, a printing device such as a printer, and a device that can be downloaded in a data file format. As the data file file format, a file format known in the art such as PDF, CSV, document file, spreadsheet software file, text file, etc. can be adopted. In addition to the keyboard, mouse, and microphone, the input device 500 can use a monitor that realizes a pointing device function in cooperation with the mouse.

An example of the processing flow from the reception of daily report information to the creation of both salary data and billing payment data will be described according to the flow chart shown in FIG. FIG. 2 is a flow chart showing an example of a processing flow from receiving daily report information in the business support device to creating both salary data and billing payment data. In this embodiment, both the hourly wage payment amount and the commission payment amount are calculated as the salary payment amount, and both the commission work billing amount and the commission payment amount are calculated as the billing payment amount.

The reception unit 102a receives the daily report information A regarding the work on a work day and contractor basis, and based on the information for identifying the person in charge included in the daily report information A, the person in charge stored in the person in charge master information storage unit 106a. Based on the information that identifies the person in charge master information B corresponding to the person and specifies the contractor included in the daily report information A, the contractor master information corresponding to the contractor stored in the contractor master information storage unit 106b. C is specified (S1).

Next, the calculation unit 102b calculates the hourly wage payment amount and the commission payment amount to the person in charge, and the commission work request amount and the step-back payment amount to the contractor based on the daily report information A received by the reception unit 102a. S2).

In detail, the calculation unit 102b gives the person in charge an hourly wage based on the work time information A1 included in the daily report information A received by the reception unit 102a and the hourly wage unit price information B2 included in the specified person in charge master information B. Calculate the amount of payment (S2-1).

Further, the calculation unit 102b is in charge based on the work amount information A2 included in the daily report information A received by the reception unit 102a and the commission unit price information B1 of the work amount included in the specified person in charge master information B. Calculate the commission payment amount to the person (S2-2).

Further, the calculation unit 102b makes a contract based on the work amount information A2 included in the daily report information A received by the reception unit 102a and the work amount commission unit price information C1 included in the specified contractor master information C. Calculate the commission work billing amount for the destination (S2-3).

Further, the calculation unit 102b is based on the sales information A3 included in the daily report information A received by the reception unit 102a and the sales rate information C2 included in the specified contractor master information C. Calculate the refund amount (S2-4).

The calculation of the hourly wage payment amount, the commission payment amount, the commission work request amount and the step-back payment amount (S2-1 to S2-4) may be performed at the same time or may be performed in any order.

After the calculation by the calculation unit 102b (S2), the data creation unit 102c creates salary data based on the hourly wage payment amount and the commission payment amount calculated by the calculation unit 102b (S3-1), and the calculation unit 102b Billing and payment data are created (S3-2) based on the calculated commission work billing amount and step-back payment amount, and are stored in the salary data storage unit 106d and the billing and payment data storage unit 106e, respectively.

[2. Concrete example]
Here, using some case examples, from the reception of daily report information in the business support device of one embodiment to the creation of salary data and billing payment data, and the total of salary payment amount, billing amount and payment amount for a predetermined period. The processing of the aggregation and the information processing of the pay slip and the preparation of the pay slip will be described with reference to FIGS. 3A-10.

3A, 3B, and 3C are diagrams showing an example of an input screen after inputting daily report information, respectively. FIG. 3A is an example of an input screen after inputting daily report information for the work on March 4, 2020, (a) is an input screen for receiving information specifying the work, and (b) is variable information and This is an example of an input screen for accepting arbitrary information. FIG. 3B is an example of an input screen after inputting daily report information about the work on March 18, 2020, (a) is an input screen for receiving information specifying the work, and (b) is variable information and This is an example of an input screen for accepting arbitrary information. FIG. 3C is an example of an input screen after inputting daily report information about the work on March 23, 2020, (a) is an input screen for receiving information specifying the work, and (b) is variable information and This is an example of an input screen for accepting arbitrary information.

FIG. 4 is a diagram showing an example of a person in charge master. FIG. 5 is a diagram showing an example of a contractor master. FIG. 6 is a diagram showing an example of an item restriction master.

FIG. 7 is a diagram showing an example of a list of billing and payment data, (a) is a list of billing and payment data before inputting daily report information for the work on March 4, 2020, and (b) is a list of billing and payment data in March 2020. A list of billing and payment data after inputting daily report information for the work on the 4th, (c) shows a list of billing and payment data after inputting the daily report information for the work on March 18, 2020.

FIG. 8 is a diagram showing an example of a salary data list, (a) is a salary data list after inputting daily report information for the work on March 4, 2020, and (b) is March 18, 2020. Shows a list of salary data after inputting daily report information about the work of.

FIG. 9 is a diagram showing an example of a payment statement, and FIG. 10 is a diagram showing an example of a pay slip.

As the first case, on March 4, 2020, from the input of daily report information about the work performed by the person in charge of the person in charge code "300" at the contractor of the store code "1001", salary data and bill payment. The processing of information up to the creation of data will be explained. The contents of the work at the contractor in the first case are the in-house work related to the maintenance of the crane game machine and the consignment work related to the maintenance of the vending machine.

First, the reception unit 102a outputs the input screen 31 and receives the information for specifying the work among the daily report information about the work. FIG. 3A (a) is an input screen 31 for receiving information specifying the work, and shows the one after inputting each item. The reception unit 102a receives information for identifying the person in charge from the identifier of the person in charge entered in the person in charge code field 31a, and receives information for specifying the contractor from the identifier of the contractor entered in the store code field 31b. Accept and accept work day information from the date entered in the work day field 31c.

Next, the reception unit 102a identifies the person in charge master information 41a corresponding to the person in charge of the person in charge code "300" from the person in charge master 41 based on the identifier of the person in charge, and the contractor based on the identifier of the contractor. The contractor master information 51a corresponding to the contractor of the store code "1001" is specified from the master 51.

Next, the reception unit 102a outputs the input screen 32 to receive the variable information for determining the salary payment amount and the billing payment amount and other optional information among the daily report information related to the work.

The reception unit 102a outputs an input screen displaying items suitable for the contract contents in the contract destination master information 41a with reference to the item restriction master 61 shown in FIG. Since the contract content is "in-house work and outsourced work", the items for inputting all variable information are displayed, and only when all the items are input, the daily report information registration button 32l can be pressed. And.

FIG. 3A (b) is an input screen 32 for receiving variable information and arbitrary information displayed after pressing the confirmation button 31d on the input screen shown in FIG. 3A (a), after inputting each item. Is shown. After pressing the close button 31e, the reception process is canceled.

The reception unit 102a displays in advance the same contents as those entered in FIG. 3A (a) in the person in charge code field 32a, the store code field 32b, and the work day field 32c. The reception unit 102a is the latest of the corresponding contractor based on the billing payment data 71a of the corresponding store code in the billing payment data 71 shown in FIG. 7A from the input contractor identifier (store code). The number of payout counters "100" is specified, and the value is displayed in advance in the previous payout counter column 32f.

The reception unit 102a has the hour and minute "11:00" input in the work start time column 32d and the hour and minute "11:00" input in the work end time column 32e as variable information for determining the salary payment amount and the billing payment amount. Receives work time information as a time value "1" from "12:00", and accepts sales information as a sales value "15,000" from the sales amount of the crane game machine entered in the company's sales amount field 32i, and outsourced work. Information on the amount of work is received as the number of work "5" from the number of maintenance work of the vending machine input in the number field 32j.

The reception unit 102a receives information on the number of current payout counters of the crane game machine as other optional information. The numerical value in the payout number column 32h is automatically displayed by subtracting the numerical value in the previous payout counter column 32f from the numerical value after inputting the numerical value in the current payout counter column 32g of the crane game machine. The reception process in the reception unit 102a is confirmed by pressing the daily report information registration button 32l on the input screen 32. If the close button 32m is pressed, the button is canceled.

Next, the calculation unit 102b integrates the unit value "1,100" of the hourly wage unit price information included in the person in charge master information 41a with the time value "1" of the work time information received by the reception unit 102a. , Calculate the hourly wage payment amount "1,100" to the person in charge.

Further, the calculation unit 102b integrates the unit value "400" of the commission salary unit price information of the work amount included in the person in charge master information 41a into the work number "5" of the work amount information received by the reception unit 102a. Then, the commission payment amount "2,000" to the person in charge is calculated.

Further, the calculation unit 102b sets the unit value "1,000" of the commission unit price information of the work amount included in the contractor master information 51a to the work number "5" of the work amount information received by the reception unit 102a. By accumulating, the commission work billing amount "5,000" to the contractor is calculated.

Further, the calculation unit 102b integrates the sales value "20%" of the sales rate information included in the contractor master information 51a into the sales value "15,000" of the sales information received by the reception unit 102a. Then, the step-back payment amount "3,000" to the contractor is calculated.

Next, the data creation unit 102c obtains salary data 81a for the work of the first case as shown in FIG. 8A based on the hourly wage payment amount and the commission payment amount calculated by the calculation unit 102b. It is created, added to the salary data list 81, and stored in the salary data storage unit 106d. The salary data 81a created by the data creation unit 102c includes items of work day, person in charge code, work time, number of work, hourly wage payment amount, and commission payment amount.

Further, the data creation unit 102c has a billing payment data 71b for the work of the first case as shown in FIG. 7B based on the commission work billing amount and the step-back payment amount calculated by the calculation unit 102b. Is created, added to the billing payment data list 71, and stored in the billing payment data storage unit 106e. The billing payment data 71b created by the data creating unit 102c includes a store code, a work date, a step-back payment amount, a commission work billing amount, a payout counter, and a number of payouts.

Next, as the second case, daily report information on the work performed by the person in charge of the person in charge code "400" on March 18, 2020 at the contractor of the same store code "1001" as in the first case. The processing of information from the input of to the creation of salary data and billing payment data will be described. In the second case, the content of the work at the contractor is only the in-house work related to the maintenance of the crane game machine.

First, the reception unit 102a outputs the input screen 33 and receives the information for specifying the work among the daily report information about the work. FIG. 3B (a) is an input screen 33 for receiving information specifying the work, and shows the one after inputting each item. Similar to the first case, the reception unit 102a obtains information for identifying the person in charge, information for specifying the contractor, and information on the work day from the person in charge code column 33a, the store code column 33b, and the work date column 33c. The person in charge master information 41b corresponding to the person in charge of the person in charge code "400" and the contractor master information 51a corresponding to the contractor of the store code "1001" are specified from the contractor master 51.

Next, the reception unit 102a outputs the input screen 34 to receive the variable information and other arbitrary information. Since the contractor is the same as the first case, the reception unit 102a refers to the item restriction master 61 shown in FIG. 6 and sets the same items as the first case based on the contract contents in the contractor master information 41a. The input screen 34 to be displayed is output. Further, as in the first case, the items for inputting all the variable information are displayed, and the daily report information registration button 32l can be pressed only when all the items are input.

FIG. 3B (b) is an input screen 32 for receiving variable information and arbitrary information displayed after pressing the confirmation button 33d on the input screen shown in FIG. 3B (a), after inputting each item. Is shown. After pressing the close button 33e, the reception process is canceled.

The reception unit 102a displays in advance the same contents as those entered in FIG. 3B (a) in the person in charge code field 34a, the store code field 34b, and the work day field 34c. The reception unit 102a is the latest of the corresponding contractor based on the billing payment data 71b of the corresponding store code in the billing payment data 71 shown in FIG. 7B from the input contractor identifier (store code). The number of payout counters "110" is specified, and the value is displayed in advance in the previous payout counter column 34f.

The reception unit 102a works as a time value "1" from the hour and minute "14:00" input in the work start time column 34d and the hour and minute "15:00" input in the work end time column 34e as variable information. It accepts time information and accepts sales information as a sales value "20,000" from the sales amount of the crane game machine entered in the company sales amount field 34i. Unlike the first case, in the second case, only the in-house work related to the maintenance of the crane game machine is performed, and there is no outsourced work. It is input and accepted as work amount information, and as in the first case, information on the number of current payout counters of the crane game machine is received from the current payout counter column 34g as other optional information. Similar to the first case, the numerical value in the payout number column 32h is automatically displayed after the payout counter column 34g is input this time. The reception process in the reception unit 102a is confirmed by pressing the daily report information registration button 36g on the input screen 36. If the close button 36h is pressed, the button is canceled.

Next, the calculation unit 102b integrates the unit value "1,100" of the hourly wage unit price information included in the person in charge master information 41b with the time value "1" of the work time information received by the reception unit 102a. , Calculate the hourly wage payment amount "1,100" to the person in charge.

Further, the calculation unit 102b integrates the unit value "400" of the commission salary unit price information of the work amount included in the person in charge master information 41b into the work number "0" of the work amount information received by the reception unit 102a. Then, the commission payment amount "0" to the person in charge is calculated.

Further, the calculation unit 102b sets the unit value "1,000" of the commission unit price information of the work amount included in the contractor master information 51a to the work number "0" of the work amount information received by the reception unit 102a. Accumulate and calculate the commission work billing amount "0" for the contractor.

Further, the calculation unit 102b integrates the sales value "20,000" of the sales information received by the reception unit 102a with the sales value "20%" of the sales rate information included in the contractor master information 51a. Then, the step-back payment amount "4,000" to the contractor is calculated.

Next, the data creation unit 102c creates salary data 81b for the work of the second case as shown in FIG. 8B, and adds it to the salary data list 81, as in the first case. It is stored in the salary data storage unit 106d, and as shown in FIG. 7C, the billing payment data 71c for the work of the second case is created, added to the billing payment data list 71, and the billing payment data storage unit 106e. Store in.

Next, as a third case, on March 23, 2020, from the input of daily report information about the work performed by the person in charge of the person in charge code "500" at the contractor of the store code "3001", salary data. And the processing of information up to the creation of billing payment data will be described. In the second case, the content of the work at the contractor is only the consignment work related to the maintenance of the vending machine.

First, the reception unit 102a outputs the input screen 35 and receives the information for specifying the work among the daily report information about the work. FIG. 3C (a) is an input screen 35 for receiving information specifying the work, and shows the one after inputting each item.

Similar to the first case and the second case, the reception unit 102a has information for specifying the person in charge, information for specifying the contractor, and information for specifying the contractor from the person in charge code column 35a, the store code column 35b, and the work day column 35c. Receives work day information and identifies the person in charge master information 41c corresponding to the person in charge with the person in charge code "500" and the contractor master information 51c corresponding to the contractor with the store code "3001" from the contractor master 51. ..

Next, the reception unit 102a outputs the input screen 36 to receive the variable information for determining the salary payment amount and the billing payment amount and other optional information among the daily report information related to the work.

The reception unit 102a outputs an input screen displaying items suitable for the contract contents in the contract destination master information 51c with reference to the item restriction master 61 shown in FIG. Since the contract content is "consignment work", items other than counter payout items and in-house sales items are displayed as items for inputting variable information, and the entered person in charge code field 36a, store code field 36b, And, in addition to the work day column 36c, the registration button 36l of the daily report information can be pressed only when the consignment work number column 36f is input. The registration button 36l can be pressed without inputting the work start time column 36d and the work end time column 36e, and if registration is performed without inputting, the work time information is accepted as the time value "0".

FIG. 3C (b) is an input screen 36 for receiving variable information and arbitrary information displayed after pressing the confirmation button 35d on the input screen shown in FIG. 3C (a), after inputting each item. Is shown. After pressing the close button 35e, the reception process is canceled.

The reception unit 102a displays in advance the same contents as those entered in FIG. 3C (a) in the person in charge code field 36a, the store code field 36b, and the work day field 36c.

The reception unit 102a has the hour and minute "12:00" entered in the work start time column 36d and the hour and minute "12:00" entered in the work end time column 36e as variable information for determining the salary payment amount and the billing payment amount. From "14:00", the work time information is received as the time value "2", and the work amount information is received as the work number "7" from the maintenance work number of the vending machine input in the consignment work number column 32f. The reception process in the reception unit 102a is confirmed by pressing the daily report information registration button 36g on the input screen 36. If the close button 36h is pressed, the button is canceled.

Next, the calculation unit 102b integrates the unit value "1,300" of the hourly wage unit price information included in the person in charge master information 41c with the time value "2" of the work time information received by the reception unit 102a. , Calculate the hourly wage payment amount "2,600" to the person in charge.

Further, the calculation unit 102b integrates the unit value "500" of the commission unit price information of the work amount included in the person in charge master information 41c into the work number "7" of the work amount information received by the reception unit 102a. Then, the commission payment amount "3,500" to the person in charge is calculated.

Further, the calculation unit 102b sets the unit value "1,200" of the commission unit price information of the work amount included in the contractor master information 51c to the work number "7" of the work amount information received by the reception unit 102a. By accumulating, the commission work billing amount "8,400" to the contractor is calculated.

In the third case, the calculation unit 102b does not calculate the step-back payment amount to the contractor.

Next, the data creation unit 102c creates salary data and billing / payment data for the work of the third case as shown in FIG. 8B, as in the first case and the second case. It is added to the salary data list 81 and the billing payment data list 71, and stored in the salary data storage unit 106d and the billing payment data storage unit 106e (not shown).

Next, based on the billing payment data 71 for one month up to March 29, which was created by the data creation unit 102c and stored in the billing payment data storage unit 106e, the aggregation unit 102d shall perform the billing amount and / or payment. After totaling the total amount, the detail creation unit 102e creates a payment statement 91 and an invoice statement (not shown) as shown in FIG. FIG. 9 is a payment statement 91 for ABCD, including the contractor ABCD Yokohama store of the store code “1001”.

Further, based on the salary data 81 for one month up to March 29, which was created by the data creation unit 102c and stored in the salary data storage unit 106d, the aggregation unit 102d aggregates the total salary payment amount and details the details. The preparation unit 102e creates a pay slip 101 as shown in FIG. FIG. 10 is a pay slip 101 for the person in charge of the person in charge code “300”.

Although the embodiments of the present invention have been described so far, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments. Is.

For example, among the processes described in the above-described embodiment, all or part of the processes described as being automatically performed can be manually performed, or the processes described as being manually performed. It is also possible to automatically perform all or part of the above by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the above documents and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the PC 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in each device constituting the PC 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is recorded in each apparatus as necessary. It is read mechanically. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in an application program server connected to the PC 100 via an arbitrary network, and it is also possible to download all or a part thereof as needed.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the PC 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the PC 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the PC 100.

Furthermore, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful for the work information registration work of the person in charge of work, and the accounting work for calculating the salary payment amount, the billing payment amount, and the like.

100 PC
102 Control unit 102a Reception unit 102b Calculation unit 102c Data creation unit 102d Aggregation unit 102e Detail creation unit 104 Communication interface unit 106 Storage unit 106a Person in charge master information storage unit 106b Contractor master information storage unit 106c Item restriction master information storage unit 106d Salary Data storage unit 106e Billing and payment data storage unit 108 Input / output interface unit 200 Server 300 Network 400 Input device 500 Output device

Claims (10)

It is a business support device provided with a control unit for supporting the calculation work of the salary payment amount to the person in charge who performed the work at the contractor and the billing payment amount to the contractor regarding the work.
The control unit
A reception means for receiving daily report information on work on a work day and contractor basis,
Based on the daily report information and the calculation standard information of the salary payment amount, the salary payment amount to the person in charge is determined.
Based on the daily report information and the calculation standard information of the billing payment amount, the billing payment amount to the contractor is determined.
Calculation means to calculate for each work day and contractor,
A business support device characterized by being equipped with. The calculation means
By work day and contractor unit
As the salary payment amount
Based on the work time information included in the daily report information and the hourly wage unit price information included in the calculation standard information of the salary payment amount, the hourly wage payment amount to the person in charge and / or the work amount included in the daily report information. Based on the information and the information on the commission unit price of the amount of work included in the calculation standard information of the salary payment amount, the commission payment amount to the person in charge is calculated, and the bill payment amount is calculated.
Based on the information on the amount of work included in the daily report information and the information on the commission unit price of the amount of work included in the calculation standard information of the billing payment amount, the commission work billing amount to the contractor and / or the daily report information The first aspect of claim 1, wherein the step-back payment amount to the contractor is calculated based on the sales information included in the above and the sales rate information included in the billing payment calculation standard information. Business support device. The business support device according to claim 2, wherein the calculation means calculates both the hourly wage payment amount and the commission payment amount as the salary payment amount in units of working days and contractors. The business support according to claim 2 or 3, wherein the calculation means calculates both the commission work billing amount and the step-back payment amount as the billing payment amount in units of work days and contractors. Device. The business support device according to any one of claims 1 to 4, wherein the information item of the daily report information received by the reception means is different for each person in charge and / or the contractor. The control unit obtains information for identifying the person in charge, information on the work day, and information on the salary payment amount based on the salary payment amount calculated by the calculation means for each work day and contractor. Information for identifying the contractor, information on the working day, and information on the billing payment amount based on the billing payment amount calculated by the calculation means and / or creating salary data summarizing the including information. The business support device according to any one of claims 1 to 5, further comprising a data creating means for creating billing payment data including information including. The control unit aggregates the total salary payment amount for the predetermined period based on the salary data for the predetermined period, and / or the billing amount and / or the payment amount for the predetermined period based on the billing payment data for the predetermined period. The business support device according to claim 6, further comprising a totaling means for totaling the totals of the above. The control unit creates a pay slip based on the payroll data for a predetermined period, and / or provides a statement creating means for creating a billing statement and / or a payment statement based on the billing payment data for a predetermined period. The business support device according to claim 6 or 7, further comprising. It is a business support method for supporting the calculation work of the salary payment amount to the person in charge who performed the work at the contractor and the billing payment amount to the contractor regarding the work, which is executed in the business support device provided with the control unit. hand,
Executed by the control unit,
A reception step that accepts daily report information about work on a work day and contractor basis,
Based on the daily report information and the calculation standard information of the salary payment amount, the salary payment amount to the person in charge is determined.
Based on the daily report information and the calculation standard information of the billing payment amount, the billing payment amount to the contractor is determined.
Calculation steps to be calculated for each work day and contractor, and
A business support method characterized by including. It is a business support program to support the calculation work of the salary payment amount to the person in charge who performed the work at the contractor and the billing payment amount to the contractor regarding the work to be executed by the business support device equipped with the control unit. There,
To make the control unit execute
A reception step that accepts daily report information about work on a work day and contractor basis,
Based on the daily report information and the calculation standard information of the salary payment amount, the salary payment amount to the person in charge is determined.
Based on the daily report information and the calculation standard information of the billing payment amount, the billing payment amount to the contractor is determined.
Calculation steps to be calculated for each work day and contractor, and
A business support program characterized by including.

Images