|By: Guest||Posted on: Mar 10 2021 at 04:49:35 AM|
|Does the company behind MiniMrp offer custom (cost) changes?|
I.e. Custom reports?
|By: Support||Posted on: Mar 10 2021 at 07:19:25 AM|
|What kind of report would you like?|
|By: Guest||Posted on: Mar 10 2021 at 08:26:33 AM|
|I hate to bring it up, but some form of average costing. So we was wondering if a report or excel output could be done that had all the receipts grouped by part, the cost of each receipt (ie the cost on the PO) then the total, and average of the group.|
If the result could be shown aginst the standard cost, we could then change the standard when it was more that a certain amout out.
We love using the system, but we do see this as a problem, we want to be able to value our assemblies and stock based on average, not standard costs - this just helps us get closer to that.
It maybe to much, but just thought we would ask.
|By: Support||Posted on: Mar 11 2021 at 05:56:38 AM|
|This is already Work In Progress.|
You'll be able to cost assemblies and total inventory value based on the average cost of your OnHand inventory.
There'll be two options, well, three options actually. #1 would be to use the standard, manually inputted, cost. #2 would be to use FIFO/Average and #3 would be to use most recent purchase price.
Sorry. Can't give any time scale on this. During the summer I hope.
|By: Guest||Posted on: Mar 11 2021 at 08:45:17 AM|
|That is fantastic news!|
Many thanks -
|By: Guest||Posted on: Aug 19 2021 at 02:27:34 AM|
|Is this still on track?|
|By: Support||Posted on: Aug 19 2021 at 03:49:07 AM|
|It's taking time. Not because it's difficult for us to do. But because we fear it will cause a lot of confusion.|
The Math is done. We just need to decide how to use the result present it to the user in a meaningful way.
Look, for example, at the current system. You look in a BOM and you see the total cost of the BOM and can see the cost of individual components. You can select a component and go to that component's detail and see that the item cost shown in the BOM is indeed the current cost of the item from the supplier.
Now consider if instead of current cost we used an average cost paid for the item. That average would not be the same as the current actual cost. If we used the Average cost of components in a BOM that would skew the cost of the BOM but the user would not be able to directly see where each component price came from.
|By: Guest||Posted on: Aug 19 2021 at 04:02:44 AM|
|But also consider that using 'past' average cost of components to show the cost of a BOM might not necessarily be a good thing.|
It is correct that the average cost of components in my current inventory would be accurate for assemblies that I build using parts that are already in my inventory.
But I also use the Build Cost when I'm talking to my customers giving them quotes for future builds. In that case the past average is no good to me at all. The most recent cost would be better.
But currently the cost of materials is going up Up UP. Everything is more expensive and will be even more expensive in future. If I quote a customer a price based on historic average of stuff I bought in the past then I'm likely to loss money.
What we need is for mini mrp to look in to the future and average the cost of FUTURE prices and use that for my FUTURE build costs.
So. What I'm getting at is Yes. Use averages to report on current value of inventory (in the reports menu). But do not try to use it for calculating build costs of assemblies.
|By: Guest||Posted on: Aug 19 2021 at 05:01:51 AM|
|When I first asked about this, I was trying to replicate what our previous system did: -|
Produced a valuation report showing "Average" or "Standard" cost.
Produced a report to value an assembly shown as "Average" and "Standard" cost.
Within each component and assembly, we had the three fields for costs - "Standard", "Last" and "Average". I am not sure if you need "Last" (although it could be helpful for components) - or if you even need to show this on the screen (maybe just in reports as extended information).
The valuation reports had three columns, last/average/standard (again not sure if you need last).
We are using the option to update component costs when goods received, this only works if the stock valuation can be averaged -
All materials are rising in cost, but I can't see how MiniMrp can give any future predictions on this, but at least when a component is increased on the system, it would not give false stock valuations and would provide a better guide to assembly costs rising over time, mainly caused when you must buy odd purchases at higher costs as a one off etc.
I think all this is just about giving as much information to the user as is reasonable, the user then must make decisions how to use it.
In the example given by support above, maybe if the information was only available in reports, which had the columns for standard and average, it would be clear how the totals were reached.
But it's great it's moving forward.
|By: Support||Posted on: Aug 19 2021 at 06:15:52 AM|
|Yes. It is moving forward. But I fear it won't be exactly what you want. I can't imagine MiniMRP would benefit from 3 columns showing item cost/valuation calculated 3 different ways.|
I want to emphasise the word MINI in the program name.
|By: Guest||Posted on: Aug 19 2021 at 10:10:32 AM|
I was just explaining what we had - all i (and others) really need is to know what the average value of the stock we have is, and ideally what the average cost of an assembly is.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.