Monthly demand(volume) to per order(volume)

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

Monthly demand(volume) to per order(volume)

Post by KarthikThilak »

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.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

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

Post by Administrator »

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
Advice to posters seeking help (it really helps us to help you)
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)

Post by KarthikThilak »

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.

Please suggest
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

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

Post by Administrator »

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.
Advice to posters seeking help (it really helps us to help you)
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)

Post by KarthikThilak »

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
(5.32 KiB) Downloaded 338 times
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

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

Post by Administrator »

Based on what you've written, I've attached what I think you need.
Attachments
demo.mdl
(2.12 KiB) Downloaded 358 times
Advice to posters seeking help (it really helps us to help you)
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)

Post by KarthikThilak »

Hello,

Thank you very much for your reply and the attached model.

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,

Please help
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

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

Post by Administrator »

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?
Advice to posters seeking help (it really helps us to help you)
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)

Post by KarthikThilak »

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)

Post by KarthikThilak »

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.

Is there a way in modelling this?Please help
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

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

Post by Administrator »

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

Is there a way in modelling this?Please help
Yes, you can use volume. But you need a way of converting the orders to volume.

Try and do what happens in the real world.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

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