OTHER COST WORKSHEET

This subtask displays Manufacturing Order (MO), inventory, item cost, and project item cost information for the selected part. For example, if an MO line (from Costpoint Production Control), item cost line, or project item cost line (from Product Definition) exists for the end item, it will appear in the Other Cost Worksheet table window, and you can set the applicable rows' Add to Proposal Costs column to "Y" (Yes) to add the Minimum Quantity and This Level Unit Cost columns to the Proposal Item Costs subtask. However, the affected rows in the Proposal Item Costs subtask can be overridden and will be used to derive proposal costs only when the highest Minimum Quantity is less than or equal to the selected breakpoint quantity for the item. All standard functions in the Line menu are disabled in this subtask. This subtask is disabled if the selected component part row is a provisional part.

Item Cost and Project Item Cost lines display in this table window if the sum of the This Level Costs columns (i.e., Material, Labor, Subcontract, Misc 1, and Misc 2) is greater than zero in the Maintain Item Cost screen or the Maintain Item Project Cost screen in Costpoint Product Definition, where the cost information can be changed and updated. Use the Compute Proposal Item Costs application to update applicable cost information for the Maintain PBOM Cost Estimates (both Indented and Summarized) applications.

Proposal, Rev, Description

These fields default from the main screen.

Item, Rev, U/M, Make/Buy, Description, Provisional

These fields default from the main screen table window for the selected item line.

Quantity Breaks

1-5

 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.

Table Window

This table window displays all Manufacturing Order (MO), inventory, item cost, and project item cost information that exists for the selected item/component part.

Costs displayed in this subtask relate to "this level" costs only, rather than total costs. You can calculate "lower level" costs by rolling up lower part costs in the PBOM using the Compute Proposal Item Costs application.

Item Cost and Project Item Cost lines display in this table window if the sum of the This Level Costs columns (i.e., Material, Labor, Subcontract, Misc 1, and Misc 2) have already been set up and are greater than zero in the Maintain Item Cost or the Maintain Item Project Cost screens in Costpoint Product Definition.

All inventory rows for the component part whose sum of cost amounts is greater than zero will load in the table window. Standard ("S" MO Type) MO lines load into this table window from Costpoint Production Control only when the line's order date is not later than the MO Order Date Cutoff for the proposal in the Details subtask of the Maintain Proposal Master screen, or if timesheet lines are issued to the MO (in the Enter Timesheets screen in Costpoint Labor). Additionally, if the MO does not have any costs or timesheet lines issued against it, or the MO status is "Planned" or "Firm Planned," it will not load into this table window. MOs whose MO Type is "C" (Customer Repair) or "R" (Rework) will not load into this table window.

Add to Proposal Costs

Use this field to load the Minimum Quantity and the This Level Unit Cost columns into the Proposal Item Costs subtask. The default for this drop-down box is "N" (No); however, if you change it to "Y" (Yes), the Minimum Quantity will default with the order quantity of the MO for MO cost source type lines. For all other lines, the Minimum Quantity field will default to "1," but can be changed, and the This Level Unit Cost fields will default with the values listed in the respective Source Unit Cost fields. Once you save the record, the line will load into the table window in the Proposal Item Costs subtask. If applicable, the This Level Unit Cost fields in the Proposal Item Costs subtask will ultimately be incorporated in Proposal Item Detail row in the main screen table window after you execute the Compute Proposal Item Costs application.

Minimum Quantity

If you change the Add to Proposal Costs field to "Y" (Yes) and tab to this field, the Minimum Quantity will default with the order quantity of the MO for MO cost source type lines.  For all other lines, this field will default to "1," but it can be changed and will load into the Proposal Item Costs subtask based on the breakpoint quantity criteria only if the Add to Proposal Costs field is "Y" and you save the record. You cannot have rows with the same Minimum Quantity.

This Level Material Unit Cost

If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value listed in the Source Material Unit Cost field, if applicable, and can be changed to reflect the desired incremental materials unit cost for the item at the specified Minimum Quantity.

This Level Labor Unit Cost

If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value listed in the Source Labor Unit Cost field, if applicable, and can be changed to reflect the desired incremental labor unit cost for the item at the specified Minimum Quantity.

This Level Subcontract Unit Cost

