Enter Item Costs

Use the Item Cost Maintenance (ICM) program to enter and change item costs per branch in base currency. See Background and Road Map for more information.

Enter the number of the item or click the Lookup icon and use the standard lookup options to select the item from a list. The item's description and stocking unit of measure are displayed for information.

The program displays these fields for the branches that you have access to and that stock this item. All costs are entered and displayed in the base currency:

Field Name	Displays
Br	The branch
Standard cost	The standard cost in base currency per stocking unit of measure Note Zero until you run the Standard Cost Rollup (MCR) program to roll up manufacturing and purchasing costs to calculate the standard costs
Base year cost	The baseline cost you can compare with other costs
Average cost	The average unit cost in base currency
Actual cost	The most recent unit cost in base currency
Last CRU dt	The date of the last cost rollup for this item, or, if the item's costs have not been rolled up, the date the item was added

Select the branch you want to display and click Select. The program displays these header fields across the screen:

Item number
Item description
Stocking unit of measure
Branch
* Excluded from cost roll * is displayed if the item's status indicates that its costs are not to be rolled up

The program displays the breakdown of the item's cost (zero until you run the Standard Cost Rollup (MCR) program to roll up manufacturing and purchasing costs to calculate the standard costs):

Field Name	Displays
Material	Total cost of the raw material and components that make up this item
Setup	Setup portion of the work performed to manufacture this item, including setup costs for lower level subassemblies
Run	Run portion of the work performed to manufacture this item, including run costs for lower level subassemblies
Labor total	Total of setup and run for the work performed to manufacture this item including total labor costs for lower level subassemblies.
Overhead	Total cost incurred in the operation of the business that are applied to this item
Service	Total cost of outside services incurred in the manufacture of this item
Total unit cost	The sum of material, labor, overhead, and service costs (standard cost). The total unit cost: Material + Labor + Overhead + Service

Enter or change data in the following fields:

Field Name

Type / Max Length

Action / Description

Cost differential

Optional
14 numeric in the format 999999999.99999

Enter a cost differential that your company uses. This field is not used by the system, but you can use it in custom reports.

Loaded cost

Optional
14 numeric in the format 999999999.99999

Enter a cost that includes the item cost (actual or average) plus an adjustment, such as a percent of overhead. You can use loaded cost as a basis for pricing in the Price-Contract Maintenance (PCM) program.

An option in the Indented Cost Report (MIC) program enables you to replace the incremental material cost with this value for cost simulations.

The system does not maintain loaded cost.

Base year cost

Optional
14 numeric in the format 999999999.99999

Enter the baseline cost you can compare with other costs.

An option in the Indented Cost Report program enables you to replace the incremental material cost with this value for cost simulations.

You can use the Base Year Cost Update (IBCU) program to update this field automatically.

User defined cost

Optional
14 numeric in the format 999999999.99999

Enter a cost that your company tracks.

An option in the Indented Cost Report program enables you to replace the incremental material cost with this value for cost simulations.

The system does not maintain user defined cost.

First rcvd cost

Optional
14 numeric in the format 999999999.99999

Enter the cost of the first unit you received. This field is not used by the system, but you can use it in custom reports.

First rcvd date

Optional
10 date

Select the date on which you received the first unit or enter a date shortcut. This field is not used by the system, but you can use it in custom reports

Average cost

Display only

Displays the average unit cost of the item.

If you selected the Update actual and average costs? option (in System Options Maintenance - Inventory Control Options), the system updates this field.

If you did not select the Update actual and average costs? option, click Other cost to update this field manually.

See Background for how the system calculates average cost.

Actual cost

Display only

Displays the most recent unit cost of the item.

If you selected the Update actual and average costs? option in the in System Options Maintenance - Inventory Control Options, the Receiver Maintenance or Receiving and Inspection program updates this field for purchased items. For manufactured items, the Manufacturing Order Close program updates this field.

If you did not select the Update actual and average costs? option, click Other cost to update this field manually.

See Background for more information.

Declared value

Display only

The item's declared value for shipping purposes.

