Simulated Cost calculation in Sage X3

By | November 26, 2021

Sage X3 has a function that will compute the simulated cost of a product, a group of goods, or all products at a site depending on the cost type routing alternative, BOM with or without immediate update, and create a report that summarizes or details the results.

Simulations of the cost are often used to estimate the price of a project as a function of its specifications (new BOM, new component, new route).

Simulated cost calculations are based on routing data time and valuation dimension data for the work centers associated with the route during processing.

As part of the calculation for raw materials, the process attempts to figure out the receipt overheads for each raw material.

To find Simulated Cost Calculation, navigate to:

All>>Costing>>Simulated Cost Calculation

Navigation page
Fig01: Navigation to Simulated cost calculation

Steps:

Several options are available for the user to determine a simulated cost, including: a selection of calculation quantities, a selection of raw material valuation, overheads, a valuation dimension rate selection, and a posting method for fixed costs.

Whenever a cost calculation includes a multi-level BOM or encompasses several products, the process is exclusive to a particular site, so another user cannot launch a cost calculation at the same time.

The system examines selected products in decreasing order of the lowest level of codes if a selection of products is requested.

The calculation of a BOM with or without the lower levels consists of reading the component costs at the first level and transferring them to the cost of the parent product.

When using BOM split, the computation takes into account component costs at the top level, as well as all components in decreasing order of the codes at the bottom level.

When the costs of the sub-levels have already been estimated, a calculation ignoring the lower BOM is warranted for an update.

parameters
Fig 2.1: Cost Calculation Parameters
parameters
Fig2.2: Cost calculation parameters

Notes on the cost of materials and subcontractors:

Materials:

A material does not have a component by definition. When the cost is defined as “calculated” rather than “input,” the “Material cost selection” field is utilized to decide how the cost is computed.

Subcontract:

The following is an example of how to value a subcontract service in a production context:

  •  If the operation has a reference price, it is taken into account.
  •  If the valuation method is on the product site, the price of the valuation method is taken into account.
  •  Locate a price list.

If a price list cannot be identified, the standard cost might be used if the PURPRICE – Standard cost default price list option is set to 1. Yes.

The calculation procedure is systematically based on the validity start date of the cost to search the subcontracting service without Work Order and the provided material list prices offered by the subcontractor and to search the material list price and the choice of Bill Of Material components.

After the successful run of the Cost Simulation process the report ITMCOST will be printed that summarizes or details the results.

Reports
Fig03: Report (ITMCOST) summarizing results of Cost Simulation

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.