Cost Planning

Overview of Cost Planning

Oracle In-Memory Cost Planning enables you to quickly and easily organize your source of costs by targeting items, such as raw materials, resources, and overhead. Cost Planning also includes several allocation methods to define cost allocation strategy. You can upload and use demand forecasts and production plans to calculate future costs, margins, and profits You can define an enterprise-wide cost strategy and perform cost planning scenarios using Oracle Database 12c Database In-Memory Option for extreme performance in all types of database workloads. Cost Planning enables you to keep the manufacturing process profitable by:

Cost Planning models direct costs, overhead, and fixed costs by using allocation pools, allocation scopes, and allocation rules.

the picture is described in the document text

Cost Centers

A cost center represents the smallest segment of an organization where you collect and report costs. It represents the destination or function of an expense, rather than the nature of the expense which is represented by the account.

A cost center is generally attached to a single legal entity. To identify the cost centers within a chart of accounts structure use one of these two methods:

Cost Centers enable specific sites to track costs by designating certain parts of their organization as cost centers. For example, a company could set up several cost centers for each department that will be ordering supplies. The department is specified on each order, and the company can then track costs by department.

Allocations

Cost allocators enable manufacturers to set up and derive accurate product costs based on historical trends and external parameters.

Cost Plans

Cost plans perform the cost allocations defined by the allocation rules included in the cost plan. After generating the cost plan, you can use the new cost types created and run simulations based on these new cost types in the Cost Impact Simulator. The simulation enables you to use an estimated cost and check how the new estimate will impact the current production and profitability. You can:

Related Topics

Searching and Viewing Allocation Pools

Creating and Updating Allocation Pools

Searching and Viewing Allocation Scopes

Creating and Updating Allocation Scopes

Searching and Viewing Allocation Rules

Creating and Updating Allocation Rules

Searching and Viewing Cost Plans

Creating and Updating Cost Plans

Analyzing Specific Cost Plans

Searching and Viewing Allocation Pools

Material costs are typically estimated using historical transactions such as purchase orders and receipts. Overheads are captured and maintained as part of expense management and budgetary control systems and are incurred at various levels of the organization. To accurately allocate these costs, they are grouped into pools. In the cost plan, allocation pools group costs by similar categories such as products, resources, or overheads.

You have the option to search for allocation pools using a quick or advanced query:

To search for allocation pool records

  1. Navigate to the Allocation Pools page by choosing either the Discrete or Process application. A listing of records appears in the Allocation Pools column.

  2. Select a specific record; the details appear in the Header, Details, Allocation History, and Allocation Distribution sections of the page.

  3. For a Quick Query in the Search region—select either the Pool Name or Description, and enter a value.

  4. Select the Search icon to view the results of your query.

    Discrete Industries

    the picture is described in the document text

    Process Industries

    the picture is described in the document text

  5. You can filter the record display by entering search criteria in any of the unmarked or blank boxes preceding the columns in the header of the table. Press return to see the results of your query.

  6. Optionally, you can select Advanced to use additional criteria for the query on the Advanced search section of the page.

  7. In this search method, specify how to filter the results of your search criteria by choosing either to match All or Any of the fields listed.

  8. Enter values in the applicable fields for your search. The default values appearing on the page:

    • Pool Name

    • Description

    • Currency

    • Inactive Date

  9. For each search criteria value, select a conditional qualifier.

    Choices are: Starts with, Ends with, Equals, Does not equal, Less than, Less than or equal to, Greater than, Greater than or equal to , Between, Not between, Contains, Does not contain, Is blank, Is not blank.

  10. You can add search criteria and reorder the display of the search fields.

    The following fields are available for the Advanced search criteria:

    • Created by

    • Creation Date

    • Ledger

    • Source Type

    • Source System

    • Updated By

    • Updated Date

  11. Select Search to display the results of your search. The details appear in the Header, Details, Allocation History, and Allocation Distribution sections of the page.

To view allocation pool details

  1. Navigate to the Allocation Pools page for a specific record by choosing either the Discrete or Process application.

    The Header region shows specific information for this pool appearing in the following fields:

    • Pool Name: A unique identifier for the pool value

    • Description

    • Source System: Source for the general ledger accounts

    • Source Type: Category of the amount value such as Actual, Budget, or Ad hoc

    • Ledger: Corporate organization general ledger account

    • Currency: The primary currency of the general ledger associated with the allocation pool

    • Inactive Date: Date this record will no longer be active, if applicable.

    the picture is described in the document text

    Account information appears in the Details region of this page including:

    • Line Type and Description: General ledger source type for this line

    • Account From and To: General ledger account number range

    • Amount: Value of this line for this currency

    • Allocation: Percentage allocated

      Enabled: Indicates if this line is active

    The Allocation History region displays a list of the allocation transactions for this pool and details in the following fields:

    Discrete Industries Process Industries
    Plan Code and Description Plan Code and Description
    Plan Month Legal Entity
    Planned Allocation Plan Calendar
    Currency Code Plan Period
    - Planned Allocation
    - Currency

    Discrete Industries

    the picture is described in the document text

    Process Industries

    the picture is described in the document text

    The Allocation Distribution region shows graphic representations of the distribution percent of the cost of the items in the pool by:

    • Discrete: Organization and Subelements

    • Process: Organization, Cost Component Classes, and Analysis Codes

  2. You can navigate to the following pages by selecting:

    • Create to access the Create Allocation Pool page.

    • Update to access the Update Allocation Pool page.

    See: Creating and Updating Allocation Pools

