Cost Roll

Form ID: (AM508000)

You can use this form to do the following:

Roll up the costs of bills of material (BOMs) based on the costs of the entities included in the BOMs, such as labor or material.
Update material costs on bills of materials.
Use the roll up cost of subassemblies for the parent BOM cost calculation.
Use the current item valuation for the cost roll process.
Use the roll up cost to update the pending standard cost of stock items whose item valuation method is Standard. For more information, see Bills of Material: Updating Standard Costs.

Attention:

When it updates the pending standard costs of items assigned to the BOMs, the system typically updates the pending costs of the stock item on the Price/Cost tab of the Stock Items (IN202500) form. The system instead updates the pending cost of the item–warehouse pair on the Price/Cost tab of the Item Warehouse Details (IN204500) form if the following conditions are met:

A warehouse is specified in the Warehouse box on the Bill of Material (AM208000) form.
A record for the item–warehouse pair exists on the Item Warehouse Details form.
The Override Std. Cost check box is selected on the Price/Cost tab of the Item Warehouse Details form.

On this form, you can also archive the results of the cost rollup process.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.


Command	Description
Archive	Archives the results of the cost calculation to the Cost Roll History (AM408000) form. You can archive the results after the cost rollup process. If the Allow Archive without Update Pending check box is selected on the BOM Preferences (AM101000) form, you can archive the cost rollup results without updating the pending costs. If the check box is cleared, you must update pending costs first by clicking Update Pending. The system archives BOM records for the current date. If you archive the results multiple times on the same date, the system overrides the previous data for this date.
Roll Costs	Rolls up the cost of the bills of material that meet the criteria in the Selection area. If no criteria are specified, the system rolls up the costs for all bills of material.
Update Pending	Updates the pending costs of the stock items assigned to the BOMs for which costs have been rolled up with the calculated costs. This is only applicable for items with the Standard valuation method. The system finds the items based on the value in the Default BOM ID box on the Stock Items (IN202500) or Item Warehouse Details (IN204500) form. If the Auto Archive when Update Pending check box is selected on the BOM Preferences (AM101000) form, the system archives the cost rollup results after updating the pending costs. The results are archived for stock items with any valuation method. For details about updating standard costs for items to be produced, see Bills of Material: Updating Standard Costs.

Selection Area

Some of the elements in this area limit the bills of material that are processed when you run cost rollup. For example, you may want to roll up costs for items in a particular warehouse or assigned to a particular item class. You can also specify whether the system should roll up costs for subassemblies included in BOMs or use the cost specified for each subassembly on the Materials tab of the Bill of Material (AM208000) form.

Attention:

The system does not use the criteria you specify to narrow the list of bills of material that are listed in the table before you run cost rollup.


Element	Description
Level	The depth of cost calculation, which indicates whether the system should calculate costs for included subassemblies. You can select either of the following options: Single (default): Calculates the costs only for the current level of each bill of material. If a BOM contains any subassemblies, the system uses the cost specified for the subassembly on the Materials tab of the Bill of Material (AM208000) form. Multi: Rolls up costs level by level from the bottom up. This means that the system first calculates costs for all subassemblies included in a bill of material, starting from the lowest-level subassemblies, and then uses these costs in calculation of the top-level BOM costs.
Item Class	The item class assigned to the stock items whose costs you would like to roll up. If Multi is selected in the Level box and the BOM assigned to an item of the class includes subassemblies, the system will calculate costs of the related subassemblies with any item class.
Warehouse	The warehouse assigned to bills of material for which you costs will be rolled up.
Inventory ID	The identifier of the stock item for which costs will be rolled up. If Multi is selected in the Level box and the bill of material assigned to the item includes subassemblies, the system will calculate costs for the subassemblies and list the subassembly records in the table.
Subitem	The subitem of the inventory item for which costs will be rolled up. This column is visible only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
BOM ID	The bill of material for which costs will be rolled up. If Multi is selected in the Level box and the BOM includes subassemblies, the system will calculate costs for the subassemblies and list the subassembly records in the table.
Revision	The revision of the BOM specified in the BOM ID box for which costs will be rolled up.
Effective Date	The effective date of the pending cost, which the system will copy to the Pending Cost Date box of the Price/Cost tab on the Stock Items (IN202500) or Item Warehouse Details (IN204500) form. This setting is required if you will apply the rolled up costs to pending costs by clicking the Update Pending button.
Include Material Scrap Factors	A check box that you select if the system should consider the scrap factor specified for materials on the Materials tab of the Bill of Material (AM208000) during the cost roll process.
Include Fixed Costs	A check box that you select if the system should include all fixed costs (such as the setup time of an operation or fixed overhead costs) in the BOM cost.
Update Material	A check box that you select if the system should update the unit costs of the materials used in the BOMs during the cost rollup.
Use Pending Standard for Purchase Items	A check box that you select if the system should use the pending standard cost instead of the standard cost for purchased items when rolling up costs. This check box applies to only items with a valuation method of Standard.
Ignore Min/Max/Lot Size Values	A check box that you select if the system should ignore the Min Order Qty., Max Order Qty., and Lot Size settings on the Manufacturing tab of the Stock Items (IN202500) or Item Warehouse Details (IN204500) form when calculating fixed costs (such as labor or overhead costs) during the cost rollup.

