Standard Cost Worksheet Table

Specifies the standard cost in the Standard Cost field on the item card, the Unit Cost field on the work center card or the Unit Cost field on the machine center card. You may, however, sometimes have to update the standard costs for a range of items and production BOMs at once. This you can do by entering data in the Standard Cost Worksheet window. See also Standard Cost Worksheet.

You use the Standard Cost Worksheet table to edit and update the standard costs of the items, work centers and/or machine centers. The program fills in this table showing the current and new cost shares when you run three batch jobs, which suggest standard costs based on:

  • The standard cost on the item cards. To run the Suggest Item Standard Cost batch job, click Actions, Functions, Suggest Item Standard Cost.

  • The standard cost on the work- and/or machine center cards. To run the Suggest Work/Mach Ctr Std Cost batch job, click Actions, Functions, Suggest Work/Mach Ctr Std Cost.

  • The rolled-up costs on the production BOMs. To run the Roll Up Standard Cost batch job, click Actions, Functions, Roll Up Standard Cost.

Note

If you have several worksheets that you want to combine into one, you can use the Copy Standard Cost Worksheet batch job.

When the costs have been rolled up, the current and new single-level and rolled-up costs for the production BOMs can be seen by adding the fields with the Choose Columns function.

All three batch jobs end by displaying the newly calculated standard costs in the Standard Cost Worksheet window, where you can change standard costs that are not satisfactory or delete lines you do not want. When you are satisfied with all the standard costs, click Actions, Functions, Implement Standard Cost Change.

Unlike most other tables, with the Standard Cost Worksheet table, the contents of the fields are temporary until they are deleted or transferred to the Item, Work Center and Machine Center tables.

List of Fields in the Table

Field Location
New Single-Lvl Mfg. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
Rolled-up Cap. Cost Field, Standard Cost Worksheet Table Inventory
New Standard Cost Field, Standard Cost Worksheet Table Inventory
New Single-Lvl Cap. Cost Field, Standard Cost Worksheet Table Inventory
Standard Cost Worksheet Name Field, Standard Cost Worksheet Table Inventory
New Single-Lvl Subcontrd Cost Field, Standard Cost Worksheet Table Inventory
New Rolled-up Mfg. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
New Rolled-up Subcontrd Cost Field, Standard Cost Worksheet Table Inventory
Single-Lvl Material Cost Field, Standard Cost Worksheet Table Inventory
New Overhead Rate Field, Standard Cost Worksheet Table Inventory
Single-Lvl Subcontrd Cost Field, Standard Cost Worksheet Table Inventory
Description Field, Standard Cost Worksheet Table Inventory
Single-Lvl Mfg. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
New Rolled-up Cap. Cost Field, Standard Cost Worksheet Table Inventory
Rolled-up Cap. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
Overhead Rate Field, Standard Cost Worksheet Table Inventory
New Rolled-up Material Cost Field, Standard Cost Worksheet Table Inventory
New Single-Lvl Material Cost Field, Standard Cost Worksheet Table Inventory
Indirect Cost % Field, Standard Cost Worksheet Table Inventory
No. Field, Standard Cost Worksheet Table Inventory
New Single-Lvl Cap. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
Single-Lvl Cap. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
Single-Lvl Cap. Cost Field, Standard Cost Worksheet Table Inventory
Implemented Field, Standard Cost Worksheet Table Inventory
Rolled-up Mfg. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
Type Field, Standard Cost Worksheet Table Inventory
Rolled-up Material Cost Field, Standard Cost Worksheet Table Inventory
Standard Cost Field, Standard Cost Worksheet Table Inventory
Rolled-up Subcontrd Cost Field, Standard Cost Worksheet Table Inventory
New Rolled-up Cap. Ovhd Cost Field, Standard Cost Worksheet Table Inventory
New Indirect Cost % Field, Standard Cost Worksheet Table Inventory
Replenishment System Field, Standard Cost Worksheet Table Inventory

See Also

Reference

Standard Cost Worksheet
Standard Cost Worksheet