Optimization Model Help

[Domes]

Hi,

I am looking for some help in how to structure an optimization model. I have a small data set and I am trying to figure out a max value problem. I have 131 Items each belonging to a different category (A,B,C,D or E) with a specific price and set value. For this model I have a budget of 60,000 that I must spend to select 8 items (1 from A, 1 from B, 1 from C, 1 from D, 1 from E, 1 from B or D, 1 from C or E, and 1 from Any Category). I am wondering if there is any way to have a model use those criteria to pick a set of combinations that will provide the maximum value. If anyone has any advice or suggestions their help would be greatly appreciated. Please take a look at the sheet I have attached.

Thanks,

Price	Value	Identifier	Category				Selections
10900	45.94	1	A				Category	Identifier	Value	Price (Budget $60,000)
8900	41.31	2	A				A
7900	38.77	3	A				B
9000	37.07	4	A				C
9100	35.04	5	A				D
8000	33.93	6	A				E
8100	31.6	7	A				B or D
6700	28.81	8	A				C or E
6800	26.76	9	A				Any
6800	25.15	10	A
6900	24.08	11	A
6700	23.17	12	A
4000	22.39	13	A
4300	20.87	14	A
5300	20.29	15	A
4000	18.68	16	A
4800	17.52	17	A
3000	11.98	18	A
3000	11.51	19	A
3000	6.463	20	A
4300	0	21	A
3000	0	22	A
11100	42.5	23	B
7200	33.26	24	B
9200	31.83	25	B
6300	30.06	26	B
5200	21.73	27	B
4200	19.34	28	B
4000	19.14	29	B
4500	18.81	30	B
4900	17.8	31	B
5300	17.56	32	B
4200	15.82	33	B
3300	14.6	34	B
5800	14.18	35	B
4500	14.08	36	B
4400	12.95	37	B
3000	12.76	38	B
3000	12.17	39	B
4800	11.91	40	B
3400	11.87	41	B
3600	9.417	42	B
3300	8.496	43	B
3600	7.475	44	B
3000	2.603	45	B
4200	0	46	B
5800	0	47	B
6300	0	48	B
5000	0	49	B
10500	44.63	50	C
10200	39.44	51	C
8400	39.11	52	C
7100	32.34	53	C
7000	30.73	54	C
6400	30.65	55	C
5300	30.18	56	C
6000	28.32	57	C
4800	25.57	58	C
5400	23.75	59	C
6500	21.94	60	C
6300	21.89	61	C
5300	20.58	62	C
5000	20.52	63	C
4800	20.18	64	C
3800	19.41	65	C
3100	16.59	66	C
3000	15.73	67	C
5200	14.53	68	C
3800	13.63	69	C
3700	13.59	70	C
3000	13.29	71	C
3000	10.1	72	C
3000	8.579	73	C
3200	5.13	74	C
3000	0	75	C
8300	34.35	76	D
7700	33.01	77	D
7200	30.37	78	D
6400	27.26	79	D
7300	26.87	80	D
6200	25.89	81	D
4800	25.88	82	D
5300	24.01	83	D
4900	21.42	84	D
3900	20.43	85	D
3600	19.43	86	D
5000	18.89	87	D
4300	18.76	88	D
5100	18.26	89	D
3400	18.26	90	D
4900	17.78	91	D
4000	17.6	92	D
3900	17.44	93	D
4900	16.36	94	D
3600	10.33	95	D
3000	10.25	96	D
3000	9.216	97	D
3500	8.584	98	D
3500	6.543	99	D
3000	5.966	100	D
3000	4.916	101	D
3000	0	102	D
3200	0	103	D
3000	0	104	D
11500	42.06	105	E
8600	37.97	106	E
8500	34.52	107	E
6500	31.23	108	E
6400	30.43	109	E
5700	28.54	110	E
5600	26.89	111	E
5000	26.08	112	E
5800	25.61	113	E
5400	23.7	114	E
4700	20.78	115	E
5300	20.25	116	E
3900	19.98	117	E
4500	18.24	118	E
4200	17.41	119	E
4100	16.72	120	E
3300	15.53	121	E
3700	12.73	122	E
3600	10.31	123	E
3000	10.18	124	E
3400	9.947	125	E
3000	7.172	126	E
3000	4.698	127	E
3000	3.156	128	E
3000	2.664	129	E
6300	0	130	E
5700	0	131	E

<tbody>
</tbody>