bobkap
Active Member
- Joined
- Nov 22, 2009
- Messages
- 313
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I need to set up pricing data for someone who pays to have "decorators" customize apparel with their company's logo or whatever. There are 2 types of decoration - embroidery and screen printing. (you use one or the other; never both on the same piece of apparel.)
One of the first challenges is that pricing is determined by quantity being decorated. (e.g. 40 shirts might cost $5 while 95 shirts cost $4 etc) The quantity brackets are different for embroidery than they are for screen printing.
Other variables:
I have hit a mental block and just cannot figure this out. My main challenge is addressing the fact that the bracket pricing is different based on the different type of decoration.
One of the first challenges is that pricing is determined by quantity being decorated. (e.g. 40 shirts might cost $5 while 95 shirts cost $4 etc) The quantity brackets are different for embroidery than they are for screen printing.
Other variables:
- Names of 4 different decorators (they all have different prices of course.).
- Number of colors. Only needed for screen printing.
- Number of locations where there will be either kind of decoration. (e.g. left chest and back for a polo shirt; or maybe just front center for a T shirt; etc)
- Value fields would be the pricing per piece based on quantity and decorator and type of decoration.
I have hit a mental block and just cannot figure this out. My main challenge is addressing the fact that the bracket pricing is different based on the different type of decoration.