Simulated Product Cost Tables

Simulated costs are generated using multiple tables in the JD Edwards EnterpriseOne system from Oracle. The Cost Simulation program sums the costs of all the components at each level of the bill of material of the parent item to arrive at a total cost for the parent item.

You can set the processing options in any of the cost simulation programs to specify the cost method that you want to use.

The Cost Simulation program uses information from these tables to generate costs:

Table Name	Description
Job Shop Manufacturing Constants (F3009)	Values from this table indicate whether overhead should be included in cost component calculations.
Work Center Rates (F30008)	Values from this table indicate the monetary amounts and percentages for the calculation of labor, machine, and overhead costs.
Routing Master (F3003)	This table stores the hours that are required for each operation, crew size, outside operation costs, and cumulative yield values.
Bill of Material Master (F3002)	This table provides information about the material that is required at each level of the bill.
Item Cost (F4105)	This table provides costs for purchased items and outside operations.
Item Cross Reference (F4104)	This table identifies the master routing.
Work Center Master (F30006)	This table provides the work center efficiency factor.
Item Master (F4101)	This table stores the low-level code. Costs are rolled up from the lowest level to the highest level.
Item Branch (F4102)	This table provides the accounting cost quantity.
Generic Message/Rates (F00191)	This table provides rates and factors for extra costs.
Item Cost Components Add-Ons (F30026)	This table provides the calculations for extra costs.