Monthly Pizzeria Control Sheet in Excel 4.0
Developed by: luztemplates
Product Specs:
Description
Ingredients Registration
Record all the ingredients used in your pizzas and determine the unit of measure of each of them to help you in the use and management of the worksheet
Register of Pizzas and Ingredients Used
Record all the pizzas your establishment sells, determine their selling prices and ingredients used to understand the cost of them
Purchasing and Expenses Control
Area for daily registration of expenses with costs (with ingredients) and general expenses (with personnel, marketing and related to the operation of the pizzeria)
Sales and Order Control
Area to record daily sales, determine which pizzas and beverages were ordered, see the order value and determine whether it is for delivery or pick-up on the spot
Delivery Tracking
Choose the day of the month and see all the orders that were made that day and which deliveries need to be made
Sales and Orders Report
Keep track of for each day of the month the number of sales made, the average ticket for those sales, and the percentage of orders for delivery that were made in comparison to the total number of orders taken at the place
Ingredient Inventory Report
See exactly how many ingredients you still have in stock and never get on hand because you do not have the main inputs needed to make your pizzas
Monthly Cash Flow
See for each of the days of the month the amount of recipes that came in, ingredients purchase costs, pizzeria overhead costs and financial result for the day and for the month as a whole
General and Financial Dashboard
Follow two control panels with the main indicators and charts in the worksheet. In the first, you will follow the total of orders and see for each day of the month the total orders for delivery and withdrawal. In the other you will see the daily cash flow in a visual chart and the most important financial indicators for your pizza restaurant
Product Specs: