Floors pace planning

The workload of planning the time and space of multiple production halls, for customer projects,has become increasingly heavy.

Ease the workload on more departments and make the process more streamlined.

DADREFO ApS developed a browser-based application with intuitive interface for creating and placing projects on multiple floorplans across time and exporting derived information as separate documents, e.g., Gantt-like timeline.
Workload significantly reduced, and more people can perform the tasks involved, making it faster and easier to maintain the plan.

After release of first production version, DADREFO ApS is doing support, maintenance, and further development on request.

• 2024, Apr - Release of requested features
• 2023, Jan, Feb, May - Release of requested features
• 2022, Dec - Release of production version
• 2022, July - First prototype
• 2022, Feb - First application demo

• Auto creating Gantt like timelines
• Create and edit projects and floorplans in 2D and time resolution from 1 day to 1 month using Advanced collision detection for fail safe placement of projects
• Create PDF from timelines
• Creation of PDF drawings from extracted data
• Import/export data for backup purposes
• Import of DXF drawings for showing projects
• Multiuser environment

During multiple online interviews with Gram Equipment A/S, the details.in the process was clarified.
List of main requirements was created and agreed upon during brainstorming sessions.

DADREFO ApS performed analysis using tools from the LEAN toolbox:

• Value-Stream-Mapping to represent the current (AS-IS) and the future (TO-BE) process
• SIPOC for listing all parts of the process
• VOC/CTQ for clear description of the needs/requirements and goals

Based on above, a custom-made browser-based application was chosen.
During the development process, demos and prototypes were released at regular basis to show progress and align details in functionality.

The browser-based application was developed using:

• Python Flask web framework as backend
• SQLite as database, using SQLAlchemy as ORM manager
• Python Report Lab for PDF outputs
• Vanilla JavaScript as frontend, using jQuery and DXF-parser
• Application tested using PyTest, Jasmine and Robot Framework

Ressource planning

Create a tool that combines data from production planning and quotes and orders from ERP system, and visualize workload and ressource capacity one year ahead

To have a better view of future workload to adjust staff in time according to need.

Excel based tool that collects, combines otuput from planning and ERP system, and shows match between workload and capacity pr departmnet pr week for one year ahead.

After release of first production version, DADREFO ApS is doing support, maintenance, and further development on request.

• 2024, Jan - Release of update for new ERP system
• 2021, Okt - Release of minor bugfix version
• 2021, April - Release of requested features
• 2020, June - Release of requested features
• 2019, May - Initial release

• Complex VBA algorithems for attaining best possible result using given data
• Data set available as pivot data set and as graphical representation
• Excel based database extracts from ERP system
• Multiple user parameters and input files for fine tuning
• Special data export function co-developed with supplier of planning system

• Base requirements for tool analysed
• Close dialog with COO, S&OP Manager, Business Controller and project planner to get all input data aligned and to clear excact definition of algorithm
• Close dialog with supplier of planning system to get correct data from system
• Planning source data cleaned for inconsistencies in cooperation with project planner and supplier of planning system
• Develop application using Excel as basetool, using advanced VBA macro setup together with pivottables and graphical output
• After initial release, close dialog with VP Service to add extended features for service data

• Using standard Microsoft Excel
• Advanced algorithems using VBA macro language
• Auto generate advanced pivottables using macros
• Auto generate graphical plots from pivottables using macros

Data overview possible? (Proof of Concept)

Proof of concept.

Overview by analysing and visualizing data

Concept proven to be not viable for continuation.