Build me an Excel solution for self-adhesive label production
Budget: £250 – £500 GBP
Task: to provide an excel solution that allows us to plan our printing and finishing production for self-adhesive labels
the task is to produce self-adhesive labels on rolls in various quantities and types
all labels are of the same size
our digital printing press is a roll-to-roll printing machine with a max print width of 333mm and a maximum print width of 312mm
Our offline label finishing machine is 333mm wide
On the finishing machine, the printed web is unwound and cut by the rotary cutting tool, then slit into lanes, then cross-cut and wound into individual rolls
the print layout is determined by the layout of the cutting tool and the number of labels per roll and labels per type
the various label types have to be processed in adjacent lanes on the web
labels of same or of similar quantities have to be grouped in batches
within a batch, lanes with fewer labels are filled up with blank, unprinted labels
after each batch, a single line of blank labels is inserted as a visual reference for manual cross-cutting
within an individual batch there should not be more than one type per lane
same types of labels can be distributed over various batches
check if using fewer lanes across the web will results in a more economical solution
consider material consumption and processing time when evaluating different solutions
the task is to produce self-adhesive labels on rolls in various quantities and types
all labels are of the same size
our digital printing press is a roll-to-roll printing machine with a max print width of 333mm and a maximum print width of 312mm
Our offline label finishing machine is 333mm wide
On the finishing machine, the printed web is unwound and cut by the rotary cutting tool, then slit into lanes, then cross-cut and wound into individual rolls
the print layout is determined by the layout of the cutting tool and the number of labels per roll and labels per type
the various label types have to be processed in adjacent lanes on the web
labels of same or of similar quantities have to be grouped in batches
within a batch, lanes with fewer labels are filled up with blank, unprinted labels
after each batch, a single line of blank labels is inserted as a visual reference for manual cross-cutting
within an individual batch there should not be more than one type per lane
same types of labels can be distributed over various batches
check if using fewer lanes across the web will results in a more economical solution
consider material consumption and processing time when evaluating different solutions