Cost Structure & Results tab of the Edit Budget Line dialog box

Cost structure refers to what you are budgeting with the selected budget line. For example, when editing a Job line, the cost structure is total hours multiplied by average wage to give you budgeted costs. You would edit the Cost Structure tab to enter the average wage. Cost Structure setup is only applicable when editing a budget line. You cannot configure it while you are adding the line because, during creation, the line is not yet linked to a budget dataset; therefore, you would not know what values you need to pull into the cost structure to display.

Fields on the Cost Structure & Results tab of the Edit Budget Line dialog box

Note: The fields that appear on this tab depend on the line type that you have selected to edit as well as options that you select on the tab.

Note: If you are adding a budget line, the Cost Structure & Results fields are not available in the Add Budget Lines wizard.

Note:Job ( Job ), Percent of Labor ( Percent of Labor ), and Percent of Hours ( Percent of Hours ) line types share the same configuration fields.

Note: If Percent is selected as the Performance Measure on the Line-Specific Options tab, the Cost Structure & Results tab is not available for the line type.

 

Field Description Appears only for selected detail line types Notes

Name

Name of the budget line.

All line types.

Read-only.

Account

Account number associated with the budget line.

For Regular Cost Accounts: 

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

  • Total

Read-only.

Line Type

Type of line type that you are editing.

All line types.

Read-only.

Factor Mode

The factor mode applied to the line: variable or fixed.


All line types.

Read-only.

Total Costs

Formula for calculating total costs.

Formulas per line type:

  • KBI = (KBI Units × Cost Per Unit) + (Fixed Costs × Factor)

  • Fixed = Fixed Costs × Factor

  • Market Segment = Fixed Costs × Factor

  • Job Class = (Hours × Adj. Rate) × Factor + (Fixed Costs × Factor)

  • Percent of Labor = Regular Cost + OT Costs + Fixed Costs

  • Revenue Center = Fixed Costs × Factor

All line types.

Read-only.

Add Range

Opens the Edit Ranges dialog box where you edit and add ranges.

  • Fixed ( Fixed )

  • KBI ( KBI )

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )


Table If a cell is editable, you can double-click and add/edit a value.

Periods

Financial periods for the budget line.

  • Fixed ( Fixed )

  • KBI ( KBI )

  • Market Segment ( Market Segment )

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

  • Calculated ( Calculated )

  • Revenue Center ( Revenue Center )

Read-only.

Rooms

Number of rooms budgeted.

  • Market Segment ( Market Segment )

Read-only.

Covers

Number of guests budgeted, usually at a banquet, event, or restaurant service.

  • Revenue Center (  )

Read-only.

Base Hours

Net hours from the referenced job line.

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Projected Hours

System-generated hours.

  • Job Class ( Job Class )

Read-only.

Net Hours

Projected Hours +/− adjustments (including overtime).

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Total Hours

Total number of hours used in calculation.

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Total Units

Total number of items used in calculation. 

For example, rooms, hours, covers, etc. are all units.

Units are typically generated by the forecasting process.

  • Calculated ( Calculated )

Read-only.

Overtime %

Percentage of line that is overtime. 

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Average Daily Rate

Room Revenue ÷ Total Occupied Rooms

  • Market Segment ( Market Segment )

Read-only.

Average Check

Food revenue ÷ food covers

  • Revenue Center ( Revenue Center )

Read-only.

Avg. Rate

Average rate of pay expected for employees during the selected time frame.

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Adjusted Rate

Average rate inclusive of all rate adjustments that have been made.

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Projected Costs

System-generated costs.

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Percentage

Percentage can refer to one of the following:

  • Percent of Base (  ) hours on the Percent of Labor (  )  from the referenced job line.

  • Percent of Base (  ) costs on the Percent of Base (  ) from the referenced budget line.

  • Percent of Labor ( Percent of Labor )

  • Percent of Base ( Percent of Base )


Regular Hours %

Percent of regular hours from the referenced job line.

  • Percent of Hours ( Percent of Hours )


OT Hours %

Percent of OT hours from the referenced job line.

  • Percent of Hours ( Percent of Hours )


Fixed Costs %

Percent of fixed costs from the referenced job line.

  • Percent of Hours ( Percent of Hours )


KBI Units

Number of units in the KBI that is referenced on the line.

  • KBI ( KBI )


Costs per Unit

Rate that is applied to each unit on the line.

  • KBI ( KBI )


Base Fixed Costs

Fixed costs on the referenced job line.

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )

Read-only.

Fixed Costs

Costs that do not change with variations in the number of units sold.

  • Fixed ( Fixed )

  • KBI ( KBI )

  • Percent of Base (  )


Fixed

Costs that do not change with variations in the number of units sold.

  • KBI ( KBI )

  • Job Class ( Job Class )

  • Percent of Labor ( Percent of Labor )

  • Percent of Hours ( Percent of Hours )


Factor

A percentage adjustment that can be used to acquire a more accurate number.

  • Fixed ( Fixed )

  • Job Class ( Job Class )

  • KBI ( KBI )

  • Percent of Base ( Percent of Base )

Read-only.

Total Costs

Total costs for line.

All line types.

Read-only.