Perky Pup Dog Shelter

profiledorritos_p
FinalProjectExcelStartFile.xlsx
Home>Business & Finance homework help>Accounting homework help>Perky Pup Dog Shelter

Adopted Dogs

Rabies cost/shot
immunization cost/shot Adoption Rates
food and body weight Age (mos) Amount
cost food/pound dog 5 $ 200.00
shot treat cost 11 $ 160.00
12 $ 65.00
Adopted Dogs Expense Calculations Revenue
Name Age (in months) Weight (in pounds) Sex City Rabies shot? Number of Immunizations CustomerID Rabies shot cost Immunization costs Total cost shots Food cost Treat cost Total costs Adoption Cost Profit
Ace 42 6 M Columbus TRUE 1 24 25 18 43 $ 40.25 2 $ 85.25
Yoda 162 13 M Columbus TRUE 3 28 25 54 79 $ 148.26 6 $ 233.26
Toby 171 16 M Dublin FALSE 1 23 0 18 18 $ 158.07 2 $ 178.07
Fluffy 10 4 F Columbus TRUE 1 21 25 18 43 $ 11.35 2 $ 56.35
Daisy 5 2 F Worthington TRUE 2 11 25 36 61 $ 5.68 4 $ 70.68
Corky 3 3 F Dublin FALSE 1 43 0 18 18 $ 4.64 2 $ 24.64
Scruffy 14 5 F Worthington FALSE 2 45 0 36 36 $ 15.48 4 $ 55.48
Lady 10 3 F Worthington FALSE 2 2 0 36 36 $ 10.66 4 $ 50.66
Bailey 174 7 F Worthington FALSE 2 42 0 36 36 $ 154.46 4 $ 194.46
Marley 3 2 F Columbus FALSE 1 26 0 18 18 $ 3.96 2 $ 23.96
Bear 66 16 M Columbus FALSE 1 22 0 18 18 $ 67.77 2 $ 87.77
Bruno 7 5 M Columbus FALSE 3 13 0 54 54 $ 9.46 6 $ 69.46
Alex 42 17 F Columbus FALSE 3 47 0 54 54 $ 47.82 6 $ 107.82
Copper 11 5 M Columbus FALSE 3 48 0 54 54 $ 12.90 6 $ 72.90
Lucky 78 6 F Columbus FALSE 1 14 0 18 18 $ 71.21 2 $ 91.21
Alfie 2 1 F Dublin TRUE 0 3 25 0 25 $ 2.41 0 $ 27.41
Rocky 6 3 M Columbus FALSE 2 10 0 36 36 $ 7.22 4 $ 47.22
Allegra 8 3 M Hilliard FALSE 0 30 0 0 0 $ 8.94 0 $ 8.94
Chance 2 3 M Columbus TRUE 0 31 25 0 25 $ 3.78 0 $ 28.78
Milo 88 8 M Hilliard FALSE 3 32 0 54 54 $ 81.18 6 $ 141.18
Alvin 28 15 M Columbus TRUE 1 33 25 18 43 $ 34.40 2 ERROR:#NAME?
Amadaous 6 3 M Hilliard TRUE 0 34 25 0 25 $ 7.22 0 $ 32.22
Amber 12 5 F Columbus TRUE 0 35 25 0 25 $ 13.76 0 $ 38.76
Teddy 8 5 M Columbus TRUE 2 36 25 36 61 $ 10.32 4 $ 75.32
Ameila 173 11 F Columbus TRUE 0 37 25 0 25 $ 156.35 0 $ 181.35
Champ 30 5 M Columbus FALSE 3 38 0 54 54 $ 29.24 6 $ 89.24
Amy 11 3 F Columbus TRUE 3 39 25 54 79 $ 11.52 6 $ 96.52
Molly 10 4 F Columbus TRUE 3 40 25 54 79 $ 11.35 6 $ 96.35
Prince 2 1 M Gahanna FALSE 0 41 0 0 0 $ 2.41 0 $ 2.41
Bella 66 6 F Columbus TRUE 3 25 25 54 79 $ 60.89 6 $ 145.89
Andy 12 13 M Columbus FALSE 2 44 0 36 36 $ 19.26 4 $ 59.26
Angelica 4 2 F Worthington TRUE 1 6 25 18 43 $ 4.82 2 $ 49.82
Lola 112 12 F Columbus FALSE 3 7 0 54 54 $ 104.58 6 $ 164.58
Charlie 41 15 M Columbus TRUE 2 9 25 36 61 $ 45.58 4 $ 110.58
Laddie 4 3 M Dublin TRUE 1 48 25 18 43 $ 5.50 2 $ 50.50
Apollo 1 1 M Columbus TRUE 0 17 25 0 25 $ 1.55 0 $ 26.55
Lanie 4 3 F Columbus FALSE 0 5 0 0 0 $ 5.50 0 $ 5.50
Sport 90 15 M Worthington TRUE 0 16 25 0 25 $ 87.72 0 $ 112.72
Jamie 1 1 M Hilliard FALSE 0 18 0 0 0 $ 1.55 0 $ 1.55
Rio 9 4 M Columbus TRUE 3 37 25 54 79 $ 10.49 6 $ 95.49
Beau 10 4 F Hilliard FALSE 0 17 0 0 0 $ 11.35 0 $ 11.35
Coco 1 2 F Worthington FALSE 0 19 0 0 0 $ 2.24 0 $ 2.24
Scout 11 4 M Columbus TRUE 3 29 25 54 79 $ 12.21 6 $ 97.21
Sugar 3 2 F Columbus TRUE 0 15 25 0 25 $ 3.96 0 $ 28.96
Ariel 1 2 F Dublin FALSE 0 4 0 0 0 $ 2.24 0 $ 2.24
Zoey 7 3 M Dublin TRUE 2 41 25 36 61 $ 8.08 4 $ 73.08
Rusty 4 1 M Columbus TRUE 0 5 25 0 25 $ 4.13 0 $ 29.13
Snow 8 4 M Columbus FALSE 3 12 0 54 54 $ 9.63 6 $ 69.63
Indy 12 8 F Dublin TRUE 3 32 25 54 79 $ 15.82 6 $ 100.82
Shadow 8 4 M Columbus TRUE 3 8 25 54 79 $ 9.63 6 $ 94.63
Number of dogs needing Rabies shots TOTAL monthly
City Average Profit yearly
Columbus
Dublin
Gahanna
Hilliard
Worthington
TOTALS

