MRP Planning Analytic MTO

The “MRP Planning Engine MTO” module enhances the OpenValue MTO solution based in the MRP Planning Engine by implementing a strong integration with analytic accounting for collecting all costs and revenues related to MTO figures and achieving thus the MTO sales order margin.

Therefore, the OpenValue MTO solution supports the overall Make to Order process management from sales to purchase for both analytic accounting and logistics perspectives also and it is fully integrated in the overall Openvalue manufacturing planning and execution solution.

Analytic Accounting integration

A sales order is labeled as MTO relevant whether one of its items has the “make to order” planning strategy in its planning parameter master data.

An analytic account has to be assigned a MTO sale order for collecting all the revenues and the costs related to an MTO process; therefore, it is possible to monitor in real time all accounting figures related to a MTO process and its margin.

The analytic account is propagated from the sale order to the MTO overall supply chain when planned orders related to an MTO item are to be converted in manufacturing orders, as shown in the picture below.

The analytic account is assigned also to the sale delivery for posting cost of sales in analytic accounting, as shown in the picture below:

Replenishment Processes

The following business cases are managed:

·        MTO Manufactured Products (manufactured part with MTO demand strategy)

·        MTO Purchased Parts

·        Subcontracting Parts (as described for MTO Manufactured Products)

·        MTS Parts (product on stock)

·        Consumables (consumable product)

·        Purchased Services (Services purchased on demand from a third party and sold)

·        Internal Services (Service internally provided)

MTO Manufactured Products

The analytic account in the sales order is propagated to the all-manufacturing orders along the supply chain by converting MTO planned orders.

Through the “MRP Product Costing” module, all direct costs are collected in the analytic account.

The Cost of Sales and Revenues are posted also on the analytic account.

MTO Purchased Parts

The costs of sales is relevant for the analytic accounting perspective, so analytic posting are performed at customer delivery goods movement. The analytic account is not propagated to the purchase order for avoiding to post the cost twice.

MTS Parts

The cost is posted on analytic account when the spare part is withdrawal from the stock. Therefore, the outbound delivery goods movement is relevant for the analytic accounting perspective.

Consumables

This business case does not make sense in the MTO process scenario. Therefore, a check has been implemented to avoid to enter a sales item with an MTS consumable item with price different to zero. That means MTS consumable can be included in MTO sales order as free goods only.

Purchased Services

For a Service purchased from a third party (purchase automatically indicator set on master data) the analytic account is propagated from the sales order to the purchase order at item level. The analytic accounting posting for both costs and revenues are performed at invoices posting.

Internal Service

The revenues are collected on the analytic account when posting the customer invoice.

All internal costs are to be collected on the same analytic account, e.g. in timesheets for internal personnel costs.

MTO Planning Engine Supply Chain Report

A custom report is available to list for a MTO sales order all the related procurement MTO elements, i.e. MTO manufacturing orders and MTO purchase order items, with their dates and quantities. Therefore, in only one report a recap of all necessary figures is provided to monitor the overall MTO supply chain and to fulfill the customer expected delivery date.