Creating and Updating Allocation Pools

Allocation pools enable the grouping of costs to get an insight into how much is being spent. Combined with the margin analysis tools, allocation pools aid in cost savings and optimization. When creating allocation pools, you can use actual, budget, or ad hoc accounts.

To create an allocation pool

  1. Navigate to the Create Allocation Pool page by choosing either the Discrete or Process application.

  2. Enter a unique value in the Pool Name and descriptive text for this record in the Description field.

    the picture is described in the document text

  3. In the Source System field select a source for the general ledger accounts. Choices are:

    • E-Business Suite

    • ERP Cloud

    • JDE

    • PeopleSoft

    • Others

  4. In the Source type field select the general ledger source. The source type selected determines available Line Type values for the pool lines in the Details table region. Choices are:

    • Actual: If selected , only Actual journal lines for the accounts selected are used when the cost plan uses this allocation pool. You can only select Line Type as Account-Actual in the pool lines.

    • Budget: If selected , only Budget journal lines for the accounts selected are used when the cost plan uses this allocation pool. You can only select Line Type as Account-Budget in the pool lines.

    • Ad hoc: If selected, you can select Account - Actual, Account - Budget, and Manual amount types in the Line Type field. The cost plan considers the Actual or Budget journals accordingly for the Pool Lines when the allocation pool is used in the cost plan.

  5. Select the corporate organization general ledger account in the Ledger field.

    The Currency field displays the currency associated with this corporate organization general ledger account.

  6. You can select a date that this pool record will no longer be active in the Inactive Date field, if applicable.

  7. In the Details table region, select information to create pool lines in the following fields:

    • Line Type:

      • Actual, if selected then the Amount equals the Account subtracted from Actual.

      • Budget, if selected then Amount equals the Account subtracted from Budget.

      • Ad Hoc, all account types are available.

    • Description: Enter descriptive text for this amount type.

    • Account From and To: Select the range of GL accounts you are using for this pool. These fields are enabled when Amount Type is Account - Actual, or Account - Budget.

    • Amount: Define the currency amounts that are not maintained in GL Accounts. This field is enabled when the Line Type field value is Manual.

    • Allocation: The percentage for each pool line defined should be less than or equal to 100 percent.

    • Enabled: The default value for a pool line is enabled, but you can choose to enable or disabled a specific pool line.

  8. Save your work.

To update and edit an allocation pool record

  1. Navigate to the Update Allocation Pool page for a particular record.

  2. In the Header region, you have the option to update the following fields:

    • Pool Name

    • Description

    • Source System

    • Source Type

    • Ledger

    • Inactive Date

    Note: The Currency field displays the primary currency for the general ledger associated with the allocation pool.

    the picture is described in the document text

  3. In the Details region, enter changes or additions for the pool lines including:

    • Line Type associated with the Source Type value of the record

    • Description

    • Account From and To ranges

    • Currency

    • Allocation percentage

    • Enabled

  4. Save your work.

Searching and Viewing Allocation Scopes

Allocation scopes let you identify the target items, resources and overheads used in calculating costs. The scope groups these items, resources and overheads and enables you to create various business scenarios for products. An unlimited number of scopes can be defined for different purposes.

You have the option to search for allocation scopes using a quick or advanced query:

To search and view allocation scopes

  1. Navigate to the Allocation Scopes page by choosing either the Discrete or Process application.

    A listing of records appears in the Allocation Scopes column. The details for a selected record appear in the Header, Attributes, and Scope Members sections of the page.

  2. For a Quick Query in the Search region—select either Name or Description, and enter a value.

  3. Select the Search icon to view the results of your query.

    the picture is described in the document text

  4. You can filter the record display by entering search criteria in any of the unmarked or blank boxes preceding the columns in the header of the table. Press return to see the results of your query.

  5. Optionally, you can select Advanced to use additional criteria for the query on the Advanced search section of the page.

  6. In this search method, specify how to filter the results of your search criteria by choosing either to match All or Any of the fields listed.

  7. Enter values in the applicable fields for your search. The default values appearing on the page are the following:

    • Name

    • Description

    • Status

  8. For each search criteria value, select a conditional qualifier.

    Choices are: Starts with, Ends with, Equals, Does not equal, Less than, Less than or equal to, Greater than, Greater than or equal to, Between, Not between, Contains, Does not contain, Is blank, Is not blank.

  9. Enter a value for any of the following fields:

    • Created By

    • Error Message

    • Inactive Date

    • Type

    • Legal Entity (for Process application)

    • Unit of Measure

    • Updated By

  10. Select Search to display the results of your search. The details appear in the Header, Attributes, and Scope Members sections of the page.

