Home Button  Buy Button 

Topic:   Shortage costs and sorting by lead time?

By: ChrisPosted on: Jul 13 2017 at 11:17:00 PM
We manufacture a single assembly that uses numerous components. I have always used an Excel spreadsheet that has vendors, their lead time, MOQ, qty required per each assy we make, and how many of each of these component we have in inventory.

Using that information, if I know we need to produce 100 units in a few weeks, I can use the above data to calculate the cost of fulfilling the order based on how many of each item we have in inventory versus what we're short on. I also always have the sheet sorted by lead time so I can easily go down the list and order as needed to cover a shipment.

Why is there no cost shown or tallied up in the Shortages section of MiniMRP? It would do everything we needed if it were possible to:

1. Sort shortages by lead time, making it easy to identify which supplier to contact and order from first.

2. Show cost associated with the shortage based on MOQ of the supplier and how many components we need to fulfill a work order/customer order.

Any recommendations? I love everything else about MiniMRP and it does exactly what I want it to do regarding BOMs/ASSYs and helping prevent an errant keystroke from throwing off my spreadsheet setup I currently use.

By: SupportPosted on: Jul 15 2017 at 10:38:00 AM
In the main shortage report (the one showing all inventory items over all planned work orders) sorting is disabled because the report is grouped by part number and sorting by other columns would break the groups.

But I can't remember why sorting is disabled in the work order shortage report (The report showing shortages for just one work order). I'll make a note of this and if possible we'll enable sorting in this report.

Showing costs of items in the shortage report. I agree that showing a column with the item cost could be beneficial. I'll have that included in the next version. But I don't think we'll go the extra step and do the math for you to show the cost of shortages based on MOQ. We'd just show the item cost and maybe columns for information such as supplier UOM and MOQ.

By: ChrisPosted on: Jul 16 2017 at 09:15:44 PM
That would be great! If I had the cost and MOQ column I could at least export it to Excel and use the formula I'm currently using to figure out overall cost of fulfillment.

By: ChrisPosted on: Aug 24 2017 at 05:19:42 PM
When is this update planned to be rolled out?

It would be very easy to "do the math" to show cost of shortage based on MOQ and it makes sense. If a part has a 500 MOQ and you only need 28 parts, and you know the piece price, it should simply multiply 500 x piece price. Pretty straightforward IMO but again, easy enough for me to export the data from MiniMRP and have that column auto-fill in Excel as-needed..

By: SupportPosted on: Aug 24 2017 at 07:03:36 PM
We're aiming for end of this year (2017) but might end up in january (or later if we keep adding features)

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Shortage costs and sorting by lead time?

Enter the numbers.

Your name here is optional