Business Overview WS APRIL FY '23 - SM Worksheet
Business Overview WS APRIL FY '23 - SM Worksheet
Business Overview WS APRIL FY '23 - SM Worksheet
Customer Voice
Company Average Top 10%
Customer Connection Metric Score 94% 100%
Employees were friendly & focused 94% 100%
Employees recognized customers by name 84% 94%
Employees recognized customers by drink 83% 94%
Greeted 99% 100%
Thanked 99% 100%
Store Operations Metric Score 93% 98%
Speed of Service 93% 100%
Employees Provided Helpful Service 95% 100%
Employees Got the Order Right 95% 100%
Beverage Tasted Great 91% 98%
Interior Cleanliness 91% 98%
Food Tasted Great 92% 100%
Category Metrics
Drip Coffee % 4.2%
Espresso % 31.0%
Blended Sales % 26.3%
Other Bev Sales % 14.5%
Food Sales % 19.1%
RTD/RTE % 0.9%
Whole Bean % 0.8%
Brewing % 0.1%
Serveware % 2.3%
VIA % 0.2%
Business Overview Summary
Please INPUT the following numbers on the worksheet. Numbers should be taken from the BSC and monthly CV Reports
Please choose Month: April FY '23
0 Total
•
Partner - Labor Metrics
Labor Metrics Graphs
Please "Copy" all 5 graphs from Labor Metrics Report (press "Ctrl" right click on all graphs) & under "Paste" click "Paste Special" and then click as "Bitmap" as seen below (fit on space provided).
*For lower versions, please Please "Copy" all 5 graphs from Labor Metrics Report (press "Ctrl" right click on all graphs) & under "Paste" click "Paste Special" and then click as "Picture Enhanced Metafile". Fit on space
provided.
g rap hs
al
c e actu
- pl a
pl e
sam
Labor Metrics Summary & Action Plan Operations and Manpower Summary & Action Plan
Labor Hours • Trading Hrs. •
le
Personnel % •
t u al tab
ce ac
Partners/str •
le - pla
s am p
IPLH •
TPLH •
Customer -Customer Voice
Customer Voice Are you within 5% of the Top 10%?
Results Top 10% Company (Y/N)
Customer Connection Metric Score 74% 100% 94% No. Please formulate action plans.
Employees were friendly & focused 74% 100% 94% No. Please formulate action plans.
Employees recognized customers by name 65% 94% 84% No. Please formulate action plans.
Employees recognized customers by drink 55% 94% 83% No. Please formulate action plans.
Greeted 101% 100% 99% Yes. Keep up the great work!
Thanked 101% 100% 99% Yes. Keep up the great work!
Store Operations Metric Score 65% 98% 93% No. Please formulate action plans.
Speed of Service 50% 100% 93% No. Please formulate action plans.
Employees Went Above and Beyond 50% 100% 95% No. Please formulate action plans.
Employees Got the Order Right 100% 100% 95% Yes. Keep up the great work!
Beverage Tasted Great 75% 98% 91% No. Please formulate action plans.
Interior Cleanliness 100% 98% 91% Yes. Keep up the great work!
Food Taste Great 75% 100% 92% No. Please formulate action plans.
tomer Voice
Customer Voice Action Plans
•
•
•
•
•
•
•
•
•
•
•
•
•
Business -Business Overview Worksheet
Sales Summary Instructions Explanations Action Plans
Net Sales 12,384,384 Sales Attainment Sales Attainment
Sales - Budget 10,566,045
Sales Attainment Ü •Example: Renovation •
Sales Attainment 117% 117% On target. Well Done! No need for explanation or Action Plans. Sales vs. Budget •Example: U-Turn Slot Sales vs. Budget •
Sales (VAT exclusive) 12,391,465 •Example: MMDA Pink line initiative •
AWS 528,904 Comp Sales Comp Sales
ADS 75,558
Comp Sales Ü • •
Prior Year ADS 59,286 Comp Sales • Comp Sales •
Comp Sales % 19.1% 19.1% State Comp Sales highlights on space provided. • •
ADT 392 Comp ADT Comp ADT
Prior Year ADT 316
Comp ADT Ü • •
Comp ADT Comp ADT
Comp ADT % 15.3% 15.3% State Comp ADT highlights on space provided. • •
AT 193 Comp AT Comp AT
Prior Year AT 188
Comp AT Ü • •
Comp AT Comp AT
Comp AT % 4.0% 4.0% State Comp AT highlights on space provided. • •
Amount Rate
Store Ave. - All Stores Store Ave. - All Stores
140,000 9.5
9.2
120,000
9.0 8.8 8.8
100,000 8.6 8.7 8.6
8.6 8.6
8.4 8.5
8.5 8.4 8.3
80,000 8.3
8.2
ere
60,000
8.0 7.8
h
ble
40,000
20,000
7.5
& ta
-
g raphs
7.0
al
Oct'10 Dec Feb Apr Jun Aug Oct'11 Dec'11 Oct'10 Dec Feb Apr Jun Aug Oct'11 Dec'11
Consumption
c e ac t u Oct'10 Nov Dec Oct'11 Nov'11 Dec'11
- p la
Store Ave. - All Stores
Area 1
sa
Consumption 11,360 12,354 12,361 11,535 11,260 14,948
14,000
Rate 7.8 8.4 8.4 8.8 9.2 8.6
12,000 Ave. - All Stores
10,000 Amount 89,399 101,697 101,294 98,999 103,057 110,438
8,000 Consumption 11,365 12,002 11,908 11,154 11,031 11,954
Rate 7.9 8.5 8.5 8.9 9.3 9.2
6,000
4,000
2,000
-
Oct'10 Dec Feb Apr Jun Aug Oct'11 Dec'11
•
•
•
Business -COGS Analysis
Please INPUT numbers for Sales, COGS & COGS Standardfrom BSC - COGS Worksheet.
Restaurant Explanations Action Plans
Acceptable COGS Variance (Y/N)
Sales COGs COGS % COGS Std. COGS STD. % COGS Var% Total Restaurant Total Restaurant
Total Restaurant 11,008 2,644 24.0% 2,594 23.6% 0.5% YES. No need for explanation or action plans. Tot. Rest. • Tot. Rest.
Beverages 21,222 3,989 18.8% 3,753 17.7% 1.1% YES. No need for explanation or action plans. Beverages • Beverages
Brewed 814 157 19.3% 99 12.2% 7.1% NO. Please note explanation and Action Plans on space provided Brewed • Brewed
Espresso 6,285 1,497 23.8% 1,346 21.4% 2.4% NO. Please note explanation and Action Plans on space provided Espresso • Espresso
Blended 12,345 2,132 17.3% 2,163 17.5% -0.3% YES. No need for explanation or action plans. Blended • Blended
Other Beverages 1,778 201 11.3% 144 8.1% 3.2% NO. Please note explanation and Action Plans on space provided Other Bev • Other Bev
Sales COGs COGS % COGS Std. COGS STD. % COGS Var% Food Food
Food 1,133 601 53.0% 536 47.3% 5.7% NO. Please note explanation and Action Plans on space provided Food • Food
Bakery 805 421 52.3% 365 45.3% 7.0% NO. Please note explanation and Action Plans on space provided Bakery • Bakery
RTE / RTD 125 53 42.4% 54 43.2% -0.8% YES. No need for explanation or action plans. RTE / RTD • RTE / RTD
Sandwiches & Salads 203 126 62.1% 117 57.6% 4.4% NO. Please note explanation and Action Plans on space provided Sandw. • Sandw.
Retail
Acceptable COGS Variance (Y/N) Retail Retail
Sales COGs COGS % COGS Std. COGS STD. % COGS Var%
Total Retail 1,166 524 44.9% 476 40.8% 4.1% NO. Please note explanation and Action Plans on space provided Tot. Retail • Tot. Retail
Whole Bean 425 147 34.6% 144 33.9% 0.7% YES. No need for explanation or action plans. WB • WB
Retail 741 377 50.9% 332 44.8% 6.1% NO. Please note explanation and Action Plans on space provided Retail • Retail
Serveware 533 240 45.0% 220 41.3% 3.8% NO. Please note explanation and Action Plans on space provided Serveware • Serveware
Breware 29 20 69.0% 20 69.0% 0.0% YES. No need for explanation or action plans. Breware • Breware
ORP 72 53 73.6% 51 70.8% 2.8% NO. Please note explanation and Action Plans on space provided ORP • ORP
Packaged Food 107 64 59.8% 41 38.3% 21.5% NO. Please note explanation and Action Plans on space provided Pkgd. Food • Pkgd. Food
Exceptional Findings
Action Plans Accounting Discrepancies Store Anomalies / Investigation(s)
Total Restaurant Total Restaurant Total Restaurant
• Tot. Rest. • Tot. Rest. •
• Beverages • Beverages •
• Brewed • Brewed •
• Espresso • Espresso •
• Blended • Blended •
• Other Bev • Other Bev •
Food Food Food
• Food • Food •
• Bakery • Bakery •
• RTE / RTD • RTE / RTD •
• Sandw. • Sandw. •
•
•
•
•
•
"Cut" & "Paste" Labor Metrics Summary & Action Plan Table here "Cut" & "Paste" Trading Hours Summary & Action Plan Table here
Personnel % •
Partners/str •
IPLH •
TPLH •
COGS Analysis
Total Restaurant Retail
Tot. Rest. • Tot. Retail •
Beverages • WB •
Brewed • Retail •
Espresso • Serveware •
Blended • Breware •
Other Bev • ORP •
Food Pkgd. Food •
Food •
Bakery •
RTE / RTD •
Sandw. •
-R E P O R T E N D -
Business - Inventory Movement
Identify and input your store's Top 5 variances (in terms of cost) for Ingredients, Food & Retail
Ingredients Qty. Variance Variance amount in pesos Findings Action Steps
Ingredient 1 0 0.00 Ingredient 1 • Ingredient 1
Ingredient 2 0 0.00 Ingredient 2 • Ingredient 2
Ingredient 3 0 0.00 Ingredient 3 • Ingredient 3
Ingredient 4 0 0.00 Ingredient 4 • Ingredient 4
Ingredient 5 0 0.00 Ingredient 5 • Ingredient 5
Other Variances Qty. Variance Variance amount in pesos Findings Action Steps
Other 1 0 0.00 Other 1 • Other 1
Other 2 0 0.00 Other 2 • Other 2
Other 3 0 0.00 Other 3 • Other 3
Other 4 0 0.00 Other 4 • Other 4
Other 5 0 0.00 Other 5 • Other 5
Action Steps
•
•
•
•
•
Action Steps
•
•
•
•
•
Action Steps
•
•
•
•
•
Action Steps
•
•
•
•
•