Sales

mark up for items
ItemID Description Category Cost Number Sold Selling price Revenue Expenses (Cost) Profit Category Total Profit
13 10 lb premium bag dog food Food 14.77 food
12 7 lb bag dog food Food 7.82 other
5 Carrying case large Other 50 supplies
4 Carrying case small Other 35 toy
16 Greenie chews Supplies 4.29
10 Kong toy Toy 8.5
3 Large collar Other 12.99
2 Medium collar Other 10.99
14 Milkbones Supplies 3.75
8 Name tag Other 3.5
6 Nylon leash Other 7.99
7 Retractable leash Other 14.99
1 Small collar Other 8.99
15 Snausage treats Supplies 2.99
9 Squeaky toy Toy 1.5
11 Tug toy Toy 4.5
TOTAL monthly
yearly

Items

Item ID Description Category Cost
1 Small collar Other 8.99
2 Medium collar Other 10.99
3 Large collar Other 12.99
4 Carrying case small Other 35.00
5 Carrying case large Other 50.00
6 Nylon leash Other 7.99
7 Retractable leash Other 14.99
8 Name tag Other 3.50
9 Squeaky toy Toy 1.50
10 Kong toy Toy 8.50
11 Tug toy Toy 4.50
12 7 lb bag dog food Food 7.82
13 10 lb premium bag dog food Food 14.77
14 Milkbones Supplies 3.75
15 Snausage treats Supplies 2.99
16 Greenie chews Supplies 4.29

Individual Sales

Sale ID Item ID
1588 14
1589 13
1590 1
1591 15
1592 2
1593 4
1594 5
1595 11
1596 9
1597 10
1598 6
1599 4
1600 7
1601 4
1602 8
1603 13
1604 10
1605 3
1606 13
1607 4
1608 10
1609 16
1610 7
1611 6
1612 5
1613 5
1614 12
1615 13
1616 14
1617 8
1618 14
1619 15
1620 12
1621 6
1622 9
1623 13
1624 1
1625 2
1626 4
1627 14
1628 9
1629 12
1630 13
1631 9
1632 5
1633 13
1634 3
1635 13
1636 2
1637 13
1638 12
1639 4
1640 12
1641 13
1642 3
1643 12
1644 13
1645 7
1646 2
1647 6
1648 1
1649 4
1650 7
1651 11
1652 10
1653 6
1654 9
1655 4
1656 14
1657 12
1658 15
1659 16
1660 2
1661 6
1662 10
1663 13
1664 3
1665 7
1666 2
1667 12
1668 13
1669 12
1670 10
1671 9
1672 13
1673 12
1674 10
1675 11
1676 5
1677 13
1678 12
1679 7
1680 11
1681 2
1682 11
1683 4
1684 10
1685 2
1686 9

