Chapter 3 – Input
Everyday at least once a day, scheduler need to develop up-to-date production schedule send to all concern
In every morning, scheduler will update information which comes from 2 sources:
Production Supervisor – send actual output report of yesterday including Balance Quantity of each operation as of today (7:00, 8:00, up to start time of shift)
Account Executive/Program Officer/Material Planner – send Job Order Loading Requisition for new Job Order
In summary, scheduler will update schedule as of date and update information from both sources to “Scheduler Workbench” worksheet:
• Update Schedule as of Date
• Update Current Order
• Loading New Order
3-1 Update Schedule as of Date
Step 1: Click on “Scheduler Workbench” worksheet to create product information.
Step 2: Update “Schedule As of” date
For daily schedule, update from “yesterday” to “today”, for this example “8/9 8:00” to “8/10 8:00”
Step 3: Update “Gantt Chart Start Date”
3-2 Update Current Order
Step 1: Click on “Scheduler Workbench” worksheet to create product information.
Step 2: Update Balanced Quantity of current job order
Scheduler will use balance quantity from shop floor report to update “Balance Qty”. If Balance Qty is less than Order Qty Balance Qty will display in red color for visual control.
You can delete completed operation by selecting data from column A to column R, and press on “Del” button on your keyboard. Then, click on at “Job Order” header to sort all orders.
Ensure that the rest operations will have Op. No. continuous running number (2, 3, 4 or 3, 4, 5 NOT 1, 3, 4). Also ensure that if you use some of 5 user-defined fields, column A – E may be hided and forgot to delete.
After delete these rows, click on at “Job Order” header to sort all orders.
Step 3: Click on “Rescheduling” button for rescheduling.
Demonstration Video
Update Actual Quantity from Shop Floor
www.planning-templates.com/mini-course-part-d-1-0.html
3-3 Load New Order
Step 1: Click on “Scheduler Workbench” worksheet to create product information.
Order Input Data
Job Order: Job Order or Production Order or Manufacturing Order
Customer: select customer from drop down list, if does not found need to create new customer in “Customer” worksheet
Product: select product from drop down list, if does not found need to create new product in “Product” worksheet
Order Qty: Order Quantity
Balance Qty: for new job order, Balance Qty is the same quantity as Order Qty
No Earlier Than Date: Production will not start before this date. You can by input the delivery date of shortage material to prevent production line down if build product before this date.
Due Date: Committed delivery date with customer
Priority: Priority number from High to Low ( 0..1..2..3..4..5….) Finite Scheduling will sequence job order by priority number
If you know total number of operations of this job order you can copy all columns above into new rows, preparing before enter operation input data (routing).
Operation Input Data ( Routing )
Op No.: Operation Number. Product will be processed sequenced by this operation number.
Work Center: machine or machine group which product will be process thru this work center.
Set Up (Min): Fixed amount of set up time (minute) of this operation. You can apply for some process which need to waiting for x days before start this operation.
UPH (Unit per Hour): Number of product output per hour.
Transfer Batch Hrs: Number of hours which current operation start date will start after the previous operation start date. The first operation cannot have “transfer batch hrs” data (may be Op no.2 if the rest operations are OP no. 2, 3, 4)
Demonstration Video
Loading New Job Order
www.planning-templates.com/mini-course-part-d-2-0.html
Cost Center: Cost Center which the work center under it.
CC-WC: cost center number-work center number. Use for sorting by Job Order.
Hrs Req.: Total hour required of this operation.
Hrs Req. = Set Up Time + (Balance Qty x UPH)
Calendar: Calendar numbers which work center use it.
OP Start: Planned Operation Start Date, the result of finite scheduling.
OP End: Planned Operation End Date, the result of finite scheduling.
OP Earlier/Late (-): Number of day which product at this operation has been finished before due date or late (-). If it’s late, system will show number in red color
Order Start: Planned Order Start Date, the result of finite scheduling.
Order End: Planned Order End Date, the result of finite scheduling.
Job Earlier/Late (-): Number of day which product has been finished before due date or late (-). If it’s late, system will show number in red color
Job No-OP No.: Job Order Number and Operation Number for quick reference
Remark-1 : 4 columns in below table (Cost center, CC-WC, Hrs Req., Calendar) can be hide using button, or unhide using button for reporting propose.
Remark-2 : 4 columns in below table (Order Start, Order End, Job Earlier/Late (-), Job No-OP No.) can be hide using button, or unhide using button for reporting propose.