Click Other cost to update this field manually.

Purch taxable?

Optional

Select if you want newly-entered purchase order lines to default to "taxable"

Incr matl cost

Optional
14 numeric in the format 999999999.99999

For a component, enter the material cost incurred at this item's level of the bill of material.

Do not include the material cost of components or subassemblies below this item.

Incr setup cost

Optional
14 numeric in the format 999999999.99999

Enter the setup labor cost incurred at this item's level of the bill of material.

Do not include the setup cost of components or subassemblies below this item.

If you select the Calc labor and overhead? field in the Standard cost Rollup (MCR) program, this field displays setup labor costs bases on the item's routing.

Incr run cost

Display only

This is a system-calculated field and is the difference between the item's total incremental labor and its incremental setup cost.

Incr labor cost

Optional
14 numeric in the format 999999999.99999

Enter the total labor cost (including setup and run) incurred at this item's level of the bill of material.

Do not include total labor costs of components or subassemblies below this item.

If you select the Calc labor and overhead? fields in the standard cost rollup program, this field displays the total labor costs based on the item's routing.

Incr ovhd cost

Optional
14 numeric in the format 999999999.99999

Enter the overhead cost incurred at this item's level of the bill of material. This amount is in addition to that calculated for the overhead codes for this item.

Do not include the overhead cost of components or subassemblies below this item.

If you select the Calc labor and overhead? field in the Standard Cost Rollup (MCR) program, this field displays overhead cost calculated from the item's overhead codes or the overhead codes for the Work Center Maintenance (WCM) used for the item's routing.

Incr OS cost

Optional
14 numeric in the format 999999999.99999

Enter the outside service cost incurred at this item's level of the bill of material.

Do not include outside service cost for components or subassemblies below this item.

Overhead code 1 - 4

Conditional/Optional
2 alphanumeric

If this is an item you buy, select a code that identifies the type of overhead cost for this item.

Taxability 1 - 10

Required
1 alphanumeric

Select the taxability type:

Select	If
Y	This taxing authority applies
Blank or N	This taxing authority does not apply
I	Indicates that tax is included in the price. Valid if the Third-Party Sales Tax Interface is being used. (Treated as blank or N if the interface is not active.)

Note
These fields may have different labels based on the Tax type description 1 - 10 options in System Options Maintenance (XM) program (Enterprise Options). Any tax field not blank in the XM program, cannot be blank in this program.

The Unassigned label means no tax type exists for this field.

(Optional) Click Other cost to enter or change data in these fields:

Field Name	Type / Max Length	Action / Description
Average cost	Optional 14 numeric in the format 999999999.99999	Enter the average cost to manufacture or purchase the item. The system maintains this field. See Background.
Actual cost	Optional 14 numeric in the format 999999999.99999	Enter the cost of the most recent manufacturing or purchase order for this item. The system maintains this field. See Background.
Declared value	Optional 14 numeric in the format 999999999.99999	Enter the item's declared value for shipping purposes.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to an active field, enter data and click Apply.
Enter notes	Click Notes. See Enter Notes for Items.
Enter data in custom fields your company uses	Click User. See Enter Data in User or Shadow File Fields. Note This button only displays if you have set up fields for the Item Cost Maintenance (ICM) program in the User Fields Maintenance (XMO) program.
Go to a related program	Click Jump. See Jump.
Display changes made to item	Click Audit. See Display an Audit Trail. Click Exit to return to this program. Note Audit trail logging must be activated.
Change the Average cost, Actual cost, or Declared value fields.	Click Other cost.
Display cost rollup history	Click CRU history. See Display Cost Rollups. Click Exit to return to this program.
Display this item's branch record	Click Br item inq. See Display a Branch Item. Click OK to return to this program.
View or import documents associated with this branch item cost record	Click Documents. Click View to view archived and imported documents, See Display Document Archive. The View button is active only if archived documents are available. Click Import to import a document for this invoice. See Document Archiving and Document Import for more information. Note This button displays only if the document import feature is active.
Return to the previous screen.	Click OK.
Exit the program.	Click Exit.