How does the Work Order Cost Roll-Up Register calculate costs in Sage 100
How does the Work Order Cost Roll-Up Register calculate costs listed on the report
The Cost Roll-Up Register for Work Order calculates the cost of each bill based on the cost of each component in its bill of materials, yield and scrap percentages, and the labor and overhead in the routing. The cost of all component bills assigned to the specific parent bill is recalculated, regardless of the number of levels involved. The standard cost for the inventory item is updated with the calculated cost following the completion of the report.
The cost of each component item can be specified to use the average, last, or standard cost. The labor and overhead amounts are calculated based on the information contained in the product routing specified for the bill. In addition, scrap and yield percentages can be factored into the cost. Information provided on the register includes the bill number, description (if applicable), labor and overhead costs, material cost, total calculated cost, old cost, and cost variance.
You can select whether to update the cost of only the parent bills selected, or the update the cost of all component bills, regardless of the number of levels involved. Option bills are not included in the cost calculation. Only the current revision of the base bills is updated.
If cost rollup is performed on inventory items using the Standard Cost valuation method, the appropriate General Ledger adjustments are posted to the Inventory and Manufacturing Variance Adjustment accounts.
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.