Customers

CustomerID LName FName Address City State Zip
1 Saxton Michael 4110 Old Redmond Rd. Worthington OH 43201
2 Lebihan Laurence 342 S. Drexel Hilliard OH 43209
3 Sommer Martín 5400 E. Broad St. Worthington OH 43213
4 Berglund Christina 707 Oxford Rd. Columbus OH 43222
5 Trujillo Ana 7 Houndstooth Rd. Hilliard OH 42001
6 Moos Hanna 29 King's Way Hilliard OH 43287
7 Citeaux Franco 3400 8th Avenue Suite 210 Columbus OH 43210
8 Callahan Laura Coventry House Miner Rd. Dublin OH 43255
9 Moreno Antonio 49 Gilbert St. Dublin OH 40032
10 Fuller Andrew 2345 Dublin-Granville Rd. Dublin OH 43213
11 Dodsworth Anne Edgeham Hollow Hilliard OH 43255
12 Leverling Janet 507 - 20th Ave. E.Apt. 2A Columbus OH 43221
13 Hardy Thomas 74 Rose St. Gahanna OH 43277
14 Anders Maria 4726 - 11th Ave. N.E. Columbus OH 43214
15 Peacock Margaret 908 W. Capital Way Columbus OH 43228
16 King Robert 14 Garrett Hill Worthington OH 43226
17 Davolio Nancy 865 N. Cassingham Columus OH 43209
18 Buchanan Steven 722 Moss Bay Blvd. Westerville OH 43277
19 Bentley Johnny 184 N. West St. Columbus OH 43210
20 Taylor Madeline 664 Main St. Westervile OH 43221
21 Montebon Andrew 12 Apollo Ave. Dublin OH 43235
22 Collins Bruce 779 Gemini Dr. Hilliard OH 43227
23 Schwartz Kathy 7382 Park Ln. Columbus OH 43215
24 Smith Michael 222 East 7th St. Hilliard OH 43209
25 Walters John 55 Elm Street Columbus OH 43213
26 Jones Jennifer 18 Main Street Dublin OH 43218
27 Still Elvira 34 S. Onza Ave Hilliard OH 43209
28 Chamberlin Mary 9423 S. Forest Ave. Westervile OH 43221
29 Pierce Erin 832 S. William Ave. Hilliard OH 43227
30 Lopez Kristina 4344 W. Gala Ln. Hilliard OH 43209
31 Bond Diana 2348 S. Bala Dr. Dublin OH 43218
32 Andrews Jenny 432 Tercera Dr. Westerville OH 43277
33 Scott Eli 858 E. Aire Ct. Worthington OH 43226
34 Johnson Martha 43 Kings Rd. Columbus OH 43214
35 Nixon Connor 947 S. Forest Columbus OH 43221
36 Edwards Margot 4290 E. Alameda Dr. Dublin OH 43213
37 Einstien Cecilia 2343 W. Audrey Ln. Dublin OH 43255
38 Mennissa Oscar 90 E. Royal Dr. Hilliard OH 43287
39 Clinton Margot 75 Brooklea Dr. Columbus OH 43222
40 Belvadere Edith 235 N. Cactus Dr. Worthington OH 43213
41 Carter Monte 23 Mill Ave. Hilliard OH 42001
42 Long Jannelle 45 Burr Rd. Columbus OH 43210
43 Bishop Colleen 564 S. Lemon Dr. Dublin OH 40032
44 Wormer Emily 94 Evergreen Ave. Hilliard OH 43255
45 Farr Lenny 32 W. Orange St. Gahanna OH 43277
46 Roosevelt Courtney 23 Suffolk Ln. Columbus OH 43228
47 Lopez Amber 5832 Fremont St. Columus OH 43209
48 Raines Joe 433 S. Gaucho Dr. Dublin OH 43235

Financial

Options Present Value Future Value Annual Interest Rate # Compounding periods Type Years Payment RESULT (TRUE or FALSE) Explanation
1
2