Variable and Fixed Overhead Absorption in Microsoft Dynamics NAV

Variable and Fixed Overhead Absorption in Microsoft Dynamics NAV
There are Dynamics NAV clients that would like to separate Variable and Fixed Overhead. If we look at a Dynamics NAV Work Center Card, we see that we can put in a Direct Unit Cost and an Indirect Cost % or Overhead Rate. However, there is no place to indicate if this cost is Variable or Fixed. To accommodate a Fixed Cost Component to the Cost of Production, we start by creating a new Work Center that I have named “FIXED OVERHEAD”. View of the Work Center Card
Figure 1 – View of the Work Center Card We have set the Direct Unit Cost to 10.00 and the Unit cost Calculation to “Units”. Creating a new Work Center for the Fixed Cost Component
Figure 2 – Creating a new Work Center for the Fixed Cost Component We created a new General Product Posting Group called FIXED OH and pointed the Direct Cost Applied Account to a new General Ledger Account that we also called FIXED OH. Creating a new General Product Posting Group
Figure 3 – Creating a new General Product Posting Group We then added a Parallel Operation to the Routing Lines using the new FIXED OVERHEAD Work Center. Adding a Parallel Operation to the Routing Lines
Figure 4 – Adding a Parallel Operation to the Routing Lines To test it, we created a Released Production Order that calls for the routing to which I added the parallel step. Creating a Released Production Order that calls for the routing set up previously
Figure 5 – Creating a Released Production Order that calls for the routing set up previously After we have changed the Production Order to the finished status, we can see in the General Ledger that it reflects the appropriate Debit to the WIP account and to the Fixed Overhead Absorbed account. The General Ledger shows the appropriate values as desired
Figure 6 – The General Ledger shows the appropriate values as desired For more information on this or any other Dynamics NAV costing topic, please contact ArcherPoint. Read more "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.

Trending Posts

Stay Informed

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