It is necessary to implement the accounting of working hours and salaries of employees of a construction company using Excel
1. Number of employees (if this is important) 10-50
2. Employees have different positions
3. Hourly wages for different positions vary (may be different for different employees of the same position)
4. Salary is fixed for a standard 8-hour working day and corresponds to the hourly rate of a specific EMPLOYEE
5. Salary has an allowance that can be adjusted for overtime hours and work performed on weekends. There should be the possibility of rewarding each specific employee with the allocation of costs to the location and dividing this amount among several locations
6. Employees work at different locations (including one employee may work at more than one location in one day)
7. At one location, employees can be involved in different types of work
7. Reports on employees are needed: weekly, monthly, by locations. (number of worked days, hours, including overtime. Total salary)
8. General reports by locations are needed (Project implementation period in days, Number of worked human-days, Number of involved employees, Total salary and breakdown by employees.
9. Reports on types of work are needed (Labor costs per unit of measurement, funds per unit of measurement)
10. We implement the project in Google Sheets with the possibility of delegating data entry to a responsible person, but without the ability to see reports
