Basic Instructions for rolling all Standard Costs

Basic Instructions for rolling all Standard Costs




Basic Instructions for rolling all Standard Costs


Summary:  This document explains the basic steps to roll standard costs on all MFG. items in the system.  A methodical approach is key to making sure that all costs are correctly rolled throughout all items in the system. 



Considerations:

If you are attempting to update all costs including the following please do so in the order as described.


  1. Update Labor Rates – located in the System Setup Tab, Lists, Employee Level.
  2. Update Overhead Rates – there are two methods for doing this.
    1. If you are using work center level rates update each work center for the correct rate
    2. If you are using Master Center Type Rates update the Center Type Rates and make sure to apply the change across all of the related machines

  3. Update if required the Standard Calc. Quantity remember this is used to spread the costs of a setup across X quantity of produced parts.  The default in the system is 1000 pieces however this can be overridden at the item level on the Standard Costing Tab
  4. Update Raw Materials Cost – various methods can be used (please see Raw Material Cost update for more information)
    1. Update Future Costs with average costs (uses the current average cost calculated by the system)
    2. Update Future Costs with Last Purchase Order Price
    3. Before proceeding the user can run reports to find any major variance in the cost updates on the purchased items.

  5. Update any Outsource Costs – this is required due to the nature of how outsource works, the user will have to update each item with an outsource cost.


Rolling Costs on all MFG. Items:

  1. In the inventory module proceed to the lowest level item that you can find
  2. Go to the Standard Costing Tab and select Calculate Cost
  3. At the prompt to recalculate now click on the no button  
  4. In the Cost Calculation Module do the following 
  5. When this is completed if there are requirements too the system will book entries to the Asset accounts for inventory offset by entries to the expense accounts 


  1. Step 1 – select the Calculate All Button and then select the Calculate Future Costs button  at the prompt select yes
  2. Step 2 – before posting you can run various reports to see the overall effect that the cost roll will have on the current value of inventory.  You can make any corrections now as nothing has been posted yet
  3. Step 3 Select the Roll all to Current Button  


Rules:

  1. Make sure that all of the following PIT transactions are posted before proceeding
    1. Receiving Transactions
    2. Shipments Pending Invoice 
    3. Scrap
    4. Intercompany 
    5. Manual Adjustments
    6. Disposition
    7. If using Assy 1,2,3 Mfg. Types
      1. Process WIP
      2. Finish Process WIP

    8. Physical Inventory 
    9. PM
    10. RMA 




    • Related Articles

    • Rolling Std Cost for Raw Materials

      ​ ​ Rolling Std Cost for Raw Materials Summary:  This document gives the user a General Overview of how to role the Last Purchase price of a raw material into standards.   The system will pre-populate the Future cost of the Raw Material with the last ...
    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...
    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...
    • Account Revaluation

      Standard Costing in EIQ EnterpriseIQ supports a complete Standard Costing system, linking various inventory and financial transactions to specific General Ledger accounts.  The complete standard, perpetual inventory (explained below) costing system ...
    • Tips and Tricks for Proper Inventory Control

      ​ ​ Tips and Tricks for Proper Inventory Control – GL/Perpetual  Summary:  This document explains how to help keep the Perpetual Inventory and G/L Accounts in balance when using Standard Costing or Actual Costing* in EIQ.   Many things can cause the ...