To follow this example, open the Hotel Design example shown in Figure 35, Hotel pricing problem spreadsheet model.
Figure 35. Hotel pricing problem spreadsheet model
The decision variables correspond to cells G7 through G9.