Unexpectedly High New Standard Cost in Microsoft Dynamics NAV

Unexpectedly High New Standard Cost in Microsoft Dynamics NAV

There are times when you are using the Dynamics NAV Standard Cost Method and rolling up a Standard Cost for a Produced Item you get an unexpectedly high Standard Cost. A probable cause is that you have selected "Cost Includes Setup" in the Manufacturing Setup and that you have a setup time in a Routing Line but forgot to enter a value for ‘Lot Size’ on the item card. Checking or unchecking the “Cost Includes Setup” in the Manufacturing Setup window can affect Standard Cost
Figure 1 – Checking or unchecking the “Cost Includes Setup” in the Manufacturing Setup window can affect Standard Cost From the Dynamics NAV Help for Lot Size on the Item Card: If the item routing includes fixed costs such as setup time, then the value in this field is used to calculate the standard cost price and distribute the fixed costs of manufacturing the item. Here is the Routing for the Bicycle Item 1000 that shows Setup Time in the Routing. Setup Time in the Routing table
Figure 2 – Setup Time in the Routing table When we roll up the standard cost for Item 1000 with the Lot Size set to zero, we get $533,399. Setting the Lot Size to zero…
Figure 3 – Setting the Lot Size to zero… …yields a Standard Cost of $533,399
Figure 4 – …yields a Standard Cost of $533,399 When we set the Lot Size to 10, I get a Standard Cost of $383.099 Setting the Lot Size to 10…
Figure 5 – Setting the Lot Size to 10… …yields a Standard Cost of $383,099
Figure  6 – …yields a Standard Cost of $383,099 For more information on this or any other Dynamics NAV topic, please contact ArcherPoint. For more step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of How-To blogs.

Trending Posts

Stay Informed

Choose Your Preferences
First Name
*required
Last Name
*required
Email
*required
Subscription Options
Your Privacy is Guaranteed