If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value listed in the Source Subcontract Unit Cost field, if applicable, and can be changed to reflect the desired incremental subcontract unit cost for the item at the specified Minimum Quantity.

This Level Misc1 Unit Cost

If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value listed in the Source Misc1 Unit Cost field, if applicable, and can be changed to reflect the desired incremental miscellaneous unit cost for the item at the specified Minimum Quantity.

This Level Misc2 Unit Cost

If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value listed in the Source Misc2 Unit Cost field, if applicable, and can be changed to reflect the desired incremental miscellaneous unit cost for the item at the specified Minimum Quantity.

Proposal Unit Cost

This field displays the total sum of the This Level Unit Cost fields. You cannot manually change this field, but the system will recalculate this field if you make a change in any of the This Level Unit Cost fields.

Cost Source Type, Cost Source Description

You can load seven different items in the Cost Source Type column.  If you are populating the row with item cost data (from the Maintain Item Cost screen in Product Definition), the Cost Source Type (and Cost Source Description) will display "IL" (Item Last Cost), "IS" (Item Standard Cost), or "IR" (Item Reference Cost), depending on whether the item cost row is "Last," "Standard," or "Reference," respectively. If you are populating the row with project item cost data (from the Maintain Project Item Cost screen in Product Definition), the Cost Source Type (and Cost Source Description) will display "PL" (Project Last Cost), "PS" (Project Standard Cost) or "PR" (Project Reference Cost), depending on whether the project item cost row is "Last," "Standard," or "Reference," respectively.  If you are populating the row with data from a manufacturing order (from Costpoint Production Control), the Cost Source Type (and Cost Source Description) will display "MO" (Manufacturing Order).  If you are populating the row with inventory data (i.e., from an inventory abbreviation), the Cost Source Type (and Cost Source Description) will display "IN" (Inventory).

Cost Source ID

This field displays the inventory abbreviation if the line is an inventory cost source type, or the manufacturing order ID if the line is an MO cost source type. This field is blank for item cost and project item cost lines.

Source Material Unit Cost

This field displays the material unit cost for the cost source type (and cost source ID, if applicable). This field will be set to zero for MO costs.

Source Labor Unit Cost

This field displays the labor unit cost for the cost source type (and cost source ID, if applicable). This field includes This Level labor costs only for MOs, not inventory, cost source types. For MO cost source types, the system calculates this field as the sum of the timesheet line labor costs assigned to this MO, divided by the MO's build quantity.

Source Subcontract Unit Cost

This field displays the subcontract unit cost for the cost source type (and cost source ID, if applicable). This field includes This Level subcontract costs only for MOs, not inventory, cost source types. For MO cost source types, the system calculates this field as the sum of subcontract costs for this MO, divided by the MO's build quantity.

Source Misc1 Unit Cost

This field displays the miscellaneous unit cost for the cost source type (and cost source ID, if applicable). This field includes This Level miscellaneous 1 costs only for MOs, not inventory, cost source types. For MO cost source types, the system calculates this field as the sum of the timesheet line Misc1 costs assigned to this MO, divided by the MO's build quantity.

Source Misc2 Unit Cost

This field displays the miscellaneous unit cost for the cost source type (and cost source ID, if applicable). This field includes This Level miscellaneous 2 costs only for MOs, not inventory, cost source types. For MO cost source types, the system calculates this field as the sum of the timesheet line Misc2 costs assigned to this MO, divided by the MO's build quantity.

Source Unit Cost

This field displays the sum total of all source unit cost fields. 

MO Date

This field displays the MO order date for the MO cost source type row.  For all other lines, this field is blank.

MO Quantity

This field displays the MO build quantity for the MO cost source type row.  For all other lines, this field is blank.

MO Type

This field displays "S" (Standard) because only standard MO types will display for the MO cost source type row. For all other lines, this field is blank.

MO Status

This field displays the MO status for the MO cost source type row. Only "R" (Released), "S" (In-Shop), "L" (Closed), and "C" (Completed) MOs will display. For all other lines, this field is blank.

Warehouse

This field displays the MO warehouse ID for the MO cost source type row.  For all other lines, this field is blank.

Project

This field displays the project ID for project item costs, inventory, and/or the MO cost source type row. For all other lines, this field is blank.