Hello World! I'm brand new to this community so please let me know if solutions to problems of this nature should be sought elsewhere. I have not done much reading through other topics but I get the impression that many of the people seeking help here are looking to help for professional or real world problems. I warn you ahead of time, this is not my case. I am trying to calculate the best combination of items in a game based on a few variable factors while accounting for the items statistics. I imagine this will require a matrix of some sort, but I have no idea how to set that kind of thing up. Here is what I would like to use excel to calculate: There are 3 classes of items: weapons, protection, and vehicles. The pertinent statistics I would like to account for each item are upkeep, attack, and defense. The rules of the game dictate that each member in your mob is assigned one weapon, one protection, and one vehicle item. To be able to afford these items, you must have a certain level of income to cover the upkeep of the items. I would like to use excel to determine, based on a mob of size X and an income of size Y what the optimal combination of items is. I would like to calculate the best combination of items based on the total value of attack + defense. To clarify, if I had a mob of 100 with an income of $1000, I would need a total 100 weapons, 100 protections, and 100 vehicles and I want my excel calculator to tell me how many of each item i should buy. I would greatly appreciation any direction in setting up the solution for this equation. I know it is a pretty trivial request considering the real world lack of importance, but would really appreciation some help. Thank you very much. Also, I tried to describe all of the pertinent information but if I have left out anything important, please let me know and I will be happy to add an update. Thank you.

Here is a visual representation of what I'm looking for..


WEAPONS
Name Upkeep Attack Defense
weapon a 200 15 12
weapon b 100 14 13

PROTECTION
Name Upkeep Attack Defense
item a 150 10 15
item b 125 8 12

VEHICLES
Name Upkeep Attack Defense
vehicle a 400 20 18
vehicle b 250 16 14


Mob Size: X (lets say 50 for this example)
Income: Y (lets say 10,000 for this example)

I want the calculator to tell me...

32 weapon a and 18 weapon b
25 protection a and 25 protection b
12 vehicle a and 38 vehicle b

I'm looking to account for several items in each category. THANK YOU VERY MUCH TO ALL WHO ARE WILLING TO HELP!