Fast please
guest001
BUS150Exam11.xlsxDocumentation
| Adventure Supplies | ||
| Author | ||
| Date | ||
| Purpose | To create an order form for orders made at Adventure Supplies | |
A-Markets
| Regional Market Size ($M) | |||||||||
| Region | Y2013 | Y2014 | Y2015 | Y2016 | Y2017 | Y2018 | Y2019 | SPARKLINES | |
| Cascade | 15,000 | 21,000 | 22,000 | 22,000 | 30,000 | 33,000 | 28,000 | ||
| Newport | 14,500 | 18,000 | 17,000 | 17,000 | 14,000 | 11,000 | 15,000 | ||
| Aquine | 3,000 | 9,000 | 9,000 | 14,000 | 14,000 | 10,000 | 10,300 | ||
| Others | 15,000 | 17,000 | 16,000 | 20,000 | 15,000 | 16,000 | 21,000 | ||
| Total Units | $ 47,500.00 | $ 65,000.00 | $ 64,000.00 | $ 73,000.00 | $ 73,000.00 | $ 70,000.00 | $ 74,300.00 | ||
A-Products
| Adventure Supplies Product List | Discounted | ||||||
| Product ID | Product Name | Price | Price | ||||
| bb7117 | Backpacks | $ 99.95 | Statistic Summary | ||||
| bl2815 | Lady Boots Covers (Medium) | $ 14.95 | Lowest Price | ||||
| bl6638 | Snowboard Leash | $ 5.95 | Highest Price | ||||
| br9002 | Bug Repellent (Deep Woodes) | $ 7.55 | Average Price | ||||
| fa8442 | First Aid Kit (Pack Size) | $ 11.95 | # of Products Listed | ||||
| fa8401 | First Aid Kit (Large) | $ 8.73 | |||||
| gps1015 | Zendo GPS meter | $ 82.81 | |||||
| gps1587 | GPS Tracking Unit | $ 112.45 | Discount | 10% | |||
| led7331 | Rechargeable Lantern (small) | $ 9.95 | |||||
| led7991 | LED Rechargeable Kit | $ 21.94 | |||||
| p5148 | Self-Inflating Pad | $ 37.25 | |||||
| p5148 | Self-Inflating Pillow | $ 17.95 | |||||
| p4981 | Pad Cover | $ 9.15 | |||||
| pj5199 | Insulated Jacket Women's | $ 175.22 | |||||
| pw6558 | Insulated Pants Women's | $ 85.87 | |||||
| sb2818 | Down Sleeping Bag | $ 178.21 | |||||
| sb3089 | Arctic Sleep Bag | $ 234.89 | |||||
| sb5317 | Attack Snowboard Women's | $ 148.21 | |||||
| sb5501 | Attack Snowboard Men's | $ 148.21 | |||||
| sb6601 | Solar Battery Recharging Unit | $ 32.55 | |||||
| sb8108 | Solar Battery Panels | $ 48.78 | |||||
| sb8502 | Sunblock SPF 30 (Hiking Size) | $ 12.32 | |||||
| sg8128 | Polarized Snow Goggles | $ 39.45 | |||||
| sh5591 | Snow Helmet Women's | $ 87.15 | |||||
| sh8810 | Snow Helmet Men's | $ 87.15 | |||||
| sp5588 | Snowshoes Pair | $ 63.21 | |||||
| t7815 | 2 Person Tent | $ 295.15 | |||||
| t7829 | 4 Person Tent | $ 335.24 | |||||
| tr8140 | Trail Mix (Pouch) | $ 9.95 | |||||
| tr8480 | Trail Mix (Box) | $ 19.95 | |||||
| wb7133 | Insulated Water Bottle | $ 6.75 | |||||
| wp0312 | Water Purifier | $ 21.55 | |||||
| wp5818 | Water Purifier Tablets | $ 10.31 | |||||
| ws8995 | Snowshoes Kid's | ||||||
| ws6832 | Snowshoes Women's | $ 378.15 | |||||
| ws8989 | Snowshoes Mens's | $ 5.15 | |||||
A-Order
| Adventure Supplies | ||||||||||||
| 1000 Brickell Way Miami, FL 33131 (305) 555-1133 | ||||||||||||
| Client Information | Product List | |||||||||||
| Client Name | Dummy Dog | Delivery Type | Shipping Charge | Est. Delivery Days | Product ID | Product Name | Supplier # | Price | ||||
| Order # | 1011 | Standard | $5.95 | 7 | bb7117 | Backpacks | 9384211732 | $ 99.95 | ||||
| Order Date | 4/5/18 | 3 Day | $15.95 | 3 | bl2815 | Lady Boots Covers (Medium) | 7113555139 | $ 14.95 | ||||
| 2 Day | $23.95 | 2 | bl6638 | Snowboard Leash | 8440054690 | $ 5.95 | ||||||
| Ship-To | Express | $38.75 | 1 | br9002 | Bug Repellent (Deep Woodes) | 9287184643 | $ 7.55 | |||||
| Street | 343 Any Lane | fa8442 | First Aid Kit (Pack Size) | 9989380458 | $ 11.95 | |||||||
| City | Fargo | Sales Tax | 6.75% | fa8401 | First Aid Kit (Large) | 7936911440 | $ 8.73 | |||||
| State | ND | gps1015 | Zendo GPS meter | 7667698206 | $ 82.81 | |||||||
| ZIP | 3231 | gps1587 | GPS Tracking Unit | 8398674178 | $ 112.45 | |||||||
| Phone | 9995552020 | Customer Order Details | led7331 | Rechargeable Lantern (small) | 9907563822 | $ 9.95 | ||||||
| Product ID | Product Name | Price | Qty | Charge | led7991 | LED Rechargeable Kit | 6056469220 | $ 21.94 | ||||
| Delivery Options | br9002 | Bug Repellent (Deep Woodes) | 3 | p5148 | Self-Inflating Pad | 6764959792 | $ 37.25 | |||||
| Delivery Type | Express | fa8401 | First Aid Kit (Large) | 1 | p5148 | Self-Inflating Pillow | 4593793389 | $ 17.95 | ||||
| Deliver Days | sb2818 | Down Sleeping Bag | 4 | p4981 | Pad Cover | 8201631947 | $ 9.15 | |||||
| Est. Delivery Date | led7331 | Rechargeable Lantern (small) | 2 | pj5199 | Insulated Jacket Women's | 7681998890 | $ 175.22 | |||||
| wb7133 | Insulated Water Bottle | 7 | pw6558 | Insulated Pants Women's | 7681998890 | $ 85.87 | ||||||
| tr8140 | Trail Mix (Pouch) | 15 | sb2818 | Down Sleeping Bag | 8710206256 | $ 178.21 | ||||||
| sb3089 | Arctic Sleep Bag | 7204897085 | $ 234.89 | |||||||||
| sb5317 | Attack Snowboard Women's | 5740196981 | $ 148.21 | |||||||||
| sb5501 | Attack Snowboard Men's | 5740196981 | $ 148.21 | |||||||||
| Subtotal | sb6601 | Solar Battery Recharging Unit | 9060195345 | $ 32.55 | ||||||||
| Sales Tax | sb8108 | Solar Battery Panels | 6245995232 | $ 48.78 | ||||||||
| Shipping & Handling | sb8502 | Sunblock SPF 30 (Hiking Size) | 5956839076 | $ 12.32 | ||||||||
| Shipping & Handling Discount | sg8128 | Polarized Snow Goggles | 7695419340 | $ 39.45 | ||||||||
| sh5591 | Snow Helmet Women's | 5814867430 | $ 87.15 | |||||||||
| TOTAL | sh8810 | Snow Helmet Men's | 7987784638 | $ 87.15 | ||||||||
| sp5588 | Snowshoes Pair | 5186251538 | $ 63.21 | |||||||||
| t7815 | 2 Person Tent | 6432349898 | $ 295.15 | |||||||||
| t7829 | 4 Person Tent | 6432349898 | $ 335.24 | |||||||||
| tr8140 | Trail Mix (Pouch) | 8922181048 | $ 9.95 | |||||||||
| tr8480 | Trail Mix (Box) | 5090559580 | $ 19.95 | |||||||||
| wb7133 | Insulated Water Bottle | 8863650577 | $ 6.75 | |||||||||
| wp0312 | Water Purifier | 6821591406 | $ 21.55 | |||||||||
| wp5818 | Water Purifier Tablets | 4887752979 | $ 10.31 | |||||||||
| ws8995 | Snowshoes Kid's | 8062341890 | ||||||||||
| ws6832 | Snowshoes Women's | 8062341890 | $ 378.15 | |||||||||
| ws8989 | Snowshoes Mens's | 8062341890 | $ 5.15 |
A-Historical Sales
| Adventure Supplies | ||||
| Top Items Historical Sales | ||||
| 2018 | ||||
| Product ID | Q1 | Q2 | Q3 | Q4 |
| bl2815 | $ 90,155 | $ 79,111 | $ 113,001 | $ 114,342 |
| bl6638 | $ 29,111 | $ 25,878 | $ 32,999 | $ 40,003 |
| gps1015 | $ 32,150 | $ 30,100 | $ 33,322 | $ 40,132 |
| p4981 | $ 33,567 | $ 30,333 | $ 36,320 | $ 37,123 |
| pj5199 | $ 23,000 | $ 23,000 | $ 23,999 | $ 24,000 |
| sb5501 | $ 11,110 | $ 15,011 | $ 12,999 | $ 16,545 |
| t7815 | $ 45,789 | $ 54,993 | $ 60,999 | $ 70,898 |
| wp0312 | $ 114,556 | $ 75,898 | $ 132,999 | $ 115,101 |
| Totals: | $ 379,438 | $ 334,324 | $ 446,638 | $ 458,144 |
| 2019 | ||||
| Product ID | Q1 | Q2 | Q3 | Q4 |
| bl2815 | $ 93,155 | $ 95,111 | $ 133,001 | $ 134,300 |
| bl6638 | $ 25,111 | $ 27,878 | $ 63,500 | $ 75,656 |
| gps1015 | $ 32,155 | $ 35,653 | $ 33,322 | $ 52,000 |
| p4981 | $ 33,567 | $ 30,332 | $ 37,400 | $ 43,590 |
| pj5199 | $ 23,411 | $ 25,000 | $ 26,999 | $ 25,000 |
| sb5501 | $ 12,050 | $ 15,000 | $ 18,000 | $ 21,767 |
| t7815 | $ 45,789 | $ 54,993 | $ 62,999 | $ 74,898 |
| wp0312 | $ 125,000 | $ 225,000 | $ 140,999 | $ 143,450 |
| Totals: | $ 390,238 | $ 508,967 | $ 516,220 | $ 570,661 |