To view details of an allocation scope record

  1. Navigate to the Allocation Scopes page by choosing either the Discrete or Process application and selecting a specific record.

    In the Header region, specific information for this scope appears in the following fields:

    • Name: A unique value for this scope record

    • Description

    • Type: Choices are: Item, Resource, or Overhead

    • Legal Entity (for Process application): Corporation, partnership for a legal construct

    • Unit of Measure

    • Inactive Date: The date that this scope record will no longer be active, if applicable.

    • Status: The values available are Error, Validation in Progress, and Validated.

      The value is Draft when creating or updating the plan.

    the picture is described in the document text

    In the Attributes region, information on Attribute Type in the range of From and To Values appears. This table shows both the included and excluded attribute values.

    In the Scope Members region, individual components of the scope members display for the selected attribute in the Attributes region:

    • Discrete Industries: Item, Description, Organization, Primary Unit of Measure, Conversion Rate.

    • Process Industries: Resource, Description, Organization, Primary Unit of Measure, Conversion Rate.

    Discrete Industries

    the picture is described in the document text

    Process Industries

    the picture is described in the document text

  2. You have the option to select:

    • Validate to run the Validate Cost Planning Scopes background process.

      This program checks if the products, resources, and overheads included in the scope have the unit of measure conversion defined. When the scope is validated, you can review the actual products, resources, and overheads finalized as this scope.

      The value is Draft when creating or updating the plan. Other values are Error, Validation in Progress, or Validated

      You can export these details to a spreadsheet, see: Background Processes

    • Create to navigate to the Create Allocation Scope page.

    • Update to navigate to the Update Allocation Scope page.

    See: Creating and Updating Allocation Scopes

Creating and Updating Allocation Scopes

Cost accountants can run different scopes to analyze identified costs and trends for production. These costs are recorded in the general ledger.

To create an allocation scope

  1. Navigate to the Create Allocation Scope page by choosing either the Discrete or Process application.

  2. In the Header region, enter the following values:

    • Name: A unique value for this scope record.

    • Description

    • Legal Entity (for Process application): Corporation, partnership for a legal construct.

    • Inactive Date: A date that this scope record will no longer be active, if applicable.

    • Unit of Measure

    • Type: Choices are: Item, Resource, or Overhead

    In the Status field, the value is Draft, when creating or updating the plan:

    • When you select Validate, the system generates the Validate Cost Planning Scopes background process and the status becomes Validation in Progress.

    • Once validation is completed based on the result, the status is either Validated or Error (if there are issues).

    the picture is described in the document text

  3. In the Attributes table region, select the following values:

    • Attribute Type

    • Include Values, From and To Value range

    • Exclude Values, From and To Value range

    Depending on the Scope Type value selected in the Header section, the following table shows the choices available for each attribute type:

    Discrete Industries
    Item Overhead Resource
    Cost Group Cost Type Cost Type
    Cost Subelement Department Department
    Cost Type Organization Organization
    Item Overhead Resource
    Item Category WIP Accounting Class Resource Group
    Organization - WIP Accounting Class
    Project - -
    Subinventory - -
    Task - -
    Process Industries
    Item Resource
    Analysis Code Analysis Code
    Component Class Code Component Class Code
    Cost Type Cost Type
    Item Organization
    Item Category Resource
    Organization Resource Class
    Subinventory -
  4. Save your work.

  5. Select Validate to run the Validate Cost Planning Scopes background process.

    This program checks if the products, resources, and overheads included in the scope have the unit of measure conversion defined. When the scope is validated, you can review the actual products, resources, and overheads finalized as this scope.

    If the scope validation fails or does not process, you can see the status and errors in the Completion Text field on the Background Process page: see: Background Process Errors

    You can export these details to a spreadsheet, see: Background Processes

To update and edit an allocation scope record

  1. Navigate to the Update Allocation Scope page for a particular record by choosing either the Discrete or Process application.

  2. In the Header region, you have the option to update the following fields:

    • Scope Name

    • Description

    • Legal Entity (for Process application)

    • Unit of Measure

    • Inactive Date

    • Type

    Status: The value is Draft, when creating or updating the plan.

    the picture is described in the document text

  3. In the Attributes table region, select the following values:

    • Attribute Type

    • Include Values, From and To Value range

    • Exclude Values, From and To Value range

  4. Save your work.

  5. Select Validate to run the Validate Cost Planning Scopes background process. This program checks if the products, resources, and overheads included in the scope have the unit of measure conversion defined. When the scope is validated, you can review the actual products, resources, and overheads finalized as this scope.

    If the scope validation fails or does not process, you can see the status and errors in the Completion Text field on the Background Process page: see: Background Process Errors

    You can export these details to a spreadsheet, see: Background Processes

Searching and Viewing Allocation Rules

Allocation rules are used to define the cost calculation method for your cost plan. The rule sets the allocation pool, scope, driver, and cost elements or component class and analysis codes in a plan.

You have the option to search for allocation rules using a quick or advanced query:

