__STYLES__
Tools used in this project
Pizza Anyone?

About this project

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):

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png)undefined

Results:

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image006.png)undefinedundefinedundefined

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

undefined

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

undefined

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):

undefined

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

undefined

4.Which pizzas make the most revenue?

undefined

Results:

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image020.png)undefinedundefined

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

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image024.png)undefined

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.

undefinedundefined

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image025.png)

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

undefined

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.

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image031.png)undefined

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.

undefined

Results:

![](file:///C:/Users/trish/AppData/Local/Temp/msohtmlclip1/01/clip_image036.png)undefinedundefined

Discussion and feedback(0 comments)
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.