> Common Forms> > >

-or-

> Common Forms> > > >

Use this form to view and analyze detailed information about a manufactured item's calculated costs, either for a cost record within a costing version or for a calculation record that is generated by an order-specific BOM calculation. The detailed information reflects the costs for components, routing operations, and indirect costs that are included in the BOM calculation. The form displays summarized cost of goods sold information in the costing sheet format. The form can also be used to view and analyze detailed information about sales prices and weights.

Tasks that use this form

Examples

A manufacturing company builds standardized products and uses the BOM calculations to calculate standard costs for their products. The company uses the to verify the accuracy and completeness of the calculated costs and weight for each manufactured item. The company also analyzes the calculated sales prices in making decisions about sales prices that are embedded in their sales trade agreements.

Another manufacturing company builds customized products and uses a sales order to identify the unique bill of material (BOM) version and route version that defines how to produce a customized product. The company performs several order-specific BOM calculations to generate calculation records so that they can assess the calculated costs and suggested sales prices at different quantity breakpoints and profit percentages. The company uses the to verify the accuracy and completeness of the calculated cost, weight, and sales price.

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview tab

Display information about each component, routing operation, and indirect cost that is included in the BOM calculation. The explosion mode of the BOM calculation defines whether information represents a single-level or multilevel product structure.

General tab

View detailed information about the selected line item.

View cost and sales price information about the selected line item.

Display a graphic tree structure about each component, routing operation, and indirect cost that is included in the BOM calculation. View variable versus constant costs for a selected item within the graphic tree structure.

Display the segmentation of costs in the format that is defined by the costing sheet setup.

Buttons

Button

Description

View the trade agreement for a purchased item. The information is especially relevant when calculating planned costs with purchase trade agreements as the source of cost data for purchased items.

Select purchase prices or line discount to view the applicable trade agreement information.

Select purchase prices to view the applicable trade agreement information for a purchased item.

Select line discount to view the applicable trade agreement information for a purchased item.

View the Infolog about warnings for a selected line item (when the for the line item indicates that an Infolog exists).

Fields

Field

Description

Show the type of line item that is based on the icon. The types include a purchased item, a manufactured item, a routing operation, an indirect cost, and the production end-item.

Identify the line item in terms of the associated item number, the work center for a routing operation, or the code for an indirect cost.

Show the associated operation when the line item reflects a routing operation.

Show the line item's relative level in the product structure, where level 0 (zero) applies to the production end-item.

Show the cost group that is associated with a line item.

Show the quantity that is required for the line item.

Show the unit of measure for the required quantity. The inventory unit will be displayed for items.

Show the calculated weight of the production end-item and the individual weights for each component item.

Show a warning symbol when an Infolog exists for the line item. View the Infolog contents for the line item by clicking the Logbutton.

Show the quantity that is used in the BOM calculation for the production end-item.

Show the calculation group for the line item. The calculation group can define the source of cost data for purchased items (for calculating planned costs), the basis for calculating the sales price, and the defaults for warnings.

Show the inventory dimensions that are associated with the line item.

Show the type of line item. The values include item, BOM and service for an item; setup, process and quantity for a routing operation; surcharge or rate for an indirect cost; and production for the end-item.

Show the operation number that is related to the line item.

Show the unit cost for the line item.

Show the quantity of the line item that is used in the BOM calculation.

Show the total cost for the line item, which equals the unit cost multiplied by quantity.

Show the cost price model that was actually used for a line item for purchased material. The cost price model indicates the source of cost data for the purchased material that is based on the BOM calculation group that is assigned to the component.

  • - The item's cost record was used as the source of cost data.

  • - The item's purchase price record was used as the source of cost data.

  • - The item's purchase trade agreement information was used as the source of cost data.

  • - The item's current inventory price was used as the source of cost data. The current inventory price reflects the item's inventory model.

Show the unit sales price for the line item.

Show the quantity of the line item that is used in the BOM calculation.

Show the total sales price for the line item, which equals the unit cost multiplied by quantity.

Show the calculated contribution margin for the line item.

Show the calculated contribution margin for the line item, which equals the sales price minus unit cost, divided by unit sales price.

Show the variable required quantity for the line item.

Show the constant required quantity for the line item. For example, a constant quantity can be defined for a component or for the setup time that is related to a routing operation.

Show the total required quantity for the line item. The quantity equals the sum of the variable and constant quantities.

Show the per-unit required quantity. The quantity equals the total required quantity divided by the BOM calculation quantity.

Show the vendor when trade agreements are used as the source of cost data for a purchased item.

Show the quantity basis when trade agreements are used as the source of cost data for a purchased item. Trade agreements can have quantity breakpoints.

Show the net weight per unit of the line item.

Show the total quantity that is required for the line item, which reflects the BOM calculation quantity.

Show the total net weight for line item, which reflects the BOM calculation quantity.

Show the unit cost for the line item.

Show the quantity basis for the unit cost. Unit costs are typically expressed for a quantity of 1, but the quantity basis can be a different value, such as 100, in order to handle greater decimal precision.

Show the total required quantity for the line item.

Show the variable cost contribution, which equals the unit cost divided by the price unit, multiplied by the total required quantity.

Show the total miscellaneous charges for the line item. Note that miscellaneous charges for a purchased item are manually entered and are calculated for a manufactured item that is based on amortizing constant costs over the accounting lot size.

Show the basis for amortizing miscellaneous charges.

Show the constant cost contribution, which equals the miscellaneous charges divided by the number of series, multiplied by the total required quantity.

Show the sum of the variable cost contribution and the constant cost contribution.

Show the per-unit cost, which equals the total cost amount divided by the BOM calculation quantity.

Show the unit sales price for the line item. The calculated sales price can reflect the profit-setting percentages that are associated with the cost group that is assigned to the line item.

Show the quantity basis for the unit price. Unit prices are typically expressed for a quantity of 1, but the quantity basis can be a different value, such as 100, in order to handle greater decimal precision.

Show the variable sales contribution, which equals the unit sales price divided by the price unit, multiplied by the total required quantity.

Show the total miscellaneous charges for the line item.

Show the basis for amortizing miscellaneous charges.

Show the constant sales contribution, which equals the miscellaneous charges divided by the number of series, multiplied by the total required quantity.

Show the sum of the variable sales contribution and the constant sales contribution.

Show the per-unit sales price, which equals the total cost amount divided by the BOM calculation quantity.

Select the level that you want to use to display the costing sheet information.

  • - Display the information with a breakdown for the single-level product structure.

  • - Display the information with a breakdown for the multilevel product structure.

  • - Display the information for the total without a breakdown for levels in the product structure.

Select the quantity basis to display costing sheet information.

  • - Display the costs per unit.

  • - Display the costs per BOM calculation quantity.

  • - Display the costs per user-specified quantity.

Enter a quantity to display costing sheet information when you select a per basis of a user-specified quantity.

Show the costing sheet code.

Show the description of the costing sheet code.

Show variable costs for the costing sheet code that is based on the behavior that is defined in the cost group.

Show fixed costs for the costing sheet code that is based on the behavior that is defined in the cost group.

Show the total cost for the costing sheet code, which equals the variable plus fixed costs.

See Also