To search for and view allocation rules

  1. Navigate to the Allocation Rules page by choosing either the Discrete or Process application.

    A listing of records appears in the table.

  2. For a Quick Query in the Search region—select either Name or Description, and enter a value.

  3. Select the Search icon to view the results of your query.

  4. Optionally, you can select Advanced to use additional criteria for the query on the Advanced search section of the page.

  5. In this search method, specify how to filter the results of your search criteria by choosing either to match All or Any of the fields listed.

  6. Enter values in the applicable fields for your search. The default values appearing on the page are the following:

    • Name

    • Description

    • Cost Element (for Discrete application)

    • Subelement (for Discrete application)

    • Inactive Date

  7. For each search criteria value, select a conditional qualifier.

    Choices are: Starts with, Ends with, Equals, Does not equal, Less than, Less than or equal to, Greater than, Greater than or equal to , Between, Not between, Contains, Does not contain, Is blank, Is not blank.

  8. Enter a value for any of the following fields:

    Discrete Process
    Allocation % Allocation %
    Basis Type Analysis Code
    Classification Classification
    - Component Class Code
    Driver Driver
    Driver Plan Driver Plan
    Driver Plan Type Driver Plan Type
    Function Function
  9. Select Search to display the results of your search. The details of your records appear in the following fields for Discrete and Process applications.

    Discrete application fields are:

    • Name and Description: The unique name for this record and descriptive text.

    • Cost Element: The choices set up in your general ledger.

    • Subelement: Mandatory field for some cost elements.

    • Allocation: Percent allocation if this rule is associated with an allocation pool.

    • Enabled

    Discrete Industries

    the picture is described in the document text

    Process application fields are:

    • Name and Description

    • Legal Entity

    • Usage Type

    • Component Class Code

    • Analysis Code

    • Allocation Percentage

    • Enabled

    Process Industries

    the picture is described in the document text

  10. Select a record to view details of a particular rule. Information for this record appears in the following fields:

    • Classification

    • Basis Type (for Discrete)

    • Scope

    • Scope Type

    • Pool

    • Pool Type

    • Inactive Date

    • Allocation Percentage

      Note: The allocation percentage value is applicable only for the rules associated to a pool.

    the picture is described in the document text

    The Cost Driver section of the details region shows information in the following fields:

    • Driver: Cost basis used to allocate costs to product.

    • Function: Choices are Average, First, Last, Maximum, Minimum.

    • Driver Plan

    • Driver Plan Type: This value is dependent on the cost driver selected.

    • Unit Cost Method: Choices are Average, First, Last, Maximum, Minimum.

    • Unit Cost Plan

    • Price List

  11. You can navigate to the following pages by selecting:

Managing Fixed Costs and Fixed Codes

You can edit fixed cost subelements, fixed component class codes, and fixed analysis codes within In-Memory Cost Management Cloud Service without having to navigate outside of the application.

To manage fixed cost subelements

  1. Navigate to the Allocation Rules page for Discrete products and select Edit Fixed Costs.

    The Manage Fixed Cost Subelements dialog window appears.

  2. You can perform the following tasks to maintain fixed cost subelements:

    • Add—select the Add Row icon to create a new record. Enter values in the Code, Name, and Description fields in the new row.

    • Change—select a record to change information. Enter the applicable information in the Code, Name, and Description fields of the row.

    • Delete—select rows and select the Delete selected rows icon.

    the picture is described in the document text

  3. Save your work.

To manage fixed component class codes

  1. Navigate to the Allocation Rules page for Process products and select Edit Fixed Component Class Codes.

    The Manage Fixed Component Class Codes dialog window appears.

  2. You can perform the following tasks to maintain fixed component class codes:

    • Add—select the Add Row icon to create a new record. Enter values in the Code, Name, and Description fields in the new row.

    • Change—select a record to change information. Enter the applicable information in the Code, Name, and Description fields of the row.

    • Delete—select rows and select the Delete selected rows icon.

    the picture is described in the document text

  3. Save your work.

To manage fixed analysis codes

  1. Navigate to the Allocation Rules page for Process products and select Edit Fixed Analysis Codes

    The Manage Fixed Analysis Codes dialog window appears.

  2. You can perform the following tasks to maintain fixed component class codes:

    • Add—select Add Row icon to create a new record. Enter values in the Code, Name, and Description fields in the new row.

    • Change—select a record to change information. Enter the applicable information in the Code, Name, and Description fields of the row.

    • Delete—select rows and select the Delete selected rows icon.

    the picture is described in the document text

  3. Save your work.

Creating and Updating Allocation Rules

The allocation rule defines the allocation details including cost elements, default allocation pool, default scope, and cost driver. A cost plan can have multiple allocation rules to use in various scenarios.

