Prediction for Inventory of Restaurants

by Riley MacDonald

Submitted : Spring 2018

In these projects I was able to figure out from past inventory orders how much of something that we need to order using a linear regression model. To make the regression model you need a lot of data to make the model, so you can predict the future inventory. My boss gave me two months worth of data for each day except Sundays because Chick-fil-A does not open that day. From that I took the day that had the most information which was Tuesday from March to May. Using Excel I was able to make a graph and plot the points of data and made a linear regression model out of it with the formula to make future predictions of what we might have to order.

[ Back ]