Have you ever wanted to model your supply chain? Want to know how much you need to produce/purchase based on inventory levels and demands?
Build the file on your own by following the steps or get it here:
https://www.etsy.com/il-en/ExcelHighway/listing/1178231496/mps-mrp-template-in-excel?utm_source=Copy&utm_medium=ListingManager&utm_campaign=Share&utm_term=so.lmsm&share_time=1651662151374
You can follow this video and build your own MPS (master production schedule) and MRP (material requirements planning).
You can define the suppliers. lead time, costs, BOM, items and much more.
You can see gaps from your requirements and financial estimations.
MRP MPS Model in Excel (2022)
Support this channel on Patreon:
https://www.patreon.com/ExcelHighway
Chapters:
00:00 Intro
00:50 Review of the file
01:39 Build the suppliers database
04:50 BOM
06:35 Inventory
07:35 Demand
08:25 MPS engine
11:10 BOM explosion
13:39 MRP engine
14:18 Summary
Source