To create an allocation rule for the Discrete application

  1. Navigate to the Create Allocation Rule page by selecting the Discrete application.

    the picture is described in the document text

  2. In the Allocation Rule region, enter information in the following fields:

    • Name: Enter a unique value.

    • Cost Element, choices are:

      • Fixed Cost

      • Material

      • Material Overhead

      • Outside Processing (Non Routing)

      • Outside Processing (Routing)

      • Overhead (Non Routing)

      • Overhead (Routing)

      • Resource (Non Routing)

      • Resource (Routing)

      Note: Routing Versus Non Routing Cost Elements

      • Routing: Planning for the resource rate or overhead rate which will be used when rolling up the cost for items, using their respective routings.

      • Non Routing: The cost plan is going to directly calculate the cost for the items being planned in the scope.

    • Scope: Select an allocation scope record to use as a default in this rule.

    • Pool: Select an allocation pool record to use as a default in this rule.

    • Description: Enter descriptive text related to this rule.

    • Subelement: The subelement is a mandatory field for all cost elements except the following: Resource (Routing), Overhead (Routing), and Outside Processing (Routing). In these cases the field is disabled.

    • Basis Type, choices are:

      • For Material Overhead cost element—Item, Lot, Resource Units, Resource Value, Total Value.

      • All other cost elements: Item or Lot.

      This field is disabled for Resource (Routing), Overhead (Routing) and Outside Processing (Routing) cost elements.

    • Allocation %: Enter the percentage amount allocated by the pool. The default value is 100. This field is only applicable for the rules associated to a pool.

    • Inactive Date: Select a date this rule will no longer be active, if applicable.

    • Classification, Scope Type, and Pool Type field values are derived from the cost element selection.

      In the Classification field, if the cost element is Fixed the classification is Fixed. For all other cost elements the classification is Variable.

  3. Select values in the Cost Driver region to specify the method to apportion amounts or expenses chosen in the pool and applied to the members in the scope.

    Scope members can be items, resources, and overheads. Depending on the Driver value selected, certain fields are enabled or disabled.

    • Driver, choices are:

      • If the default Allocation Pool is null—the choices are Invoice, Landed Cost, Price List, Purchase Order, Quote, or Receipt.

      • If the default Allocation Pool is provided—the cost driver choices are Volume, Value, Contribution Margin, Planned Volume, Planned Value, and Planned Contribution Margin.

    • Unit Cost Method—choices are Planned or Average Volume.

    • Function—choices are Average, First, Last, Maximum, or Minimum.

    • Unit Cost Plan—the value in the Unit Cost Method field determines plans successfully imported into Cost Planning.

    • Driver Plan—this value is imported after you run the Import Supply/Demand for Cost Planning process.

      This field is enabled only for cost drivers Planned Volume, Planned Value, and Planned Contribution Margin.

    • Cost Driver Plan Type—Three different plan types are supported dependent on the cost driver selected including: Procurement, Production, and Demand.

    • Price List—Imported records when the driver is a price list.

  4. Save your work.

To create an allocation rule for the Process application

  1. Navigate to the Create Allocation Rule page by selecting the Process application.

    the picture is described in the document text

  2. In the Allocation Rule region, enter information in the following fields:

    • Name: Enter a unique value.

    • Usage Type, choices are:

      • Fixed Cost

      • Material

      • Overhead

      • Resource

      • Standard Cost Adjustment

    • Legal Entity: Corporation, partnership for a legal construct.

    • Pool: Select an allocation pool record to use as a default in this rule.

    • Description: Enter descriptive text related to this rule.

    • Component Class Code: Identifies the cost component class associated to the item cost record

    • Scope: Select an allocation scope record to use as a default in this rule.

    • Allocation %: Enter the percentage amount allocated by the pool. The default value is 100. This field is only applicable for the rules associated to a pool.

    • Analysis Code: Codes used to group component costs from multiple cost component class types.

    • Inactive Date: Select a date this rule will no longer be active, if applicable.

    • Classification, Scope Type, and Pool Type field values are derived from the cost element selection.

      In the Classification field, if the usage type is Fixed Cost, the classification is Fixed. For all other usage types the classification is Variable.

  3. Select values in the Cost Driver region to specify the method to apportion costs chosen in the pool and applied to the members in the scope.

    Scope members can be products, resources, and overheads. Depending on the Driver value selected, certain fields are enabled or disabled.

    • Driver, choices are:

      • If the default Allocation Pool is null—the choices are Invoice, Landed Cost, Price List, Purchase Order, Quote, or Receipt.

      • If the default Allocation Pool is provided—the cost driver choices are Volume, Value, Contribution Margin, Planned Volume, Planned Value, and Planned Contribution Margin.

    • Unit Cost Method—choices are Planned or Average Volume.

    • Function—choices are Average, First, Last, Maximum, or Minimum.

    • Unit Cost Plan—the value in the Unit Cost Method field determines plans successfully imported into Cost Planning.

    • Driver Plan—this value is imported after you run the Import Supply/Demand for Cost Planning process.

      This field is enabled only for cost drivers Planned Volume, Planned Value, and Planned Contribution Margin.

    • Cost Driver Plan Type—Three different plan types are supported dependent on the cost driver selected including: Procurement, Production, and Demand.

    • Price List—Imported records when the driver is a price list.

  4. Save your work.

