Enter Costs for a Project Item

When you click Inventory and then Item cost in the Project Maintenance (PSM) program, you can enter and change costs for a project item. See Background and Road Map for more information.

The program displays these fields for each item:

Field Name

Displays

Item number

The item number

Type

New: New item for this project
Prj
: An item from another project or an ECO
Std
: Item exists in your database

Project

Project number

Br

The number of the project branch

Standard cost

The standard unit cost for this item

If you entered vendor pricing for a project component, when you click Roll up its standard cost is the unit price for the lowest quantity estimate. For example, suppose that the vendor's unit price breaks are:
9.75 for 1000
9.50 for 2500
9.25 for 5000

Suppose also that you enter project quantities for 2500 and 5000, but not for 1000. When you click Roll up, the component's standard cost will be 9.50, which is the unit price for 2500, the lowest quantity estimate. If you had entered a project quantity for 1000, the component's standard cost would be 9.75.

The standard cost for the new parent item uses the unit price for the last quantity estimate. Therefore, the standard cost of all the components may not equal the standard cost of the parent. In this example the unit price for the last quantity estimate is 9.25.

Base year cost

The baseline cost you can compare with other costs

Last CRU

The date of the last cost rollup for this item

Vend price

The item's purchase price from the vendor or Project displays if the item is manufactured

  1. Select the item for which you want to enter cost data and click Select.

    Note

    If you copied the item from your database, you cannot change its fields.

  2. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

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 labor cost

Optional
14 numeric in the format 999999999.99999

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

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

After you click Roll up, this field displays 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.

After you click Roll up, this field displays overhead costs calculated based on overhead codes for the item or the overhead codes in the Work Center Maintenance (WCM) for the routings used for this item.

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.

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. 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.

User defined cost

Optional
14 numeric in the format 999999999.99999

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

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

The average unit cost of the item. For new project items, this field will be zero.

If you selected the Update actual and average costs? option in the System Options Maintenance (XM) program (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.

Actual cost

Display only

The most recent unit cost of the item. For new project items, this field will be zero.

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

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

Declared value

Optional
14 numeric in the format 999999999.99999

Enter the item's declared value for shipping purposes.

Taxability 1 - 10

Required
1 alphanumeric

Enter the taxability type:

Select

If

Y

This taxing authority applies

Blank or N

This taxing authority does not apply

I

The tax is included in the price

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.

  1. Choose the appropriate options:

To

Do This

Accept the data and exit this item

Click OK.

Exit without entering this data

Click Cancel.

Update the record

Click Apply.

Enter notes

Click Notes. See Enter Project Notes for Items.

Enter vendor pricing

Click Vend price. See Enter Vendor Pricing for a Project Item.

  1. Choose the appropriate options when you click OK or Cancel:

To

Do This

Display the selected item

Click Select.

Display items from a specific item number

Click Restart. The program prompts Item number and Branch. Enter the number for the first item to display or leave blank to begin the display with the first item in the file.

Print the item listing

Click Print. See Print.

Display the previous set of records in the file

Click Page up.

Display the next set of records in the file

Click Page down.

Exit item costs

Click Exit.

  1. Choose the appropriate options when you click Exit:

To

Do This

Change a field

Click Modify.

Delete this project

Click Delete. The program prompts Do you want to delete this record?. Click Delete to delete this entire project or click No to retain this project.

Exit without creating this project

Click Cancel.

Display additional fields

Click Other info.

Enter notes for this project

Click Notes. See Enter Notes.

Enter an item, its branch information, and costs

Click Inventory and then:

Click

To enter a/an

Item

Item record. See Enter an Item for a Project.

Branch

Branch record. Enter Branch Information for a Project Item.

Item cost

Cost record.

Back

End this action.

Enter quantities, profit, commission, and discount percents

Click Proj qtys. See Enter a Project Quantity.

Enter a bill of material

Click BOM. See Enter a Project Bill of Material.

Enter a routing

Click Routing. See Enter a Routing.

Enter a new customer

Click Customer. See Enter a New Customer.

This button displays only if you entered a new customer in the Customer number field.

Enter miscellaneous costs

Click Misc costs. See Enter Miscellaneous Costs.

Calculate costs for project quantities

Click Roll up.

Display the project and unit costs for project quantities

Click Summary. See Display a Project Summary.

Print documents for this project

Click Print and then:

Click

To print a project

Customer

Estimate for this customer. See Print or Reprint a Customer Project Estimate.

In-house

Summary for your use. See Print Project Summaries.

Cost report

Material cost report for your use. See Print a Project Indented Cost Report.

Back

End this action.

Transfer this project to your database

Click Transfer. See Transfer a Project.

Close this project

Click Close proj. See Close a Project.

Display the sales quote generated by this project or the sales order line if the sales quote has been transferred

Click Order. See Enter a Sales Quotation or Display a Summarized Sales Order.

This button displays only for a transferred customer project.

Accept the data and exit this project

Click OK.

  1. When you click OK or Cancel, enter another project number or exit the program.