Developing an Automated Ordering System and Analyzing Sales Data

This project details the development of an automated ordering system for the "Below Zero" ice cream store, aiming to streamline the ordering process and reduce errors. It includes the implementation of a Python-based system for automatic billing and customer payment, along with graphical representations of data such as temperature and sales trends, generated using Jupyter Notebook. The system incorporates logic to prevent misuse and ensures accurate price calculations. The analysis of sales data from five neighboring regions provides insights into current trends, enhancing the store's operational efficiency and customer experience. This project successfully minimizes user input errors and creates a better interface between the ice cream shop and its customers.

792429-Python

Table of Contents
1) Introduction.........................................................................................................................2
2) Ordering system..................................................................................................................2
3) Ice cream trends..................................................................................................................6
4) Conclusion..........................................................................................................................6
References..................................................................................................................................7
[1]

Introduction
For improving the business there are many parts need to upgrade. Human errors leads
to huge losses to the organization. Errors are common for everyone but sometimes minimal
errors leads to big problem. This topic also states the human error in the ice cream store that
leads to business loss. In this assignment the management of the ice cream shop wants
implement the automation system for the entire billing system. Because this process involves
too much complexity. So the automation is the only solution for improvement of the effective
process. which is done by the computer itself. In this topic various things will be going to
done like the automatic billing system and automatic customer payment etc. the other things
like graphical representation for the things like temperature for knowing the temperature and
total sales for finding the total amount received by the given region are going to be analyzed
in this part.
Ordering system
Coding and screenshots
Main python file
[2]

Checkoutregister python file
[3]

[4]

Product python file
Output
[5]

The above figure represents the output for the ice cream shop. The billing process is
automatically done by the system. For example the input was taken from the customer
like whatever they want. Later it shows the payment due for the customer products. So
again the customer needs enter the payment amount to the billing process. Then it will
show the total amount and with the return amount which is the minus amount from the
given total.
[6]

The above figure represents the different cones, toppings and different flavors which are
available in the ice cream shop.
Ice cream trends
All most all the business are upgraded according to the time changes. In previous days
the up gradation of the particular product is very slow. Whereas now a days the updating of
the product is very fast and becomes trending. Due to the population increases and modern
era updating makes every product impressive (Amador, Hartel & Rankin, 2017). In the same
way this topic also states the up gradation of the ice cream store. Below zero is the local ice
cream store that wants to improve. Improvement in the sense is not only with the products
and also needs improvement in other various things like the system needs to automatically
calculate the total price without anyone help. The automatic calculation includes the input
from the user like their name, address and their payable amount etc. the customers must need
to choose the orders by their own. The things like cone shapes, flavors and toppings are up to
their wish. The system just need to calculate the total price according to the total. The code
must have some logic like the minimum and maximum things. For example sometimes some
the lazy customers can able misuse the system like pressing all the options at a same time. So
the code must need to avoid these kind of things. For that the algorithm and logic should be
coded. In our code we avoided these kind of errors by means minimum and maximum logic.
The minimum logic contains the user must select at least one cone type for further
proceedings. The maximum logic contains the user not permitted to select the 4 toppings per
ice cream. If they try to do that then the system will prints the error message. The maximum
logic also includes the user not permitted to select the scoops more than 3 times for an ice
cream (Warren & Hartel, 2014).
[7]

Figure 1 jupyter notebook project
The above figure represents the working of the project in the jupyter notebook. All the
csv files are converted in to txt files to minimize the output time for the jupyter notebook.
The StoreDetails.csv and WeeklySales.csv and Region.csv files are need to upload in a same
project in the jupyter notebook. Otherwise the graph won’t be generated.
Figure 2 importing the csv file
The above graph represents the values which is taken as an output during the jupyter
notebook execution. The details like store, date, temperature and unemployment are there in
the StoreDetails.csv file. Where the store column represents the details of the different stores.
[8]

The value 1 represents the store with name 1. The date column represents the different dates
which is used to know about the different transactions held on the particular date. The
temperature column represents the different the highest temperature of the particular date for
the particular store. This temperature column is the important column because for an ice
cream shop the temperature plays the major role. Because if the temperature is too high then
the coolness of the ice cream may also less and leads to wastage. So temperature is also noted
for the each and every stores. The unemployment column denotes the number of the people
who are not working yet.
Figure 3 output screenshot of the jupyter notebook for representing the variables.
[9]

The above figure represents the different variables which are used to represent the
values in a graphical representation. The variable (? store) represented in the x axis and Date
is represented in the y axis.
Figure 4 representation of the store and date for the given value
The above figure represents the graphical representation of the different dates for a
store 1. The different dates are represented in the y axis and store 1 in the x axis.
[10]

Figure 5 representation of store and date for the whole data
The above graph represents the actual output for the whole data in the store details csv
file. There lot of data are there in the given csv file. Among the data are combined and shown
together in the graph. The x axis represents the store details for the different stores. The store
details represents the name of the stores. The y axis represents the different dates for the
different stores.
Conclusion
From this topic various things were done successfully. The automatic billing system
for the below zero ice cream shop was done. The coding and logic of the program was also
done successfully. The logic for the minimum and maximum also executed and completed.
Taking inputs from the users and calculation of billing process was also done successfully.
[11]