Order 1076349: Read Instructions
Documentation Sheet
| Title: | Allison's Lipsticks | |
| Author: | Anna Holly | |
| Date: | 22-May-18 | |
| Purpose: | The purpose is the Inventory of different types of Lipsticks. I'll show Whole Sale Prices, Item Names, Give a Budget and so forth. | |
| (Expand as necessary) | ||
| Project Elements | Explanation **Feel free to utilize more space for explanation then what is provided by stretching the rows or wrapping the text. | Location (Sheet Tab and Cell References hyperlinks) |
| Data Sheets | ||
| Formulas/Functions (list each) | ||
| Formula #1 | Multiplied markup percent by the wholesale price to find the Markup Cost | |
| Formula #2 | Added the Wholesale Cost and Markup cost to get the Retail Cost | |
| Formula #3 | ||
| IF-function | ||
| Filtered List | ||
| Conditional Formatting | ||
| Chart #1 | ||
| Chart #2 | ||
| Lookup Table w/Lookup Function | ||
| Data Validation w/ error message | ||
| Pivot Table with chart | ||
| Pick one of two | ||
| One-Variable Data Table | ||
| Goal Seek | ||
| Pick two of four | ||
| Macro | ||
| Two-Variable Data Table | ||
| Scenario Manager | ||
| Solver | ||
| Additional Included Functionalities |
Inventory
| Mark up % | 1.25 | |||||||
| Product Number | Item Name | Finish | Color | On Hand | Wholesale Cost | Markup Cost | Retail Cost | Need to Order |
| 1 | Angel | Gloss | Coral | 10 | 5 | 6.25 | 11.25 | |
| 2 | Allison | Matte | Light Pink | 10 | 6 | 7.5 | 13.5 | |
| 3 | Anna | Sheen | Rose | 15 | 10 | 12.5 | 22.5 | |
| 4 | Adore | Glitter | Peach | 10 | 6 | 7.5 | 13.5 | |
| 5 | WheelPretty | Shimmer | Salmon | 15 | 11 | 13.75 | 24.75 | |
| 6 | Gabrielle | Matte | Crepe | 10 | 6 | 7.5 | 13.5 | |
| 7 | Satin | Gloss | Lavendar | 10 | 5 | 6.25 | 11.25 | |
| 8 | Silk | Gloss | Magenta | 10 | 5 | 6.25 | 11.25 | |
| 9 | Lace | Shimmer | Lilac | 10 | 7 | 8.75 | 15.75 | |
| 10 | Vintage | Sheen | Plum | 10 | 8 | 10 | 18 | |
| 11 | Tailored | Matte | Orchid | 10 | 6 | 7.5 | 13.5 | |
| 12 | Bella | Gloss | Violet | 20 | 11 | 13.75 | 24.75 | |
| 13 | Brave | Matte | Lemonade | 10 | 6 | 7.5 | 13.5 | |
| 14 | Innocence | Shimmer | Nude | 10 | 7 | 8.75 | 15.75 | |
| 15 | Fairy | Shimmer | Pink Nude | 10 | 7 | 8.75 | 15.75 | |
| 16 | Romance | Sheen | Red | 10 | 8 | 10 | 18 | |
| 17 | Elegance | Glitter | Wine Red | 10 | 5 | 6.25 | 11.25 | |
| 18 | ShowStopper | Glitter | Cherry Red | 10 | 5 | 6.25 | 11.25 | |
| 19 | Millionaire | Matte | Ruby Red | 10 | 6 | 7.5 | 13.5 | |
| 20 | Yonce | Matte | Crimson Red | 10 | 6 | 7.5 | 13.5 | |
| 21 | Queen B | Matte | Candy Red | 11 | 11 | 13.75 | 24.75 | |
| 22 | Partition | Shimmer | Orange | 10 | 7 | 8.75 | 15.75 | |
| 23 | Yes | Glitter | Blue | 10 | 6 | 7.5 | 13.5 | |
| 24 | Tempting | Sheen | Black | 10 | 8 | 10 | 18 | |
| 25 | Pretty Woman | Gloss | Blush | 10 | 5 | 6.25 | 11.25 |
Order Form
| Allison's Lipsticks |
| Order Sheet |
| Name |
| Address |
| City |
| State |
| Zip |
| Item Number |
| Total |
| Sub Total |
Filtered Sheet
| Mark up % | 1.25 | |||||||
| Product Number | Item Name | Finish | Color | On Hand | Wholesale Cost | Markup Cost | Retail Cost | Need to Order |
| 1 | Angel | Gloss | 10 | 5 | 6.25 | 11.25 | ||
| 2 | Allison | Matte | 10 | 5 | 6.25 | |||
| 3 | Anna | Sheen | ||||||
| 4 | Adore | Glitter | ||||||
| 5 | WheelPretty | Shimmer | ||||||
| 6 | Gabrielle | Matte | ||||||
| 7 | Satin | Gloss | ||||||
| 8 | Silk | Gloss | ||||||
| 9 | Lace | Shimmer | ||||||
| 10 | Vintage | Sheen | ||||||
| 11 | Tailored | Matte | ||||||
| 12 | Bella | Gloss | ||||||
| 13 | Brave | Matte | ||||||
| 14 | Innocence | Shimmer | ||||||
| 15 | Fairy | Shimmer | ||||||
| 16 | Romance | Sheen | ||||||
| 17 | Elegance | Glitter | ||||||
| 18 | ShowStopper | Glitter | ||||||
| 19 | Millionaire | Matte | ||||||
| 20 | Yonce | Matte | ||||||
| 21 | Queen B | Matte | ||||||
| 22 | Partition | Shimmer | ||||||
| 23 | Yes | Glitter | ||||||
| 24 | Tempting | Sheen | ||||||
| 25 | Pretty Woman | Gloss |