Price list creation for printed labels

Completado Publicado hace 4 años Pagado a la entrega
Completado 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

Excel Procesamiento de datos

Nº del proyecto: #21412635

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 4 años

Adjudicado a:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that you'll enter an item number and you'll see all associat Más

$140 USD en 1 día
(204 comentarios)
7.3

4 freelancers están ofertando un promedio de $195 por este trabajo

noelcortes

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

$140 USD en 1 día
(0 comentarios)
0.0