Business Intelligence & Analytics
ghada_3
MIS305-372_Sec201_MJNMnon-profitpetcenter.xlsxPET
| pet | ||||||||||||
| PetID | PetName | Class | Gender | Breed | CoatColor | EyeColor | Height | Weight | DOB | AdoptionFees | TotalExpenses | |
| 1 | Angora Rabbit | Rabbit | male | Orange With White | black | 10 cm | 5.34 kg | 16-Aug-2013 | $ 350 | $193 | ||
| 2 | Boo puppies | Dog | male | orange | black | 32 cm | 8.6 kg | 9-Sep-2015 | $ 350 | $1,670 | ||
| 3 | Bichon Frise Puppies | Dog | male | Non-Sporting | white | black | 15 cm | 5.44 kg | 3-Jul-2016 | $ 350 | $1,506 | |
| 4 | Beagle Puppies | Dog | male | Hound | white with brown | black | 30 cm | 6 kg | 13-Sep-2017 | $ 350 | $1,352 | |
| 5 | Bloodhound Puppies | Dog | male | Hound | Brown | black | 58 cm | 40 kg | 16-Nov-2015 | $ 350 | $2,278 | |
| 6 | French Bull Dog Puppies | Dog | male | Toy | black | black | 30 cm | 8 kg | 9-Sep-2015 | $ 350 | $2,564 | |
| 7 | Afghan Hound Puppies | Dog | male | Hound | white | black | 58 cm | 40 kg | 24-Mar-2014 | $ 350 | $2,270 | |
| 8 | Samoyed Puppies | Dog | female | working | white | black | 30 cm | 8 kg | 3-Mar-2016 | $ 350 | $2,276 | |
| 9 | American Cocker Spaniel Puppies | Dog | female | Sporting | Golden and Black | Brown | 59 cm | 25 kg | 2-Feb-2014 | $ 350 | $2,772 | |
| 10 | Beagle Puppies | Dog | female | Hound | Bicolor | black | 30 cm | 8 kg | 3-Mar-2015 | $ 350 | $2,158 | |
| 11 | Snow White | Cat | female | Persian | white | blue | 18 cm | 3.9 kg | 1-May-2013 | $ 350 | $1,850 | |
| 12 | Light | Cat | male | Persian | white | blue and green | 27 cm | 6 kg | 2-Aug-2015 | $ 350 | $1,286 | |
| 13 | Brownie | Cat | female | American Persian | brown, orange, and black | gold | 25 cm | 5 kg | 1-Mar-2016 | $ 350 | $1,322 | |
| 14 | Licorice | Cat | female | persian | black and white | gold | 19 cm | 3 kg | 2-Oct-2016 | $ 350 | $1,778 | |
| 15 | Lily | Cat | female | persian | white | blue | 15 cm | 1.5 kg | 2-Oct-2016 | $ 350 | $1,644 | |
| 16 | Shiro | Cat | male | American Persian | white | blue | 20 cm | 2.2 kg | 14-Dec-2016 | $ 350 | $1,250 |
PET_EXPENSE
| expenses per pet | |||||||||
| IDP | Rescue | PetServices | Fundraising | HealthCare | Grooming | alive | death expense | TotalExpenses | |
| 1 | $ 100 | $ 8 | $ 50 | $ 30 | $ 5 | yes | $0 | $ 193 | |
| 2 | $ 900 | $ 40 | $ 600 | $ 70 | $ 60 | yes | $0 | $ 1,670 | |
| 3 | $ 500 | $ 72 | $ 700 | $ 126 | $ 108 | yes | $0 | $ 1,506 | |
| 4 | $ 250 | $ 104 | $ 800 | $ 182 | $ 16 | yes | $0 | $ 1,352 | |
| 5 | $ 800 | $ 136 | $ 900 | $ 238 | $ 204 | yes | $0 | $ 2,278 | |
| 6 | $ 850 | $ 168 | $ 500 | $ 294 | $ 252 | no | $500 | $ 2,564 | |
| 7 | $ 1,000 | $ 20 | $ 600 | $ 350 | $ 300 | yes | $0 | $ 2,270 | |
| 8 | $ 900 | $ 232 | $ 700 | $ 406 | $ 38 | yes | $0 | $ 2,276 | |
| 9 | $ 650 | $ 264 | $ 800 | $ 462 | $ 96 | no | $500 | $ 2,772 | |
| 10 | $ 800 | $ 296 | $ 500 | $ 518 | $ 44 | yes | $0 | $ 2,158 | |
| 11 | $ 900 | $ 104 | $ 500 | $ 108 | $ 238 | yes | $0 | $ 1,850 | |
| 12 | $ 200 | $ 36 | $ 600 | $ 156 | $ 294 | yes | $0 | $ 1,286 | |
| 13 | $ 200 | $ 168 | $ 700 | $ 204 | $ 50 | yes | $0 | $ 1,322 | |
| 14 | $ 300 | $ 20 | $ 800 | $ 252 | $ 406 | yes | $0 | $ 1,778 | |
| 15 | $ 150 | $ 232 | $ 400 | $ 300 | $ 62 | no | $500 | $ 1,644 | |
| 16 | $ 180 | $ 264 | $ 400 | $ 348 | $ 58 | yes | $0 | $ 1,250 | |
DONATION
| donations | ||||||
| DonorID | DonorType | Donations | Date | |||
| 101 | individual | $ 13 | 1-Jan-2011 | |||
| 102 | individual | $ 40 | 8-Mar-2012 | |||
| 103 | orgonization | $ 2,000 | 6-Aug-2015 | |||
| 104 | orgonization | $ 3,600 | 3-Jan-2017 | |||
| 105 | orgonization | $ 5,200 | 5-Dec-2012 | |||
| 106 | individual | $ 68 | 6-Nov-2011 | |||
| 107 | individual | $ 84 | 17-Jan-2010 | |||
| 108 | Government | $ 1,000 | 8-Feb-2016 | |||
| 109 | Government | $ 1,106 | 9-Jul-2013 | |||
| 110 | Government | $ 1,302 | 10-Feb-2017 | |||
| 111 | Government | $ 1,408 | 11-Mar-2010 | |||
| 112 | orgonization | $ 3,000 | 12-Jan-2011 | |||
| 113 | orgonization | $ 3,000 | 13-Feb-2013 | |||
| 114 | individual | $ 5 | 14-Apr-2014 | |||
| 115 | individual | $ 10 | 15-May-2015 | |||
| 116 | individual | $ 70 | 16-Jun-2016 | |||
| 117 | individual | $ 21 | 1-May-2017 | |||
| 118 | individual | $ 15 | 18-Aug-2011 | |||
| 119 | orgonization | $ 1,000 | 19-Sep-2010 | |||
| 120 | orgonization | $ 3,030 | 20-Oct-2013 | |||
| 121 | orgonization | $ 3,700 | 21-Nov-2014 |
SAVING
| saving | ||||||||
| Management&Adminstration | totalPetExpenses | totalAdoptionFees | totalDonations | retainedEarnings | ||||
| $ 2,000 | $ 28,169 | $ 5,600 | $ 29,672 | $5,103 |
TOTAL_EXPENSE
| Total Expense | ||||||||
| ExpenseType | Amount | |||||||
| Rescue | 8680 | |||||||
| Pet Service | 2164 | |||||||
| Fundrasing | 9550 | |||||||
| Health Care | 4044 | |||||||
| Grooming | 2231 | |||||||
| Death Expense | 1500 |
TOTAL_EXPENSE_PER_PET
| Total Expense Per Pet | |||||||
| Class | ExpenseAmount | ||||||
| Rabbit | 193 | ||||||
| Cat | 9130 | ||||||
| Dog | 18846 |
FUNDRASING_DONATION_ADOPTION
| Fundraising Donation Adoption | |||||
| FundRaising | Donations | Date | AdoptionRate | ||
| 3 | $ 84 | 17-Jan-2010 | 280 | ||
| 84 | $ 1,408 | 11-Mar-2010 | 470 | ||
| $ 1,050 | $ 1,000 | 19-Sep-2010 | 337 | ||
| $ 900 | $ 13 | 1-Jan-2011 | 4 | ||
| $ 13 | $ 3,000 | 12-Jan-2011 | 101 | ||
| $ 500 | $ 15 | 18-Aug-2011 | 5 | ||
| $ 10 | $ 68 | 6-Nov-2011 | 23 | ||
| $ 70 | $ 40 | 8-Mar-2012 | 15 | ||
| $ 50 | $ 5,200 | 5-Dec-2012 | 173 | ||
| $ 50 | $ 3,000 | 13-Feb-2013 | 101 | ||
| $ 700 | $ 1,106 | 9-Jul-2013 | 373 | ||
| $ 800 | $ 3,030 | 20-Oct-2013 | 102 | ||
| $ 1,000 | $ 5 | 14-Apr-2014 | 2 | ||
| $ 100 | $ 3,700 | 21-Nov-2014 | 124 | ||
| $ 1,000 | $ 10 | 15-May-2015 | 3 | ||
| $ 600 | $ 2,000 | 6-Aug-2015 | 500 | ||
| $ 600 | $ 1,000 | 8-Feb-2016 | 337 | ||
| $ 400 | $ 70 | 16-Jun-2016 | 24 | ||
| $ 90 | $ 3,600 | 3-Jan-2017 | 121 | ||
| $ 1,000 | $ 1,302 | 10-Feb-2017 | 439 | ||
| 530 | $ 21 | 1-May-2017 | 90 |
