Where an organization has a large volume of inventory – carrying out regular checks to ensure that the correct stock is available can become problematic and time consuming.

Cycle counting is a popular tool that can be used to aide the process, putting in a structured system to prove the accuracy of stock information. Strictly speaking, cycle counting is a sampling technique where certain parts of the inventory are reviewed and the results used to imply the robustness of the inventory as a whole.

The typical process is that the ERP system will generate a list of inventory locations to audit, these will be inspected and findings entered back into the ERP system. For example – The ERP system may say to check stock Location A1001 which should have 987 of part ABC123 – the location is inspected and it’s found that 980 parts are present – this information is relayed back to the materials controller who will make the necessary amendments (-7) in the ERP.

Cycle counting using random samples

Perhaps the most common implementation of cycle counting is that of utilizing a random sample.

This means that at each check a random location is selected (typically by the ERP system) the locations are then checked and the results fed back in. This routing happens periodically (in many organizations this is done daily with a set percentage target of inventory to be verified over a given period).

An alternative approach is to conduct several random sample checks to achieve a level of comfort over the findings and then conduct the cycle count on a particular product or range of stores locations using those results as the indicator for the larger warehouse. This method works well where the warehouse is full of comparable products but less so where there is product diversity.

ABC driven cycle count process

ABC Analysis is a method that is often used to segment inventory. Where the organization has an inventory that is diverse in product type and cost – traditional cycle count processes are not appropriate as they do not account for values.

ABC typically segments inventory by cost with the most expensive items being categorized as ‘A’ items and so on.

Before undertaking a ABC driven cycle count process an ABC analysis will need to be carried out (in many ERP systems the results can be stored within the database to help drive cycle count processes.) The structure of the cycle count is that the ‘A’ Class items will be checked / counted more frequently than the ‘B’ items which in turn will be counted more than the ‘C’ class items.

Problems with cycle count processes

Cycle count processes are not without their issues.

• The process can be particularly resource hungry for organizations with large warehouses/inventories
• Administration involved in producing check sheets where it cant be automated
• The inventory accuracy of items not counted may be low and counted items may not be representative of the overall inventory
• Write on / Write Off processes and financial authorisation to change stock figures need to be robust

One of the key tasks for any business is utilizing your assets effectively (whether that’s materials, people or tools and equipment) in order to meet your customer requirement.  Ensuring you maximize your productivity whilst at the same time managing your costs is not easy.  Demand profiles can fluctuate and customers may only provide a short term horizon of orders – which makes long term business planning more difficult.

Planning your production requires a variety of inputs from supply chain, operations through to capacity planning for the assembly line.  Coupled with this complexity there is often a significant disconnect between the sales order input team and the production line – orders get taken without reviewing appropriate lead times or dependencies leaving manufacturing with an up hill battle.

As an example consider that the item we need to produce has an 8 week lead time – however the sales team promise the item to the customer in 4 weeks time – this puts our planning system into arrears – with the significant pressure on our supply chain to bring in the materials required and further pressure on the manufacturing team to meet lead time – the common result is inventory arriving which can’t be used because we’re waiting for other supplier deliveries, assembly lines working out of process and an unhappy customer that does not get what they wanted when they wanted it!

The alternative is to apply a production scheduling tool – such as Master Production Scheduling – which endeavours to put together a business plan for production that features materials requirements, resources, capacity etc.  Master Production Scheduling is very common in manufacturing where the plan links to a demand pattern (not necessarily the same profile as ordered by the customer.) and in many cases presents an ideal opportunity to create a smoothed production plan.

Using Master Production Scheduling

MPS is the plan that drives the business – and commits resources and materials (costs) to meet the plan.  The plan is what the business can achieve – not necessarily what the customer wants!   To some extent MPS allows the business to divorce production from the sales order.  The table below demonstrates a smoothed production schedule that can be met by its ‘suppliers’ (supply chain, resources capacity etc).  However notice that the volumes against the sales orders are different.

Week 1 Week 2 Week 3 Week4 Week 5 Week 6 Week 7 Week 8
Sales Orders 5 15 7 13 6 14
MPS 10 10 10 10 10 10 10 10
Running balance 5 0 3 0 6 0

In this simple example note that we have no firm orders allocated against week 7.  This enables the sales team to see when they can commit to deliveries with the customer – they know there is no point promising another 20 units in week 3 – that order will not be met – however Weeks 7 & 8 have slots free.  Notice too how the production plan does not allow the produced part to go stock out.  This is a subjective rule as you might be happy to allow stock outs depending on your agreed service level with your customer.  The balance is to keep a steady drum beat of production while ensuring your stock levels do not get out of hand.

The company production plan drives the organization so it needs to be robust. A plan that is not viable can have serious consequence so there are some important habits that need to be established if an MPS is to work properly, namely

  • Suppliers must feed into the schedule in a timely fashion
  • No planning in arrears
  • Incorporate Capacity planning
  • Ensure the plan is stable – do not change it every 5 minutes!

What does an MPS consist of

An Master Production Schedule will utilize a series of variables to help construct it.

  • Sales Demand
  • Forecast Demand,
  • Costs
    • Production Costs
    • Inventory Costs
  • Lead times
  • Capacity
  • Parts supply

Parts supply can be an interesting calculation – in that most organizations do not have 100% delivery schedule adherence from their suppliers – it’s vitally important that correct scheduling of supplier deliveries takes place in order that the plan is valid.

The plan itself will need to be reviewed and recalculated periodically (e.g. weekly / monthly).  You should look to have a metric that reviews the stability of your MPS – if you are changing it extensively every time its reloaded then your planning process may not be functioning effectively.

MPS at the parent level part

Typically you will not MPS every part in the organization – you will look at the Bill of Material and agree at which level to drive production – for example if we look at our part below– Part Number 123 – we will MPS it at the top level – our MRP system should drive the requirements for the lower level parts – for example the purchased child parts.

Part Number 123……(Top Level Part – MPS’d)

…..Child part – manufactured

………Raw Material

………Purchased Part

…..Child part – Purchased part

…..Child part – Purchased Part

…..Child part – Purchased Part

Problems with MPS

Master Production Scheduling does have its frailties – it relies on good quality inputs and usually a robust MRP system.  If we took the example of Part Number 123 above what would the impact be to our scheduling if the lead time for the Purchased parts were incorrect?  Incorrect MRP data is often a cause for MPS failure.

Another common problem is poor parts supply – items do not turn up when they are supposed to – that can result in severe impacts to the schedule.  The schedule must make assumptions in parts deliveries.

Many MPS will work with a fixed and forecast time window – that means that the business agrees that it will not change the MPS plan within a given window of time – for example the first 6 weeks of the plan will always remain fixed.  This can be extremely difficult as there is a trade off between keeping your plan effective or supporting customers that might come in with a last minute urgent requirement – there may be reasonable rationale to review gaps in the capacity plan for urgent activity depending on your business.