Price list creation for printed labels
$30-250 USD
Pagado a la entrega
Hello - I am hoping to receive assistance with building a pricelist for a customer. We make custom printed labels and with any given part number, there is a volume, per thousand label cost (raw material, ink, equipment, operator, etc) which is fluctuates with volume while makeready costs are fixed whether they order 15,000 or 600,000. Attached is an example of one particular size of label that is designated by the drawing number. There are 20 active label sizes/drawing numbers and each drawing number has its own tab in my current database... I have attached one tab from my workbook. This drawing# 193304 only has 9 part numbers, but each drawing has anywhere from two part numbers all the way to one that carries 57. Although the makeready costs are constant throughout any given calculation dictated by volume, this cost is determined by the number of colors that the part number calls for... This is why you see this fixed cost range from $525 to nearly $1,100. Our goal is to allow our buyer to simply type in a part number and have a range of different volumes pop up for her to choose from. Based on a demanded product manufacturing quantity that she pulls from her SAP system each day, she would then match that number from SAP with the closest volume ONLY the respective per thousand label price assigned to whatever scenario she might input... We do not want to reveal anything from the columns headlined in blue in the attached example. For example siting info from the attached: She types in "53107FA17" and after hitting Enter, she would be presented with per thousand label pricing at volumes of 15,000, 30,000, 50,000, 60,000, 90,000, 100,000, 150,000 and 600,000. She then considers the demand range and then make a choice as to how many labels to purchase. There are approximately 400 part numbers distributed throughout 20 separate tabs with each tab representing its own label size. Please review the attached database example for 3 part numbers that all share the same drawing number and let me know if this is something that you might be able to help us with. Thank you, Kevin
Nº del proyecto: #21412635
Sobre el proyecto
4 freelancers están ofertando un promedio de $195 por este trabajo
I am an expert full-time graphic designer with over 10 years of experience. In order to create the best image that positions your brand in the market I have some questions that complement your briefing. Send me a mes Más