The global overtime report for GBU Composite Materials is comprised of data provided by the payroll teams of USA, UK, Germany & China by the 6th of each month. Contacts as of July 10th 2018 are as follows
USA: Rudy Alvarez
UK: Konstantins Krupjanko
Germany: Ulrich Von Hartz
China: Lihua (Eva) Chen
Tabs
Overview
Locations
Overtime
Direct Overtime
4 Tabs
Total Hours
Total Regular Hours
Total Overtime Hours
Average % Overtime
Vacation Hours
Map displaying locations and % Overtime
Overtime Hours for Aero Sites
Split of total and direct overtime
General Comments
Data are updated in country specific files by the 6th of each month by the contacts named above.The google sheets are as follows - beware to not change the structure:
The files are comprised of the raw data as well as a country specific list of cost centers that are considered “direct” and by opposition the cost centers not in the list are considered “indirect”.
Site Controllers are responsible for providing the relevant cost centers to be added to the “direct” cost center list.
Period of Analysis
Monthly, Updated on the 7th of each month.
Specifications:
To see specifications for this dashboard, use the following link:
