excel

profilekk11
e00_cumexam_data.xlsx

Employee Data

Fireball Technology Company
Salary and Benefit Expenditures
Employee Benefits Code Need Daycare Salary Pension Costs Health Insurance Costs Daycare Costs Total Employee Cost
1 2 No 39100
2 1 Yes 37150
3 3 Yes 32500
4 3 Yes 34000
5 1 No 35650
6 2 No 42500
7 3 Yes 29900
8 3 No 34000
9 3 No 30450
10 1 No 35200
11 3 Yes 33000
12 3 Yes 28600
13 2 Yes 36000
14 2 No 37300
15 3 No 34000
16 1 Yes 36500
17 3 Yes 33000
18 3 Yes 34000
19 1 No 34500
20 3 Yes 34000
21 3 Yes 30000
22 2 No 40000
23 2 No 36000
24 2 No 37000
25 1 Yes 42850
26 1 Yes 42000
27 1 No 44000
28 1 No 40660
29 2 No 44000
30 1 Yes 48500
31 1 Yes 42000
32 2 No 47500
33 2 No 47000
34 1 Yes 48500
35 2 No 52500
36 1 Yes 62520
37 1 Yes 61250
38 1 No 57000
39 2 No 58500
40 1 Yes 60050
41 2 No 72000
Summary Statistics:
Number of Employees:
Lowest Total Employee Cost:
Average Total Employee Cost:
Maximum Total Employee Cost:
Median Total Employee Cost:
Today's Date:

Benefits

Benefits Code Pension Health Insurance Daycare Contribution
1 0.05 0.3 5000
2 0.075 0.25 4000
3 0.03 0.1 1000

Earnings

Fireball Technology Company
Earnings Summary
Division Quarter 1 Quarter 2 Quarter 3 Quarter 4 Trend
Computer Division $42,125 $35,528 $43,187 $39,254
Accounting Division $33,522 $35,220 $38,454 $40,210
Financial Division $21,358 $24,523 $25,383 $27,354