Use this screen to calculate the quantities of each item in a proposal and its PBOMs, summarize the quantities required, and look up costs for the items and have them roll-up to a specified PBOM level. The application will generate 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 roll-ups of assemblies, end items, and proposals.
You must first establish proposal IDs, proposal bills of material records and the most recent numerical data in the Maintain Proposal Master screen and Maintain Proposal BOM screen, respectively.
For the selected proposal/revision, the system will calculate each end item's quantity requirements and costs by the specified quantity breakpoint in the Maintain Proposal Master 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 will also be 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 will appear 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, will also be 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 will be 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 will first determine 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 will be stored in a worktable. The system will use scrap and yield percentages to adjust requirements if you select the Include Scrap/Yield in Quantity Calculations checkbox. Each items’ requirements will be summarized by item and make/buy code.
Once requirements have been determined, the application will cost each item by looking at existing proposal cost information and other sources. Once this has been performed, the system can generate cost rollups for PBOMs to cost assemblies.
Enter, or use Lookup to select, the proposal ID for which you would like each end item's quantity requirements and costs to be calculated by quantity breakpoint, as specified in the Maintain Proposal Master screen.
Use this group box to specify the type of report you would like to print.
Select this radio button to have the report sorted first by proposal line number, and then by PBOM in indented BOM order for each proposal line that has a PBOM. End items without a PBOM will still be printed on the report with cost data. Proposal Total Costs will be printed at the top of the report.
Select this radio button so that a given item ID and make/buy code combination will be printed only once on the report. Proposal Total Costs will be printed, but no other subtotal costs will be calculated. Selecting this radio button enables the following radio buttons in order to further detail the sort order:
Select this radio button to print the report in item ID, revision, and make/buy code order.
Select this radio button to print the report in commodity code (for the item or provisional part), item ID, revision, and make/buy code order. A page break will be inserted for each new commodity and commodity description. Items that do not have commodity codes will also be included on the report.
Select this radio button to print the report in total extended cost (descending), item ID, revision, and make/buy code order.
Select this radio button to print the report in make/buy code, item ID, and revision order.
Select this radio button to print all breakpoints for the given proposal.
Select this radio button to print a specific breakpoint for the given proposal. Specify the breakpoint quantity in the drop-down box to the right of this radio button.
Select this checkbox to have the system process and calculate burden amounts by cost element for the given proposal. Burden costs will print on the report for Material Burden, Labor Burden, Subcontract, Miscellaneous 1, and Miscellaneous 2, per the settings in the Burden subtask of the Maintain Proposal Master screen. Total costs by element will be the sum of the direct cost amount and the burden amount. If you do not select this checkbox, no calculation will be made and the burden and total cost rows will not be printed on the report.
Select this radio button to have previously existing proposal item cost rows used for proposal item detail updates and cost roll-ups.
Select this radio button to have the system look up cost information based on the parameters defined in the 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.
Select this radio button to have all previous proposal item cost rows deleted during processing.
Select this checkbox 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.
Select this checkbox to have the system identify cost source information for items whose Make/Buy status is "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 Details subtask of the Maintain Proposal Master screen), only those manufacturing order rows will be selected for processing where the order date is later than or the same as the MO Order Date Cutoff. The system will exclude any MOs that have a "Rework" or "Customer Repair" type, the status of "Planned," "Firm Planned," "Released," or "In-Shop," and no cost and/or timesheet allocations. If you did not select the Include Orders/Quotes for Quantities Larger than Item Breakpoint Quantities checkbox in the Materials Estimating Settings screen, the system will also exclude any MO rows where the build quantity is greater than the highest breakpoint quantity requirement for the part.
Select this radio button print the report.
Select this radio button to load processed data into the Materials Estimating Impromptu Catalog so you can generate your own indented BOM reports.
Select this checkbox to have required quantities for components and subassemblies adjusted by PBOM scrap and yield percentages. Once requirements have been determined during processing, the application will cost each item by looking at existing proposal cost information and other sources. Once 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 will use the adjusted gross requirement quantities when determining the gross requirements of any components of this part.
If you select this checkbox, minimum and multiple lot size quantities will be included on the report. If the output is the Impromptu report file, the system will lookup the minimum and multiple lot size quantities and include them in the report tables, regardless of the status of this checkbox.
Minimum/multiple lot sizes will not be 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."
Select this checkbox 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.
Select this pushbutton to access additional options for calculating net available component inventory and other inventory selections.
Select this button on the toolbar to view proposal item costs before processing.
Select this button on the toolbar to print proposal item costs before processing.
Select this button on the toolbar to compute the proposal item costs.
Select this button on the toolbar to compute the proposal item costs and print a report.