Atlantic Supply Chain Blog

Blog posts

You Can Pry this Spreadsheet from my Cold, Dead Fingers

Your sales people are using SF.COM. Your accountants and finance team are using SAP.  Quality data is rigorously being entered into your MES system. Why, then, are your planners and schedulers still using spreadsheets? In fact, they have told you they will only give them up if you pry them from their cold, dead fingers. Wasn’t your ERP implementation supposed to get rid of Excel schedules?

The Case for Integrated Distribution and Plant Scheduling

Management consultants have made fortunes claiming to provide the secret sauce for breaking down “organizational silos” and “getting everyone on the same page”. Yet some organizational boundaries remain persistently in place. Perhaps none are as persistent as the silo between distribution and manufacturing planning and scheduling.

The tools are separate. “I use MRP and finite capacity scheduling,” say the plant guys. “I use DRP and inventory planning,” say the distribution people.

Gantt Chart Pivoting

The Gantt Chart was invented by Henry Gantt in 1910 to help manufacturing plants schedule their operations. With the advent of computerized scheduling systems, users can now manage their schedules using computerized Gantt charts. Atlantic Supply Chain of course provides a Gantt chart (aka Schedule Board), as shown below:

 

 

Atlantic Supply Chain Suite Catalog

The Catalog

The Atlantic Supply Chain Suite organizes Planning and Scheduling data in an in-memory Catalog.  The catalog contains two types of objects, Dimensions and Cubes.

 

Dimensions

Dimensions are lists of data objects.  Many different data objects can be contained by a dimension.  The simplest object type, a "Simple Dimension Entry" consists of a Code and Description.  For example, a Machines dimension could contain the entries {DPRESS1, Drill Press 1}, {DPRESS2, Drill Press 2} and {SAW, Band Saw}.