Spreadsheet: 802690d1666972062-employee-costing-model-labour-model-query
Sheet: Lead

Staff Code | Last Name | First Name | Full Name | Cost Centre | Cost Centre Desc | Category | Job Title | Direct/Indirect | Perm/Casual | Annual | Bonus | Increase % | Month | Joining Date | Leaving Date | Increase Effective | January | February | March | April | May | June | July | August | September | October | November | December | FY 2023
 |  |  |  |  |  |  |  | Indirect |  | 22215 |  |  |  |  | august
 |  |  |  |  |  |  |  | Direct |  | 21945
 |  |  |  |  |  |  |  | Indirect |  | 9043 |  |  |  |  | september
 |  |  |  |  |  |  |  | Indirect |  | 23614
 |  |  |  |  |  |  |  | Direct |  | 17934 | 1000 | 0.035 | April
 |  |  |  |  |  |  |  | Direct |  | 2169 |  |  |  |  | January
 |  |  |  |  |  |  |  | Direct |  | 28246
 |  |  |  |  |  |  |  | Direct |  | 2182
 |  |  |  |  |  |  |  | Direct |  | 20999
 |  |  |  |  |  |  |  | Indirect |  | 11819
 |  |  |  |  |  |  |  | Indirect |  | 4066
 |  |  |  |  |  |  |  | Direct |  | 4488
 |  |  |  |  |  |  |  | Direct |  | 41758
 |  |  |  |  |  |  |  | Indirect |  | 49975
 |  |  |  |  |  |  |  | Direct |  | 40262
 |  |  |  |  |  |  |  | Indirect |  | 4456
 |  |  |  |  |  |  |  | Indirect |  | 32996
 |  |  |  |  |  |  |  | Direct |  | 30834
 |  |  |  |  |  |  |  | Indirect |  | 16053
 |  |  |  |  |  |  |  | Direct |  | 33270
 |  |  |  |  |  |  |  | Direct |  | 15798
 |  |  |  |  |  |  |  | Indirect |  | 24094
 |  |  |  |  |  |  |  | Direct |  | 36724
 |  |  |  |  |  |  |  | Indirect |  | 6675
 |  |  |  |  |  |  |  | Indirect |  | 46112
 |  |  |  |  |  |  |  | Indirect |  | 21644
 |  |  |  |  |  |  |  | Direct |  | 35680
 |  |  |  |  |  |  |  | Direct |  | 8481
 |  |  |  |  |  |  |  | Indirect |  | 27706
 |  |  |  |  |  |  |  | Indirect |  | 40628
 |  |  |  |  |  |  |  | Direct |  | 8906
 |  |  |  |  |  |  |  | Indirect |  | 38546
 |  |  |  |  |  |  |  | Direct |  | 12043
 |  |  |  |  |  |  |  | Direct |  | 14666
 |  |  |  |  |  |  |  | Indirect |  | 7188
 |  |  |  |  |  |  |  | Indirect |  | 22671
 |  |  |  |  |  |  |  | Indirect |  | 16568
 |  |  |  |  |  |  |  | Direct |  | 16130
 |  |  |  |  |  |  |  | Direct |  | 15930
 |  |  |  |  |  |  |  | Direct |  | 16331
 |  |  |  |  |  |  |  | Direct |  | 45068
 |  |  |  |  |  |  |  | Direct |  | 11807
 |  |  |  |  |  |  |  | Indirect |  | 20317
 |  |  |  |  |  |  |  | Direct |  | 31142
 |  |  |  |  |  |  |  | Indirect |  | 46864
 |  |  |  |  |  |  |  | Direct |  | 27864
 |  |  |  |  |  |  |  | Direct |  | 38074
 |  |  |  |  |  |  |  | Direct |  | 26504
 |  |  |  |  |  |  |  | Direct |  | 32782
 |  |  |  |  |  |  |  | Direct |  | 25209
 |  |  |  |  |  |  |  | Direct |  | 34021
 |  |  |  |  |  |  |  | Direct |  | 32378
 |  |  |  |  |  |  |  | Direct |  | 48298
 |  |  |  |  |  |  |  | Indirect |  | 26450
 |  |  |  |  |  |  |  | Indirect |  | 49875
 |  |  |  |  |  |  |  | Indirect |  | 3106
 |  |  |  |  |  |  |  | Indirect |  | 14881
 |  |  |  |  |  |  |  | Direct |  | 21949
 |  |  |  |  |  |  |  | Indirect |  | 2871
 |  |  |  |  |  |  |  | Direct | Casual | 14570
 |  |  |  |  |  |  |  | Direct |  | 43672
 |  |  |  |  |  |  |  | Direct |  | 4256
 |  |  |  |  |  |  |  | Direct |  | 39810
 |  |  |  |  |  |  |  | Direct |  | 24194
 |  |  |  |  |  |  |  | Indirect |  | 30139
 |  |  |  |  |  |  |  | Direct |  | 34594
 |  |  |  |  |  |  |  | Direct |  | 13738
 |  |  |  |  |  |  |  | Indirect |  | 46793
 |  |  |  |  |  |  |  | Indirect |  | 10520
 |  |  |  |  |  |  |  | Direct |  | 28922
 |  |  |  |  |  |  |  | Direct |  | 21956
 |  |  |  |  |  |  |  | Indirect |  | 38803
 |  |  |  |  |  |  |  | Direct |  | 22115
 |  |  |  |  |  |  |  | Direct |  | 37092
 |  |  |  |  |  |  |  | Indirect |  | 39469
 |  |  |  |  |  |  |  | Direct |  | 49326
 |  |  |  |  |  |  |  | Direct |  | 12862
 |  |  |  |  |  |  |  | Indirect |  | 30591
 |  |  |  |  |  |  |  | Direct | Casual | 8462
 |  |  |  |  |  |  |  | Direct |  | 12986
 |  |  |  |  |  |  |  | Direct |  | 29373
 |  |  |  |  |  |  |  | Direct |  | 31805
 |  |  |  |  |  |  |  | Indirect |  | 16132
 |  |  |  |  |  |  |  | Direct |  | 32853
 |  |  |  |  |  |  |  | Direct |  | 33858
 |  |  |  |  |  |  |  | Indirect |  | 26517
 |  |  |  |  |  |  |  | Direct |  | 30994
 |  |  |  |  |  |  |  | Indirect |  | 19389
 |  |  |  |  |  |  |  | Direct |  | 20379
 |  |  |  |  |  |  |  | Indirect |  | 2118
 |  |  |  |  |  |  |  | Indirect |  | 20757
 |  |  |  |  |  |  |  | Direct |  | 44656
 |  |  |  |  |  |  |  | Direct |  | 16099
 |  |  |  |  |  |  |  | Direct |  | 39364
 |  |  |  |  |  |  |  | Direct |  | 18015
 |  |  |  |  |  |  |  | Indirect |  | 43456
 |  |  |  |  |  |  |  | Direct |  | 3003
 |  |  |  |  |  |  |  | Direct |  | 11822
 |  |  |  |  |  |  |  | Indirect |  | 14082
 |  |  |  |  |  |  |  | Direct |  | 42092
 |  |  |  |  |  |  |  | Direct |  | 30873
 |  |  |  |  |  |  |  | Direct |  | 7427
 |  |  |  |  |  |  |  | Indirect |  | 19348
 |  |  |  |  |  |  |  | Direct |  | 39249 |  |  |  |  | August
 |  |  |  |  |  |  |  | Direct | Casual | 25457
 |  |  |  |  |  |  |  | Direct |  | 31851
 |  |  |  |  |  |  |  | Indirect |  | 15375
 |  |  |  |  |  |  |  | Indirect |  | 3653
 |  |  |  |  |  |  |  | Direct |  | 42214
 |  |  |  |  |  |  |  | Indirect |  | 11375
 |  |  |  |  |  |  |  | Direct |  | 46819
 |  |  |  |  |  |  |  | Direct |  | 19919
 |  |  |  |  |  |  |  | Direct |  | 2694
 |  |  |  |  |  |  |  | Direct |  | 3083
 |  |  |  |  |  |  |  | Direct |  | 35824
 |  |  |  |  |  |  |  | Indirect |  | 10939
 |  |  |  |  |  |  |  | Direct |  | 19615
 |  |  |  |  |  |  |  | Direct |  | 47599
 |  |  |  |  |  |  |  | Direct | Casual | 23226
 |  |  |  |  |  |  |  | Direct |  | 5952
 |  |  |  |  |  |  |  | Direct |  | 26963
 |  |  |  |  |  |  |  | Indirect |  | 38657
 |  |  |  |  |  |  |  | Direct |  | 21034
 |  |  |  |  |  |  |  | Direct |  | 23893
 |  |  |  |  |  |  |  | Indirect |  | 30637
 |  |  |  |  |  |  |  | Indirect |  | 1306
 |  |  |  |  |  |  |  | Direct |  | 47571
 |  |  |  |  |  |  |  | Indirect |  | 26671
 |  |  |  |  |  |  |  | Indirect |  | 47144
 |  |  |  |  |  |  |  | Direct |  | 35830
 |  |  |  |  |  |  |  | Direct |  | 38309
 |  |  |  |  |  |  |  | Direct |  | 13959
 |  |  |  |  |  |  |  | Indirect |  | 4257
 |  |  |  |  |  |  |  | Direct |  | 4994
 |  |  |  |  |  |  |  | Direct |  | 17394
 |  |  |  |  |  |  |  | Direct |  | 14533
 |  |  |  |  |  |  |  | Indirect |  | 18820
 |  |  |  |  |  |  |  | Direct |  | 25522
 |  |  |  |  |  |  |  | Direct |  | 29436
 |  |  |  |  |  |  |  | Indirect |  | 10311
 |  |  |  |  |  |  |  | Indirect |  | 13136
 |  |  |  |  |  |  |  | Indirect |  | 42485
 |  |  |  |  |  |  |  | Indirect |  | 12211
 |  |  |  |  |  |  |  | Direct |  | 42548
 |  |  |  |  |  |  |  | Direct |  | 11559
 |  |  |  |  |  |  |  | Indirect |  | 12517
 |  |  |  |  |  |  |  | Indirect |  | 1887
 |  |  |  |  |  |  |  | Direct |  | 12884
 |  |  |  |  |  |  |  | Indirect |  | 33172
 |  |  |  |  |  |  |  | Direct |  | 9846
 |  |  |  |  |  |  |  | Indirect |  | 36368
 |  |  |  |  |  |  |  | Indirect |  | 13932
 |  |  |  |  |  |  |  | Direct |  | 38845
 |  |  |  |  |  |  |  | Direct |  | 19905
 |  |  |  |  |  |  |  | Direct |  | 36477
 |  |  |  |  |  |  |  | Direct |  | 39582
 |  |  |  |  |  |  |  | Direct |  | 46920
 |  |  |  |  |  |  |  | Direct |  | 3174
 |  |  |  |  |  |  |  | Direct |  | 16777
 |  |  |  |  |  |  |  | Direct |  | 34359
 |  |  |  |  |  |  |  | Indirect |  | 49655
 |  |  |  |  |  |  |  | Direct |  | 3120
 |  |  |  |  |  |  |  | Indirect |  | 48479
 |  |  |  |  |  |  |  | Direct |  | 33806
 |  |  |  |  |  |  |  | Direct |  | 41594
 |  |  |  |  |  |  |  | Indirect |  | 18581
 |  |  |  |  |  |  |  | Indirect |  | 37065
 |  |  |  |  |  |  |  | Indirect |  | 21756
 |  |  |  |  |  |  |  | Indirect |  | 36160
 |  |  |  |  |  |  |  |  |  | 9040