Actual & Forecast Payroll % Trend Column

Week Time Periods

This column displays either the actual payroll percent or the user-adjusted forecasted payroll percent, depending whether actuals are available for the week.

The application uses these formulas to calculate the values in this column.

  • If actual payroll data is available and actual sales data is not available:

    [ actual payroll / Adjusted Forecast Sales ] * 100

  • If both actual payroll and actual sales data are available:

    [ actual payroll / actual sales ] * 100

  • If actual payroll data is not available and actual sales is available:

    [ Adjusted Forecast Payroll / actual sales ] * 100

  • If neither actual payroll and actual sales data are available:

    [ Adjusted Forecast Payroll / Adjusted Forecast Sales ] * 100

Month, Quarter, and Year Time Periods

This column displays payroll percent calculated from one of these combinations of data:

  • actual sales and actual payroll
  • actual sales plus Adjusted Forecast Sales and actual payroll plus Adjusted Forecast Payroll
  • Adjusted Forecast Sales and Adjusted Forecast Payroll

The application uses these formulas to calculate the values in this column:

  • If actual payroll data is available and actual sales data is not available for the entire time period:

    [ actual payroll / Adjusted Forecast Sales ] * 100

  • If both actual payroll and actual sales data are available for the entire time period:

    [ actual payroll / actual sales ] * 100

  • If actual payroll data is not available and actual sales is available for the entire time period:

    [ Adjusted Forecast Payroll / actual sales ] * 100

  • If neither actual payroll and actual sales data are available for the entire time period:

    [ Adjusted Forecast Payroll / Adjusted Forecast Sales ] * 100

  • If actual payroll and sales data is available for only part of the time period:

    [ ( actual payroll + Adjusted Forecast Payroll ) / ( actual sales + Adjusted Forecast Sales ] * 100