Spreadsheet: 72183d1272900904-use-table-to-auto-populate-other-tables-printing-job-plan-v4b
Sheet: Instructions

This tab should serve as a reference on how to use this job planning sheet for the Printing department. It will also give you some pointers on how to use the sheet effectively.
UNDERSTANDING THE JOB PLAN
1) On the "Printing" tab, you will see the cells that have a tan background as pictured to the right.
 | A) Order #: Place the order number for the job plan based on the schedule
 | B) Machine: Choose the machine number from the drop down list
 | C) Job Name: Choose the job name from the drop down list
 | D) Quanity: Enter the scheduled quantity in linear feet.
 | E) Set-up Type: Amount of lane changes they will need to perform
2) On the "Printing" tab, you will see the cells that have a blue background as pictured to the right. EACH of these cells will automatically calculate based on the information you entered in the tan boxes.
 | A) Planned Set Up Time: Based on the amount of lane changes, an appropriate set up time will be allotted.
 | B) Planned Run Time: Based on the machine and job, a planned run time will be calculated based on the run speeds and efficiences expected.
 | C) Machine Speed: Our expected instantaneous speeds in feet per minute.
 | D) Linear Feet/Hr: The machine speed times efficiency times 60 minutes
3) On the "Printing" tab, you will see the cells that have a white and orange background as pictured to the right. These cells are intended for the operator to fill out
 | A) Set up Start & End Times + Actual Set Up Time : Allows us to measure how efficienct the crew was at the set up versus the planned start up time.
 | B) Run Start & End Times + Actual Run Time: Allows us to measure how efficient the crew was overall in achieving the job target.
 | C) Material On/Off: ..
4) The next step on the job plan is the hourly tracking of production data.
 | A) Plan: The top box lets the operator know what the plan is both per hour and cumulatively.
 | B) Actual: The operator will log their actual feet produced per hour and then keep a running tally of their cumulative production.
5) For CI, the operator will outline any issues that led to them not hitting their targets.
 | A) Barrier Description / Action Taken: This should serve as the operators chance to outline the issues they are facing. DT codes will be tracked and pareto-ized for continuous improvement.
6) For waste reduction, the operator will track their waste
 | A) For each product / machine, a target waste will be communicated and the shift will track waste by set-up and production.
HOW THE STANDARDS WORK
1) On the "[NAME]," you will see this table at the top. The speeds and efficiences we set are DEFAULT values if we do not have a specific setting for a job.
 | A) Machine: Machine number
 | B) Speed: Target instantaneous speed
 | C) Efficiency Factor: Amount of time the machines will be running product (Total time - cycle times and other limiting factors)
 | D) Hourly Target: Speed * Efficiency Factor * 60
 | E) Waste %: Target waste in pounds
2) On the "[NAME]," you will see this table below the machine table. The set-up times should be based on observations and best practices.
 | A) Set-up Type: # of Lane Changes
 | B) Time: Time the set-up should take
3) On the "[NAME]," you will see a table like this for each machine. This allows us to set both job specific and machine specific targets.
 | A) 124: Jobs: Each job that could run on the machine (e.g. [NAME], Dove Soap, etc)
 | B) Speed: Target instantaneous speed
 | C) Efficiency Factor: Amount of time the machines will be running product (Total time - cycle times and other limiting factors)
 | D) Hourly Target: Speed * Efficiency Factor * 60
 | E) Waste %: Target waste in pounds
 |  |  |  |  |  |  |  | NOTE: The picture
 |  |  |  |  |  |  |  | is just a sample,
 |  |  |  |  |  |  |  | these #'s are
 |  |  |  |  |  |  |  | random