Anna Bob Sheril John Cathy Susan
Wages/hr $ 18.00 $ 21.00 $ 12.00 $ 14.00 $ 16.50 $ 17.50
1/1/1999 48.0 2.0 4.7 1.8 17.1 7.6
2/1/1999 26.8 14.5 26.9 40.4 17.0 33.8
3/1/1999 6.6 44.1 11.4 16.8 11.8 8.6
4/1/1999 46.3 1.1 37.0 14.0 19.9 38.5
5/1/1999 49.8 28.4 1.6 44.8 25.9 20.0
6/1/1999 25.7 44.1 10.3 11.8 21.7 26.6
7/1/1999 23.1 19.4 41.3 6.8 44.0 37.7
8/1/1999 5.3 40.7 31.4 27.3 14.5 40.4
9/1/1999 48.4 26.7 42.6 5.9 24.1 13.1
10/1/1999 21.3 46.6 39.3 45.5 27.5 34.8
11/1/1999 10.6 8.0 8.1 11.1 18.8 5.1
12/1/1999 9.1 20.6 10.0 36.2 43.7 10.7
1/1/2000 2.4 9.4 0.1 2.6 0.6 28.7
2/1/2000 33.2 10.5 26.0 27.2 9.0 32.6
3/1/2000 12.6 46.1 41.5 0.3 20.6 34.0
4/1/2000 44.8 26.6 25.0 31.2 2.2 47.1
5/1/2000 9.4 43.5 35.6 5.0 1.5 20.5
6/1/2000 12.4 17.0 14.8 32.9 43.2 7.9
7/1/2000 41.5 21.4 37.9 49.9 33.3 9.2
8/1/2000 5.6 43.9 3.0 32.3 33.8 50.0
9/1/2000 31.2 32.1 45.5 31.6 27.6 3.8
10/1/2000 6.5 38.0 43.8 29.5 34.8 5.1
11/1/2000 6.6 48.3 29.0 45.9 7.9 20.6
12/1/2000 1.0 48.2 18.2 0.7 26.9 16.5
1/1/2001 39.2 39.8 22.3 10.1 41.0 46.3
2/1/2001 24.2 34.6 25.0 1.1 7.2 29.4
3/1/2001 35.1 1.2 33.4 25.7 10.5 26.3
4/1/2001 18.4 23.5 11.1 3.5 41.7 16.1
5/1/2001 9.8 35.1 23.9 35.2 47.9 28.7
6/1/2001 44.6 9.9 47.2 35.6 12.0 14.0
7/1/2001 36.8 24.6 19.4 26.9 2.6 32.1
8/1/2001 29.0 18.5 24.4 34.7 34.2 0.0
9/1/2001 47.3 40.0 40.0 27.6 46.4 11.6
10/1/2001 41.1 12.4 20.3 8.3 15.9 6.8
11/1/2001 5.3 25.3 28.7 30.5 42.1 8.6
12/1/2001 49.6 42.5 0.4 18.6 36.9 22.5
1/1/2002 25.3 3.4 37.0 33.8 29.2 22.3
2/1/2002 49.0 41.2 31.1 19.7 27.4 39.6
3/1/2002 15.6 41.5 12.1 31.2 36.6 3.6
4/1/2002 34.2 20.7 20.3 39.3 47.4 15.8
5/1/2002 13.1 39.9 28.3 23.2 21.3 42.9
6/1/2002 42.4 23.0 0.6 0.7 47.1 32.5
7/1/2002 24.7 30.3 21.4 47.6 24.5 40.3
8/1/2002 25.0 4.7 3.9 27.6 40.7 48.1
9/1/2002 32.3 22.9 42.1 1.4 30.7 1.0
10/1/2002 34.2 30.9 9.7 5.6 35.8 34.3
11/1/2002 6.8 3.4 32.0 11.7 35.9 16.9
12/1/2002 8.1 10.5 0.1 18.7 44.9 27.0
1/1/2003 24.3 30.5 48.3 3.0 4.2 2.4
2/1/2003 32.2 28.3 43.6 37.5 20.7 4.1
3/1/2003 39.9 10.7 18.3 6.2 33.1 19.9
4/1/2003 5.5 46.9 26.1 5.1 4.3 43.1
5/1/2003 11.8 48.2 1.6 14.0 41.0 25.7
6/1/2003 46.2 23.0 45.3 35.9 6.1 8.0
7/1/2003 43.7 32.1 48.0 4.6 34.9 34.6
8/1/2003 43.9 4.9 25.2 10.0 14.7 16.3
9/1/2003 7.4 39.3 32.1 19.5 30.8 11.8
10/1/2003 24.3 46.6 37.8 0.4 5.7 21.4
11/1/2003 46.6 12.0 31.6 1.4 1.7 27.2
12/1/2003 25.1 3.9 3.1 36.2 7.2 29.7
1/1/2004 17.1 14.7 21.4 0.8 18.7 5.7
2/1/2004 8.9 39.9 27.0 11.7 1.6 17.1
3/1/2004 16.0 16.1 46.4 29.3 18.8 4.1
4/1/2004 46.2 24.9 33.8 39.9 29.9 1.0
5/1/2004 3.6 0.8 17.6 17.0 30.8 46.9
6/1/2004 24.2 20.0 20.2 46.3 26.4 36.1
7/1/2004 35.7 42.3 13.0 12.4 3.8 35.5
8/1/2004 12.3 18.2 49.3 45.3 22.0 3.9
9/1/2004 8.4 23.8 39.1 20.5 44.7 31.0
10/1/2004 32.4 44.2 19.2 43.3 11.4 9.4
11/1/2004 27.5 32.1 1.7 31.6 0.1 33.7
12/1/2004 28.6 24.1 21.6 19.8 44.4 44.5
1/1/2005 40.3 6.2 47.0 31.6 3.0 23.8
2/1/2005 48.5 0.7 44.5 7.4 3.1 39.4
3/1/2005 11.0 45.9 48.4 33.2 42.2 0.0
4/1/2005 22.1 38.6 36.5 34.5 4.2 32.0
5/1/2005 24.1 24.4 32.9 15.3 14.0 36.8
6/1/2005 31.3 21.0 33.6 18.8 12.2 34.0
7/1/2005 26.4 12.4 47.3 5.7 33.7 24.3
8/1/2005 40.7 26.2 44.8 18.8 39.2 25.7
9/1/2005 45.4 49.8 3.6 5.1 21.8 6.8
10/1/2005 44.4 17.0 3.2 28.2 35.8 41.1
11/1/2005 10.3 16.2 29.7 45.2 7.8 48.0
12/1/2005 21.5 45.9 26.0 47.0 1.4 15.2
1/1/2006 27.6 1.6 32.0 2.8 37.8 19.4
2/1/2006 32.4 43.1 36.1 12.5 7.1 38.1
3/1/2006 30.1 49.0 36.8 29.6 0.9 28.3
4/1/2006 28.2 44.2 14.4 20.8 4.0 5.7
5/1/2006 6.6 9.6 46.9 24.2 42.8 18.8
6/1/2006 22.3 11.2 9.3 1.5 16.3 12.5
7/1/2006 29.3 19.5 41.7 29.2 1.4 43.0
8/1/2006 8.6 28.8 41.1 3.6 7.9 42.4
9/1/2006 1.6 10.8 13.9 31.8 0.0 22.5
10/1/2006 1.1 16.6 43.1 34.0 29.6 9.7
11/1/2006 45.2 1.2 30.0 6.1 32.0 49.3
12/1/2006 44.2 16.2 4.1 29.5 3.0 24.7
1/1/2007 48.7 21.0 28.2 44.1 29.5 31.5
2/1/2007 30.2 40.9 27.1 35.3 23.7 28.2
3/1/2007 37.7 36.2 47.9 13.9 29.7 43.6
4/1/2007 42.8 8.4 34.0 42.5 20.4 7.5
5/1/2007 22.6 34.5 21.2 37.0 3.7 35.4
6/1/2007 43.4 25.2 8.7 21.5 11.3 14.9
7/1/2007 44.0 30.9 23.9 38.5 20.1 29.6
8/1/2007 29.4 36.9 30.6 10.9 32.1 34.0
9/1/2007 18.5 17.5 5.6 31.8 13.7 9.4
10/1/2007 12.5 23.5 31.2 43.4 49.8 19.6
11/1/2007 46.6 27.4 2.0 38.4 10.9 34.2
12/1/2007 2.7 44.7 24.4 43.1 3.0 21.2
1/1/2008 15.7 1.8 16.9 12.4 7.5 9.9
2/1/2008 41.7 37.2 42.1 10.9 33.3 40.5
3/1/2008 43.7 1.4 41.9 18.2 5.9 21.0
4/1/2008 29.6 34.5 23.0 20.1 8.4 0.4
5/1/2008 38.5 35.4 42.9 45.2 31.4 33.5
6/1/2008 41.2 2.9 4.6 22.0 32.4 4.1
7/1/2008 9.7 28.5 40.8 7.8 0.6 31.5
8/1/2008 7.5 11.3 22.5 15.8 12.2 20.1
9/1/2008 35.5 40.0 45.9 44.9 32.8 3.4
10/1/2008 44.4 20.7 2.5 0.9 13.0 33.4
11/1/2008 38.8 21.8 43.2 17.2 12.9 33.2
12/1/2008 15.9 21.3 37.1 48.9 20.8 11.6
1/1/2009 26.0 39.5 21.9 15.8 14.4 20.3
2/1/2009 21.6 19.7 23.6 49.2 4.2 3.0
3/1/2009 21.4 26.4 47.8 5.4 28.3 26.0
4/1/2009 13.5 1.8 19.6 24.6 10.8 26.2
5/1/2009 36.6 28.1 22.4 43.8 47.2 31.0
6/1/2009 4.9 32.3 28.8 9.2 24.3 39.2
7/1/2009 18.0 14.8 7.8 38.8 7.2 28.0
8/1/2009 39.0 28.3 26.3 17.2 32.9 0.2
9/1/2009 33.7 19.1 44.9 37.1 3.8 36.7
10/1/2009 9.7 5.7 1.2 31.4 37.2 18.2
11/1/2009 15.4 15.3 2.9 26.6 18.4 4.5
12/1/2009 22.9 9.9 31.1 20.8 32.2 18.0
1/1/2010 36.7 47.7 31.6 33.2 46.7 12.7
2/1/2010 2.5 9.4 9.4 29.6 43.2 4.1
3/1/2010 43.2 46.1 2.1 30.6 1.0 22.6
4/1/2010 12.9 5.5 27.1 26.4 10.6 13.2
5/1/2010 39.2 39.0 22.7 35.3 43.0 33.6
6/1/2010 41.2 32.5 6.7 21.8 15.0 28.6
7/1/2010 43.5 12.0 45.9 41.5 49.7 29.8
8/1/2010 29.3 31.6 3.7 32.3 14.8 36.2
9/1/2010 2.7 32.4 22.9 8.2 29.0 27.0
10/1/2010 16.9 49.9 47.7 12.9 30.6 20.1
11/1/2010 2.8 27.8 49.7 36.2 20.2 49.9
12/1/2010 41.0 47.5 36.7 29.5 45.7 19.8
Kelly Mike Paul Total Hours Paid
$ 15.00 $ 12.00 $ 33.00
Write the formula in cells K3 and L3 which should gener
49.5 48.4 4.4 183.5 $ 2,871.25
same values as shown. These formulas should be
8.7 26.5 47.0
propagated down to te end of the table.
42.5 21.8 9.0
27.4 0.2 24.8 Please find the proper function (we never used it before
13.6 29.1 22.3 do do it in the very simple matter.
8.4 48.6 45.1
35.2 35.7 15.4
16.9 28.9 42.4
31.2 33.1 20.0
39.2 7.6 37.2
24.1 9.5 49.8
7.6 43.3 43.4
29.7 12.7 5.0
27.0 21.6 43.7
29.4 28.1 19.4
48.3 7.8 19.6
47.5 31.8 16.5
29.0 31.0 7.7
30.8 13.2 30.3
24.0 35.9 44.8
15.1 15.6 14.9
48.9 28.2 32.1
8.0 23.5 42.5
24.0 34.9 20.6
46.5 3.7 21.7
21.4 10.7 12.4
26.5 39.5 28.1
34.2 29.3 20.3
33.9 32.6 38.2
6.3 28.4 19.7
42.5 3.9 14.5
7.3 12.8 43.1
3.5 31.7 17.4
12.4 27.5 48.3
22.2 16.7 31.7
2.3 25.2 9.9
15.9 32.2 25.6
32.8 23.3 44.2
32.9 24.6 40.8
27.4 18.7 37.8
13.2 33.8 49.6
27.7 25.0 1.2
25.2 31.7 38.7
12.3 23.0 24.1
39.0 31.1 30.9
19.4 32.7 21.7
40.8 38.7 16.5
19.1 49.1 3.0
24.5 41.4 1.1
22.4 32.5 23.9
34.7 3.7 8.4
19.5 33.1 24.6
11.3 21.6 23.1
47.2 30.0 16.3
41.5 39.3 48.4
38.5 2.0 46.2
34.0 11.1 28.6
42.6 42.8 35.0
35.2 30.7 33.8
14.2 30.7 4.3
49.2 35.9 14.6
45.5 14.9 15.3
32.8 8.7 42.5
48.9 36.2 49.2
8.8 41.6 27.9
32.9 7.1 48.8
11.4 2.0 14.5
19.1 10.7 44.1
3.9 11.4 40.0
8.6 34.0 47.8
31.6 39.2 48.9
22.7 6.6 43.9
29.4 30.8 22.1
46.2 3.3 38.6
9.7 36.9 21.6
48.4 27.2 20.0
19.8 5.5 10.2
25.0 26.5 15.3
44.4 31.9 31.9
27.0 2.3 20.5
22.0 42.6 39.8
23.1 44.6 22.4
3.8 46.4 31.7
24.2 39.4 47.4
23.3 28.4 7.0
45.7 5.3 2.3
4.1 28.9 27.2
5.6 12.7 33.8
25.7 49.3 33.6
13.8 17.2 42.1
23.1 23.8 39.2
12.5 41.2 33.3
25.3 7.9 9.3
29.1 28.1 18.0
30.7 49.4 29.2
12.3 14.0 3.3
46.8 2.2 14.5
7.6 3.8 24.3
2.1 38.8 39.6
48.3 24.3 28.4
40.2 5.1 4.9
46.4 27.6 49.7
5.8 7.0 34.2
41.9 16.0 21.6
34.5 19.3 44.1
18.5 6.0 19.3
19.7 3.9 14.5
32.7 46.1 17.7
48.9 31.8 42.5
39.2 15.8 7.3
43.6 39.0 44.5
8.6 7.7 0.3
9.4 30.1 22.7
25.5 36.1 34.6
9.1 15.1 42.5
7.8 49.0 11.4
49.5 4.4 10.9
0.3 41.2 32.5
47.0 46.4 6.7
17.8 18.5 1.7
34.4 31.1 24.9
37.2 28.5 27.2
43.0 12.9 37.7
14.6 24.8 18.3
17.4 23.8 35.2
11.3 16.6 37.7
20.1 43.9 26.0
32.7 48.6 41.4
17.6 48.1 21.8
39.2 23.7 18.7
18.1 20.0 4.1
25.1 8.4 3.3
14.1 19.3 30.8
25.6 42.0 35.7
36.9 39.5 35.2
19.6 13.7 43.9
3.5 0.9 28.8
25.0 3.7 31.5
8.9 30.5 41.7
19.6 22.0 8.6
43.8 27.4 42.0
1.6 43.8 36.8
18.9 24.9 11.5
3.1 18.4 45.7
cells K3 and L3 which should generate
n. These formulas should be
te end of the table.
er function (we never used it before)
mple matter.
Anna Bob Sheril John Cathy Susan
1/1/1999 48.0 2.0 4.7 1.8 17.1 7.6
2/1/1999 26.8 14.5 26.9 40.4 17.0 33.8
3/1/1999 6.6 44.1 11.4 16.8 11.8 8.6
4/1/1999 46.3 1.1 37.0 14.0 19.9 38.5
5/1/1999 49.8 28.4 1.6 44.8 25.9 20.0
6/1/1999 25.7 44.1 10.3 11.8 21.7 26.6
7/1/1999 23.1 19.4 41.3 6.8 44.0 37.7
8/1/1999 5.3 40.7 31.4 27.3 14.5 40.4
9/1/1999 48.4 26.7 42.6 5.9 24.1 13.1
10/1/1999 21.3 46.6 39.3 45.5 27.5 34.8
11/1/1999 10.6 8.0 8.1 11.1 18.8 5.1
12/1/1999 9.1 20.6 10.0 36.2 43.7 10.7
1/1/2000 2.4 9.4 0.1 2.6 0.6 28.7
2/1/2000 33.2 10.5 26.0 27.2 9.0 32.6
3/1/2000 12.6 46.1 41.5 0.3 20.6 34.0
4/1/2000 44.8 26.6 25.0 31.2 2.2 47.1
5/1/2000 9.4 43.5 35.6 5.0 1.5 20.5
6/1/2000 12.4 17.0 14.8 32.9 43.2 7.9
7/1/2000 41.5 21.4 37.9 49.9 33.3 9.2
8/1/2000 5.6 43.9 3.0 32.3 33.8 50.0
9/1/2000 31.2 32.1 45.5 31.6 27.6 3.8
10/1/2000 6.5 38.0 43.8 29.5 34.8 5.1
11/1/2000 6.6 48.3 29.0 45.9 7.9 20.6
12/1/2000 1.0 48.2 18.2 0.7 26.9 16.5
1/1/2001 39.2 39.8 22.3 10.1 41.0 46.3
2/1/2001 24.2 34.6 25.0 1.1 7.2 29.4
3/1/2001 35.1 1.2 33.4 25.7 10.5 26.3
4/1/2001 18.4 23.5 11.1 3.5 41.7 16.1
5/1/2001 9.8 35.1 23.9 35.2 47.9 28.7
6/1/2001 44.6 9.9 47.2 35.6 12.0 14.0
7/1/2001 36.8 24.6 19.4 26.9 2.6 32.1
8/1/2001 29.0 18.5 24.4 34.7 34.2 0.0
9/1/2001 47.3 40.0 40.0 27.6 46.4 11.6
10/1/2001 41.1 12.4 20.3 8.3 15.9 6.8
11/1/2001 5.3 25.3 28.7 30.5 42.1 8.6
12/1/2001 49.6 42.5 0.4 18.6 36.9 22.5
1/1/2002 25.3 3.4 37.0 33.8 29.2 22.3
2/1/2002 49.0 41.2 31.1 19.7 27.4 39.6
3/1/2002 15.6 41.5 12.1 31.2 36.6 3.6
4/1/2002 34.2 20.7 20.3 39.3 47.4 15.8
5/1/2002 13.1 39.9 28.3 23.2 21.3 42.9
6/1/2002 42.4 23.0 0.6 0.7 47.1 32.5
7/1/2002 24.7 30.3 21.4 47.6 24.5 40.3
8/1/2002 25.0 4.7 3.9 27.6 40.7 48.1
9/1/2002 32.3 22.9 42.1 1.4 30.7 1.0
10/1/2002 34.2 30.9 9.7 5.6 35.8 34.3
11/1/2002 6.8 3.4 32.0 11.7 35.9 16.9
12/1/2002 8.1 10.5 0.1 18.7 44.9 27.0
1/1/2003 24.3 30.5 48.3 3.0 4.2 2.4
2/1/2003 32.2 28.3 43.6 37.5 20.7 4.1
3/1/2003 39.9 10.7 18.3 6.2 33.1 19.9
4/1/2003 5.5 46.9 26.1 5.1 4.3 43.1
5/1/2003 11.8 48.2 1.6 14.0 41.0 25.7
6/1/2003 46.2 23.0 45.3 35.9 6.1 8.0
7/1/2003 43.7 32.1 48.0 4.6 34.9 34.6
8/1/2003 43.9 4.9 25.2 10.0 14.7 16.3
9/1/2003 7.4 39.3 32.1 19.5 30.8 11.8
10/1/2003 24.3 46.6 37.8 0.4 5.7 21.4
11/1/2003 46.6 12.0 31.6 1.4 1.7 27.2
12/1/2003 25.1 3.9 3.1 36.2 7.2 29.7
1/1/2004 17.1 14.7 21.4 0.8 18.7 5.7
2/1/2004 8.9 39.9 27.0 11.7 1.6 17.1
3/1/2004 16.0 16.1 46.4 29.3 18.8 4.1
4/1/2004 46.2 24.9 33.8 39.9 29.9 1.0
5/1/2004 3.6 0.8 17.6 17.0 30.8 46.9
6/1/2004 24.2 20.0 20.2 46.3 26.4 36.1
7/1/2004 35.7 42.3 13.0 12.4 3.8 35.5
8/1/2004 12.3 18.2 49.3 45.3 22.0 3.9
9/1/2004 8.4 23.8 39.1 20.5 44.7 31.0
10/1/2004 32.4 44.2 19.2 43.3 11.4 9.4
11/1/2004 27.5 32.1 1.7 31.6 0.1 33.7
12/1/2004 28.6 24.1 21.6 19.8 44.4 44.5
1/1/2005 40.3 6.2 47.0 31.6 3.0 23.8
2/1/2005 48.5 0.7 44.5 7.4 3.1 39.4
3/1/2005 11.0 45.9 48.4 33.2 42.2 0.0
4/1/2005 22.1 38.6 36.5 34.5 4.2 32.0
5/1/2005 24.1 24.4 32.9 15.3 14.0 36.8
6/1/2005 31.3 21.0 33.6 18.8 12.2 34.0
7/1/2005 26.4 12.4 47.3 5.7 33.7 24.3
8/1/2005 40.7 26.2 44.8 18.8 39.2 25.7
9/1/2005 45.4 49.8 3.6 5.1 21.8 6.8
10/1/2005 44.4 17.0 3.2 28.2 35.8 41.1
11/1/2005 10.3 16.2 29.7 45.2 7.8 48.0
12/1/2005 21.5 45.9 26.0 47.0 1.4 15.2
1/1/2006 27.6 1.6 32.0 2.8 37.8 19.4
2/1/2006 32.4 43.1 36.1 12.5 7.1 38.1
3/1/2006 30.1 49.0 36.8 29.6 0.9 28.3
4/1/2006 28.2 44.2 14.4 20.8 4.0 5.7
5/1/2006 6.6 9.6 46.9 24.2 42.8 18.8
6/1/2006 22.3 11.2 9.3 1.5 16.3 12.5
7/1/2006 29.3 19.5 41.7 29.2 1.4 43.0
8/1/2006 8.6 28.8 41.1 3.6 7.9 42.4
9/1/2006 1.6 10.8 13.9 31.8 0.0 22.5
10/1/2006 1.1 16.6 43.1 34.0 29.6 9.7
11/1/2006 45.2 1.2 30.0 6.1 32.0 49.3
12/1/2006 44.2 16.2 4.1 29.5 3.0 24.7
1/1/2007 48.7 21.0 28.2 44.1 29.5 31.5
2/1/2007 30.2 40.9 27.1 35.3 23.7 28.2
3/1/2007 37.7 36.2 47.9 13.9 29.7 43.6
4/1/2007 42.8 8.4 34.0 42.5 20.4 7.5
5/1/2007 22.6 34.5 21.2 37.0 3.7 35.4
6/1/2007 43.4 25.2 8.7 21.5 11.3 14.9
7/1/2007 44.0 30.9 23.9 38.5 20.1 29.6
8/1/2007 29.4 36.9 30.6 10.9 32.1 34.0
9/1/2007 18.5 17.5 5.6 31.8 13.7 9.4
10/1/2007 12.5 23.5 31.2 43.4 49.8 19.6
11/1/2007 46.6 27.4 2.0 38.4 10.9 34.2
12/1/2007 2.7 44.7 24.4 43.1 3.0 21.2
1/1/2008 15.7 1.8 16.9 12.4 7.5 9.9
2/1/2008 41.7 37.2 42.1 10.9 33.3 40.5
3/1/2008 43.7 1.4 41.9 18.2 5.9 21.0
4/1/2008 29.6 34.5 23.0 20.1 8.4 0.4
5/1/2008 38.5 35.4 42.9 45.2 31.4 33.5
6/1/2008 41.2 2.9 4.6 22.0 32.4 4.1
7/1/2008 9.7 28.5 40.8 7.8 0.6 31.5
8/1/2008 7.5 11.3 22.5 15.8 12.2 20.1
9/1/2008 35.5 40.0 45.9 44.9 32.8 3.4
10/1/2008 44.4 20.7 2.5 0.9 13.0 33.4
11/1/2008 38.8 21.8 43.2 17.2 12.9 33.2
12/1/2008 15.9 21.3 37.1 48.9 20.8 11.6
1/1/2009 26.0 39.5 21.9 15.8 14.4 20.3
2/1/2009 21.6 19.7 23.6 49.2 4.2 3.0
3/1/2009 21.4 26.4 47.8 5.4 28.3 26.0
4/1/2009 13.5 1.8 19.6 24.6 10.8 26.2
5/1/2009 36.6 28.1 22.4 43.8 47.2 31.0
6/1/2009 4.9 32.3 28.8 9.2 24.3 39.2
7/1/2009 18.0 14.8 7.8 38.8 7.2 28.0
8/1/2009 39.0 28.3 26.3 17.2 32.9 0.2
9/1/2009 33.7 19.1 44.9 37.1 3.8 36.7
10/1/2009 9.7 5.7 1.2 31.4 37.2 18.2
11/1/2009 15.4 15.3 2.9 26.6 18.4 4.5
12/1/2009 22.9 9.9 31.1 20.8 32.2 18.0
1/1/2010 36.7 47.7 31.6 33.2 46.7 12.7
2/1/2010 2.5 9.4 9.4 29.6 43.2 4.1
3/1/2010 43.2 46.1 2.1 30.6 1.0 22.6
4/1/2010 12.9 5.5 27.1 26.4 10.6 13.2
5/1/2010 39.2 39.0 22.7 35.3 43.0 33.6
6/1/2010 41.2 32.5 6.7 21.8 15.0 28.6
7/1/2010 43.5 12.0 45.9 41.5 49.7 29.8
8/1/2010 29.3 31.6 3.7 32.3 14.8 36.2
9/1/2010 2.7 32.4 22.9 8.2 29.0 27.0
10/1/2010 16.9 49.9 47.7 12.9 30.6 20.1
11/1/2010 2.8 27.8 49.7 36.2 20.2 49.9
12/1/2010 41.0 47.5 36.7 29.5 45.7 19.8
Kelly Mike Paul Total Hours Paid
49.5 48.4 4.4 183.5 $ 2,871.25 Find the same solution as before, but now the wages
8.7 26.5 47.0 in another table.
42.5 21.8 9.0
27.4 0.2 24.8
13.6 29.1 22.3
8.4 48.6 45.1
35.2 35.7 15.4
16.9 28.9 42.4
31.2 33.1 20.0 Anna Bob
39.2 7.6 37.2 $/hr $ 18.00 $ 21.00
24.1 9.5 49.8
7.6 43.3 43.4 $/hr
29.7 12.7 5.0 Anna $ 18.00
27.0 21.6 43.7 Bob $ 21.00
29.4 28.1 19.4 Sheril $ 12.00
48.3 7.8 19.6 John $ 14.00
47.5 31.8 16.5 Cathy $ 16.50
29.0 31.0 7.7 Susan $ 17.50
30.8 13.2 30.3 Kelly $ 15.00
24.0 35.9 44.8 Mike $ 12.00
15.1 15.6 14.9 Paul $ 33.00
48.9 28.2 32.1
8.0 23.5 42.5
24.0 34.9 20.6
46.5 3.7 21.7
21.4 10.7 12.4
26.5 39.5 28.1
34.2 29.3 20.3
33.9 32.6 38.2
6.3 28.4 19.7
42.5 3.9 14.5
7.3 12.8 43.1
3.5 31.7 17.4
12.4 27.5 48.3
22.2 16.7 31.7
2.3 25.2 9.9
15.9 32.2 25.6
32.8 23.3 44.2
32.9 24.6 40.8
27.4 18.7 37.8
13.2 33.8 49.6
27.7 25.0 1.2
25.2 31.7 38.7
12.3 23.0 24.1
39.0 31.1 30.9
19.4 32.7 21.7
40.8 38.7 16.5
19.1 49.1 3.0
24.5 41.4 1.1
22.4 32.5 23.9
34.7 3.7 8.4
19.5 33.1 24.6
11.3 21.6 23.1
47.2 30.0 16.3
41.5 39.3 48.4
38.5 2.0 46.2
34.0 11.1 28.6
42.6 42.8 35.0
35.2 30.7 33.8
14.2 30.7 4.3
49.2 35.9 14.6
45.5 14.9 15.3
32.8 8.7 42.5
48.9 36.2 49.2
8.8 41.6 27.9
32.9 7.1 48.8
11.4 2.0 14.5
19.1 10.7 44.1
3.9 11.4 40.0
8.6 34.0 47.8
31.6 39.2 48.9
22.7 6.6 43.9
29.4 30.8 22.1
46.2 3.3 38.6
9.7 36.9 21.6
48.4 27.2 20.0
19.8 5.5 10.2
25.0 26.5 15.3
44.4 31.9 31.9
27.0 2.3 20.5
22.0 42.6 39.8
23.1 44.6 22.4
3.8 46.4 31.7
24.2 39.4 47.4
23.3 28.4 7.0
45.7 5.3 2.3
4.1 28.9 27.2
5.6 12.7 33.8
25.7 49.3 33.6
13.8 17.2 42.1
23.1 23.8 39.2
12.5 41.2 33.3
25.3 7.9 9.3
29.1 28.1 18.0
30.7 49.4 29.2
12.3 14.0 3.3
46.8 2.2 14.5
7.6 3.8 24.3
2.1 38.8 39.6
48.3 24.3 28.4
40.2 5.1 4.9
46.4 27.6 49.7
5.8 7.0 34.2
41.9 16.0 21.6
34.5 19.3 44.1
18.5 6.0 19.3
19.7 3.9 14.5
32.7 46.1 17.7
48.9 31.8 42.5
39.2 15.8 7.3
43.6 39.0 44.5
8.6 7.7 0.3
9.4 30.1 22.7
25.5 36.1 34.6
9.1 15.1 42.5
7.8 49.0 11.4
49.5 4.4 10.9
0.3 41.2 32.5
47.0 46.4 6.7
17.8 18.5 1.7
34.4 31.1 24.9
37.2 28.5 27.2
43.0 12.9 37.7
14.6 24.8 18.3
17.4 23.8 35.2
11.3 16.6 37.7
20.1 43.9 26.0
32.7 48.6 41.4
17.6 48.1 21.8
39.2 23.7 18.7
18.1 20.0 4.1
25.1 8.4 3.3
14.1 19.3 30.8
25.6 42.0 35.7
36.9 39.5 35.2
19.6 13.7 43.9
3.5 0.9 28.8
25.0 3.7 31.5
8.9 30.5 41.7
19.6 22.0 8.6
43.8 27.4 42.0
1.6 43.8 36.8
18.9 24.9 11.5
3.1 18.4 45.7
before, but now the wages are listed
Sheril John Cathy Susan Kelly Mike Paul
$ 12.00 $ 14.00 $ 16.50 $ 17.50 $ 15.00 $ 12.00 $ 33.00