Ready-made database access Calculation of pay for piece-work dresses
Option 7. Calculation of pay for piece-work dresses
Table 1. List of prices
Table structure: Job code, Job title, Price (RUB per unit)
Table 2. Brigade Handbook
Table structure: Brigade code, Personnel number, Surname I.O.
Table 3. Apparel
Table structure: Outfit number, Brigade code, Personnel number, Job code, Executed volume (in units of measure), KTU (the labor participation coefficient can have values from 0 to 1)
Enter information in Table 1 on the five works, in Table 2 - data on 10 workers from the three brigades.
Create the "Order" form to enter data in Table 3, providing for the control of the input data (the volume executed, the brigade code) and the issuing of messages when input errors occur. Enter data for three orders, with one outfit should contain data for one team and each worker can perform only one job. Within a month, several outfits can be issued for one brigade. Entering the personnel number and code of work should be carried out using the list fields based on the reference tables.
Create a form (such as master / slave) to obtain information about the performance of work of a given type by workers´ brigades. The value of the work code field must be selected from the combo box. The main form must contain the following fields: Job code, Job title, Price. The subordinate form should contain the columns: number of the brigade, number of the order, scope of work and cost of work.
Create a request to create a table "Statement of charges of the team", which has the following structure: Personnel number, Surname IO, Scope of work, Pricing, Accrued by the piece, Accrued by the KTU. Calculation Accrued KTU execute according to the formula:
Accrued KTU = Prize for team * KTU worker / KTU brigade
The brigade number and the size of its bonus must be entered when the query is executed.
Create a report "Statement of Charges for the Brigade ... for the month." Brigade number must be entered on request. The statement must contain columns: No. p / p, Personnel number, Surname, Surname, Extradition, Signature. The statement must contain the final amount for issuance.