## Monthly demand(volume) to per order(volume)

Use this forum to discuss any issues relating to Systems Dynamics and Systems Thinking.
KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Monthly demand(volume) to per order(volume)

Hello,

I need to transform my monthly demand(volume) to per order(volume)to be shipped and then direct it to the consolidated shipment stock.

My aim is to know if the order(volume) to be shipped by parcel or pallet.

Please let me know how this could be done?
Last edited by KarthikThilak on Thu Jul 06, 2017 7:54 am, edited 1 time in total.

Posts: 3203
Joined: Wed Mar 05, 2003 3:10 am

### Re: Monthly demand(volume) to per order(volume)

KarthikThilak wrote:I need to transform my monthly demand(volume) to per order(volume)to be shipped and then direct it to the consolidated shipment stock.
You need a parameter which converts the monthly demand to order, something like

number of orders = monthly demand * orders per monthly demand unit
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559

KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Re: Monthly demand(volume) to per order(volume)

I do not have the info on how much volume of articles were ordered.

Is there any way where I can input an equation in consolidated shipment and direct each shipment's volume to either parcel or pallet.

Posts: 3203
Joined: Wed Mar 05, 2003 3:10 am

### Re: Monthly demand(volume) to per order(volume)

Can you give a brief outline of the actual problem?

Your original post was "I need to transform my monthly demand(volume) to per order(volume)to be shipped", but how can you do this if you don't know how many orders you have?

It would also help if you uploaded the model to help explain what you are trying to do.
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559

KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Re: Monthly demand(volume) to per order(volume)

Hello,

I have data of the number of orders per month.But,This data does not include the volume of products ordered.Just the number of orders.

From the attached model,

I am trying to optimise the shipping volume and number of parcels(cartons) to be shipped.

Ex : If an order volume is 0.5 cubic metre and the number of cartons is 4,is it better to ship via pallet or parcel.

For this,I need to formulate an equation for consolidated shipment.

This is what I am trying to achieve.
Attachments
model- decision making 1.mdl

Posts: 3203
Joined: Wed Mar 05, 2003 3:10 am

### Re: Monthly demand(volume) to per order(volume)

Based on what you've written, I've attached what I think you need.
Attachments
demo.mdl
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559

KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Re: Monthly demand(volume) to per order(volume)

Hello,

My point is how would I go about adding the decision parameter volume in the below model.The volume of the shipment(assuming what demand we get is what we ship) is the key factor which decides if we ship it as a parcel or pallet.

Pallet capacity is not so imp. I have tried thinking to model volume using lookup with the demand.But,since it is not a constant, I will not be able to vary it and see with the slider as to what happens when volume is higher/lower and inturn to freight costs related to parcel or pallet is cheaper.

Is there any other way,

Posts: 3203
Joined: Wed Mar 05, 2003 3:10 am

### Re: Monthly demand(volume) to per order(volume)

My point is how would I go about adding the decision parameter volume in the below model.The volume of the shipment(assuming what demand we get is what we ship) is the key factor which decides if we ship it as a parcel or pallet.
You can work out volume if you multiply demand by the volume it takes.

Surely pallet capacity is very important. If you have huge demand, it's not all going to fit on one pallet is it?
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559

KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Re: Monthly demand(volume) to per order(volume)

Yes ,you are right.

But,I am focussing on the demand which fits in one pallet.

The pallet shipments are priced based on only volume.The Parcel shipments are priced based on each parcel(x EUR /parcel)

So,I intend to use lookup table for pallet shipments to get the freight cost for them.to get an optimal volume split for shipping per order.

I have historical data for the period of a year for pallet shipments and parcel shipments.

This is the reason why I am thinking of modelling the volume as decision parameter.

Is there a way in modelling this?
Last edited by KarthikThilak on Wed Jul 12, 2017 9:30 am, edited 1 time in total.

KarthikThilak
Member
Posts: 21
Joined: Mon May 29, 2017 9:25 am
Vensim version: PLE

### Re: Monthly demand(volume) to per order(volume)

Yes ,you are right.

But,I am focussing on the demand(volume) which fits in one pallet.

The pallet shipments are priced based on only volume.The Parcel shipments are priced based on each parcel(x EUR /parcel)

So,I intend to use lookup table for pallet shipments to get the freight cost for them.to get an optimal volume split for shipping per order.

I need to vary the volume(per order) by the slider so that I can see the cheaper option between freight costs of parcel and pallet.Does this mean I have to model it as a constant?

I have historical data for the period of a year for pallet shipments and parcel shipments.

This is the reason why I am thinking of modelling the volume as decision parameter.

Posts: 3203
Joined: Wed Mar 05, 2003 3:10 am

### Re: Monthly demand(volume) to per order(volume)

KarthikThilak wrote:This is the reason why I am thinking of modelling the volume as decision parameter.