Excel spreadsheets
LucyMarie8985
Lucy.Schreck-EX2016-ChallengeYourself-9-4.xlsxSummary
| VaccineID | Total Units Shipped | Total Cost |
| DTP | ||
| FLU | ||
| HEPA | ||
| HEPB | ||
| HZV | ||
| LYD | ||
| MMR | ||
| RBV | ||
| YF | ||
| VaccineID | Average Unit Shipped Per Year | Average Cost per Year |
| DTP | ||
| FLU | ||
| HEPA | ||
| HEPB | ||
| HZV | ||
| LYD | ||
| MMR | ||
| RBV | ||
| YF |
2016 Shipments
| 2016 Summary | |||||
| VaccineID | Quantity | Cost | |||
| DTP | 750 | $ 5,500 | |||
| FLU | 500 | $ 4,500 | |||
| HEPA | 40 | $ 2,900 | |||
| HEPB | 0 | $ - 0 | |||
| HZV | 13 | $ 260 | |||
| LYD | 0 | $ - 0 | |||
| MMR | 0 | $ - 0 | |||
| RBV | 100 | $ 1,000 | |||
| YF | 0 | $ - 0 | |||
| Shipment Details | |||||
| ShipmentID | DateShipped | LocationID | VaccineID | Quantity | Cost |
| 1 | 10/25/16 | NEW2 | FLU | 500 | 4500 |
| 2 | 10/31/16 | ZAGI | RBV | 100 | 1000 |
| 3 | 11/5/16 | KIN1 | DTP | 250 | |
| 4 | 11/6/16 | LUA1 | DTP | 425 | 4250 |
| 5 | 11/15/16 | ADD1 | DTP | 75 | 750 |
| 6 | 12/1/16 | SAN2 | HZV | 13 | 260 |
| 7 | 12/20/16 | ACC1 | HEPA | 10 | 725 |
| 8 | 12/20/16 | GUA1 | HEPA | 10 | 725 |
| 9 | 12/20/16 | ZAG1 | HEPA | 10 | 725 |
| 10 | 12/22/16 | POR1 | HEPA | 10 | 725 |
2017 Shipments
| 2017 Summary | |||||
| VaccineID | Quantity | Cost | |||
| DTP | 0 | $ - 0 | |||
| FLU | 275 | $ 500 | |||
| HEPA | 0 | $ - 0 | |||
| HEPB | 20 | $ 2,000 | |||
| HZV | 0 | $ - 0 | |||
| LYD | 210 | $ 2,100 | |||
| MMR | 2500 | $ 10,000 | |||
| RBV | 20 | $ 5,000 | |||
| YF | 100 | $ 1,500 | |||
| Shipment Details | |||||
| ShipmentID | DateShipped | LocationID | VaccineID | Quantity | Cost |
| 11 | 1/15/17 | JER1 | FLU | 100 | 500 |
| 12 | 1/15/17 | NEW1 | FLU | 100 | 500 |
| 13 | 1/20/17 | NEW2 | FLU | 50 | 200 |
| 14 | 1/20/17 | ZAG1 | FLU | 25 | 500 |
| 15 | 2/1/17 | KIN1 | LYD | 100 | 1000 |
| 16 | 2/1/17 | ADD1 | LYD | 100 | |
| 17 | 2/1/17 | GUA1 | LYD | 10 | 500 |
| 18 | 2/1/17 | GUA1 | HEPB | 20 | 2000 |
| 19 | 2/1/17 | GUA1 | RBV | 10 | 2500 |
| 20 | 2/15/17 | SAN1 | RBV | 10 | 2500 |
| 21 | 2/15/17 | KIN1 | MMR | 2500 | 10000 |
| 22 | 2/15/17 | KIN1 | YF | 100 | 1500 |
Locations
| LocationID | Location |
| ACC1 | Accra, Ghana |
| ADD1 | Addis Ababa, Ethiopia |
| BAG1 | Baghdad, Iraq |
| BAN1 | Bangkok, Thailand |
| BRA1 | Bratislava, Slovakia |
| BUC1 | Bucharest, Romania |
| DHA1 | Dhaka, Bangladesh |
| GUA1 | Guatemala City, Guatemala |
| HAR1 | Harare, Zimbabwe |
| JER1 | Jerusalem, Israel |
| KAB1 | Kabul, Afghanistan |
| KIG1 | Kigali, Rwanda |
| KIN1 | Kingston, Jamaica |
| LAP1 | La Paz, Bolivia |
| LUA1 | Luanda, Angola |
| MAP1 | Maputo, Mozambique |
| MOG1 | Mogadishu, Somalia |
| NEW1 | New Delhi, India |
| NEW2 | New Orleans, United States |
| PHN1 | Phnom Penh, Cambodia |
| POR1 | Port-au-Prince, Haiti |
| SAN1 | Santo Domingo, Dominican Republic |
| SAN2 | San Salvador, El Salvador |
| WIN1 | Windhoek, Namibia |
| ZAG1 | Zagreb, Croatia |
