Plan instead of taking risks

Plan instead of taking risks

Everyone knows that business cannot be run spontaneously, making decisions intuitively. A company needs more meticulous assumptions based on concrete calculations and analyses, not trial and error. The most effective and efficient approach is to create a plan that covers the company’s operations as a whole – however, this is a demanding task. So, to what extent does theory diverge from practice?

Planning in every company is a complex and multifaceted process. Almost all company departments are involved in planning mechanisms – sales, logistics, production, marketing, finance, HR, etc. Each department prepares its own plan covering activities in its respective area. These include, for example:

– Forecasting demand for the company’s products and services (Forecasting),
– Sales and Operations Planning (S&OP),
– Rough Cut Capacity Planning (RCCP),
– Building and managing the Master Production Schedule (MPS),
– Planning inventory of finished goods/semi-finished products/materials and managing allocations in the distribution network,
– Purchasing planning.

However, all these plans must be properly coordinated – without cooperation within the organization, it is impossible to plan the entire company’s activities well and comprehensively, and individual stages become ineffective, if not completely useless.

The ideal plan
Planning processes have been best classified in the international supply chain management standard developed by the APICS association. A key stage is Sales and Operations Planning (S&OP) – this provides a starting point for estimating enterprise resource requirements (RCCP) and creating the Master Production Schedule (MPS). MPS, in turn, allows for Material Requirements Planning (MRP), and with it, Capacity Requirements Planning (CRP). The last two plans are already execution stages: operations scheduling and production execution recording.

Sales and Operations Planning is the process of developing a strategy that provides managers with the ability to integrate marketing plans for new and existing products with supply chain management, which is intended to result in a competitive advantage. The process connects all business-related plans: sales, marketing, development, production, procurement, and finance. Such coordination, usually established on a monthly basis, improves the consistency of activities across different segments of the enterprise. The Master Production Schedule (MPS), on the other hand, is a more detailed stage where specific quantities planned for production in subsequent planning periods are determined – at this level, a weekly cycle is most often used.

Imperfect ERP
To handle such a volume of information, every larger enterprise must use some form of ERP system. Although the name Enterprise Resource Planning indicates that these are systems used for planning enterprise resources, in practice, they usually only prove effective as transactional systems, primarily recording events occurring in the company. This means they support production execution control, which – referring to the comprehensive process presented above – is merely the final, execution stage. Software often also provides the ability to perform calculations related to Material Requirements Planning (MRP) and Capacity Requirements Planning (CRP) as detailed material planning, but even these segments do not work as they should in many companies.

ERP systems usually have modules related to the Master Production Schedule (MPS), but this is most often a place to enter specific numbers, not a tool supporting the preparation of such a plan. At the first two stages (S&OP and MPS) – which are typically planning-oriented – ERP systems are practically useless because the transactionality they focus on does not yet have such significance. Instead, features of tools such as configuration flexibility, the ability to perform multiple variants and simulations, or cross-sectional analyses of the impact of plan changes on the company’s status become key, and ERPs do not provide this. Therefore, companies have to manage with other methods.

Support in Excel
Despite the lack of tools in ERP systems, some elements of MPS and S&OP planning function in most enterprises. However, due to the fact that the most popular tool used for this is Excel, these tasks are very time-consuming and not everything is always possible to calculate or check within reasonable time frames. Excel is a calculation program – it handles that great – but good planning requires What-if analyses, which not only calculate the entered variants but automatically take into account various options (the manual entry of which would be prohibitively time-consuming) and identify the most favorable one.

How to do it better?
Organizations need tools dedicated to planning processes to work more efficiently. The system should provide:

– the ability to build a dedicated planning model (because every company is unique),
– simple preparation of different plan variants and their comparison,
– conducting larger simulations covering the long-term impact on the entire company,
– data synchronization from various sources and/or data consistency thanks to a central database,
– immediate data processing and charts facilitating their analysis.

It is particularly important that every employee can use their own configuration tailored to individual needs while simultaneously using the same data as everyone else. Changes made in any planning area should automatically update values in other areas (e.g., changing the production plan should change planned machine loads, required employee man-hours, planned inventory of finished goods and materials, and purchasing needs). For a planner, the ability to work at different levels is very important: department, plant, company, and not only on specific stock-keeping units but also on product families or assortment groups.

Planning details, observing the whole
The ability to continuously monitor selected indicators (the most important of which are revenues and costs, cash flow, the size and value of inventory at the end of the month, and their turnover ratio) is crucial so as not to get lost in a sea of detailed information during the planning process and not lose sight of the direction in which the company should be heading. Therefore, a general perspective is just as important as the ability to check changes in solution details and analyze their impact on the overall situation. In some respects, humans are still smarter than machines. However, it is worth using the computational capabilities they offer to streamline the planning process and simplify one’s work.