Compute Proposal Item Costs

Use the Compute Proposal Item Costs 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.

Note:

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.