finite capacity loaing in excel

Flexible on Shift Capacity and Powerful Visual Scheduling

Finite Loader's Main Features

Production Planner or Scheduler can load Job Order in Shift Schedule to meet Customer Order Due Date. Provide visual control tool to alert them when out of Due Date or Over Capacity!

1. Shift Schedule : Flexible Number of Shift per Day

schedule template


You can mix the different number of shifts per day in the same production schedule.
for an example in above screen
- workcenter#1 can have capacity 21 hour per day by running 3 shift per day, shift A..B..C, with 7 hour per shift
- workcenter#2 can have capacity 20 hour per day by running 2 shift per day, shift A..B, with 7 working hour per shift and 3 overtime hour per shift
- workcenter#3 can have capacity 8 hour per day by running only 1 shift per day with 8 hour per shift

2. Production Run Rate of products can varies on each machines

schedule template


workcenter#2 can produce Product A at rate 20 unit per hour, while if run on the old machine,workcenter#1, will be produced at only rate 10 unit per hour

3. Powerful Visual Scheduling

3.1 Green bar chart for On Time zone

production scheduling template


3.2 Red Alert when order is late

production scheduling template

3.3 Red Alert when over shift capacity

production scheduling template

4. Flexible Gantt Chart by selecting From-To Date

production scheduling template

You can have 60-day Time Schedule or 180-Shift Time Schedule, but you can feel free to filter for reporting propose in one page.

Buy Now  

5. Easy to clear job done with automated rescheduling

BEFORE

production scheduling template

AFTER

production scheduling template

SELECT START DATE

production scheduling template

6. Automated Start Date & End Date Calculation

BEFORE

production scheduling template

AFTER

production scheduling template



7. Custom Multi-Dimensioanl Report using Pivot Table

Production Schedule by Sales / Customer

production schedule example

Late Report

production schedule example

finite capacity loaing in excel

Excel-based Finite Capacity Loading System

Flexible on Shift Capacity and Powerful Visual Scheduling

- Flexible Number of Shift per Day
- Powerful Visual Scheduling
-- Green bar chart for On Time zone
-- Red Alert when order is late
-- Red Alert when over shift capacity
- Flexible Gantt Chart by selecting From-To Date
- 10 Work Centers with 60-day Schedule or 180-Shift Schedule
- Easy to clear job done with automated rescheduling
- Sort by Job Order, Sort by Start date
- "One Button" Automated Start Date & End Date Calculation
- "DIY" Custom-made Multi-Dimensional Schedule Report using Pivot Table

Buy Now  

Want to see more powerful products?

Automated Production Scheduling Tool

Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.