Excel Formulas for Retail & Restaurant Business

Looking to optimize your retail or restaurant business using Microsoft Excel? This video is for you.
In this tutorial, we'll cover a variety of Excel formulas that are specifically tailored for businesses in the retail and restaurant industries. COS / COGS, COL, APC / APT, SSSG, SSTG, Menu Mix & Sales Mix, TMTO, Retention, these formulas will help you make data-driven decisions and streamline your business operations. By the end of this video, you'll have a solid understanding of how to use Excel to improve your retail or restaurant business. Whether you're a business owner, manager, or analyst, these formulas will help you save time, reduce errors, and make better decisions. So grab a cup of coffee and join us for this exciting Excel tutorial.

✅ Please Join my channel. It really keeps me Motivated to create such productive videos for you.
   / @office-monk  

======================================
📂 File Link:
https://docs.google.com/spreadsheets/...
======================================

Chapters:
00:00 - intro
00:53 - COS / COGS - Cost of Goods Sold
02:28 - COL - Cost of Labor
04:00 - APC / APT - Average Per Check / Transaction
04:28 - SSSG / SSTG - Same Store Sales Growth / Same Store Sales Growth
06:13 - Menu Mix & Sales Mix
08:05 - TMTO & Retention - Team Member Turnover / Team Member Retention
00:00 - Closing



#excel #excelformulasforrestaurants #excelformulasforretail #exceltips #exceltutorial #exceltricks #excelhacks #excelhack #DSR #DailySalesReport #RestaurantDSR #SalesReport #Sales #ClubDSR #ResortDSR #HotelDSR #advancedexcel #advancedexceltraining #Excel #maintainsalesreportinexcel #HowToMakeDailySalesReport #SuggestiveSelling #UpSelling #dashboard #averagepercheck #apc #apt #averagepertransaction

Gears I use:
Samsung Phone: https://amzn.to/3kCmIBN
Camera: https://amzn.to/3kA9aH1
Camera Lens: https://amzn.to/3mmxUmE
Tripod: https://amzn.to/3m8ITQg
Laptop: https://amzn.to/3y3XDmd
Lights: https://amzn.to/3J5V0qn

Topics Covered:

How to calculate COS / COGS,
How to calculate Food Cost,
How to Calculate COL,
How to calculate Cost of Labor,
How to calculate Menu Mix,
How to calculate Sales Mix,
How to calculate SSSG,
How to calculate SSTG,
Same Store Sales Growth,
Same Store Transaction Growth,
Team Member Turn over,
TMTO,
Staff Retention,
Retention,
How to calculate retention and turnover,
APC, APT, Average Per Check, Average Per Ticket, Average Per Transaction,

Please Like, Share & Subscribe #OfficeMonk