Sales, costs, net profit, net profit percentage, food gross profit margin and beverage gross profit margin are all found here, allowing you to compare weekly figures at a glance. The shareholder scores section at the top of each worksheet shows a summary of the vital details found elsewhere on the sheet. The net profit percentage shows your profit as a proportion of all sales, while the net profit per cover calculates the net profit per customer.
The first, net profit, simply shows sales minus costs.
The net profit section automatically creates three calculations for you. Again, this information is automatically calculated based on information entered elsewhere on the spreadsheet. The average sale per cover section calculates the average spend per customer in each of the beverage, dinner (lunch and dinner) and breakfast categories. There is nothing to enter in this section, as figures are calculated automatically based on the data entered in the cover data, sales data and costs section. The cost share distribution calculates a total cost from each of the four categories: food, beverages, labour and other, giving a gross profit margin from each category based on this. If any of these do not apply, simply enter 0, and a dash will be displayed in the cell, indicating there is no information to display for this category.Īs with the cover and sales data, completing the budget and last year columns will allow the spreadsheet to calculate a comparison against each, and these will be colour coded with arrows to indicate whether or they are an increase or decrease. Aside from food and drink costs, there is space to enter any other expenditure, including cleaning materials, glassware and cutlery, kitchen replacement, guest supplies, printing and stationary, miscellaneous, music and entertainment, and equipment hire. Similarly, beverages are split into beverage inventory opening, beverage cost and beverage inventory closing. Food is split into food inventory opening, food cost and food inventory closing. The costs list is grouped into sections, starting with labour costs, such as managers salary, kitchen labour cost, bar labour cost, breakfast labour cost, dinner labour cost and other labour costs. The costs section provides spaces to fill in a wide variety of costs that can be expected in a restaurant. Once all sections are complete, the comparison against budget and last year will be automatically generated for you, with the same colour scheme as in cover data visible. There are rows, for filling in your food sales for breakfast, lunch and dinner separately, as well as a line for beverages, and one for any other sales you may make. Sales DataĪs with the cover data section, there is space here to fill out your actual, budget and last year data. If your actual cover numbers match your budget or last year cover numbers, you will see a blue arrow. Green text and arrows indicate in increase compared to your budget or last year, while red text and arrows indicate you are down against budget or the previous years. To compare against plan and last year, ensure you fill these columns in too, and the comparison against both your budget and last year will be automatically completed for you. Simply enter your cover numbers into the actual column for breakfast, lunch and dinner. Use this section to enter the number of customers for breakfast, lunch and dinner. Contains Fields for Logo & Company info.Unlocked - so that you can customize it just a little more.WorkApps Package your entire business program or project into a WorkApp in minutes.Digital asset management Manage and distribute assets, and see how they perform.Resource management Find the best project team and forecast resourcing needs.Intelligent workflows Automate business processes across systems.Governance & administration Configure and manage global controls and settings.Streamlined business apps Build easy-to-navigate business apps in minutes.Integrations Work smarter and more efficiently by sharing information across platforms.Secure request management Streamline requests, process ticketing, and more.Process management at scale Deliver consistent projects and processes at scale.Content management Organize, manage, and review content production.Workflow automation Quickly automate repetitive tasks and processes.Team collaboration Connect everyone on one collaborative platform.Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.
0 kommentar(er)
