COMPUTE PROPOSAL ITEM COSTS

Use this screen to calculate the quantities of each item in a proposal and its proposal bills of materials (PBOMs), summarize the quantities required, and look up costs for the items and have them roll up to a specified PBOM level. The application generates a report displaying the quantities required and the associated costs of the proposal item with subtotals. You must run this process to determine the quantities required and cost rollups of assemblies, end items, and proposals.

You must run this process whenever a modification occurs to a proposal or proposal BOM, and before accessing the Manage Proposal BOM Cost Estimates - Indented or Manage Proposal BOM Cost Estimates - Summarized screen. If cost modifications are made, you must rerun this process to roll up the cost modification.

You must first establish proposal IDs, proposal bills of material records and the most recent numerical data on the Manage Proposals screen and Manage Proposal Bills of Material screens, respectively.

Before running the application, use to preview the result.

For the selected proposal/revision, the system calculates each end item's quantity requirements and costs by the specified quantity breakpoint on the Manage Proposals screen. In addition, if an end item is a part or a provisional part with a PBOM in that proposal, all quantity requirements and costs of components associated with that end item are also calculated.

Two worktables are populated as the system determines quantity requirements. The detail worktable contains a row for each end item and processed PBOM line. A subassembly row appears in the worktable if it is found in an end item's PBOM, and the cumulative lead time and quantity gross requirements (by breakpoint), and level in which the component appears in the indented PBOM, are also stored in the worktable.

The summary worktable revises gross requirements (by breakpoint) and inventory information by item and/or provisional part. A given item and its make/buy code are stored on only one row, regardless of the number of times it appears in the proposal and its PBOMs. The system uses the summary worktable to insert and update proposal item detail rows.

The system first determines each item's gross requirements for each breakpoint by checking end item quantity breakpoints and exploding PBOMs for that end item where appropriate. The results are stored in a worktable. The system uses scrap and yield percentages to adjust requirements if you select the Include Scrap/Yield in Quantity Calculations check box. Each item's requirements are summarized by item and make/buy code.

After requirements have been determined, the application costs each item by looking at existing proposal cost information and other sources. After this has been performed, the system can generate cost rollups for PBOMs to cost assemblies.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Proposal/Rev

Option

Always displays One.

Start

Enter, or click to select, the proposal ID and revision for which you would like each end item's quantity requirements and costs to be calculated by quantity breakpoint, as specified on the Manage Proposals screen. The description displays in the adjacent, unlabeled field.

Sort By

Use this group box to specify how you like the report to be sorted. The selection are based on the type of report you can generate and print.

1st Sort

Select the sort type from the drop-down list. The options available are:

The Summarized BOM options allows a given item ID and make/buy code combination to be printed only once on the report. Proposal total costs are printed, but no other subtotal costs are calculated.

Options

Print Quality Breakpoints

Print All Breakpoints

Select this option to print all breakpoints for the given proposal.

Print Breakpoint Number

Select this option to print a specific breakpoint for the given proposal. Specify the breakpoint quantity in the drop-down list found at the right of this option.

Print Burden Costs

Select this check box to have the system process and calculate burden amounts by cost element for the given proposal. Burden costs print on the report for Material Burden, Labor Burden, Subcontract, Miscellaneous 1, and Miscellaneous 2, per the settings on the Costing Parameters tab of the Manage Proposals screen. Total costs by element are the sum of the direct cost amount and the burden amount. If you do not select this check box, no calculation is made, and the burden and total cost rows are not printed on the report.

Include Scrap/Yield in Quantity Calculations

Select this check box to have required quantities for components and subassemblies adjusted by PBOM scrap and yield percentages. After requirements have been determined during processing, the application costs each item by looking at existing proposal cost information and other sources. After this has been performed, the system can generate cost rollups for PBOMs to cost assemblies.

Scrap/yield is included in quantity calculations by the following: PBOM Gross Requirement Quantity = (quantity breakpoint requirement x (1 + BOM scrap percentage for the component)) divided by the component part yield percentage. If the resulting gross quantity is not a whole number, and if the part's unit of measure is EA (Each), the quantity is rounded up to the next whole number. The system uses the adjusted gross requirement quantities when determining the gross requirements of any components of this part.

Suppress Exception Messages

Select this check box to suppress exception messages from the report for those assemblies and components that did not process as a result of lack of detailed cost information.

Use Min/Mult Lot Sizes for Components

If you select this check box, minimum and multiple lot size quantities are included on the report. If the output is the Impromptu report file, the system looks up the minimum and multiple lot size quantities and includes them in the report tables, regardless of the status of this check box.

