AYK 30
| Apply Your Knowledge | |
| Project 30 – Inventory Data | |
| Input boxes in tan | |
| Output boxes in yellow | |
| Given data in blue | |
| Answers in red | |
Orders
| Order | Order Date | Product | Qty |
| 1 | 1/1/11 | Ipod Shuffle | 1 |
| 1 | 1/1/11 | Ipod Mini | 2 |
| 2 | 1/1/11 | LG C2000 | 1 |
| 3 | 1/1/11 | Nokia 6061 | 1 |
| 4 | 1/1/11 | Ipod Shuffle | 1 |
| 5 | 1/1/11 | Ipod Mini | 2 |
| 6 | 1/1/11 | Ipod Nano | 1 |
| 6 | 1/1/11 | Nokia 6061 | 1 |
| 7 | 1/1/11 | Ipod Shuffle | 1 |
| 7 | 1/1/11 | Ipod Nano | 1 |
Products
| Product Name | Product Description | Category ID | Unit Price | Reorder Level | Lead Time | Supplier Name | QOH |
| Ipod Shuffle | 1GB | MP3 | $99.00 | 10 | 10 | Apple | 52 |
| Ipod Mini | 4GB | MP3 | $149.00 | 25 | 10 | Apple | 20 |
| Ipod Nano | 2GB | MP3 | $199.00 | 25 | 10 | Apple | 22 |
| LG C2000 | Camera phone with 3x digital zoom | Cell Phone/SmartPhone | $99.00 | 5 | 10 | LG | 24 |
| Nokia 6061 | Media Net capable for surfing the Internet | Cell Phone/SmartPhone | $79.00 | 10 | 10 | Nokia America | 26 |
| Nokia 6102 | EDGE high-speed data access | Cell Phone/SmartPhone | $99.00 | 10 | 5 | Nokia America | 20 |
| Motorola RAZR V3 | Black | Cell Phone/SmartPhone | $149.00 | 10 | 5 | CellularFactory | 10 |
| LG CU320 | MP3 Music Player with Stereo Sound | Cell Phone/SmartPhone | $149.00 | 10 | 5 | LG | 10 |
| Garmin Streetpilot 2730 | Portable Car Navigation | GPS | $899.00 | 5 | 10 | Garmin | 2 |
| Magellan Explorist | explorist 100 North American | GPS | $125.00 | 5 | 5 | CellularFactory | 5 |
Suppliers
| Supplier Name | Contact Name | Address | City | State/Province | Postal Code | Country | Phone Number | Email Address | ShippingMethod |
| Apple Computers | Steve Jobs | 1 Infinite Loop | Cupertino | CA | 95014- | USA | (401) 555-1212 | apple.com | FedEx |
| LG Twin Towers | S.S.Kim | LG Twin Towers | Seoul | 15047- | Korea | (100) 555-4822 | lge.com | USPS | |
| Nokia Americas | Regina Murphy | 6000 Connection Drive | Irving | TX | 75039- | USA | (972) 894-5735 | nokia.com | USPS |
| CellularFactory | Megan Bell | 3030 Market Street | Denver | CO | 100 – | USA | (303) 988-4490 | cellularfactory.com | DHL |
| Garmin International Inc | Robert McCloud | 1200 East 151st Street | Olathe | KS | 66062-3426 | USA | (913) 397-8200 | garmin.com | FedEx |
