Operational Production Scheduling With Excel: Chances And Limitations

    Elmar Karlowitsch
    May 11, 2016

    Microsoft Excel is certainly one of the most used standard software products of today - if not the most used. The plethora of both user types and application areas is very remarkable: Companies of any size use the application in almost any functional area. Just as striking: The application, designed as spreadsheet program, is very often used for rather untypical purposes. Everybody knows this “Excel Monster Application”, which is designed to deliver an output which the respective company pretty much depends on, but which basically no longer can be handled appropriately. This phenomenon particularly can get observed when it comes to the operational production scheduling within small to mid-size manufacturing companies. Hence, this blog post discusses the possibilities and limitations of an operational production scheduling with Excel.

    The good old days with Excel being the shiny star

    During their early years, the small and mid-size companies mentioned above typically don’t use a dedicated or even integrated software landscape for their business planning processes. For obvious reasons: especially in these early years both quantity and complexity of planning data are manageable and a “homegrown handmade” Excel solution perfecly does the job. Machines are allocated to orders “manually” and a rough operational production schedule with delivery dates per order is created. A new order will be “puzzled” in as good as the Excel sheet allows. In this scenario, Excel proves to cope with the requirements of an operation production scheduling. 

    Your business growth as tripping point

    Operational_Production_Scheduling_with_Excel.pngBut, however, even the “manual” integration of jobs that in the long run cannot be reasonably supported through Excel, reaches its limits first, when the number of orders starts to grow. It gets even worse if jobs consist of several operations being logically dependent. And - if the business grows - usually more machines will be purchased adding to the planning complexity. In addition, due to the growing business, the small and mid-size manufacturers will have to vary their order types, so that increasingly different order types with various routings will have to be scheduled. In general, the situation in most cases can be described as follows:

    • Increasing number of jobs, and more and more “rush jobs” have to be scheduled
    • Increasing number of resources
    • Increasing number and variety of order types

    So, you could say: "my plan constantly is in motion!”, and exactly this motion is not supported by Excel solutions.

    The Gordian Knot of Excel-based scheduling

    If an order consists of several logically dependent operations – no matter whether in predecessor-successor or predecessor-predecessor relations – all successors and predecessors have to be shifted manually when an operation is moved backwards or forwards. There’s no planning logic whatsoever between an order’s operations, this often resulting in manually moving around the planning data quite frantically.

    Gordian_Knot_S.jpgThe situation gets worse by the fact that one order in the production schedule cannot be viewed as if it would the only one. Of course, all orders compete for the same scarce resource capacity. This means that if one operation and all the logically related operations of the same job have been moved, it has to be verified whether the new temporal position of the operations is permitted at all or whether there will be resource conflicts with other operations of other orders. This permissibility check is also not supported by Excel in a purposeful way.

    This in fact lets the planner painfully suffer if an especially important order – let's call it "rush job"  – has to be added to the plan on short notice. There are simply no tools to modify the plan in an easy way so that the priorities inherent in this situation will be taken into account. And now, at the latest, Excel changes from being a useful device to becoming a troublesome task, the maintenance of which using up important and scarce capacities without providing the benefit once intended.

    Let's do it: easy operational production scheduling

    At this point, it is more than obvious that only an adequate software tool will provide the desired support for the altered planning situation. Mastering the above mentioned “plan in motion” is the challenge and at the same time the necessary basis for successful planning. So, as a consequence, the software tool should provide the following features to meet the requirements of operational time and resource scheduling:

    • Monitor-Jobs_View.pngIntegration of planning logic for a simple visualization of logical dependencies of operations
    • Proactive support of the planning, e.g. by visual warnings in case of resource conflicts
    • Enabling automatic scheduling taking into account specified priorities for quick and efficient dispatching of "rush jobs" and performing “what-if” scenarios
    • Supporting master data management
    • Enabling connection to other business software, e.g. ERP systems so that the production planning tool can grow sustainably together with the total software landscape.

    Does the outlined planning dilemma, sound familiar to you? Has your operational production planning with Excel reached its limits? Then test just plan it! We’d be glad to create a demo version for you on the basis of your data. You will see and grasp immediately how simply just plan it will bring your operational production planning to the next level you need so urgently.

    Let's start with a demo, and then we are happy to provide you with a trial account.

    New call-to-action

    Subscribe by Email

    Comments (1)