ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PACKING ARRANGEMENTS (https://www.excelbanter.com/excel-discussion-misc-queries/136701-packing-arrangements.html)

Pushpendra

PACKING ARRANGEMENTS
 
I have data like:
A = 50
B = 60
C = 80
D = 90
E =30

I want to arrange these in different boxes which can hold:
A =20
B = 20
A + B = 18
A + C = 18

LIKEWISE I WANT TO PLACE THE QUANTITY AUTOMATICALLY IN BOXES

BOX -1; A = 20
BOX -2; A = 20
BOX -3; A = 10 & B = 8
BOX -4; B =20

LIKE THIS:

HELP ME TO SOLVE THE SAME.

Toppers

PACKING ARRANGEMENTS
 
How many combinations of parts to boxes are there?

What about D & E? Are A+B and A+C the only combinations involving these parts?

With your sample data, can you provide a complete solution for A to E?

"Pushpendra" wrote:

I have data like:
A = 50
B = 60
C = 80
D = 90
E =30

I want to arrange these in different boxes which can hold:
A =20
B = 20
A + B = 18
A + C = 18

LIKEWISE I WANT TO PLACE THE QUANTITY AUTOMATICALLY IN BOXES

BOX -1; A = 20
BOX -2; A = 20
BOX -3; A = 10 & B = 8
BOX -4; B =20

LIKE THIS:

HELP ME TO SOLVE THE SAME.



All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com