Question

As a real estate investor, you want to maximize your profit by buying and renting houses. You have exactly 8 alternatives which will be given in a format as below. Write a VBA code that maximize your monthly rent with the following constraints: - You can buy the houses within the given budget (in Cell B6). - You can't buy more than 5 houses. Each house is unique. - You give a cleaning service with a limited capacity, so total number of rooms in these houses can not exceed 20. - Show your answer (total maximum monthly rent) in a message box. Example input: B House 1 2 Price 500.000 3 Rent 2.300 4 Rooms 4 C House 2 300.000 1.500 3 D JHouse 3 700.000 3.300 4 House 4 800.000 3.600 3 House 5 600.000 2.500 3 House 6 150.000 900 2 House 7 House 8 1.000.000 720.000 4.500 3.800 54 Total budget 3.000.000

Answer 1

	House 1	House 2	House 3	House 4	House 5	House 6	House 7	House 8
Price	500,000.00	300,000.00	700,000.00	800,000.00	600,000.00	150,000.00	1,000,000.00	720,000.00
Rent	2,300.00	1,500.00	3,300.00	3,600.00	2,500.00	900.00	4,500.00	3,800.00
Rooms	4	3	4	3	3	2	5	4
Total Rent Amount If house Purchased	9,200.00	4,500.00	13,200.00	10,800.00	7,500.00	1,800.00	22,500.00	15,200.00
Total Budget	3,000,000.00
Total Cost of Houses Purchased	2,920,000.00
Maximum Monthly Rent	60,100.00
Number of Rooms	17