Final project Excel -PERKY DOG SHELTER
MathStat Grades
FinalProjectExcelStartFile.xlsxAdopted Dogs
| Rabies cost/shot | ||||||||||||||||
| immunization cost/shot | Adoption Rates | |||||||||||||||
| food and body weight | Age (mos) | Amount | ||||||||||||||
| cost food/pound dog | ||||||||||||||||
| shot treat cost | ||||||||||||||||
| 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 | |||||||||
| Yoda | 162 | 13 | M | Columbus | TRUE | 3 | 28 | |||||||||
| Toby | 171 | 16 | M | Dublin | FALSE | 1 | 23 | |||||||||
| Fluffy | 10 | 4 | F | Columbus | TRUE | 1 | 21 | |||||||||
| Daisy | 5 | 2 | F | Worthington | TRUE | 2 | 11 | |||||||||
| Corky | 3 | 3 | F | Dublin | FALSE | 1 | 43 | |||||||||
| Scruffy | 14 | 5 | F | Worthington | FALSE | 2 | 45 | |||||||||
| Lady | 10 | 3 | F | Worthington | FALSE | 2 | 2 | |||||||||
| Bailey | 174 | 7 | F | Worthington | FALSE | 2 | 42 | |||||||||
| Marley | 3 | 2 | F | Columbus | FALSE | 1 | 26 | |||||||||
| Bear | 66 | 16 | M | Columbus | FALSE | 1 | 22 | |||||||||
| Bruno | 7 | 5 | M | Columbus | FALSE | 3 | 13 | |||||||||
| Alex | 42 | 17 | F | Columbus | FALSE | 3 | 47 | |||||||||
| Copper | 11 | 5 | M | Columbus | FALSE | 3 | 48 | |||||||||
| Lucky | 78 | 6 | F | Columbus | FALSE | 1 | 14 | |||||||||
| Alfie | 2 | 1 | F | Dublin | TRUE | 0 | 3 | |||||||||
| Rocky | 6 | 3 | M | Columbus | FALSE | 2 | 10 | |||||||||
| Allegra | 8 | 3 | M | Hilliard | FALSE | 0 | 30 | |||||||||
| Chance | 2 | 3 | M | Columbus | TRUE | 0 | 31 | |||||||||
| Milo | 88 | 8 | M | Hilliard | FALSE | 3 | 32 | |||||||||
| Alvin | 28 | 15 | M | Columbus | TRUE | 1 | 33 | |||||||||
| Amadaous | 6 | 3 | M | Hilliard | TRUE | 0 | 34 | |||||||||
| Amber | 12 | 5 | F | Columbus | TRUE | 0 | 35 | |||||||||
| Teddy | 8 | 5 | M | Columbus | TRUE | 2 | 36 | |||||||||
| Ameila | 173 | 11 | F | Columbus | TRUE | 0 | 37 | |||||||||
| Champ | 30 | 5 | M | Columbus | FALSE | 3 | 38 | |||||||||
| Amy | 11 | 3 | F | Columbus | TRUE | 3 | 39 | |||||||||
| Molly | 10 | 4 | F | Columbus | TRUE | 3 | 40 | |||||||||
| Prince | 2 | 1 | M | Gahanna | FALSE | 0 | 41 | |||||||||
| Bella | 66 | 6 | F | Columbus | TRUE | 3 | 25 | |||||||||
| Andy | 12 | 13 | M | Columbus | FALSE | 2 | 44 | |||||||||
| Angelica | 4 | 2 | F | Worthington | TRUE | 1 | 6 | |||||||||
| Lola | 112 | 12 | F | Columbus | FALSE | 3 | 7 | |||||||||
| Charlie | 41 | 15 | M | Columbus | TRUE | 2 | 9 | |||||||||
| Laddie | 4 | 3 | M | Dublin | TRUE | 1 | 48 | |||||||||
| Apollo | 1 | 1 | M | Columbus | TRUE | 0 | 17 | |||||||||
| Lanie | 4 | 3 | F | Columbus | FALSE | 0 | 5 | |||||||||
| Sport | 90 | 15 | M | Worthington | TRUE | 0 | 16 | |||||||||
| Jamie | 1 | 1 | M | Hilliard | FALSE | 0 | 18 | |||||||||
| Rio | 9 | 4 | M | Columbus | TRUE | 3 | 37 | |||||||||
| Beau | 10 | 4 | F | Hilliard | FALSE | 0 | 17 | |||||||||
| Coco | 1 | 2 | F | Worthington | FALSE | 0 | 19 | |||||||||
| Scout | 11 | 4 | M | Columbus | TRUE | 3 | 29 | |||||||||
| Sugar | 3 | 2 | F | Columbus | TRUE | 0 | 15 | |||||||||
| Ariel | 1 | 2 | F | Dublin | FALSE | 0 | 4 | |||||||||
| Zoey | 7 | 3 | M | Dublin | TRUE | 2 | 41 | |||||||||
| Rusty | 4 | 1 | M | Columbus | TRUE | 0 | 5 | |||||||||
| Snow | 8 | 4 | M | Columbus | FALSE | 3 | 12 | |||||||||
| Indy | 12 | 8 | F | Dublin | TRUE | 3 | 32 | |||||||||
| Shadow | 8 | 4 | M | Columbus | TRUE | 3 | 8 | |||||||||
| 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 | food | ||||||||||
| 12 | other | ||||||||||
| 5 | supplies | ||||||||||
| 4 | toy | ||||||||||
| 16 | |||||||||||
| 10 | |||||||||||
| 3 | |||||||||||
| 2 | |||||||||||
| 14 | |||||||||||
| 8 | |||||||||||
| 6 | |||||||||||
| 7 | |||||||||||
| 1 | |||||||||||
| 15 | |||||||||||
| 9 | |||||||||||
| 11 | |||||||||||
| 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 |
