Monthly rent at an apartment complex is $500. Operating costs average $15,000 per month regardless of the

Question:

Monthly rent at an apartment complex is $500. Operating costs average $15,000 per month regardless of the number of units rented. Construct a spreadsheet model to determine the profit if 35 units are rented. The manager has observed that the number of units rented during any given month varies between 30 and 40. Use your model to evaluate the profit for this range of unit rentals.