Order cutting plan

[svorm]

hi

i need a solver but i cant it.
i m working at textile confection factory.
i m making cutting plan manually.
how do i change it automaticly using by macro or solver?


you can find the sample in attach.
cutting plan.xlsx

thanks for help

[Kaper]

Unfortunately, I think the sample file does not give a clear explanation.

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

You may say that it is included in your file, then please show (in separate sheets), what would be your solution for such 3 cases:
a) order of 200 pieces each size
b) order of 500 pieces S and 500 pieces L, and 200 pieces XL
c) order of 500 pieces S only

[svorm]

dear Kaper

Thanks for back. I've added more comments.
The main purpose ;
1-Supply order quantitiy for each size completely
2-Make minimum plan.


You can find the file in attach.

cutting plan.xlsx