BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ashishdhakad
Fluorite | Level 6

Hi , I just wanted to know the calculation formula of Reorder level , order upto level and Safety stock in Proc MIRP although i i know it will be automatically given by the proc but i just wanted to know , can someone help me in the formula . Thank You

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

When SAS documentation such as at https://documentation.sas.com/doc/en/pgmsascdc/v_024/irpug/irpug_mirp_details03.htm

Has limited details like:

The OBJECTIVE=CREATEORDER option in the PROC MIRP statement is designed to support order generation. When multiple locations are ordering from one upstream location and the total order amount exceeds the available inventory at the upstream location, you have to decide how to allocate the available inventory among all orders. PROC MIRP uses marginal analysis to decide the best allocation based on service-level targets, demand volume, and current inventory status at the downstream locations.

one suspects much more than a simple "formula" is involved and the implementation of that analysis may need many pages of description.

 

 

 

 

 

View solution in original post

1 REPLY 1
ballardw
Super User

When SAS documentation such as at https://documentation.sas.com/doc/en/pgmsascdc/v_024/irpug/irpug_mirp_details03.htm

Has limited details like:

The OBJECTIVE=CREATEORDER option in the PROC MIRP statement is designed to support order generation. When multiple locations are ordering from one upstream location and the total order amount exceeds the available inventory at the upstream location, you have to decide how to allocate the available inventory among all orders. PROC MIRP uses marginal analysis to decide the best allocation based on service-level targets, demand volume, and current inventory status at the downstream locations.

one suspects much more than a simple "formula" is involved and the implementation of that analysis may need many pages of description.

 

 

 

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 431 views
  • 0 likes
  • 2 in conversation