The Other Cost Worksheet 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 may 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 or 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.
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.
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 using the Compute Proposal Item Costs application to roll up lower part costs in the PBOM.
Item cost and project item cost lines display in this table window if the Level Costs columns (i.e., Material, Labor, Subcontract, Misc 1, and Misc 2) have already been set up and their sum is greater than zero in the Maintain Item Cost or Maintain Item Project Cost screen 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. MOs whose Type is "Standard" (in the Enter Manufacturing Orders screen in Costpoint Production Control) load into this table window 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 Enter Timesheets 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.
You can 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. When you save the record, the system will load the line 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 be incorporated in Proposal Item Detail row in the main screen table window after you execute the Compute Proposal Item Costs application.
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 can be changed, and it 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.
If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value 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.
If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value 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.
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.
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.
If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value 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.
This field displays the total sum of the This Level Unit Cost fields. You cannot manually change this field, but if you modify a value in any of the This Level Unit Cost fields, this field will reflect the change.
Seven different items can be loaded in the Cost Source Type column. If the row is being populated 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 listed as Last, Standard, or Reference, respectively. If the row is being populated with project item cost data (from the Maintain Project Item Cost screen in Product Definition), the Cost Source Type (and Cost Source Description) will appear as "PL" (Project Last Cost), "PS" (Project Standard Cost) or "PR" (Project Reference Cost) based on whether the project item cost row has a Type of "L" (Last), "S" (Standard), or "R" (Reference), respectively. If the row is being populated with data from a manufacturing order (from Costpoint Production Control), the Cost Source Type (and Cost Source Description) will display "MO" (Manufacturing Order). If the row is being populated with inventory data (i.e., from an inventory abbreviation), the Cost Source Type (and Cost Source Description) will display "IN" (Inventory).
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.
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.
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 by adding up the timesheet line labor costs assigned to this MO and dividing the sum by the MO's build quantity.
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 by adding up the subcontract costs for this MO and dividing the sum by the MO's build quantity.
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 by adding up the timesheet line Misc1 costs assigned to this MO and dividing the sum by the MO's build quantity.
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 by adding up the timesheet line Misc2 costs assigned to this MO and dividing the sum by the MO's build quantity.
This field displays the sum total of all source unit cost fields.
This field displays the MO order date for the MO cost source type row. For all other lines, this field is blank.
This field displays the MO build quantity for the MO cost source type row. For all other lines, this field is blank.
This field displays "S" (Standard); only standard MO types display for the MO cost source type row. For all other lines, this field is blank.
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.
This field displays the MO warehouse ID for the MO cost source type row. For all other lines, this field is blank.
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.