Can Excel help find best use of resources with two constraints?

[Coyotex3]

Hello guys, I have the list below:

Book3
	A	B	C	D	E	F	G	H
1		1 Pack	2 Packs	3 Packs	4 Packs
2	VIP	$ 15.0	$ 30.0	$ 60.0	$ 120.0		Max Budget:	$ 120.0
3	Diamond	$ 12.0	$ 24.0	$ 44.0	$ 84.0		Minimum:	8 Packs
4	Gold	$ 11.0	$ 22.0	$ 40.0	$ 70.0
5	Silver	$ 10.0	$ 20.0	$ 36.0	$ 65.0
6	Preferred	$ 8.0	$ 16.0	$ 28.0	$ 44.0
7	Basic	$ 4.0	$ 8.0	$ 16.0	$ 30.0
Sheet1

I'm trying to figure out the best way to utilize the max budget to get the best quality packs while satisfying the minimum number of packs required constraint? Can Excel help with something like this?

 

[Leo Skywalker]

Seems that there are more than two constrains.

Why would anybody buy a 3-pack, instead of buying a 1-pack and a 2-pack?, or even worse, why would anybody buy a 4-pack VIP for $120, instead of four 2-packs for the same amount of money?

3-packs and 4-packs are more expensive, there is no reason to buy those in any quality.

 

[Coyotex3]

Seems that there are more than two constrains.

Why would anybody buy a 3-pack, instead of buying a 1-pack and a 2-pack?, or even worse, why would anybody buy a 4-pack VIP for $120, instead of four 2-packs for the same amount of money?

3-packs and 4-packs are more expensive, there is no reason to buy those in any quality.

My apologies. I shared the wrong information. It should've been this:

Book4
	A	B	C	D	E	F	G	H
1		1- Pack	2 Packs	4 Packs	8 Packs
2	VIP	$ 15.0	$ 30.0	$ 60.0	$ 120.0		Max Budget:	$ 120.0
3	Diamond	$ 12.0	$ 24.0	$ 44.0	$ 84.0		Minimum Amount	8 Packs
4	Gold	$ 11.0	$ 22.0	$ 40.0	$ 70.0
5	Silver	$ 10.0	$ 20.0	$ 36.0	$ 65.0
6	Preferred	$ 8.0	$ 16.0	$ 28.0	$ 44.0
7	Basic	$ 4.0	$ 8.0	$ 16.0	$ 30.0
Sheet1

Cell Formulas
Range	Formula
H3	H3	=E1

 

[Coyotex3]

Or perhaps this

Book7
	A	B	C	D	E	F	G	H	I	J
1		1- Pack	2 Packs	4 Packs	8 Packs	Value
2	VIP	15	30	60	120	6			Max Budget:	120
3	Diamond	12	24	44	84	8			Minimum Amount	8 Packs
4	Gold	11	22	40	70	7			Max Amount	12 Packs
5	Silver	10	20	36	65	10
6	Preferred	8	16	28	44	9
7	Basic	4	8	16	30	9
Sheet1

Cell Formulas
Range	Formula
J3	J3	=E1

While trying to also get the highest average value possible?

 

[Coyotex3]

Bumping.