Excel 3
Sheial 234
EX2016-FixIt-3-6-solution.pdf
Guest List
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
A B C D E F G H I J
Guest List
82 cost per invitation $0.97 58 postage cost $0.56
4 6 $125.46
1.52
Title First Name Last Name Name Tag Street City State Zip Phone NumAttending Mr. Cindy Jacobs CINDY JACOBS 417 9th St. Rocklin CA 95602 916-598-6952 1 Mrs Larrina Grande LARRINA GRANDE 87441 Palace Square Newcastle CA 95602 916-741-8526 4 Miss Katherine Hairless KATHERINE HAIRLESS 2068 Harry Hill Auburn CA 95602 530-888-0805 1 Mr James Muchley JAMES MUCHLEY 87543 Baldys Road Auburn CA 95602 530-885-6523 1 Mr./Mrs William Holland WILLIAM HOLLAND 9225 Marchmont Dr Saramento CA 95602 (916)348-9982 2 Mr/Mrs Bethany Sanchaz BETHANY SANCHAZ 8852 Jones Lane Santa Rosa CA 95602 (707)521-3478 3 Mrs Gerald Watkins GERALD WATKINS 446 Chest Ave San Jose CA 95602 (415)441-8639 2 Mr Emily Thatcher EMILY THATCHER 2275 Oak Park Lane Rocklin CA 95602 (916)315-8690 1 Mr/Mrs Louisa Cater LOUISA CATER 852 Paly Place Roseville CA 95602 (916)789-4470 2 Mr. Harold Roger HAROLD ROGER 14 Header Dr Rocklin CA 95602 555-1324 Mr. Michael Slocum MICHAEL SLOCUM 543 Tulip Ave Rocklin CA 95602 555-2453 0 Mr. Adam Melon ADAM MELON 387 Daly St Rocklin CA 95602 555-2606 0 Mr. Claire Ace CLAIRE ACE 9083 Rocky Rd Rocklin CA 95602 555-2690 Mr. Jackson Perry JACKSON PERRY 883 Forest Drive Rocklin CA 95602 555-9902 1 Mr. James Smith JAMES SMITH 5366 Onyx Drive Rocklin CA 95602 (916)521-6654 1 Mrs. Jim Smith JIM SMITH 5366 Onyx Drive Rocklin CA 95602 (916)632-5152 0 Ms. Tom Jackson TOM JACKSON 2323 Windyl Drive Rocklin CA 95602 (916)632-0127 0 Mr. Chuck Newman CHUCK NEWMAN 4477 Jade Road Roseville CA 95602 (916)624-5656 1 Miss. Barbra Williams BARBRA WILLIAMS 1453 Frosty St. San Diego CA 95602 (619)279-9486 0 Mr. Walter Pell WALTER PELL 890 1st Ave. San Diego CA 95602 (619)560-2356 1 Mrs. Jerry Jones JERRY JONES 5678 Oak Ave. Auburn CA 95602 (530)823-4983 4 Mr. Christopher Jones CHRISTOPHER JONES 5678 Oak Ave. Auburn CA 95602 (530)823-4983 0 Miss. Keith Lee KEITH LEE 7823 Seacrest Weimar CA 95602 (530)637-9901 1 Mr. Byung Nagato BYUNG NAGATO 23 Shadow Ln Dark City CA 95602 458-6288 1 Mr. Sharon Nagasaki SHARON NAGASAKI 410 Lemoen Dr Watershed CA 95602 626-8324 1 Ms. David Lonsdale DAVID LONSDALE 725 Wave st. La Beach CA 95602 364-6274 5 Mr. Karen Negreedy KAREN NEGREEDY 858 Steal Way Dark City CA 95602 458-5826 2 Ms. Larry Chama LARRY CHAMA 443 Harty Ave. Watershed CA 95602 626-5461 2 Mr Brenda Smith BRENDA SMITH 564 Newby Street Rack CA 95602 906-452-5581 2 Ms Matt Castle MATT CASTLE 48265 Long St Dewy CA 95602 554-967-4518 2 Mrs Techi Willows TECHI WILLOWS 852 Spree St Bark CA 95602 613-555-4321 6 Mr Marie Bond MARIE BOND 1007 Pagent St Steams CA 95602 541-948-4849 1 Mr Juan Scott JUAN SCOTT 8584 Sure Ln Nowhere CA 95602 987-654-3210 1 Miss Kim Johnson KIM JOHNSON 5687 Art Way Rocklin CA 95602 916-789-5285 1
Average number of guests in each group
Total cost for
purchasing and mailing
Total number of guests attending Count of invitations sent Count of missing responses Largest group attending
Page 1
SOLUTION SAMPLE
Guest List
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
A B C D E F G H I J
Mr Charles Nosmiles CHARLES NOSMILES 4412 Meanie Street Loomis CA 95602 916-883-2546 1 Mrs Larrina Grande LARRINA GRANDE 87441 Palada Circle Newcastle CA 95602 916-741-8526 4 Miss Katherine Hairless KATHERINE HAIRLESS 2068 Bald Hill Auburn CA 95602 530-888-0805 1 Mr James Muchley JAMES MUCHLEY 87543 Harry's Road Auburn CA 95602 530-885-6523 1 Mr./Mrs William Holland WILLIAM HOLLAND 9225 Larchmont Dr Saramento CA 95602 (916)348-9982 2 Mr/Mrs Bethany Sanchaz BETHANY SANCHAZ 8852 Smith Lane Santa Rosa CA 95602 (707)521-3478 3 Mrs Gerald Watkins GERALD WATKINS 446 Chester Ave San Jose CA 95602 (415)441-8639 2 Mr Emily Thatcher EMILY THATCHER 2275 Oak Tree Lane Rocklin CA 95602 (916)315-8690 1 Mr/Mrs Louisa Cater LOUISA CATER 852 Park Place Roseville CA 95602 (916)789-4470 2 Mr. Harold Roger HAROLD ROGER 14 Body Dr Rocklin CA 95602 555-1324 0 Mr. Michael Slocum MICHAEL SLOCUM 543 Lily Av Rocklin CA 95602 555-2453 Mr. Adam Melon ADAM MELON 387 Day St Rocklin CA 95602 555-2606 0 Mr. Claire Ace CLAIRE ACE 9083 Rock Rd Rocklin CA 95602 555-2690 0 Mr. Jackson Perry JACKSON PERRY 883 Forest Ln Rocklin CA 95602 555-9902 1 Mr. James Smith JAMES SMITH 5366 Onyx Drive Rocklin CA 95602 (916)521-6654 1 Mrs. Jim Smith JIM SMITH 5366 Onyx Drive Rocklin CA 95602 (916)632-5152 0 Ms. Tom Jackson TOM JACKSON 2323 Windfall Drive Rocklin CA 95602 (916)632-0127 0 Mr. Chuck Newman CHUCK NEWMAN 4477 Emerald Road Roseville CA 95602 (916)624-5656 1 Mrs. Steve Nicks STEVE NICKS 2897 Tyler Street Lincoln CA 95602 (916)521-4646 4 Mr. Bill Wilson BILL WILSON 1925 Park Ln. Colfax CA 95602 530-346-8953 2 Mrs. Robert Nettle ROBERT NETTLE 45 High St. Auburn CA 95602 530-889-7632 2 Mrs. Debbie Frost DEBBIE FROST 25572 Sierra Way Weimar CA 95602 530-637-8521 3 Mr. Linzy O'Neil LINZY O'NEIL 6312 Westridge Ave. Alta CA 95602 530-346-9975 Mr. Josh Hawkins JOSH HAWKINS 7438 Atlantic Dr. Auburn CA 95602 530-878-7369 1
Page 2
SOLUTION SAMPLE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Shopping List number of different items 15 $246
$1,500 $40
$3,915.96
City Source Item Description Quantity Units CostperUnit Cost Tax Total Cost
6%
Roseville Super Supermarket Appetizers 12 pounds $10.00 $120 $7.20 $127.20
Folsom Sharons Bakery Cake 1 Each $350.00 $350 $21.00 $371.00
Citrus Heights The Party Store
Dessert Forks,
Cofee spoons 100 each $0.50 $50 $3.00 $53.00
Citrus Heights The Party Store Dessert Plates 100 each $1.00 $100 $6.00 $106.00
Citrus Heights The Party Store Dinner Plates 100 each $1.25 $125 $7.50 $132.50
Citrus Heights The Party Store Dinner Silverware 100 sets $1.00 $100 $6.00 $106.00
Folsom Flower Power FloristFlower 20 each $40.00 $800 $48.00 $848.00
Roseville Party Rentals
Glass Coffee Cups
and Saucers 50 each $2.00 $100 $6.00 $106.00
Citrus Heights The Party Store Glasses 100 each $1.50 $150 $9.00 $159.00
Carmichael Engravers Invitations 70 each $0.89 $62 $3.74 $66.04
Sacramento The Entertainers Music 1 each $1,500.00 $1,500 $90.00 $1,590.00
Citrus Heights The Party Store Napkins 100 each $0.50 $50 $3.00 $53.00
Citrus Heights The Party Store Salad Plates 100 each $0.75 $75 $4.50 $79.50
Folsom Costco - Folsom Soft Drinks and 8 case $9.00 $72 $4.32 $76.32
Citrus Heights The Party Store Table Cloths 10 each $4.00 $40 $2.40 $42.40
Average item cost Highest Item Cost Lowest Item Cost Total Cost with Tax
SOLUTION SAMPLE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H
look up table
1st column 2nd column 3rd column
CompanyName Street City State Zip ContactFN ContactLN Cell Phone
BevMO 2000 Price Dr. Sacramento CA 95643 Brenda Green 888-8888
Costco - Folsom
345 Stanford Ranch
Road Folsom CA 95612 Juan Whitenhouse 666-7878
Cravens 456 Bishop Street Folsom CA 95613 Manuel Enriquez 667-7879
CreativeBallons 454 Vernon Street
Citrus
Heights CA 99509 Karen Bonnet 677-7654
Engravers 600 Arden Way Carmichael CA 95605 David Newsom 878-9089
Flower Power Florist 3456 Tulip Drive Folsom CA 95613 Shane David 666-7911
John's Dishes 9857 First Street Folsom CA 95614 Bob Adzich 666-7122
Party Rentals 455 Douglas Bld. Roseville CA 95643 Techi Smith 765-0987
Sharons Bakery 700 Leidersdorf Folsom CA 95612 Sharon Coon 555-6666
Super Supermarket 1345 Sierra Blvd. Roseville CA 95643 Marie Jorgenson 676-8765
The Entertainers 1600 Broadway Sacramento CA 95643 Larry Shane 786-8998
The Flower Shop 12Marh Lane Sacramento CA 95644 Sue Marshal 786-8449
The Party Store 333 Galilee Drive
Citrus
Heights CA 99509 Matt Canoli 555-8989
Total Wines 652 Sutter Street Folsom CA 95612 Byung Jacobs 777-7777
SOLUTION SAMPLE
1
2
3
4
5
6
7
8
9
10
11
12
A B
Party Financing As of 5/10/2017
# of Invitations 58
# of Guests 82
Cash Available for Event $2,000.00
Do We Need to Borrow? yes
Amount to Borrow $2,041.42
APR 7.5%
# Months to Pay 12
Monthly Payment Amount $177.11SOLUTION SAMPLE
