Excel spreadsheet recreate
waterdawg77
NP_EX16_3a_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 3: SAM Project 1a | |
| Snackin-Pak | |
| 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
| Snackin-Pak | |||||
| 2/4/16 10:50 | |||||
| Boxed Set Components & Calories | Packaging | 10 | Product Information Lookup | ||
| Baked Goods | 91 | Packing Weight (oz.) | 30 | Boxed Set | Sweet Stuff |
| Bars/Clusters | 78 | Calories | |||
| Chips/Pretzels | 51 | # of Components | 0 | ||
| Dried Fruit | 80 | Net Weight (oz.) | 29 | ||
| Granola | 87 | Shipping Weight (lbs.) | |||
| Nuts | one hundred | Overweight? | |||
| Popcorn | 63 | ||||
| Boxed Set Information | Calories | # of Components | Net Weight (oz.) | ||
| Fit Bits | ERROR:#VALUE! | 20 | |||
| Great Grains | 165 | 15 | |||
| Munchie Madness | 25 | ||||
| Sweet Stuff | 363 | 29 | |||
| Boxed Set Configurations | |||||
| Fit Bits | Dried Fruit | Granola | Nuts | ||
| Great Grains | Bars/Clusters | Granola | |||
| Munchie Madness | Baked Goods | Bars/Clusters | Granola | Popcorn | |
| Sweet Stuff | Baked Goods | Bars/Clusters | Chips/Pretzels | Dried Fruit | Popcorn |
Orders
| Snackin-Pak | |||||||||||||||
| Transaction Growth | |||||||||||||||
| Orders | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Most Ordered | Least Ordered |
| Fit Bits | 305 | 380 | 555 | 494 | 569 | 1026 | 1302 | 1408 | 1047 | 954 | 712 | 761 | 9513 | 1408 | |
| Great Grains | 67 | 547 | 897 | 1097 | 826 | 473 | 943 | 1122 | 1501 | 1248 | 1262 | 1629 | 11612 | 1408 | |
| Munchie Madness | 112 | 129 | 181 | 422 | 1408 | ||||||||||
| Sweet Stuff | 136 | 256 | 482 | 919 | 817 | 1150 | 790 | 891 | 1274 | 1143 | 778 | 540 | 9176 | 1408 | |
| Total Orders | 508 | 1183 | 1934 | 2510 | 2212 | 2649 | 3035 | 3421 | 3822 | 3457 | 2881 | 3111 | 30723 | 1408 | |
| Average Monthly Fulfillment | |||||||||||||||
| Inventory Tracker | |||||||||||||||
| Components | Jan | Feb | Mar | Total | Peak Inventory | Lowest Stock | |||||||||
| Bars/Clusters | 5728 | 3090 | 4935 | 2126 | 6198 | 2032 | 2660 | 2503 | 5592 | 6152 | 2149 | 5153 | 48318 | 2032 | |
| Popcorn | 3826 | 2514 | 5097 | 2488 | 3277 | 2906 | 2940 | 5922 | 2162 | 5074 | 5490 | 2739 | 44435 | 2162 | |
| Baked Goods | 1933 | 2532 | 3292 | 5650 | 2818 | 2030 | 1622 | 5682 | 6366 | 6975 | 3679 | 2838 | 45417 | 1622 | |
| Chips/Pretzels | 1893 | 3273 | 1673 | 6576 | 6315 | 4978 | 4926 | 1561 | 3937 | 1960 | 6461 | 6767 | 50320 | 1561 | |
| Nuts | 4202 | 3538 | 1994 | 2709 | 1700 | 4433 | 2155 | 2943 | 3260 | 6185 | 5208 | 4863 | 43190 | 1700 | |
| Granola | 1922 | 4553 | 6838 | 1543 | 6816 | 3585 | 3366 | 2661 | 4641 | 2045 | 3238 | 2991 | 44199 | 1543 | |
| Dried Fruit | 6800 | 2951 | 2834 | 3222 | 2682 | 1996 | 4074 | 4999 | 3380 | 1763 | 6887 | 6657 | 48245 | 1763 | |
| Total Inventory | 26304 | 22451 | 26663 | 24314 | 29806 | 21960 | 21743 | 26271 | 29338 | 30154 | 33112 | 32008 | 324124 | 21743 | |
| Average Monthly Inventory | 3758 | 3207 | 3809 | 3473 | 4258 | 3137 | 3106 | 3753 | 4191 | 4308 | 4730 | 4573 | 46303 |
