Skip Headers

Oracle In-Memory Cost Management for Process Industries User's Guide
Release Release 12.1
Part Number E52182-05
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Cost Simulations

Overview of Process Manufacturing Cost Impact Simulations

The In-Memory Cost Management Cost Impact Simulation tool provides a method to analyze the impact of cost variations in items, resources, overheads, and recipes on your enterprise. You can specify the new cost and review at all the impacted assemblies and subassemblies. This new cost is the simulated cost. For the impacted material and resources- you can view the current on hand, work in process, and in transit values compared with the simulated value. You can review summary to detailed data for each affected assembly, and view the indented cost structure in the detail page. In the View Detail page further cost changes can be made to material, material overhead, resources, overhead, outside processing, and resubmitted in the simulation program.

The Cost Impact Simulation page enables you to:

Oracle Hyperion Smart View uses data changes you input and executes one of several PL/SQL procedures depending on the simulation stage: validating, creating, or updating a simulation. After creating a simulation, you can see a summary view of assembly level cost data and an exploded detail view of indented cost data.

Related Topics

Connecting to Data Sources

Using the Member Selector

Modifying Cost Simulation Results

Creating Process Manufacturing Cost Simulations

Viewing Process Manufacturing Cost Simulation Summaries and Details

Purging Simulation Records

Using the Member Selector

The Member Selection dialog box enables you to select multiple values to display on the spreadsheet when searching for column values. Available values, or members, for the dimension selected appear in a tree.

To select multiple values on the spreadsheet

  1. Navigate to either the Cost Simulation or Cost Comparison worksheet.

  2. Place your cursor in the column for the associated value you want to search.

  3. Select Member Selection in the In-Memory Cost Management ribbon.

    The Member Selection dialog box appears.

  4. Click the Dimension Selector button to change the column.

    the picture is described in the document text

  5. In the drop-down menu, select the parameter or column type you are searching.

    The available values appear in a tree list.

  6. Enable the check boxes next to the values you want to enter on the spreadsheet.

  7. Select the Right-Arrow tool to move values to the Selection pane.

  8. Select OK to save your work.

    The values selected are displayed on the spreadsheet grid.

Creating Process Manufacturing Cost Simulations

The Cost Impact Simulation tool is also used to investigate the data contained in your cost structures in recipe ingredients, batches, and formulas within process manufacturing operations. You enter text or search for cost parameters, refresh the data entry, enter simulated costs, and submit the changes for the simulated rollup.

Note: Before performing any cost impact simulations, ensure that a standard cost rollup for the Calendar code in the period of the simulation can be performed.

Results can be analyzed in summary and detail pages. In the View Summary page, you can review the simulated and current cost of the impacted final products and intermediate products. In the View Detail page, you can review the indented cost structure of a particular impacted assembly and subassembly for the simulation.

Value Searching for Simulations

When searching for values for cost simulations - you can either enter search criteria and select Refresh to update the column values, or enter values in the required columns:

In both methods, the system calculates a simulation cost value with the new cost you supply. If you want to add subelements to the existing cost structure of an item or override its cost, you can enter a value for the particular entity.

Cost simulation records can be deleted from your system using the Purge Simulation concurrent request program, see: Purging Simulation Records

To enter cost parameters in the Cost Impact Simulation tool for Process Manufacturing

  1. Navigate to the Process Create Simulation worksheet.

    Note: In the In-Memory Cost Management product, Smart View always opens in a new active Excel worksheet.

  2. If you need to establish or change a connection to your data, select the Smart View Panel, see: Connecting to Data Sources

  3. Enter search parameters by entering values, or partial values and wild card characters in the required parameter columns including:

    These parameters have the same functions as parameters of the cost rollup, see: Running Standard Cost Rollup, Oracle Process Manufacturing Cost Management User's Guide.

    the picture is described in the document text

  4. You can filter your search by looking for values for Organization, Calendar, or Period.

  5. To select multiple values, choose Member Selection. The Member Selection dialog box appears for selecting from a large list of specific column type values. See: Using the Member Selector

  6. Depending on the search method selected, you will choose either Refresh or Simulate, see: Value Searching for Simulations

  7. If you choose Refresh, the corresponding data for the parameters selected appears.

    The Refresh function displays only user defined or defaulted costs for a particular entity. If no calendar and period are specified, the system identifies the period related to current system date and then refreshes data corresponding to that period.

    the picture is described in the document text

    The associated data displays in the rows of the spreadsheet including:

Launching a Simulation in the Process Create Simulation Smart View Spreadsheet

After entering cost changes in the Simulated Rate or Amount column, submit the changes for the simulated rollup. The procedure for launching the simulation uses only two Run Time Prompts in the simulation.

To launch a Process cost simulation

  1. After you select Refresh for searching data, enter cost changes in the Simulated Rate or Amount column.

  2. Select Simulate. The Calculation Script dialog box appears for entering calculation script values.

  3. Enter required values in the Simulation Code and Simulation Description prompts. The Simulation code can be an alphanumeric value less than or equal to 10 characters.

    the picture is described in the document text

  4. Select Launch to create the simulation.

  5. After creating the cost simulation, you can select the following functions in the In-Memory Cost Management ribbon:

Viewing Process Manufacturing Cost Simulation Summaries and Details

The Process View Summary page layout displays the unit cost summary information for product items and associated recipes, formulas, and resource usages.

To view Process Manufacturing cost simulation summaries

  1. Navigate to the Process View Summary page.

    The Summary page layout shows the finished goods costs in a summary format. You can view the summary of the unit costs and simulated costs displayed for comparison.

    the picture is described in the document text

    Note: This layout is view-only. You cannot modify any data in the summary layout.

    The information appears in the following columns:

  2. Select item rows and use the Zoom In tool (or double-click left mouse button) to display the View Detail page, and the Zoom Out tool (or double-click right mouse button) to return to the View Summary page.

To view cost simulation details

  1. Navigate to the Process View Details page. You can:

    the picture is described in the document text

  2. Information displays in the following columns:

Related Topics

Creating Process Manufacturing Cost Simulations

Modifying Cost Simulation Results

Modifying Cost Simulation Results

You can further test and update simulations from the results displaying on the View Detail page. You modify cost values and run the Simulation Calculation script again. The Update Simulation program:

To modify cost simulation details

  1. On the View Detail page for a cost simulation, select the costs you want to change.

    You can update the quantity, rate or amount, and unit cost for the following entities as shown in the following table:

    Entity Qty/Rate or Amount Unit Cost
    Component Yes No
    Resource Yes Yes
    Overhead No Yes
    Outside processing (OSP) Yes Yes
    Material No Yes
    Material Overhead No Yes
  2. Select Simulate to display the Update Simulation dialog box.

  3. Choose Launch.

  4. After the simulation successfully processes, choose Close.

    The View Detail page refreshes with values based on the new modified values entered.

Related Topics

Creating Cost Simulations, Oracle In-Memory Cost Management for Discrete Industries User's Guide

Creating Process Manufacturing Cost Simulations

Viewing Cost Simulation Summaries and Details, Oracle In-Memory Cost Management for Discrete Industries User's Guide

Viewing Process Manufacturing Cost Simulation Summaries and Details