question

Anggoro P avatar image
0 Likes"
Anggoro P asked Anggoro P commented

Repeat schedule resource per week: quantity by percentage (per weekdays)

Hi,

I have one weekly prob distribution for demand quantity. Also, I have different percentage demand during weekdays.

I use schedule source, then choose repeat schedule, fill the table with 5 different rows, representing working days. For quantity I select by percentage and put daily percentage (e.g Monday 20%, Tuesday 30%, etc and make sure the total is 100%) and put the same distribution for all rows (all days)

Is it the correct approach to model it?

Note: after inputting all data for every row, if I want to check again the data by opening the quantity field again, it seems that the percent and quantity are back to default data. Is it a bug or actually the data input before are already saved?

Thanks!

@steven.hamoen

Choose One
by percentage
a.jpg (57.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Mischa Spelt avatar image
0 Likes"
Mischa Spelt answered Anggoro P commented

If you are seeing the default pick option every time you open it, you may be re-selecting it from the dropdown. Selecting an option from the drop down will copy a "clean" version of that pickoption to the logic of the field. To see / change what you have entered before, use the "Properties" button next to the field.

Also, the way you have used the "by percentage" option here does not make sense: you should make sure that the percentages add up to 100 and in the screenshot you only have 30. Also note that entering the same distribution for all Quantity fields of the By Percentage option is the same as just entering it straight into the quantity field. And it is unlikely that your model time units are days, so entering time 1, 2, 3, ... 5 will probably generate too many tokens (every second, minute or hour instead of day).

Perhaps you can share your input data: how is the demand specified exactly?


properties-popup.png (138.3 KiB)
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Anggoro P avatar image Anggoro P commented ·
@Mischa Spelt

Thanks Mischa, let me explain it more detail.

The model time units are days, so I assumed that the time field in the table is a list of working days (e.g. 1 is Mon, 2 is Tue, etc). Because I only have a weekly demand quantity distribution, I set the quantity field by percentage. As you saw in the picture, it represent demand quantity for Thursday is 30% of a weekly demand quantity distribution, which in my example is normal(10,2).

My idea is to repeat this for the rest of rows, also make sure the total percentage for all table rows (means all working days is 100%) and put the same distribution in every table row. In the end the total quantity during the week will be equal to a weekly demand quantity generated.

Is it a correct approach?

0 Likes 0 ·