The Material Cost Worksheet subtask displays all vendor quote, purchase order line, and PO line history information for the selected component part row in the main screen. For example, if a PO line (from Costpoint Purchasing) or vendor quote (from Costpoint Procurement Planning) exists for the selected row's part, it will appear in the Materials Cost Worksheet table window, and you can set the applicable rows' Add to Proposal Costs column to "Y" (Yes) to add the Minimum Quantity, This Level Material Unit Cost, and cost source data columns to the Proposal Item Costs subtask. All standard functions in the Line menu are disabled in this subtask.
Vendor quote lines that appear in this screen's table window must meet the following criteria:
The quote does not have an expiration date or it has not yet expired, or
The quote has expired, but the Include Expired Vendor Quotes checkbox is selected in the Details subtask of the Maintain Proposal Master screen, and the quote's expiration date does not exceed the date in the Quote Expire Date Cutoff field (if populated) in the Details subtask.
Similarly, purchase order lines (with standard parts) that appear in this screen's table window must meet the following criteria:
The PO line's order date has not exceeded the PO Order Date Cutoff field (if populated) in the Details subtask of the Maintain Proposal Master screen.
The PO line's Source Net Unit Cost is greater than zero or the Ord Ref Type for the PO line (in the Enter POs screen) is not "R" (Vendor Return).
PO history lines (with standard parts) that appear in this screen's table window must meet the following criteria:
The Include Archived PO History checkbox is selected in the Materials Estimating Settings screen.
The PO history line's order date does not exceed the PO Order Date Cutoff field (if populated) in the Details subtask of the Maintain Proposal Master screen.
The PO history line's Source Net Unit Cost is greater than zero or the Ord Ref Type for the PO history line (originally entered in the Enter POs screen) is not "R" (Vendor Return).
These fields default from the main screen.
These fields default from the main screen table window for the selected item line.
These fields default from the main screen table window for the selected item line. Each calculated value in the proposal quantity break field will default in the appropriate field in this group box.
The default sort order for the table window is Cost Source Type, Cost Source ID, Cost Source Release, and Cost Source Line.
Use this field to load this cost information into the Proposal Item Costs subtask. The default for this drop-down box is "N" (No); however, if you change it to "Y" (Yes) and save the record, the system will insert a new row with quantity cost and cost source information into the Proposal Item Costs subtask.
Enter the minimum quantity of items that this cost covers. If you change the Add to Proposal Costs field to "Y" (Yes) and tab to this field, this field will default to the value from the Quantity (Part U/M) field (if populated), or from the Quote/Order Quantity field if the Quantity (Part U/M) field is zero or null. You can change the minimum quantity on the line, but it will load into the Proposal Item Costs subtask only if the Add to Proposal Costs field is "Y" and you save the record.
Enter the incremental materials unit cost for the item at the specified minimum quantity. If you change the Add to Proposal Costs field to "Y" (Yes), the default value for this field will be calculated as follows:
If you selected the Rollup Purchasing Line Charges in Unit Costs checkbox in the Materials Estimating Settings screen, the system calculates this field as follows:
Net Unit Cost + (Extra Charges/Minimum Quantity)
If you did not select the Rollup Purchasing Line Charges in Unit Costs checkbox in the Materials Estimating Settings screen, this field will display the net unit cost. You can change this field to represent the incremental material unit cost for the item at the specified minimum quantity. The value in this field will load into the Proposal Item Costs subtask only if the Add to Proposal Costs field is "Y" and you save the record.
Nine different items can be loaded in the cost source type column, depending on whether the line is from a purchase order, blanket order, item/vendor quote, or purchase order history. The following table outlines the nine valid cost source type values:
|
Cost Source Type |
Details |
Notes |
|
QT (Item or Vendor Quote line) |
The Enter Quotes by Item screen or Enter Quotes by Vendor screen in Costpoint Procurement Planning. |
|
|
PO (Purchase Order line) |
The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Purchase Order." |
|
|
PE (Blanket Release Order line) |
Created in the Create Blanket Releases screen in Costpoint Purchasing for an existing Blanket Order (in the Enter POs screen). The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Release Order." |
Release Order has been created for the Blanket Order. Release number is 1 or greater for the existing Blanket Order. |
|
PA (Blanket Order line) |
The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order; line's Purchase Agreement code is "A" or "S" in the Enter POs screen. |
|
PB (Blanket Order line) |
The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order; line's Purchase Agreement code "A" or "S" in the Enter POs screen. |
|
HO (PO History line) |
The Archive Purchase Orders screen and the Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Purchase Order." |
|
|
HR (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Release Order." |
Release Order has already been created for the Blanket Order. Release number is 1 or greater for the existing Blanket Order. |
|
HA (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order; line's Purchase Agreement code is "A" or "S" in the Enter POs screen. |
|
HB (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order; line's Purchase Agreement code is not "A" or "S" in the Enter POs screen. |
This field displays the description of the cost source type (i.e., Quote, PO, Blanket Order) that was used to determine the unit costs for this part at this quantity breakpoint. You can view additional cost source details in the Proposal Item Costs subtask. You establish cost source types and descriptions in the ME Cost Source Types screen.
This field displays the PO, blanket, or quote ID in which the item appears for the selected line.
This field displays the release number for the PO, blanket, or quote ID.
This field displays the number of the line in which the item appears in the cost source.
This field displays the unit of measure for the item as it appears in the cost source.
This field displays the gross unit cost for the item as it appears in the cost source.
This field displays the volume discount percentage for the item as it appears in the cost source.
This field displays the net unit cost for the item as it appears in the cost source. This field is derived from the Source Gross Unit Cost and Volume Discount, if applicable.
If the source unit of measure is the same as the part's default unit of measure (in Costpoint Product Definition), this field is populated with the Source Net Unit Cost, and the Quantity (Part U/M) field with the Quote/Order Quantity. If the source unit of measure and part's default unit of measure are different, the system searches for a matching unit of measure conversion in the Maintain Parts screen (for standard parts) or Units of Measure screen in Costpoint Product Definition (for both standard and provisional parts). If a matching conversion factor exists, the system will populate the Net Unit Cost Part U/M field and Quantity (Part U/M) field with the converted cost and quantity, respectively. However, if no matching unit of measure conversion exists, both fields will be null.
For example, part "A" has a U/M of "EA" (Each) in the Maintain Parts screen in Costpoint Product Definition, and a U/M of "Box" on a PO line in the Enter POs screen in Costpoint Purchasing (i.e., 12 units each of part "A" are in one box). On the PO line, there are 3 boxes of part A, with a Source Net Unit Cost of $30.00. In the Units of Measure Conversion subtask of the Maintain Parts screen, you would enter "Box" in the U/M From field, "EA" in U/M To, "12" in Conv Factor, "M" (Multiply) in Direction, with no rounding enabled (Rounding Type is "N"). If no conversion factor is found for part "A," the system looks for the correct conversion factor set up in the Unit of Measure application.
Using this conversion factor, the system multiplies the value in the Quote/Order Quantity field (3 boxes) by the Conv Factor (12) to obtain a Quantity (Part U/M) of 36. The system calculates the Net Unit Cost Part U/M field by dividing the Source Net Unit Cost ($30.00) by the Conv Factor (12) to obtain a $2.50 net unit cost for each unit of part "A."
The vendor and vendor name display for the item as they appear in the cost source.
If the vendor is flagged as a payroll vendor, or has an Approval Code of "Not Approved" or "Pending," the quote or purchase order is excluded. If the vendor has an Approval Code of "Pending," you will receive a warning.
This field displays "Y" (Yes), "N" (No), or "P" (Preferred) for the item; this is taken from the Appr field in the Assign Vendors screen in Costpoint Product Definition.
This field displays the vendor's order address code that applies to the line's cost information as it appears in the cost source. This field will be null if the line is from a vendor quote.
This field displays the vendor lead time for the item as it appears in the cost source. This field will display only if the line is from a vendor quote.
This field displays any charges from the Line Charges subtask of the Enter POs, Enter Quotes by Vendor, or Enter Quotes by Items screens. You can manually add extra charges in the Add Vendor Quotes subtask before saving the quote line; those charges will default into this field.
If the Extra Charges field is populated, enter, or use Lookup to select, the line charge type that is assigned to the PO or vendor quote. You establish charge type information in the PO Line Charge Types screen in Costpoint Purchasing.
This field displays the order date (from the PO line) or quote date (from the vendor quote) for the item as it appears in the cost source.
This field displays the order quantity (from the PO line) or quote quantity (from the vendor quote) for the item as it appears in the cost source.
If the source unit of measure is the same as the part's default unit of measure (in Costpoint Product Definition), the Net Unit Cost (Part U/M) is populated with the Source Net Unit Cost, and the Quantity (Part U/M) field with the Quote/Order Quantity. If the source unit of measure and part's default unit of measure are different, the system searches for a matching unit of measure conversion in the Maintain Parts screen (for standard parts) or Units of Measure screen in Costpoint Product Definition (for both standard and provisional parts). If a matching conversion factor exists, the system will populate the Net Unit Cost Part U/M field and Quantity (Part U/M) field with the converted cost and quantity, respectively. However, if no matching unit of measure conversion exists, both fields will be null.
For example, part "A" has a U/M of "EA" (Each) in the Maintain Parts screen in Costpoint Product Definition, and a U/M of "Box" on a PO line in the Enter POs screen in Costpoint Purchasing (i.e., 12 units each of part "A" are in one box). On the PO line, there are 3 boxes of part A, with a Source Net Unit Cost of $30.00. In the Units of Measure Conversion subtask of the Maintain Parts screen, you would enter "Box" in the U/M From field, "EA" in U/M To, "12" in Conv Factor, "M" (Multiply) in Direction, with no rounding enabled (Rounding Type is "N"). If no conversion factor is found for part "A," the system looks for the correct conversion factor set up in the Unit of Measure application.
Using this conversion factor, the system multiplies the value in the Quote/Order Quantity field (3 boxes) by the Conv Factor (12) to obtain a Quantity (Part U/M) of 36. The system calculates the Net Unit Cost Part U/M field by dividing the Source Net Unit Cost ($30.00) by the Conv Factor (12) to obtain a $2.50 net unit cost for each unit of part "A."
This field displays the period of performance end date (from the PO line) or expiration date (from the item/vendor quote) for the item as it appears in the cost source.
This field displays the buyer ID for the PO/quote as it appears in the cost source.
This field displays the project ID for the PO/quote as it appears in the cost source.
This field displays up to 254 alphanumeric characters of notes associated with the line item as it appears in the cost source.
This field displays "Y" (Yes) if the PO line or PO line history item has been issued to the purchase order (via the Enter Issues screen in Costpoint Inventory). This field displays "N" (No) if the line is a quote or has not been issued to a purchase order.
This field displays "Y" (Yes) if the PO line is a from subcontract purchase order (i.e., the order reference type is "M"). This field displays "N" (No) if the PO line (or PO line history) does not have an order reference type of "M" (Manufacturing Order) or if the line is a quote.
This field displays "Y" (Yes) if the PO line is from a vendor return (i.e., the order reference type is "R") that was entered in the Enter Vendor Returns screen in Costpoint Receiving. This field displays "N" (No) if the PO line (or PO line history) does not have an order reference type of "R" (Vendor Return) or if the line is a quote.
This field displays the vendor's Approval Code that was set in Accounting » Accounts Payable » Vendor Info » Approve Vendors. This is "A" if the vendor is approved, "N" if the vendor is not approved, or "P" if the vendor's approval status is pending.