• Home
  • About Me
  • Contact
  • German
  • TestPage

Microsoft BizApps Finance & Controlling

Microsoft BizApps Finance & Controlling

Tag Archives: inventory cost revaluation

Parallel inventory valuation – an alternative approach (Part 2)

15 Wednesday Mar 2017

Posted by Ludwig Reinhard in General Ledger, Inventory

≈ Comments Off on Parallel inventory valuation – an alternative approach (Part 2)

Tags

Inventory, inventory cost revaluation, parallel, standard costs, valuation

After having analyzed how to deal with purchase price variances in order to arrive at a second (parallel) inventory value, let’s have a look at the second standard cost variance type – the inventory cost revaluation – and how to deal with those variances to obtain a second (parallel) inventory value for standard cost items.

 

Scenario:
At the end of a fiscal year, the standard costs of a first item are adjusted from $100 to $109. For a second standard cost item, the standard costs are adjusted from $100 to $95. As there are currently 100 pcs from each of the items on stock, a total inventory value of $20000 can be identified (before adjusting the standard cost prices) in the financial statements illustrated in the next figure.

203_p2_0005_neu

warningsign1 For reasons of simplicity the inventory values/balances have been created by posting an inventory adjustment journal that resulted in an inventory receipt & profit transaction.

 

The aforementioned revaluation of the standard cost item is realized by recording and activating the new standard cost prices in the standard cost costing version, as exemplified in the next screen print.

203_p2_0010_neu

Once the new standard cost prices are activated, the financial statements show a $400 higher inventory value. This can be identified from the next figure.

203_p2_0015

The overall increase in the inventory value can be explained by the value increase of the first standard cost item [($109-$100) x 100 pcs] and the value decrease of the second standard cost item [($95-$100) x 100 pcs]. If the revalued items will be sold subsequently, the newly activated standard cost prices will be used for posting the issue transactions.

 

At this point the question arises whether the inventory cost revaluation amount can remain in the income statement as illustrated in the previous screen print or whether an adjustment similar to the one that has been shown in the first part for the purchase price variance (PPV) is required in order to get a second (parallel) inventory value?

This question can be answered by stating that no split and allocation of the cost revaluation is required, if the cost revaluation is done in a way to adjust the standard cost prices to an ‘actual’ market price. If this is the case, any previously recorded adjustment and allocation of the PPV needs to be reversed in order to avoid an over-adjustment of inventory values towards actual market prices/values.

In practice, most companies do not adjust their standard cost prices in a way to reflect ‘actual’ (market) cost prices. Otherwise, they would have chosen an alternative actual cost price valuation model right from the beginning. Against the background of this common adjustment behavior, it can be argued that an adjustment of the recorded standard cost revaluation amount is necessary in order to arrive at an approximated actual inventory cost price. The main question in this context is then how such an adjustment can be realized?

From the authors’ perspective, the complete cost revaluation amount needs to be shifted (allocated) from the income statement to the balance sheet in order to arrive at an actual cost valuation amount. That is because only those items that are currently on stock (or in process) – that is receipt transactions – are affected by the cost change variance. If those items are sold or consumed later on the adjusted higher/lower standard cost price will ensure that the cost revaluation amount that has been allocated to the balance sheet is successively eliminated. For that reason no split up and allocation of the cost revaluation amount is necessary.

The next part of this series continues with analyzing cost change variances and how they need to be incorporated into this parallel inventory valuation approach.

Microsoft BizApps Deutschland Podcast

Dynamics UserGroup Deutschland

Project Accounting Book – Part 2

Project accounting book

Categories

  • Accounts Payable
  • Accounts Receivable
  • Bank Management
  • Book reviews
  • Budgeting
  • Cost accounting
  • Fixed Assets
  • General Ledger
  • Inventory
  • Management Reporter
  • Miscellaneous
  • Podcast
  • PowerPlatform
  • Project
  • Sustainability
  • Uncategorized

Tags

Advanced bank reconciliation AI Allocations Artificial Intelligence Automation Azure Bank reconciliation BizApps Budgeting Controlling Copilot Copilot Studio Cost accounting module Cost center accounting D365 D365FO Dynamics 365 Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Flow Global Warming invoice invoice recording IOT LEGO Management Accounting MS Flow MT940 PowerApps Power Apps PowerAutomate Power Automate PowerPlatform Power Platform Process Mining Project RPA Security SharePoint Sustainability Sustainability Accounting Sustainability Manager Tax time recording Vendor payments WBS workflow

Enter your email address to follow this blog and receive notifications of new posts by email.

Subcribe

  • RSS - Posts
  • RSS - Comments

Legal

  • Disclaimer

Important Websites

  • Microsoft BizApps Links

Archives

  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015

Blog at WordPress.com.

  • Subscribe Subscribed
    • Microsoft BizApps Finance & Controlling
    • Join 615 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Microsoft BizApps Finance & Controlling
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...