Assignment 2b (alexander Chow)

Alexander Chow 11/6/07 Software Application A Pd.7

4

Excel Assignment 2b (Basic Formulas)

Boyd, Chad Fleming, Corey Fleming, Regina Leveille, Jamie Leveille, Jason Leveille, Lisa Williams, Erynn

2 3 20 12 52 25 22

6 7 21 14 48 21 23

8 9 23 10 58 20 25

6 7 26 11 39 19 28

To ta

l

M ar ch

Fe br ua ry

Ja nu ar y

be r D

N

ov em

ec em

be r

Alexander Chow's Ski Adventures - Training Sessions

3 4 18 8 41 18 19

25 30 108 55 238 103 117 676

To ta l

4

Alexander Chow 11/6/07 Software Application A Pd.7

Alexander Chow 11/6/07 Software Application Pd.7

4

Excel Assignment 2b (Basic Formulas) Alexander Chow's Ski Adventures - Payroll January 1-7 Name Boyd, Chad Fleming, Corey Fleming, Regina Leveille, Jamie Leveille, Jason Leveille, Lisa Williams, Erynn Total

Rate of Pay $5.00 $6.10 $5.75 $5.50 $6.75 $7.25 $11.00

Regular Hour

Overtime Hours 31 40 40 38 40 40 40

0 2 5 0 3 7 12

Regular Pay $155.00 $244.00 $230.00 $209.00 $270.00 $290.00 $440.00

Overtime Pay $$18.30 $43.13 $$30.38 $76.13 $198.00

Total Pay $155.00 $262.30 $273.13 $209.00 $300.38 $366.13 $638.00 $2,203.93

Alexander Chow 11/6/07 Software Application A Pd.7

4

Excel Assignment 2b (Basic Formulas) Alexander Chow's Ski Adventures - Payroll January 1-7 Name Boyd, Chad Fleming, Corey Fleming, Regina Leveille, Jamie Leveille, Jason Leveille, Lisa Williams, Erynn Total

Rate of Pay $5.00 $6.10 $5.75 $5.50 $6.75 $7.25 $11.00

Regular Hour

Overtime Hours 40 31 33 40 30 40 40

5 0 0 6 0 10 15

Regular Pay $200.00 $189.10 $189.75 $220.00 $202.50 $290.00 $440.00

Overtime Pay $37.50 $$$49.50 $$108.75 $247.50

Total Pay $237.50 $189.10 $189.75 $269.50 $202.50 $398.75 $687.50 $2,174.60