�ݺ�ߣ

Finite capacity planning and scheduling
for manufacturing
Odoo – frePPLe connector
Gaspard Dessy - portcities.net
Johan De Taeye - frepple.com

Agenda
▪ Overview
▪ Odoo and frePPLe
▪ Connector
▪ Business case
▪ Roadmap
▪ Q&A

Introduction
Business transactions that execute the
day-to-day operations in a company
- Manage sales orders
- Manage purchase orders
- Track all inventory movements
- Create production orders
- HR
- Accounting & finance
- …
odoo ERP
Odoo ERP is the backbone
to execute a company’s
business processes

Introduction
- HR
- …
odoo ERP
How do we make best use of
our bottleneck resources?
How much inventory do we
need to carry?
When can we
ship this new
order?
What are our
capacity needs
for next year?
How do I schedule material,
capacity and labour around
my constraints?
Some tough questions your
production planner has to answer
to plan beyond the execution of the
transactions…
What is the impact of the unexpected
downtime on a machine?

Introduction
- HR
- …
odoo ERP
When excel is no longer
the right tool to answer
these questions… FrePPLe finite capacity planning
and scheduling tool to offer smart
decision support to the planner

Introduction
Business transactions to
execute the day-to-day
business processes
- System of reference for all
business data
- Transaction execution
Advanced planning beyond
the ERP transactions
- Demand forecasting
Statistical forecast calculation based on
historical demand
- Inventory planning
Advanced calculations of safety stocks
and reorder quantities
- Production planning
Finite capacity planning and scheduling
Dynamic and smart handling of
constraints
Demand prioritization and constrained
supply allocation

Functional
Inventory
Sales orders
Manufacturing orders
Purchase orders
Locations
Items
Customers
Manufacturing orders
Work orders
Procurement orders
Distribution orders
Workcenters
Routings
Bill of materials

Technical
Deep integration of data and UI
1. All data is maintained in Odoo
2. When the frePPLe plan is generated the
connector connects live to the Odoo
web server to retrieve the data
3. The frePPLe planning engine sends back
purchase requisitions, manufacturing
orders and work orders
4. A copy of the data is (optionally) saved
in the frePPLe database for reporting
and analysis purposes
5. Single-signon between Odoo and
frePPLe: single web-based UI for the
end user
Odoo frePPLe
1 4
3
2
5
Single data source used
for planning
Unified user interface
for the end users

Business cases
Wooden furniture factory located in Indonesia
Employs 1200 people
Running Odoo
FrePPLe, integrated with Odoo, will enable improved capacity
planning process and improved on time delivery
250+ CNC machines facility based in Malaysia
They are integrating frePPLe with Odoo
They hope to reduce the planning team from 20 to 5-10, and
decrease the WIP by better forecasting purchasing and MTS.
Furniture factory
CNC Machining facility

Manufacture
Business Case: furniture factory
Machining
Timber Laminate Sub Assembly
Processing
Drilling
Moulding
Assembly
Finishing
Fitting
Packaging
Material
Finished
goods
Shipment
HW &
Pack
Company data
● 1100 employees
● 500 40-feet containers per year
● Located in Java, Indonesia
● 1500 finished goods SKU
● 5 warehouses, 9 production
departments
Products & manufacturing
● Over 100 individual operations (work order)
and 50 workers involved in the
manufacturing of one SKU (finished good)
● Finished goods MTO and MTS
● Components shared between SKU
Company data & production process

All manufacturing ops after 2 weeks
Current process
1. Receive order inquiry
2. Analyze free capacity based on
planning.
3. Commit to a shipment date..
4. Create work orders for components
Previous situation
Decision to
produce
Order inquiry
MTS stock
Hypothesis: plan doesn’t change
Decision to produce finished item based on
forecasted capacity and a 40MB Excel file
Work order for
new MO
All machining operations will be
finished after 1 week
Finishing takes 1 more week
Packaging 1 week
MO finished
goods
Hypothesis: fixed lead-time
WO
components
Weaknesses
1. Planning of work order is fixed (once set, cannot
change)
a. Wrong capacity usage for new inquiry
b. Inability to react to delay (manually)
2. Capacity analysis simplify a lot
a. Don’t take into account real machine usage
b. Lead to overtime, delay, planning overhead

Committed plan
Confirmed MO, WO
Sales Order / Shipment plan
PO and Incoming Shipment
Odoo - frePPLe integration
Master data
Product
BOM, Routing
Product-Supplier-Leadtime
Work Center, Schedule
Odoo frePPLe
frePPLe Modeling
Download data from Odoo
Generate plan
Adjust parameters, generate plan
Upload plan to Odoo
proposed plan
PO with scheduled date
MO and each sub-WO
Process:
1. frePPLe data updated from Odoo
2. Planning
- Generate new plan in frePPLe + adjustments
- Push draft plan to Odoo
3. Validate plan
- Planner confirm 2 days of operations
4. Execution
- Production team process validated orders
- Odoo is updated and will impact next planning
Note: Draft plan will be deleted by frePPLe
Validate and execute plan
Planner validate PO, MO, WO
Processing on the floor

Live demo
1. Create a new sales order in Odoo
2. Run connector Odoo=>frePPLe
3. Generate finite capacity plan in frePPLe
4. Review and approve plan in frePPLe
5. Run connector frePPLe=>Odoo
6. Check out the new procurement and
manufacturing orders in Odoo
it’s DEMO time!

1. Create a new sales
order in Odoo
it’s DEMO time!

2. Run connector
Odoo=>frePPLe
it’s DEMO time!

3. Generate finite capacity
plan in frePPLe
it’s DEMO time!

4. Review and approve
plan in frePPLe
it’s DEMO time!

5. Run connector
frePPLe=>Odoo
it’s DEMO time!

6. New Odoo procurement
and manufacturing orders
it’s DEMO time!

Roadmap
▪ FrePPLe 4.0
▪Interactive plan editors
▪ Forecast editor for demand forecasting (already available
in 3.2)
▪ Distribution planning screen (already available in 3.2)
▪ Gantt chart plan editor for production planning
▪Enhanced odoo connector
▪ Integrated user interface with single sign-on
▪ Less code in the connector due to frePPLe data model
changes
▪Scheduled for end 2016

Roadmap - integrated user interface
▪ Technical:
▪ Odoo browser window
showing frePPLe in <iframe>
▪ Single signon between applications
with web tokens
▪ Similar CSS styling of both applications
▪ Functional:
▪ Single user account and unified user
experience
▪ Screenshot:
forecast editor providing
advanced demand forecasting
functionality

Thank You!
https://frepple.com
info@frepple.com
+32 477.385.362
http://www.portcities.net/
gaspard@portcities.net +62-
813-2970-6795

�ݺ�ߣ

Frepple-Odoo integration - Odoo experience days 2016

Recommended

More Related Content

Similar to Frepple-Odoo integration - Odoo experience days 2016 (20)

Recently uploaded (20)

Frepple-Odoo integration - Odoo experience days 2016