You have chosen to sponsor your bid up to a maximum amount of .
We need a spreadsheet with the following characteristics:
1. Dynamic financial projection for hotel, 12 months, variating amount of rooms and occupancy rate.
2.This worksheet has to convert everything automatically (Formulas have to work with variables)
3. Data Needed in the worksheet: Houskeeping and management cost, net profit, gross profit, net room revenue,avg daily rate.
Something like this; But better: