Scribd
Upload
12 views3 pages

Ski Holiday Staff Pay Overview

The document outlines a ski holiday staff roster including 11 employees, their roles, pay codes, and weekly hours and pay. It lists 4 pay codes (A, B, C, D) with corresponding hourly rates and calculates total weekly pay by pay code and in total, along with maximum, minimum and average individual pay.

Uploaded by

icy bear
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views3 pages

Ski Holiday Staff Pay Overview

The document outlines a ski holiday staff roster including 11 employees, their roles, pay codes, and weekly hours and pay. It lists 4 pay codes (A, B, C, D) with corresponding hourly rates and calculates total weekly pay by pay code and in total, along with maximum, minimum and average individual pay.

Uploaded by

icy bear
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Ski Holidays

Job code Job description Pay Code


A Administration/Office A
B Snowboard Instructor B
H Host/Hostess C
S Ski Instructor D
SA Senior Administrator
TA Transport assistant
TB Trainee Snowboard Instructor
TM Transport Manager
TS Trainee Ski Instructor

Employees
Code Name Pay code Job description (lookup)

TA Arne Bircher A Transport assistant


TS Jon Haby A Trainee Ski Instructor
TM Thomas Tobler C Transport Manager
B Tim Frueh B Snowboard Instructor
TA Dekke Heitz A Transport assistant
B Simone Aebi B Snowboard Instructor
A Luca Rim B Administration/Office
B Lara Forrer B Snowboard Instructor
B John Zwinky B Snowboard Instructor
SA Romina Von Gunten D Senior Administrator
A Arenwald Wurgler A Administration/Office

Staff Count 11
Total Sum (Pay code A)
Total Sum (Pay code B)
Total Sum (Pay code C)
Total Sum (Pay code D)
ays
Pay per Hour
£ 30.00
£ 35.00
£ 20.00
£ 15.00

Hours worked Pay per Hour weekly Pay


(weekly) (Lookup)
10 £ 30.00 £ 300.00
25 £ 30.00 £ 750.00
25 £ 20.00 £ 500.00
15 £ 35.00 £ 525.00
12 £ 30.00 £ 360.00
25 £ 35.00 £ 875.00
12 £ 35.00 £ 420.00
25 £ 35.00 £ 875.00
12 £ 35.00 £ 420.00
40 £ 15.00 £ 600.00
38 £ 30.00 £ 1,140.00
Total £ 6,765.00
Max £ 1,140.00
Min £ 300.00
Average £ 615.00

You might also like