Hello everyone!
I am working on a sheet for a friend of mine who needs help pricing consignment goods at their store. I have attached a worksheet that I started to show the user interface for now.
All I have done is built a simple "dependent dropdown" sheet to show how the final workbook should function.
All the additional sheets correspond to the categories of items in the store, and each category has specific items in the store.
Right now, the company has a problem agreeing on how to price goods and they pay this employee the most because of the extensive training and understanding it requires. This way the owner can determine the price in the database and there is now more discussion.
Ideally, the owner of the store would be able to input the value in the category/item sheets of how they want to price a Premium, Standard, or Economy good, ie. a Premium pair of womens jeans are $85, an Economy pair would be $35.
What I want the sheet to do is have a regular employee be able to look at a boys 5T shirt and using the drop-downs to determine the price:
1. Select Category (Kids)
2. Select Item (Kids>Boys Shirt)
3. Select Brand (Premium, Standard, Economy) this would be the difference between a Gucci shirt or a Hanes shirt.
4. Select Condition (New, Excellent, Good, Fair, Poor) this field puts a function on it the diminish the value depending on the selection, ie. New = 90% (.9) of the input value, Excellent = 80% (.8) of the input value, etc.
And the price needs to end up in the price field.
The only thing I am set on are the four selection fields for the employee input, everything else can be rebuilt to so it functions properly.
The database also needs to be expandable, meaning the owner can continually add new items as they come into the store, and also they have a easy (not computer programmer) interface so they can change those three columns of the price fields.
Thanks so much and I hope you can help!
Zach
Bookmarks