Monthly demand(volume) to per order(volume)
-
- 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?
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.
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Monthly demand(volume) to per order(volume)
You need a parameter which converts the monthly demand to order, something likeKarthikThilak 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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- 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.
Please suggest
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
-
- Super Administrator
- Posts: 4590
- 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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- 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.
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 399 times
-
- Super Administrator
- Posts: 4590
- 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
- (2.12 KiB) Downloaded 422 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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- Member
- Posts: 21
- Joined: Mon May 29, 2017 9:25 am
- Vensim version: PLE
Re: Monthly demand(volume) to per order(volume)
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
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
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Monthly demand(volume) to per order(volume)
You can work out volume if you multiply demand by the volume it takes.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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- 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?
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.
-
- 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.
Is there a way in modelling this?Please help
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
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Monthly demand(volume) to per order(volume)
Yes, you can use volume. But you need a way of converting the orders to volume.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
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559