Editing the Cost Structures Tab
Using Cost structures, you can configure how Budgeting calculates total dollars using units, rates, factors, and fixed dollar amounts. To see a full discussion of these terms, see About Budget Line Data.
There are two different methods of editing the cost structure screens: with ranges and without ranges. KBI, Market Segment, Revenue Center and Percent of Base lines are configured using ranges. Fixed and Job Class lines are configured without ranges. Total and Calculated lines do not have a cost structure tab.
- Editing KBI, Market Segment & Revenue Center Lines.
- Editing Percent of Base Lines.
- Editing Job Class Lines.
- Editing Fixed Lines.
Editing KBI, Market Segment, and Revenue Center Lines
Fields related to KBI, Market Segment, and Revenue Center Lines
Field | Description |
Rate Table | Represents the dollar amounts associated with the units for KBIs, market segments and revenue centers. Because you name the units during the configuration process, the labels for this table will vary (ADR, Avg. Wage, etc.)
|
Factor           | Adjust for circumstances.
|
Fixed ($) | Enter amounts that are the same every period. Â
|
*or whatever number is big enough as to be unattainable. For example, you only have 400 rooms so you would enter a number that is slightly greater than 400 in the To Volume field. Or if your volume is based on the number of guests in your very busy restaurant, you may want to enter 200000 because that number is larger than the maximum occupancy of your restaurant, multiplied by the number of days your restaurant is open. Therefore, this is a safe number that you would never exceed.
Editing KBI, Market Segment, and Revenue Center Lines
To edit the Cost Structures tab:
- Select the Cost Structures tab.
- Determine whether you need to add, delete, or change data.
- To add a range:
- Click the Add Range icon.
- Enter a From Volume/To Volume.
- Enter data into the Period fields.
- (Optional) Repeat Steps a-c for each range you need to create.
- To delete a range:
- Click in any cell of the range you want to delete.
- Click the Delete Range icon.
- To change data:
- Triple-click in the cell you want to change to put it in editing mode.
- Enter the new data.
- To add a range:
Editing Percent of Base Lines
Fields related to Percent of Base Lines
Field | Description |
Percentage Table | Represents the percentage of the base line's total dollars that you spend on a given item if the line represents an expense or the amount you make if the line represents revenue. You may step the rates, based on the total dollars of the base line, or you may have one rate no matter the dollar amounts.
|
Factor | Adjust for circumstances.
|
Fixed ($) | Enter amounts that are the same every period. Â
|
*or whatever number is big enough as to be unattainable. For example, you only have 400 rooms so you would enter a number that is slightly greater than 400 in the To Volume field. Or if your volume is based on the number of guests in your very busy restaurant, you may want to enter 200000 because that number is larger than the maximum occupancy of your restaurant, multiplied by the number of days your restaurant is open. Therefore, this is a safe number that you would never exceed. |
Editing Percent of Base Lines
- Select the Cost Structures tab.
- Determine whether you need to add, delete, or change data.
- To add a range:
- Click the Add Range icon.
- Enter a From Volume and a To Volume.
- Enter data into the Period fields.
- (Optional) Repeat Steps a-c for each range you need to create.
- To delete a range:
- Click in any cell of the range you want to delete.
- Click the Delete Range icon.
- Do one of the following:
- Click OK to return to the Manage Budget Lines screen.
Or - Click on the next tab you want to edit.
- Click OK to return to the Manage Budget Lines screen.
- To change data:
- Triple-click in the cell you want to change to put it in editing mode.
- Enter the new data.
- To add a range:
Editing Job Class Lines
Fields related to Job Class Lines
Field | Description |
Rate Table | Represents the average wages that you spend for each hour of labor. Job Class lines do not use ranges. |
Fixed ($) | Enter amounts that are the same every period.  |
Factor | Adjust for circumstances. |
Editing Job Class Lines
- Select the Cost Structures tab.
- Triple-click in the cell below the appropriate Period to put it in editing mode.
- Enter the new data.
- (Optional) Repeat Steps 2-3 for each Period as appropriate.
Editing Fixed Lines
Fields related to Fixed Lines
Field | Description |
Dollars Table | Represents the dollar amounts that you spend on a given item. |
Editing Fixed Lines
- Select the Cost Structures tab.
- Triple-click in the cell below the appropriate Period to put it in editing mode.
- Enter the new data.
- (Optional) Repeat Steps 2-3 for each Period as appropriate.