Standard Cost Worksheet Table

List of Fields in the Table

You enter and update 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 3 batch jobs, which suggest standard costs based on:

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, either by zooming on the lines or by adding the fields with the Show Column function.

All 3 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 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.



© 2009 Microsoft Corporation. All rights reserved.