cis

profileagsbwuq1
SalesSummary.xlsx
Home>Computer Science homework help>cis

Regional Sales

Nationwide Sales
Annual
Jan Feb Mar Quarter1 Apr May June Quarter2 July Aug Sept Quarter3 Oct Nov Dec Quarter4 Year
Eastern Sales
Baseball Bats 500 100 100 700 500 800 4,200 5,500 3,000 3,400 1,200 7,600 300 200 1,700 2,200 $16,000
Olympic Frisbees 1,000 1,000 2,000 4,000 2,000 2,000 2,000 6,000 2,000 2,000 2,000 6,000 2,000 2,000 2,000 6,000 $22,000
Golf Club Sets 500 200 1,200 1,900 5,000 3,800 2,300 11,100 4,500 3,900 2,800 11,200 2,600 800 2,400 5,800 $30,000
Athletic Wear 2,000 2,000 2,000 6,000 2,000 2,000 2,000 6,000 2,000 2,000 2,000 6,000 2,000 2,000 3,000 7,000 $25,000
Kayaks 200 100 200 500 600 1,000 2,800 4,400 1,800 3,200 1,200 6,200 300 200 400 900 $12,000
Tennis Racquets 1,000 1,500 1,500 4,000 1,500 1,500 1,500 4,500 1,500 1,500 1,500 4,500 1,500 1,500 2,000 5,000 $18,000
Camping Equipment 500 300 400 1,200 1,800 3,400 4,200 9,400 5,000 2,300 3,200 10,500 1,600 600 1,700 3,900 $25,000
Football Pads 500 100 200 800 800 1,800 1,100 3,700 1,400 8,000 4,300 13,700 2,900 3,200 3,700 9,800 $28,000
Boxing Gloves 800 800 800 2,400 800 800 800 2,400 800 800 800 2,400 800 800 1,200 2,800 $10,000
Eastern Total $7,000 $6,100 $8,400 $21,500 $15,000 $17,100 $20,900 $53,000 $22,000 $27,100 $19,000 $68,100 $14,000 $11,300 $18,100 $43,400 $186,000
Western Sales
Baseball Bats 400 750 300 1,450 750 750 350 1,850 2,500 3,300 1,500 7,300 400 350 750 1,500 $12,100
Olympic Frisbees 750 900 1,500 3,150 800 1,750 1,800 4,350 1,800 2,100 2,100 6,000 2,100 1,500 2,000 5,600 $19,100
Golf Club Sets 500 750 1,100 2,350 4,000 3,500 2,000 9,500 3,500 3,750 2,500 9,750 3,000 1,000 2,100 6,100 $27,700
Athletic Wear 1,700 1,500 1,500 4,700 1,600 1,800 2,100 5,500 1,800 2,100 1,500 5,400 2,100 2,100 2,500 6,700 $22,300
Kayaks 670 400 400 1,470 750 1,500 3,000 5,250 1,800 3,500 1,500 6,800 400 500 600 1,500 $15,020
Tennis Racquets 1,000 500 750 2,250 1,300 1,750 1,500 4,550 1,500 2,000 1,800 5,300 1,750 1,750 2,000 5,500 $17,600
Camping Equipment 400 750 600 1,750 1,500 3,500 4,000 9,000 4,500 2,100 3,000 9,600 1,500 800 1,400 3,700 $24,050
Football Pads 650 650 500 1,800 900 2,000 1,100 4,000 1,750 7,500 2,000 11,250 2,800 2,750 2,900 8,450 $25,500
Boxing Gloves 800 750 750 2,300 900 750 750 2,400 900 900 800 2,600 1,200 1,300 3,000 5,500 $12,800
Western Total $6,870 $6,950 $7,400 $21,220 $12,500 $17,300 $16,600 $46,400 $20,050 $27,250 $16,700 $64,000 $15,250 $12,050 $17,250 $44,550 $176,170
National Total $13,870 $13,050 $15,800 $42,720 $27,500 $34,400 $37,500 $99,400 $42,050 $54,350 $35,700 $132,100 $29,250 $23,350 $35,350 $87,950 $362,170

National Sales

Nationwide Sales
Annual
Q1 Q2 Q3 Q4 Q$-Q3 Year
Baseball Bats 2,150 7,350 14,900 3,700 (11,200)
Olympic Frisbees 7,150 10,350 12,000 11,600 (400)
Golf Club Sets 4,250 20,600 20,950 11,900 (9,050)
Athletic Wear 10,700 11,500 11,400 13,700 2,300
Kayaks 1,970 9,650 13,000 2,400 (10,600)
Tennis Racquets 6,250 9,050 9,800 10,500 700
Camping Equipment 2,950 18,400 20,100 7,600 (12,500)
Football Pads 2,600 7,700 24,950 18,250 (6,700)
Boxing Gloves 4,700 4,800 5,000 8,300 3,300
Sales Details

Proper Case

Org Chart

Personnel

