How to check production order statistics in Business Central?
In this video, I want to show you how to view a production order statistic, seeing how much money you have used on a production order in Business Central.
This is what happens in the video
But before doing that, I’d like to point your attention to one issue on the item card, because it is important to understand, when watching the statistics.
So, I go to the item number 1210 that I am producing, I can see on my item card in the field number, lot size is not filled in, meaning it’s zero.
Using Business Central, the lot size will default be set to 1, if 0 is entered.
So, when calculating, the lot size will now be defined as 1.
And what does the lot size express? It expresses the normal quantity I want to produce an item in, so when I enter the released production order now, and I’ve done postings on materials, and output a time and material on this item, the Back Wheel.
So, when I’m watching the statistics for this item, the base statistics was based on a lot size of 1, but in this case, I’m actually producing 25.
So, when I enter Navigate, Order, Statistics, I can see the statistics on the released production order.
The first column, my standard cost comes from the item card, and here I can see the capacity cost being very high, and that’s because the set-up time on the routing is divided by 1, because the lot size is 1.
Whereas the expected cost is very low, because I actually expected to produce 25, and in real life, I produced only 18 for some operations, and 19 and 20 for others.
So, my expected cost is calculated on this specific production order, with 25 pcs, and the actual cost is the real cost that I’ve consumed, I can see the deviations in percentages and in money for this specific production order.
This actual cost of 6820 is the amount that goes into the WIP account and waits there until the production order is reported finished.