Excel spreadsheet recreate
waterdawg77
NP_EX16_3b_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 3: SAM Project 1b | |
| You've Got Style | |
| PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONS | |
| Author: | Mirielle White |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Product Lookup
| You've Got Style | ||||||
| 4/25/16 10:46 | ||||||
| Clothing Set Components, Item Counts, & Avg Total Weight | Packaging | Product Information Lookup | ||||
| Shirt/Blouse | 4 | 160 | Packing Weight (oz.) | 56 | Boxed Set | Retro Fit |
| Pants/Shorts | 3 | 192 | Item Count | |||
| Dress/Skirt | 2 | 96 | # of Components | 0 | ||
| Sweater/Vest | 2 | 116 | Net Weight (oz.) | 604 | ||
| Socks | 5 | 40 | Shipping Weight (lbs.) | |||
| Underwear | four | 48 | Overweight? | |||
| Accessories | 5 | 40 | ||||
| Clothing Set Information | Item Counts | # of Components | Net Weight (oz.) | |||
| Bizzy Caz | 12 | 392 | ||||
| High Society | 136 | |||||
| Retro Fit | 16 | 604 | ||||
| Weekend Wanderer | ERROR:#VALUE! | 440 | ||||
| Clothing Set Configurations | ||||||
| Bizzy Caz | Shirt/Blouse | Pants/Shorts | Socks | |||
| High Society | Dress/Skirt | Accessories | ||||
| Retro Fit | Shirt/Blouse | Pants/Shorts | Dress/Skirt | Sweater/Vest | Accessories | |
| Weekend Wanderer | Shirt/Blouse | Pants/Shorts | Socks | Underwear |
Orders
| You've Got Style | |||||||||||||||
| Transaction Growth | |||||||||||||||
| Orders | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Most Ordered | Least Ordered |
| Bizzy Caz | 24 | 387 | 451 | 558 | 1057 | 1479 | 1909 | 2146 | 1793 | 964 | 1142 | 832 | 12742 | 2146 | |
| High Society | 260 | 652 | 462 | 373 | 237 | 390 | 555 | 315 | 463 | 354 | 445 | 843 | 5349 | 2146 | |
| Retro Fit | 214 | 516 | 809 | 1539 | 2146 | ||||||||||
| Weekend Wanderer | 348 | 660 | 936 | 828 | 603 | 1003 | 1269 | 748 | 1073 | 1107 | 628 | 582 | 9785 | 2146 | |
| Total Orders | 632 | 1699 | 1849 | 1759 | 1897 | 2872 | 3733 | 3209 | 3329 | 2639 | 2731 | 3066 | 29415 | 2146 | |
| Average Monthly Fulfillment | |||||||||||||||
| Inventory Tracker | |||||||||||||||
| Components | Jan | Feb | Mar | Total | Peak Inventory | Lowest Stock | |||||||||
| Shirt/Blouse | 2717 | 6270 | 5158 | 3680 | 5974 | 4704 | 6511 | 3657 | 5867 | 4042 | 2417 | 6280 | 57277 | 2417 | |
| Pants/Shorts | 3226 | 1500 | 6691 | 6845 | 3610 | 5284 | 5725 | 2374 | 1572 | 4527 | 6868 | 3640 | 51862 | 1500 | |
| Dress/Skirt | 3282 | 4708 | 5221 | 4328 | 1757 | 5019 | 4118 | 6383 | 2422 | 4432 | 3484 | 5504 | 50658 | 1757 | |
| Sweater/Vest | 1567 | 2643 | 6590 | 3506 | 4054 | 3672 | 6107 | 3576 | 6773 | 6499 | 4092 | 2387 | 51466 | 1567 | |
| Socks | 2836 | 2446 | 5930 | 5299 | 3474 | 4731 | 6888 | 5097 | 4533 | 2670 | 6106 | 2021 | 52031 | 2021 | |
| Underwear | 2661 | 3603 | 2666 | 3366 | 3160 | 4334 | 4569 | 6909 | 2484 | 4488 | 6271 | 1610 | 46121 | 1610 | |
| Accessories | 2273 | 4263 | 6197 | 1881 | 4187 | 1990 | 2311 | 2600 | 6719 | 3727 | 2418 | 2036 | 40602 | 1881 | |
| Total Inventory | 18562 | 25433 | 38453 | 28905 | 26216 | 29734 | 36229 | 30596 | 30370 | 30385 | 31656 | 23478 | 350017 | 18562 | |
| Average Monthly Inventory | 2652 | 3633 | 5493 | 4129 | 3745 | 4248 | 5176 | 4371 | 4339 | 4341 | 4522 | 3354 | 50002 |