Table

The table lists the bills of material for which the system has rolled up costs.

Attention:

The system does not use the criteria you specify in the Selection area to narrow the list of bills of material that are listed in the table before you run cost rollup.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 1. Table Columns
Column	Description
BOM ID	The bill of material whose cost has been rolled up.
Revision	The revision of the bill of material specified in the BOM ID column.
Warehouse	The warehouse assigned to the BOM.
Inventory ID	The stock item assigned to the BOM.
Subitem	The subitem of the inventory item. This column is visible only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Unit Cost	The unit cost of the item, which has been calculated during the cost rollup process. The system copies this cost to the pending cost of the item when you click Update Pending.
Material	The total cost of the BOM materials. The system calculates the cost of subassemblies included in the BOM depending on the value of the Level box in the Selection area. The system uses the cost of each material that is a finished good from the Price/Cost tab of the Stock Items (IN202500) form or the Item Warehouse Details (IN204500) form according to the valuation method assigned to the material on the General tab of the Stock Items (IN202500) form as follows: Average or FIFO: The average cost is used. If the average cost is 0, then the last cost is used. Standard: The standard cost is used. Specific: The last cost is used.
Fixed Labor	The fixed labor cost. The system calculates this cost as the sum of the setup times for each operation of the bill of material multiplied by the standard rate of the work center assigned to the operation.
Variable Labor	The variable labor cost. The system calculates this cost as the sum of the labor time (which is a run time multiplied by the number of run units) for each operation multiplied by the standard rate of the work center assigned to the operation.
Fixed Overhead	The total cost of fixed overhead.
Variable Overhead	The total cost of variable overhead.
Tools	The total cost of tools.
Machine	The total machine cost. The system calculates this cost as the sum of the machine time for each operation multiplied by the machine rate per hour.
Subcontract	The cost of materials with a type of Subcontract and a subcontract source of Purchase or Ship to Vendor.
Ref. Material	The cost of materials that have a type of Subcontract and a subcontract source of Vendor Supplied. The cost of these materials is not included in the product cost because the materials are supplied by the vendor.
Lot Size	The lot size, which the system uses to apportion fixed costs, such as fixed labor costs and fixed overhead costs. The system copies the lot size from the Lot Size box of the Stock Items (IN202500) or Item Warehouse Details (IN204500) form. If the lot size is 0, then the system copies the Min Order Qty. value. If this value is also 0, then the system specifies a lot size of 1.
Status	The status of the BOM revision.
Description	The description of the bill of material.
Level	The level of the BOM relative to the parent BOM. For the top-level bill of material, the level is 0. For the subassembly of the top-level BOM, the level is 1. The system defines the levels of all nested subassemblies similarly.
Fixed Labor Time	The total setup time for all operations of the BOM.
Variable Labor Time	The total run time for all operations of the BOM.
Machine Time	The total machine time for all operations of the BOM.
Item Class	The item class of the stock item specified in the BOM.
Current Standard Cost	The current standard cost if the item has the Standard valuation method. The system copies this value from the Price/Cost tab of the Stock Items (IN202500) or Item Warehouse Details (IN204500) form.
Pending Standard Cost	The pending cost if the item has the Standard valuation method. The system updates this value when you update pending costs by clicking the Update Pending button.