Date: Sat, 21 May 2022 19:28:44 +0000 (UTC) Message-ID: <1512345103.53.1653161324982@120c66fa906f> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_52_964989970.1653161324982" ------=_Part_52_964989970.1653161324982 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Activity Based Forecasting

# Activity Based Forecasting

=20
=20
=20
=20

This article provides recommendations to managers on forecasting schedul= es and labor.

## Overview

Activity-Based Scheduling allows managers to base their Labor % on proje= cted sales for their specific department sales and allows for a per schedul= e analysis to cut labor expenses. For example, this would be useful if you = were writing a Back-of-House (BOH) schedule and wanted to see the generated= sales projections, which would only reflect the Food departments.

Activity-Based Scheduling helps managers have the right people on s= taff, calculate an accurate server-to-customer ratio, and analyze = ;the anticipated sales down to each department.

## Schedule Forecasts

Consider the scenario where a manager wants the Kitchen and Server sched= ules to be based on other department sales.

• The table below lists three departments, the department sales, and a= n =E2=80=9CX=E2=80=9C indicating if that department will be included in a s= chedule=E2=80=99s projection metrics.

• The sum of all department sales will equal the total sales for the e= ntire store.

• Each schedule sales value will be less than or equal to the store-wi= de sales.

Dep= artment

Dep= artment Sales

Kit= chen Schedule

Ser= ver Schedule

Food

\$1000

X

X

Liquor

\$500

X

Catering

\$250

X

Total Sales

\$1750

\$1250

\$1500

• Instead of using department sales directly, our system calculates av= erages over six weeks, ending with the last date of recorded sales.

• An average is calculated for each day of the week. For example, an a= verage is calculated for six consecutive Mondays.

• For each day of the week grouping, we remove outliers that are more = than one standard deviation away from our mean.

## Labor Departments

The departments are configured using the Labor Setup page in Decision Lo= gic: • Once these departments are configured in Labor Setup, it=E2=80=99s t= ime to create a schedule.

• When a new schedule is created, the projections panel at the bottom = of the page will display the Schedule Sales.

• These are the sales sum determined by how the Labor schedule's depar= tments have been set up.

• Toggling the =E2=80=9CAll Schedules=E2=80=9D switch will display the= store-wide sales instead. If you do not want to manually update the Sales Forecasts, you can s= elect Generate sales, and all projected sales will be used.

Labor Forecasting:

• Updating the Targeted Sales on the Sales Forecasting page will affec= t all schedules.

• When a Target Sales value is set for a day, a =E2=80=98department sa= les override=E2=80=99 value is created for each department.

• This generated amount is proportional to the percent that the depart= ment sales make of the store=E2=80=99s total sales.

Dep= artment

Dep= artment Sales

Dep= artment Sales Override

Food

\$1000

(1000 / 1750) * 2000 =3D \$1142.86

Liquor

\$500

(500 / 1750) * 2000 =3D \$571.43

Catering

\$250

(250 / 1750) * 2000 =3D \$285.71

Total Sales

\$1750

\$2000

When viewing the Projections section at the bottom of Labor Scheduler, t= he Schedule Sales values will update accordingly.

Dep= artment

Dep= artment Sales Override

Kit= chen Schedule

Ser= ver Schedule

Food

\$1142.86

X

X

Liquor

\$571.43

X

Catering

\$285.71

X

Total Sales

\$2000

\$1428.57

\$1714.29

=20
=20
=20
=20