To update an allocation rule

  1. Navigate to the Update Allocation Rule page for a selected record.

  2. Enter your appropriate updates.

    Most fields for an existing allocation rule can be updated, but various fields are dependent on values entered in other fields.

    Classification, Pool, and Scope Type fields cannot be edited.

    the picture is described in the document text

  3. Save your work.

Searching and Viewing Cost Plans

Cost plans are used to create the allocations defined by the rules included in the cost plan. New cost types are created after generating a new cost plan. Cost types are used in simulations enabling you to use estimated costs and check how it impacts the current production and profitability.

You have the option to search for cost plans using a quick or advanced query:

To search for cost plans

  1. Navigate to the Cost Plans page by choosing either the Discrete or Process application.

    A list of existing cost plans appears in a table on the page.

  2. For a Quick Query in the Search region select one of the fields and enter a value:

    • Plan Code

    • Description

    • Legal Entity (for Process)

    • Status

  3. Select the Search icon to view the results of your query.

  4. Optionally, you can select Advanced to use additional criteria for the query on the Advanced search section of the page.

  5. In this search method, specify how to filter the results of your search criteria by choosing either to match All or Any of the fields listed.

  6. Enter values in the applicable fields for your search.

    Discrete Process
    - Plan Calendar
    From and To Month From and To Period
    Basis Cost Type Basis Cost Type
    - Basis Calendar
    - Basis Period
    Currency Currency
    Plan Date Plan Date
  7. For each search criteria value, select a conditional qualifier. Choices are: Starts with, Ends with, Equals, Does not equal, Less than, Less than or equal to, Greater than, Greater than or equal to, Between, Not between, Contains, Does not contain, Is blank, Is not blank.

  8. Select Search to display the results of your search in the table.

To view cost plan search results

  1. Navigate to the Cost Plans page by choosing either the Discrete or Process application.

    A listing of current cost plans appears in a table.

    Discrete Industries

    the picture is described in the document text

    The following values appear for the Discrete application:

    • Plan Code: Unique value created for the cost plan.

    • Description of the cost plan.

    • From and To Month: Time period range for the cost plan.

    • Basis Cost Type: Planned costs are derived from the basis cost type.

    • Currency for the plan as defined in the ledger.

    • Plan Date: Date and time the previous cost plan completed its run.

    • Status: The following values are system generated after the plan is launched: Submitted, Running, Error, or Finished values—depending on the plan execution phase and results.

    Note: If the In-Memory Cost Planning Engine program does not process, you can view errors in the Completion Text field on the Background Process page, see: Background Process Errors

    Process Industries

    the picture is described in the document text

    The following values appear for the Process application:

    • Plan Code: Unique value created for the cost plan.

    • Description of the cost plan.

    • Legal Entity: Corporation, partnership for a legal construct.

    • Basis Calendar: Name of cost calendar defined for the resource costs for the legal entity.

    • Basis Period: Period defined for the named basis calendar.

    • Basis Cost Type: Used to apply activity costs to items.

    • Plan Calendar

    • From and To Period

    • Currency for the plan as defined in the ledger.

    • Plan Date: Date and time the previous cost plan completed its run.

    • Status: The following values are system generated after the plan is launched: Submitted, Running, Error, or Finished values—depending on the plan execution phase and results.

    Note: If the In-Memory Cost Planning Engine program does not process, you can view errors in the Completion Text field on the Background Process page, see: Background Process Errors

  2. On this page you can navigate to the following pages by selecting:

    • A specific Plan Code record to navigate to the Analyze Cost Plan page, see: Analyzing Specific Cost Plans

    • Create to access the Create Cost Plan page to create a new cost plan.

    • A cost plan record and choose Update to access the Update Cost Plan page.

    • A cost plan record and choose Copy to create a new plan using any of the details of this plan. You are required to replace Cost Plan and Basis Cost Type fields with new values.

    See: Creating and Updating Cost Plans

  3. Select a record and choose Launch to run the In-Memory Cost Planning Engine background process to execute the cost plan.

    See: Background Processes

Creating and Updating Cost Plans

When creating and updating cost plans, the following components are used in the calculations:

You can choose multiple allocation rules for particular plan periods, enabling the plan to be used across organizations. For example, you can include the following values in your allocation rules:

To create a new allocation cost plan for the Discrete application

  1. Navigate to the Create Cost Plan page by choosing the Discrete application.

  2. In the Plan Header region of the page, enter values in the following fields:

    • Plan Code: A unique value for this plan. This code can be used to compare plans or treated as a separate cost type.

    • Description: Descriptive text for this plan.

    • Basis Cost Type: This basis type is used to determine how the overhead cost is earned and how it is applied to product costs.

      Costs are defined in Oracle Cost Management. See: Defining Item Costs, Oracle Cost Management User's Guide. When the plan runs, it uses the existing cost types to store the planned costs, and creates new basis cost types.

    • Currency, Currency Conversion Type, and Currency Conversion Date: : The values for currency for the plan and the daily rate are defined in the ledger. These values are automatically converted into the conversion type.

    • From and To Month: Values in these fields define the time period range for the cost plan

    • Status: Values are system generated. This record is in Draft status when creating or updating the plan.

    the picture is described in the document text

  3. Use the Options region to add additional information depending upon how you set up the items in Oracle Manufacturing, including the Planning, Bills of Material, Configurator, and Inventory products. These fields are used in the cost rollup and include:

    • Assignment Set: A group of sourcing rules for items whose replenishment they control.

    • Buy Cost Type: Costs are summed into this level of material cost for assignment sets.

    • Lot Size Option

    • Lot Size Setting

    • Include Unimplemented ECOs

    • Include Engineering Bills

    • Include Configs with Closed Orders

    • Config Order Start Date

    • Alternate Bill

    • Alternate Routing

    • Effective Date

  4. In the Plan Rules region, select values in the Rule and Scope fields.

    You can choose multiple allocation rules for a given plan period, enabling the plan to be used across organizations.

  5. For rules associated to a pool, select values in the Allocation section of the table and specify a percentage of dollars absorbed by the plan:

    • Pool

    • Allocation Percentage

    • From and To Date ranges

    • Driver, in this section enter:

      • From and To Date ranges values for this rule.

      • Mark Up Percentage: Provide a mark up percent for calculating the impact of inflation.

    the picture is described in the document text

  6. Save your work.

  7. Choose Launch to run the In-Memory Cost Planning Engine background process to execute the cost plan. See: Background Processes

To create a new allocation cost plan for the Process application

  1. Navigate to the Create Cost Plan page by choosing the Process application.

  2. In the Plan Header region of the page, enter values in the following fields:

    • Plan Code: A unique value for this plan. This code can be used to compare plans or treated as a separate cost type.

    • Description: Descriptive text for this plan.

    • Legal Entity: Corporation, partnership for a legal construct.

    • Basis Calendar: Name of cost calendar defined for the resource costs for the legal entity.

    • Basis Period: Period defined for the named basis calendar.

    • Basis Cost Type: This basis type is used to determine how the overhead cost is earned and how it is applied to product costs.

      Costs are defined in Oracle Cost Management. See: Defining Item Costs, Oracle Cost Management User's Guide. When the plan runs, it uses the existing cost types to store the planned costs, and creates new basis cost types.

    • Plan Calendar, and From Period and To Period

    • Currency, Currency Conversion Type, and Currency Conversion Date: : The values for currency for the plan and the daily rate are defined in the ledger. These values are automatically converted into the conversion type.

    • Status: Values are system generated. This record is in Draft status when creating or updating the plan.

    the picture is described in the document text

  3. In the Plan Rules region, select values in the Rule and Scope fields.

    You can choose multiple allocation rules for a given plan period, enabling the plan to be used across organizations.

  4. For rules associated to a pool, select values in the Allocation section of the table and specify a percentage of dollars absorbed by the plan:

    • Pool

    • Allocation Percentage

    • From and To Date ranges

    • Driver, in this section enter:

      • From and To Date ranges values for this rule.

      • Mark Up Percentage: Provide a mark up percent for calculating the impact of inflation.

  5. Save your work.

  6. Choose Launch to run the In-Memory Cost Planning Engine background process to execute the cost plan. See: Background Processes

To create a new cost plan from an existing record

  1. Navigate to the Cost Plans page and select the record you want to duplicate.

  2. Choose Copy.

    The Create Cost Plan page appears with details of this existing plan with the exception of several fields.

  3. Enter new values in the existing plan:

    • Discrete: Enter a new value in the Cost Plan field.

      You can also change any of the other fields on this record.

    • Process: Enter new values in the Plan Code, Description, Basis Cost Type, and From and To Period fields.

      You can also change any of the other fields on this record.

    Status values are system generated. This record is in Draft status when creating or updating the plan.

  4. Save your work to create a new cost plan.

  5. Choose Launch to run the In-Memory Cost Planning Engine background process to execute the cost plan. See: Background Processes

To update an existing cost plan

  1. Select a cost plan record and navigate to the Update Cost Plan page.

  2. Update or change any of the fields in this cost plan record according to your specific requirements.

    Status values are system generated. This record is in Draft status when creating or updating the plan.

    the picture is described in the document text

  3. Save your work.

  4. Choose Launch to run the In-Memory Cost Planning Engine background process for the updated cost plan. See: Background Processes

Analyzing Specific Cost Plans

The Analyze Cost Plan page shows all the elements included in a specific cost plan and enables you to examine direct and indirect costs for this plan. When a cost plan is setup, this page enables you to navigate to both the Plan Organization Summary worksheet and Gross Profit Analyzer dashboard for the details of the plan's calculations. The page is divided into several regions: Plan Header and and Rules where you can view your setup for costs from expenses incurred in the supply chain for purchased parts and corresponding monthly or period details.

