The Flex Period Projection provides detail which supports the P&L Performance Analysis and also supports the Expected Period End Profitability functions. The program supports the P&L Performance Analysis by giving you detailed actual vs. flex costs as part of the month end review. It supports the EPEP function by giving you the Projected period end amounts which tell you what you should spend between the date selected and month end based on actual business volume, costs to date for the period and original assumptions.
Click the image to view a sample report.
Displays actual, period end projected, flex, and base (depending on the data set chosen) for each line, based on the original assumptions used in establishing the budget. It will also show you how much you've spent for a given month and what's available to be spent for the remainder of the month based on your original budget and the associated assumptions. For example, the report will show you actual $$/Room for guest supplies (assuming it was budgeted based on a POR value) compared to budgeted $$/Room.
The four columns are:
- PTD Actual—What's been spent so far.
- RP Amount—What is left to spend based on the original budget assumptions, actual expenditures and actual business.
- Flex Amount—How much you should have spent so far, or - depending on options chosen - what your cost(s) should have been based on original budget assumptions.
- Base Amount—The data set you've selected for comparative purposes.
Report Options
| Option | Description |
Display | Choose additional options to be displayed in the report. - Summary-Rollup Level P&L View—Displays budget line totals by period.
- Detail-Account Level Data—Displays amounts and KBIs by detail for each by profit center.
- Selected Period Only—Displays data for the Period you choose in the Flex Dataset option, if selected.
- Year-to-Date—Displays the data for the year-to-date, for the Year you choose in the Flex Dataset option, if selected
- Both—Display information for both the Selected Period Only and the Year-to-Date.
- Print lines with zero values—Display all budget lines even if the data entered is zero.
- Line—Select the budget lines you would like to view. You may select any or all of the budget lines.
- Profit Snapshot—Select a previously created Profit Snapshot to be used in the comparison.
|
Flex Dataset | Choose the period and year for the flex dataset. - Period—Select a period of dataset.
- Year—Select a year of dataset.
|
Comparative Dataset | Consists of a Year and Type of data that are grouped in an organized manner. The Comparative Dataset is the dataset to which the Base Dataset is compared - Year—Select a year of dataset to compare.
- Type—Select a type of dataset to compare.
|
Column Selections | Select the column headers, and associated data, that is displayed. - Major Columns—Specifies columns of information.
- PTD Actual—Displays a column showing period-to-date totals for actuals.
- RP Amount—Displays the estimated budgeted expenses for the rest of the period.
- Period End Total—Displays a column that shows totals for the period end.
- Base Budget for Flex—Displays a column that shows data for the base.
- Statistics—Select statistics you want to view.
- %'s Columns—Displays dollar amounts and percentage lines, as well as a POR column which displays the cost per occupied room for that month.
- PAR Columns—Displays each budget line expense or revenue per available room, in detail.
- POR Columns—Displays the expenses per month per occupied room. This option displays only the POR figures across the board. This is generally a very large report due to the break down of details.
- Variances—View the differences between the Flex Dataset and the Comparative Dataset.
- PE vs. Flex—Compares the Period End results to the Flex budget.
- PE vs. Base—Compares the Period End results to the Base selected.
- PE vs. Comparative—Compares the Period End results to the Comparative dataset selected. Note: You must have selected a Year and Type for Comparative Dataset.
- Flex vs. Base—Compares the Flex to the Base dataset.
- PTD vs. Flex—Compares the Period-to-Date results to the Flex budget.
- PTD vs. Base—Compares the Period-to-Date results to the Base selected.
- PTD vs. Comparison—Compares the Period-to-Date results to the Comparative dataset selected. Note: You must have selected a Year and Type for Comparative Dataset.
|
Layout | Provides information about how the report will appear. |
Clear Columns | Allows you to quickly de-select all the Column Selections and start over. |
Related topics: