Paul Barnhurst walks through a Price-Volume-Mix analysis using a tool that calculates how price, volume, and mix changes affected margins. He uses a workbook with three products and their budget versus actual numbers, showing how the tool handles variance calculations and visualizations for financial planning.
It's going to have to continue to stay a step ahead of Microsoft built in tool. This is pretty mind blowing that it can do this but again like it's not replacement yet but it's a great start. It's getting some great stuff done and it's impressive what it's able to do on the things you've tested it for. Well, let's go ahead and move on to some FP and A use cases. We'll be able to test two or three here. This is the price volume mix where it's looking at margins and saying how much did the price impact it? How much did the volume impact it? And then how much did the mix of the individual products impact it? Called Paul's Getting Spicy. It has three different products. We won't get into the details about them but there's one called bbb, PMP and boss and we can see we have budget and actuals. So what we're going to ask it to do is we're going to ask it to fill in the price right here for these three products. We'll start with that prompt. We're going to go ahead and copy it in. Basically I said hey look in this workbook we have a price, volume mix. I want you to give me the answers in these cells. So let's see what it does here. You can see it already did some work. It says this workbook walks through a PVM topics. I can help with variance calculations, result visualization, summary. Where would you like to start? I'll give it my prompt and we'll be back here in a minute.
Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie
