Roni's Challenge

Roni’s Challenge Looking at the data we see several interesting things. First, assuming that “Time Sent” refers to the time taken to take an order we find that the difference between each block of time is the time needed to serve the customer. Now, from this we get Figure 1. On the whole, we see that the large orders such as the party size garlic bread and mac and cheese are taking the most time to prepare. This is true even in months where these were only ordered once. The second point of interest is the most popular mac and cheese combinations. From Figure 2 we see that the most popular modification made to mac and cheese is no modification at all or no side. In general, across all parent menu items, aside from removing a side or drink and after regular orders, we see that Chedder and parmesan are the most popular modifications to get. The third point of interest is given by Figure 3. Here we see the number of orders per month. From this we get the estimated orders to be made in November and December. As you can see the number of orders from June to September has increased, the predicted number of orders for November to January shows an increase. The shaded region is the error margin on how much it can go down or best case scenario for the orders in the month.

Figure 1: Average Time to Prepare Menu Item Per Month Figure 2: Modifiers each Month VS Total Modifier Count Figure 3: Forecasted Sales

App Navigations The app has many buttons which are used to navigate between pages. There is a summary on the home page which gives a brief overview on how the buttons work and what data they will show when you click on them. There is also a link

https://ronis2024dataviewer-sandbox.mxapps.io/ https://drive.google.com/file/d/1WrOx5pNJoQ1ShM8RkIkUyJoJzTFNseWY/view?usp=drive_link