PIZZA PLACE SALES REPORT

Background Problem

A pizza restaurant has a pizza sales dataset in a year, including information about the type of pizza sold, order time, and other details. This restaurant wants to optimize its production process to increase efficiency and profit by 10% within 3 months.



Problem Statement

How to increase pizza sales by 10% within 3 months?



Root Cause

rootcause

Hypothesis

Possible Root Cause Hypothesis
Size If the size of the pizza is increased proportionally to the price, customers will not feel shortchanged.
Raw Materials If the raw materials used are cheaper and of high quality, sales will increase by 10%.
Manufacturing Process If the pizza-making process follows SOP, the final pizza will be optimal.
Taste If the seller adjusts the taste to the target market, the number of customers will increase.

Metrics

Sales Trend This metric refers to analyzing changes in sales volume over a period of time. By monitoring sales trends, management can evaluate the effectiveness of marketing and operational strategies and identify sales patterns that may affect business performance.
Total Product Sold It is the aggregate number of all product units sold in a period of time. This metric gives an idea of the overall sales performance and gives an indication of the market demand for the products or services offered.
Customer Habits This metric includes analysis on customer preferences and purchasing behavior. This includes the types of products frequently purchased, frequency of purchase, time of purchase, and other preferences. Understanding customer habits is important for identifying opportunities to increase sales, improve customer satisfaction, and design more effective marketing strategies.
Pizza Type
    Category
      Size

        Total Sales

        $0

        Avg Order Value

        $0

        Total Order

        0

        Total Pizza Sold

        0

        HOURLY TREND OF TOTAL ORDERS

        MONTHLY TREND OF TOTAL ORDERS

        DAILY TREND OF TOTAL ORDERS

        TOTAL QUANTITY BY CATEGORY

        TOTAL ORDER BY SIZE

        TOP 5 BEST SELLING PIZZA

        BOTTOM 5 WORST SELLING PIZZA

        BEST SELLING PIZZA

        No Pizza Name Sum of Price