MRP & MPS Model in Excel - Master Supply Chain Management

[@excelhighway3549]

Support this channel on Patreon and receive the file: www.patreon.com/ExcelHighway

[@maimisa]

Great!

[@excelhighway3549]

Thanks

[@mahyar1976]

Awesome! Thanks

[@excelhighway3549]

You are welcome

[@mkm130402]

excellent . May I please have the copy of the spreadsheet used?

[@excelhighway3549]

Thanks , the file is available on my Patreon page: www.patreon.com/ExcelHighway

[@adnanrasheed4098]

Excellent!!!!

[@excelhighway3549]

Many thanks!

[@susanwibisono7468]

This is the best explained of MRP/MPS excel calculation. Would you please share the file?

[@excelhighway3549]

Thank you, please send me an email

[@reetkay9208]

very nicely explained. May I please have the copy of the spreadsheet used?

[@excelhighway3549]

Thank you, please send me an email.

[@travelvibes4786]

Great video

[@excelhighway3549]

Thank you

[@SD-un3ii]

Query: Sheet - MPS> Column B(On Hand Formula) seems incorrect, it should be = sumifs(Inventory _data!$C:"$C, Inventory _data!$a:"$a, $a3, Inventory _data!$d:"$d, b$1). Same with Mrp sheet for" on hand". Please, share your review.

[@1981Kato]

Thank you!.. Nicely done. Quick question regarding the MPS tab. Are you considering those as just buy/sell or assy as well ?

[@excelhighway3549]

Hi, the MPS sheet reviews the finished good items status. The items can be bought or produced in house. It will not effect the net requirements. Does that answer your question?

[@1981Kato]

@@excelhighway3549 yes. I will send you an email asking for the format. Thanks!

[@carlamaeorate4449]

Hi @Excel Highway Can you share your soft copy file? It will ,much help for me since we don't have yet system in our company to rely on. Thank you.

[@excelhighway3549]

The file is available on my Patreon page - www.patreon.com/ExcelHighway

[@joccoloccco]

Hi. I have a question, on the supplier tab. What if all the suppliers are local? And mode of transport is only land. Thank you if answered.

[@excelhighway3549]

That's not an issue. You can add a mode of transport called land with the proper lead time and just select that for the relevant suppliers.

[@joccoloccco]

@@excelhighway3549 Thank you. Also, in the Supplier tab, the production lead time. Is it per unit? (I have the weekly version of the template)

[@excelhighway3549]

@@joccoloccco the production lead time is per supplier. It's a general definition that does not depend on the item or quantity. You can of make some adjustments to structure it so they are depending.

[@mahmoudawad5467]

Hi Sir, can I get this spreadsheet so that I can enhance my learning about MRP and MPS, it would be a great support.

[@excelhighway3549]

The file is avaialbe on my Patreon page: www.patreon.com/ExcelHighway

[@MrMichaellyday13]

This is a great video & visulization of a production schedule. Would you be able to send me a copy of this spreadsheet?

[@excelhighway3549]

Thank you , the file is available on my Patreon page: www.patreon.com/ExcelHighway

[@ashoksardana5030]

Great Video Could you please share the excel file or the formulas used in this model

[@excelhighway3549]

Yes, sure

[@ashoksardana5030]

@@excelhighway3549 thank you so much

[@NickRichards-i4r]

Hi, Great video. Anyway i can get a copy of the file?

[@excelhighway3549]

Thanks, the file is available on my Patreon page or Etsy shop.

[@KO99758]

Awesome explanation. Very detail. Can I get a free copy of the spreadsheet. Thank you

[@excelhighway3549]

Thank you, please send me an email.

[@nicholassoen3708]

Would you be able to modify this into weekly basis instead of monthly?

[@excelhighway3549]

Yes, on my Patreon site you can find a monthly and weekly version: www.patreon.com/ExcelHighway

[@nicholassoen3708]

@@excelhighway3549 very nice, i'll check it out

[@nicholassoen3708]

@@excelhighway3549 OK. Sorry one more question, what if the BOM is multi level?

[@excelhighway3549]

@nicholassoen3708 I have another file there that explodes multi level BOM. You cam combine the output from that file in the mrp file.

[@johndivelbiss2762]

This was outstanding and great work. Please let me know if you would be kind enough to send me the file so that I may use it for a template. - Thanks, JD

[@excelhighway3549]

Thank you for your feedback. The file is available on my Patreon page or Etsy shop

[@mohammadsweileh8601]

Great video, where i can get the excel sheet??

[@excelhighway3549]

Please send an email to [e-mail] for the file

[@pratikpalorkar5191]

Hi Sir! Can I get a free copy of the spreadsheet to enhance my MRP and MPS learnings?

[@excelhighway3549]

The file is available on my Patreon page; www.patreon.com/ExcelHighway

[@toysnoise9521]

I bought this file from ETSY APP before two months ago it’s very helpful & grateful but actually found two types of lead time which are monthly & weekly, could you please support me to create a daily lead time form.? Thanks

[@excelhighway3549]

Thank you for your support. Please send me an email and we can discuss the details.

[@eloidacubar9045]

is it possible to request a copy of the worksheet?

[@excelhighway3549]

The file is available on my Patreon page: www.patreon.com/ExcelHighway

[@madaniahlem9501]

Hello thank you for the video. Can you share the excel file with us please ?

[@excelhighway3549]

Sure, please send an email to [e-mail]

[@sihuannguyen2122]

Thank you! You can share the file free?

[@excelhighway3549]

The file is available on my Patreon page: www.patreon.com/ExcelHighway

[@asadipushpalatha2241]

Can i get the excel spreadsheet

[@excelhighway3549]

Yes, the file is available on my Patreon page: www.patreon.com/ExcelHighway

[@nguyenletuanvu811]

Nice video. Can you share me this file. Thanks.

[@excelhighway3549]

Thank you, the link is in the description.

[@rakshitmuwal5581]

can i get this excel sheet?

[@excelhighway3549]

Please send an email to [e-mail]

[@Philbnyc]

Love to get a cooy

[@excelhighway3549]

The link is in the description

[@score9091]

Can i get free?

[@excelhighway3549]

Sorry, it's bo longer available for free. For a small payment, you can receive the file and many others on my Patreon page: www.patreon.com/ExcelHighway

[@KarlaMayVidal]

very nicely explained regarding MRP/MPS . Would you please share the file? @excelhighway3549 Thank you

[@excelhighway3549]

The file is available on my Patreon page - www.patreon.com/ExcelHighway

[@SD-un3ii]

Hi Sir, can I get this spreadsheet so that I can enhance my learning about MRP and MPS, it would be a great support.

[@excelhighway3549]

Sure, please send me an email

[@amanitghershen5727]

Can i get also pls