Packaging Calculation

[ammomormon]

Alright so this might be kind of difficult to explain. I am trying to figure out a formula or series of formulas to figure out the amount of packages I have available compared to the amount I require to have on hand.


I am trying to auto calculate the amount of packages I have not to exceed the # Req Pkgs.

[TABLE="width: 1000"]
<tbody>[TR]
[TD][/TD]
[TD]Clothing package 1[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]# Req Pkgs[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]Avail Pkgs[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Shortfall[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][TABLE="width: 80"]
<tbody>[TR]
[TD]Component[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Type[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]Product Code [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 109"]
<tbody>[TR]
[TD]Product grouping[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 109"]
<tbody>[TR]
[TD]Product on hand[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]Qty per Package[/TD]
[TD]Used[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]High top[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]S100[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]SAA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Low Top[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]S102[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]SAA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Flats[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]S103[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]SAA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Boots[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]S104[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]SAA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]1500[/TD]
[TD]24[/TD]
[TD]720[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Pants[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]P130[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]PAB[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]2700[/TD]
[TD]30[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Long Sleeve Shirt[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]T155[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]TBA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]1255[/TD]
[TD]30[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Short Sleeve shirt[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]T157[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]TBA[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Big Hat[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]H002[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]HMY[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]952[/TD]
[TD]24[/TD]
[TD]720[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD]Head band[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 94"]
<tbody>[TR]
[TD]H003[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD]HMY[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]0[/TD]
[TD]24[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[baitmaster]

welcome to the board

You're going to have to give some more info, I can't see what you mean by "the amount of packages I have available". What is going on here?

For example, your first item "High Top". As I read this, you have none. Does this mean you have no "Component 1" available or no "whole product" available?

And what exactly do "product on hand", "Qty per Package" and "Used" mean?

If you can clearly state the set of rules then you're likely to get your answers on this board, but the rules just aren't clear to me in order to write your formula