1. My small business rents date supplies to those who don't want to spend the money to buy the stuff for themselves before they try it.We give them the opportunity to try it at a low cost

The table below lists the items available to be added to the inventory, their category, cost per investment, revenue per rent, and the rent frequency (1 = sort of popular 2 = popular 3 = very popular) respectively.

I only have $400 dollars to invest. I want at least 30% of my inventory to be in high frequency (very popular) options.No one option can have more than 2 units in the inventory. At least 30% of my inventory needs to be from the games category. Formulate a spreadsheet model and use Solver to solve this LP problem

1. What inventory mix would allow me to maximize my revenue?

		cost of initial investment	revenue per rent	rent frequency
Sporty	roller blades	$ 40.00	5	3
slack line	$ 80.00	9	3
longboards	$ 80.00	5	2
Outdoors	Hammock	$ 40.00	9	2
bonfire supplies	$ 30.00	7	3
spikeball	$ 40.00	7	2
picnic supplies	$ 30.00	7	1
Crafty	Oragami	$ 30.00	7	2
Pait Supplies	$ 30.00	7	3
Icec ream maker	$ 15.00	7	1
poloroid camera	$ 60.00	5	3
Games	Twister	$ 20.00	3	3
puzzles	$ 30.00	3	2
card game	$ 10.00	3	2
board game	$ 10.00	3	2