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.

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

<tbody>
</tbody>

 

[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