![]() ![]() ![]() You can see the stats for the FOH and BOH displayed separately. Based upon the numbers you forecast, you can see the estimated Average Check (before tax), total scheduled labor hours and wages (without the cost of benefits), total labor hours per cover (not cuver as in the image!), labor cost $ per cover, labor percentage forecast, and the total number of covers served per labor hour. In the yellow areas, enter your forecasted covers, food and beverage sales, and then the rest calculates for you. The darker blue areas at the bottom of each section also automatically display the totals for each column.Īfter you have entered your scheduled hours in the Forecast Labor section, the Forecast Labor Summary area gives you “at a glance” vital into about your labor statistics. The cells in white are formulas which automatically calculate when you enter all the needed info in the yellow cells. The areas in yellow is information you need to enter. You can do this by the week, or by the day, or whatever period of time you want to forecast. If you have staff with different rates of pay working the same position, simply enter Grill Cook 1, Grill Cook 2, or some other designation so you can accurately enter the wages and hours for each team member. Next, enter the wage for each position, the number of people needed for that position. For BOH, the image below shows grill cooks, saute cooks, pantry cooks, etc, but you can rename them to whatever positions your restaurant uses. The Labor Forecast tab is for entering the scheduled hours for all of your food & beverage positions, broken down into FOH (front of house) and BOH (back of house) positions. Note: there is only one true download button near the bottom of the page…anything stating download before that is probably an ad. The download near the bottom of this page and will bring you to our download library. The spreadsheet contains multiple tabs, so lets look at each one individually. On this page I will explain how to use this restaurant labor cost Excel template, which is available to $5.00 premium members of Chefs Resources. The form on this page is designed to help you create a budget based upon your actual staffing levels, forecast labor cost based upon anticipated business levels, and then get actual labor costs when you have final numbers for the period being evaluated. If you don’t have a professional software package to track labor, then using a restaurant labor cost Excel template can help you manage your expenses. Labor cost is one of the biggest expenses a restaurant has, especially if employee benefits such as healthcare, PTO time, and/or 401k are also offered to employees. Using Excel to Track Restaurant Labor Costs ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |