個案總覽

Student Spreadsheet for product 9B17B003.

In the summer of 2016, a real estate investment company was planning management and budgeting for apartment rental units in Pittsburgh, Pennsylvania, a U.S. city with a large student population. The company needed to determine the various unit agreement terms—by year, by semester (fall, spring, and summer), and by month—using software to find optimal rents. Using Excel’s Solver tool, the optimal rents needed to be determined and incorporated into a projected profit and loss budget for fiscal year 2017.

In the summer of 2016, a real estate investment company was planning management and budgeting for apartment rental units in Pittsburgh, Pennsylvania, a U.S. city with a large student population. The company needed to determine the various unit agreement terms-by year, by semester (fall, spring, and summer), and by month-using software to find optimal rents. Using Excel's Solver tool, the optimal rents needed to be determined and incorporated into a projected profit and loss budget for fiscal year 2017.

Student spreadsheet for case W17108.