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.
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
The following table lists the fields in this table.
New Single-Lvl Mfg. Ovhd 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 |
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 |
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 |
Rolled-up Cap. Cost Field, Standard Cost Worksheet Table |
Inventory |
Standard Cost Worksheet Name Field, Standard Cost Worksheet Table |
Inventory |
Rolled-up Material Cost Field, Standard Cost Worksheet Table |
Inventory |
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