Pizza Anyone?

Purpose:

The Pizza Place has hired Trisha to analyze various metrics from their pizza restaurant. They need Trisha’s help to decide which pizzas are ordered the most and which ones generate the most revenue, what times of day they need to have more staff and which ingredients they need to make sure they have on stock for the most popular pizzas. They have operated their business well for their first year but want to continue to do well.

Objectives:

1. Which pizzas have had the most orders over the past year of business at the Pizza Restaurant?

2. What ingredients does the restaurant need to make sure they have on hand to make the top 10 ordered pizzas?

3. And what about the ingredients for the top 10 pizzas by revenue?

4. Which pizzas make the most revenue?

5. How much revenue is made per month by the pizza restaurant?

6. What time of day are the most orders placed?

7. Which size pizza sells most often?

---

1. Which pizzas have had the most orders over the past year of business at the Pizza Restaurant?

Pizzas with the most orders (query):


Results:


2. Which ingredients does the restaurant need to make sure they have on hand to make the top 10 ordered pizzas? (query):

With the following results: I would recommend having the following ingredients always on hand in decent quantities.

3.And what about the ingredients for the top 10 pizzas by revenue?

To make sure that the ingredients are available for the highest revenue pizzas (query):

Results: I would recommend also having these ingredients available as well:

4.Which pizzas make the most revenue?

Results:


5.How much revenue is made per month by the pizza restaurant? (query):


Results:

Best sales by month: July, March, May, and November are all in the $69 to $70,000 ranges. The worst months seem to be September, October, and December. I would recommend coupons or incentives, such as buy one get one half off or similar promotion to get more customers in the doors on the slower months. The overall trend is going down slightly. They may want to consider reducing the number of pizzas on the menu or have 15 to 20 core pizzas and a “make your own” option with some of the most popular ingredients. Right now, they have 32 different pizzas which may be overwhelming to some customers.


6.What time of day are the most orders placed? (query):

Results: Dinner and lunch are the times for the highest number of orders, staff schedules should reflect this higher traffic for lunch times and diner times with adequate staffing to fill orders in the mid-afternoon as well as late night.


7.Which size pizza sells most often? Large and medium pizzas have the most orders. They may want to consider specials at lunch time for small pizzas or other promotions to boost sales.

Results: