A real estate office manages 50 apartment units. When the rent is $550 per month, all units are occupied. However, for each $55 increase in rent per month, one unit becomes vacant. How many units should be rented to maximize the profit?
Write a VBA program that prompts the user to enter:
a. the rent to occupy all the units.
b. the increase in rent that results in a vacant unit.
c. you should display (clearly labeled) in a MsgBox the number of units rented to maximize profit and what the maximum profit at that number would be. You must use a FOR loop in this problem.
Please write in VBA code.