Minimum/multiple lot sizes are not used if the item is a good or service, or if the item is a standard or provisional part where the order policy type is not M.

Populate Report Table

Select this option to load processed data into the Materials Estimating Impromptu Catalog so that you can generate your own indented BOM reports.

Item Cost Detail

Do Not lookup Item Cost Detail

Select this option to use previously established proposal item cost rows for proposal item detail updates and cost rollups.

Lookup New Item Cost Detail

Select this option to have the system look up cost information based on the parameters defined on the Configure Materials Estimating Settings screen, and generate new proposal item cost rows for items in the summary worktable. The system generates new rows only if an existing row with the same item, make/buy code, and minimum quantity does not exist for that proposal.

Replace Existing Item Cost Detail

Select this option to delete all previous proposal item cost rows during processing.

Buy Parts

Select this check box to have the system identify cost source information for items whose Make/Buy status is Buy. For each buy item that is not a provisional part, the system locates the PO, PO history, and vendor quote information for costing purposes. For provisional parts, the system locates only quote line and quote line breakpoint information.

If the vendor is flagged as a payroll vendor, has an Approval Code of Not Approved, or a Vendor Status for PO of On Hold, the quote or purchase order is excluded. If the vendor has an Approval Code of Pending, Costpoint displays a warning.

Make Parts

Select this check box to have the system identify cost source information for items that have a Make/Buy code of Make. For each make item that is not a provisional part, the system locates those manufacturing order rows where the build part matches the component in the proposal. If the MO Order Date Cutoff is not null (in the Costing Parameters tab of the Manage Proposals screen), only those manufacturing order rows are selected for processing where the order date is later than or the same as the MO Order Date Cutoff. The system excludes any MOs that have a Rework or Customer Repair type, the status of Planned, Firm Planned, Released, or In-Shop, and no cost or timesheet allocations. If you did not select the Include Orders/Quotes for Quantities Larger than Item Breakpoint Quantities check box on the Configure Materials Estimating Settings screen, the system also excludes any MO rows where the build quantity is greater than the highest breakpoint quantity requirement for the part.

Net Available Component Inventory

You can view inventory detail on the View Part Inventory screen. A part's Net Available Quantity is calculated as follows:

On Hand Qty + In Inspection Qty + In Shipping Qty + On Order Qty + On Req Qty + Owed Qty + Planned Owed Qty - Reserved Qty - Planned Reserved Qty.

If you selected the Incl MRB as Available Inventory check box on the Configure Production Control Settings screen, the MRB Quantity is also added to the sum.

Include Inventory in Report

This check box is selected by default. Leave this check box selected to have Costpoint calculate available inventory quantities and store the inventory with the proposal item cost data. The system calculates inventory only for standard parts, and not for goods, services, or provisional parts.

Inventory Selection

Use this group box to specify how the system determines inventory levels for eligible parts in the summary worktable. Using the inventory project selection criteria and the MRP option code of any selected inventory project, Costpoint calculates available inventory from the appropriate inventory projects for each standard part.

Use Existing Proposal Available Inventory Quantities

Select this option to have the system use the existing available inventory quantity for calculating the proposal item's inventory.

Inventory Project

Select this option to enable the Include Common Inventory Projects and Subtract Safety Stock from Available Inventory check boxes. If you select this option, place your cursor in the blank field on the right and enter, or click to select, the inventory project. The system reviews the Project Planning Option for the selected inventory project. Assign Project Planning Options to inventory projects on the Manage Inventory Projects screen.

Netting Group

Select this option to enable the Include Common Inventory Projects and Subtract Safety Stock from Available Inventory check boxes. If you select this option, place your cursor in the field to the right and enter, or click to select, the netting group. Establish netting groups on the Manage Netting Groups screen. If the inventory project that is associated with the netting group uses common stock, and the part being reviewed is a common stock part, all inventory rows with that part where the Use Common Inventory is Y are included in the process.

All Inventory Projects

Select this option to have the system process the quantities of all inventory rows that contain the selected part.

Include Common Inventory Projects

If you select this check box and populate the Inventory Project field or Netting Group field, all inventory rows are included in the calculation where the part's Use Common Inventory is Y for that inventory project on the Manage Netting Groups screen. Assign common inventory to projects on the Manage Inventory Projects screen.

Subtract Safety Stock from Available Inventory

If you select this check box, the selected projects' safety stock quantity must be summed to determine safety stock requirements for that part. The safety stock quantities are subtracted from the net available quantity for that part.