Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

Does anyone do any What if Cost Analysis – analyzing raw material cost increases and rolling them up (through production BOMs) to review change to finished good costs?
Are there any add-ons for this?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Board of Advisors, Chairperson Emeritus
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————

[Kari Strandberg]

We perform the What if scenarios in our test database copy using the same processes that are needed to update costs (update costs on Raw Materials and L&OH rates).  There have been times that we have so much going on in the test database copy that we have made another database copy to do these scenarios.

For us, this is a requirement of our financial audit as we use standard costs and need to get to a FIFO cost for GAAP purposes.  

The need for What-if costs is desired in 4th quarter to be used for the following year’s budgeting and goal setting.

I am interested if there is an add-on or a better solution.

——————————
Kari Strandberg
Director of Finance
Bernatello’s Foods
Maple Lake, MN
——————————
——————————————-

[Andrew Good]

If you are using Standard Cost the Standard Cost Worksheet is as great tool. Alternately, if you have a reporting database it presents another good option.

——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————
——————————————-

[Victor Diercksen]

I have had a few clients over the years that do costing what-if analysis with inventory items.  I have never found an add-on that would work for the ‘typical’ NAV/BC end user.  There are some very good 3rd party solutions out there, but they are designed for companies that use AX, Oracle, SAP, etc. and are out of reach, from a budgetary perspective, for most end users here.  

I see Excel used for this, typically with a DB connection such as Jet or SSRS to automate pulling data into the worksheet.

Let me know if you find anything.

Sincerely,
Victor Diercksen

——————————
Victor Diercksen
CIO
CIO/NOW Inc.
Sandy UT
——————————
——————————————-

[John Grant]

Lewis – adding to the discussion. You are able to populate the Standard Cost Worksheet with FIFO costs even if you are not a Standard Coster. Use the Suggest Item cost and populate Purchased items first using FIFO costs. Update key items with a new what if cost and then select to Roll-up Prod. Order items which will use the new what if costs in the worksheet for the purchased item and give you a new prod. Order item cost. All can be done in the Standard Cost worksheet.

You are also able to ‘implement’ even though you are not using Standard costing. Note: The implement from the Standard Cost worksheet may create revaluation journal entries which most customers will delete from month to month but could be used to revalue the layers once a year for FIFO purposes if needed. Using the Standard Cost Worksheet with FIFO would be a tool for ‘what if’ even if you do not implement the results.

The implement causes the Rolled up and Single level values to be populated on the item record and the Standard Cost field is populated but none of the values aret used in any day-to-day transactions since the costing method is FIFO. This would allow you to use those values on the item record for ad hoc reporting.
All the above is available but as usual I recommend using a TEST company to validate before changing any of your processes.

For a single item you also could also create a Simulated Production Order to see all the costs right now using Unit cost values and a what if quantity for the item suing the statistics view on the Prod. Order. The Cost Shares from the item card can also be used to quick view an item cost for a qty of 1.

Best Regards

——————————
John Grant
Senior Application Consultant
Innovia Consulting
——————————
——————————————-

[Lewis Rosenberg]

Thanks John.  I think I suggested that to our team a couple of months ago and I don’t remember if I ever got a response.  I just put a demo video together for them to see how it actually works.  I think the steps you outlined are exactly what they are looking for.  We’ll see.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Board of Advisors, Chairperson Emeritus
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————
——————————————-

[Shawna O’Neill]

As a follow-up to this question, what is best practice to incorporate future cost increases.  We are currently in the process of resetting standards but have notifications of bigger cost increases coming and want to analyze the impact for our pricing cycle?  We have found on the item card where we can put in a purchase cost with an effective date but is there a way to get the standard cost roll to pick that up?

Thanks, Shawna O’Neill
American Art Clay Company
Indianapolis, IN

——————————
Shawna O’Neill
American Art Clay Co
Indianapolis IN
——————————
——————————————-