NATIONWIDE SALES
P e r s o n n e l R e c o r d s
Employee Gender DOB Div Hire Date PT/FT Salary PT/FT Counts
Farrell, Dudley M 2/4/88 2 4/27/08 FT 23000 FT
Finch, Robert M 8/6/86 2 1/28/97 FT 82500 PT
Kennedy, Philip M 11/6/86 3 3/28/99 FT 52225 No Data
Keith, Mildred F 4/30/74 1 8/28/10 PT 45700
King, John M 12/31/82 1 1/16/04 73000
Meehan, Eugenia F 3/21/75 1 3/28/05 FT 8200
McHugh, Georgia F 6/21/65 1 7/4/12 FT 12000
Stoddard, James M 2/12/75 3 9/10/09 FT 19500
Stein, Henry M 11/8/56 2 6/4/97 FT 29300
Glass, Cynthia F 10/21/57 3 4/20/08 FT 46100
Dickie, David M 8/12/86 1 9/24/10 PT 27600
Dodd, Doris F 11/28/61 3 10/30/11 FT 32000
Black, Edward M 9/9/80 2 6/28/04 FT 68500
Newt, Jody F 11/6/70 3 4/14/01 FT 13200
Blessing, Margaret F 11/7/78 1 9/18/99 PT 22100
Cartwright, Bob M 10/29/60 3 8/4/13 6700
Tucker, Barbara F 10/18/96 1 3/2/06 FT 84900
Nelson, Charles M 11/17/68 2 7/8/10 FT 98300
Murphy, Nichole F 6/17/58 1 7/3/11 FT 66400
Reid, Duncan M 12/14/84 2 2/28/13 FT 8500
Raymond, Frank M 1/16/70 3 3/1/13 FT 22400
Vinci, Thomas M 10/24/65 3 9/5/03 PT 53800
Thompson, Frederic M 3/1/66 2 9/17/06 PT 3500
Verdon, John M 5/7/58 2 11/25/00 FT 68400
Weber, Ernest M 1/7/72 2 2/14/10 FT 83225
Rice, John M 10/4/56 2 8/18/00 PT 25000
Scherb, Michele F 8/15/97 3 4/14/10 PT 18300
Waters, Kevin M 1/5/65 3 11/18/09 4200
Ripps, Judith F 7/29/58 2 5/7/07 PT 63400
Wagner, George M 12/2/74 3 9/21/06 PT 58700
O'Leary, Shawn M 10/14/65 1 1/29/07 FT 19350
Paige, Carol F 12/15/61 1 7/23/05 FT 11700
Mann, George M 3/9/91 3 4/14/05 FT 47600
Major, John M 3/17/61 2 2/23/06 FT 29990
Winn, Paul M 9/27/82 1 12/10/03 PT 62350
Kress, Walter M 1/14/92 2 12/15/02 FT 73210
Albert, Joel M 4/21/65 3 12/12/05 PT 61000
Berry, Alan M 8/4/65 3 12/6/09 FT 67200
Bliss, Karin F 11/20/85 3 11/7/09 PT 27100
Chisholm, Malcolm M 9/19/84 2 6/23/05 PT 10350
Dalton, William M 6/14/96 2 4/1/03 FT 54300
Dailey, Larry M 3/25/85 2 3/8/10 FT 79125
Prescott, Peggy F 2/25/86 3 11/14/12 FT 12300
Cruz, Elinor F 2/3/85 1 6/22/13 FT 9400
Kupferberg, Eli M 11/28/92 1 2/23/10 FT 32500
Erdmoor, Sally F 3/19/80 1 12/19/06 FT 74900
Eisenberg, Sun-Wong F 5/12/60 2 1/9/01 PT 94500
Grief, Frank M 11/8/81 1 1/17/07 FT 13200
McLantern, Simon M 6/22/88 3 2/25/10 8700
Jordan, Robert M 6/12/89 2 12/7/06 FT 8700
Newt, Jody F 11/6/70 3 4/14/01 FT 13200
Shaughnessy, Pierre M 11/6/83 2 9/1/04 PT 37500
Ripps, Judith F 7/29/58 2 5/7/07 PT 63400
Smith, Alphonso M 7/8/82 1 2/17/10 17000
Rinko, Carlo M 2/9/85 1 12/1/01 PT 11900
Ringrose, Millicent F 8/18/77 1 9/28/10 FT 9900
Zandonetta, Bjorn M 8/31/70 3 8/23/03 FT 26350
Zebrowski, Stanley M 4/28/90 2 9/28/11 FT 43700
Zazula, Carmen F 5/26/81 3 12/16/03 PT 7800
Finley, Maude
Hap Gaylord: User: EEO complaint filed		 F 1/12/87 1 6/21/00 PT 56500
Finver, Beau M 9/25/58 2 11/5/09 58500
Composto, Marty M 3/17/70 3 11/7/10 PT 17900
Boyenga, Gladys F 11/18/85 1 2/15/10 FT 23450
Hijuskos, Bob M 7/17/93 2 5/15/04 FT 19500
Harrison, Wilbert M 5/12/83 1 2/13/10 FT 49250
Mikulewicz, Hugo M 12/14/72 3 1/29/07 FT 11200
Pinella, Prucilla
Hap Gaylord: User: Has requested full time.		 F 2/14/69 2 1/14/04 PT 72100
Antonio, Erin F 8/20/82 1 12/29/00 FT 6900
Bartholemew, Phyllis F 4/9/75 1 11/12/12 PT 54375
Delubert, Gertie F 12/15/96 3 5/31/07 FT 7500
Winkowsin, Ruth F 7/22/85 1 8/20/04 PT 17250