To review a specific Discrete cost plan

  1. Navigate to the Cost Plans page by choosing Discrete, and select a cost plan.

    The Analyze Cost Plan page appears.

    Note: The plan status must be Finished in order to render this page.

    • The Plan Header region of the page shows the following fields: Plan Code, Description, Basis Cost Type, Currency, Currency Conversion Type, Currency Conversion Date, and From and To Month.

    • The Options section shows additional information depending on Oracle Manufacturing and is used in the cost rollup. The fields are Assignment Set, Buy Cost Type, Lot Size Option, Lot Size Setting, Include Unimplemented ECOs, Include Engineering Bills, Include Configs with Closed Orders, Config Order Start Date, Alternate Bill, Alternate Routing, and Effective Date.

      See: Creating and Updating Cost Plans

    the picture is described in the document text

  2. The Rules region shows all rules created for a particular plan. Select the rule you want to view, and the details appear in the detail panel. The following sections appear in the panel:

    • Pool details appear if the rule is associated to a pool including pool name, active dates, and allocation percent for the rule.

    • Driver details appear if the a driver is attached to a rule including Name, Function and active dates.

    • Rule details including Unit Cost Method, Unit Cost Plan, Driver Plan, Classification, Basis Type, Price List, and Markup percentage.

    • Items or Resources section, depending on the scope type selected for this rule including Item, Description, Organization, Allocated Amount, Driver Value, Unit of Measure, Standard Lot Size, and Currency.

    • Monthly Details of this plan including Plan Month, Cost Type, Allocated Amount, Markup percentage, Period Quantity, Allocated Cost, Unit Cost, Total Item Cost, Rate or Amount, and Lot Size.

    the picture is described in the document text

    the picture is described in the document text

  3. Select the Spreadsheet icon in the Monthly Details section to navigate to the Plan Item Detail worksheet for this plan, see Plan Item Summary and Details

  4. Select a value in the Actions box to submit background processes, or to navigate to the Simulation worksheet or Gross Profit Analyzer dashboard. Choices are:

    • Calculate Actuals: Launches the Calculate Actual COGM (Discrete) to calculate the actual cost of goods manufactured for a given cost plan, see: Background Processes

    • Calculate Profitability: Launches the Margin Load for Plan program that estimates the excess income over expenditures for the plan, see: Incremental Margin Load Programs

    • Analyze COGM: Navigates to the Plan Organization Summary page. Select a production plan for this action. When you access this worksheet, you can Zoom In to the details of the plan, make changes, and launch a cost simulation. See: Plan Organization Summary

    • Analyze Profitability: Navigates to the Gross Profit Analysis dashboard, which examines the profit received from the cost of the product, see: Overview of Analyzing Gross Profits

  5. After selecting an action, choose Go.

  6. Select Update to navigate to the Update Cost Plan page to make any changes for your plan, see: Creating and Updating Cost Plans

To review a specific Process cost plan

  1. Navigate to the Cost Plans page by choosing Process, and select a cost plan.

    The Analyze Cost Plan page appears.

    Note: The plan status must be Finished in order to render this page.

    The Plan Header region of the page shows the following fields: Plan Code, Description, Legal Entity, Plan Date, Basis Calendar, Basis Period, Basis Cost Type, Status, Plan Calendar, From and To Period, Currency, Currency Conversion Type, and Currency Conversion Date.

    the picture is described in the document text

  2. The Rules region shows all rules created for a particular plan. Select the rule you want to view, and the details appear in the detail panel. The following sections appear in the panel:

    • Pool details if the rule is associated to a pool including pool name, active dates, and allocation percent for the rule.

    • Driver details appear if the a driver is attached to a rule including Name, Function and active dates..

    • Rule details including Unit Cost Method, Unit Cost Plan, Driver Plan, Classification, Basis Type, Price List, and Markup percentage.

    • Items or Resources section, depending on the scope type selected for this rule including Resource name, Description, Organization, Allocated Amount, Driver Value, Unit of Measure, and Currency.

    the picture is described in the document text

    The Period Wise Details region show Plan Calendar, Plan Period, Cost Type, Allocated Amount, Markup percentage, Default Component Class Code, and Rate.

    the picture is described in the document text

  3. Select the Spreadsheet icon to navigate to the Plan Item Detail worksheet for this plan, see Plan Item Summary and Details

  4. Select a value in the Actions box to submit background processes, or to navigate to the Simulation worksheet or Gross Profit Analyzer dashboard. Choices are:

    • Calculate Actuals: Launches the Calculate Actual COGM (Discrete) to calculate +the actual cost of goods manufactured for a given cost plan, see: Background Processes

    • Calculate Profitability: Launches the Margin Load for Plan program that estimates the excess income over expenditures for the plan, see: Incremental Margin Load Programs

    • Analyze COGM: Navigates to the Plan Organization Summary page. Select a production plan for this action. When you access this worksheet, you can Zoom In to the details of the plan, make changes, and launch a cost simulation. See: Plan Organization Summary

    • Analyze Profitability: Navigates to the Gross Profit Analysis dashboard, which examines the profit received from the cost of the product, see: Overview of Analyzing Gross Profits

  5. After selecting an action, choose Go.

  6. Select Update to navigate to the Update Cost Plan page to make any changes for your plan, see: Creating and Updating Cost Plans