MHB Form some model to predict a food items probability of you know being sold

AI Thread Summary
The discussion centers on developing a predictive model for food sales at a workplace to minimize waste and avoid long wait times for customers. The user seeks to incorporate variables such as ticket sales, weather conditions, and item popularity into their model. Recommendations include analyzing past sales data using Excel to identify trends before building a complex model. The user is also looking for resources to improve their statistical knowledge, particularly in a business context. Overall, the goal is to create a reliable forecasting method for food demand.
J132456
Messages
9
Reaction score
1
Hi so I'm really new to stats, like I know mean, median, mode, and t-testsish and that is it. However, this topic really resonates with me because I know it can have real world applications. So these are my questions.

First off here is my real world problem. At my workplace, we sell food that we make. However, we have to predict how much to make before hand otherwise if we run out, the wait will be too long and people get antsy (Most of the people get mad at me, but I'm just the cashier) Next off, if we make too much food, we end up wasting money. We throw away what we don't sell, except for some food which can last a little longer. It is a loose loose scenarion unless we can predict how much to make with some degree of certainty.

As you can probably tell, I want to form some model to predict a food items probability of you know being sold. Now I'm going back to work soon so I'm starting with these variables. I can base a model on how many people have bought tickets, the pre-sales. However on holidays, there are usually lots more people. In addition, I can base it on weather, because we are out doors, there are less sails when it rains. In addition, certain items are more popular than others. I believe that using these factors, and hopefully others that you guys can bring up, will be enough to start some sort of model to predict all this stuff on.

Next, I was hoping you guys knew of any good free online texbooks I can get my hands on, or even cheap ones I can order online.

Thanks again and I can't wait to hear back from you guys.
 
Mathematics news on Phys.org
piano123 said:
Hi so I'm really new to stats, like I know mean, median, mode, and t-testsish and that is it. However, this topic really resonates with me because I know it can have real world applications. So these are my questions.

First off here is my real world problem. At my workplace, we sell food that we make. However, we have to predict how much to make before hand otherwise if we run out, the wait will be too long and people get antsy (Most of the people get mad at me, but I'm just the cashier) Next off, if we make too much food, we end up wasting money. We throw away what we don't sell, except for some food which can last a little longer. It is a loose loose scenarion unless we can predict how much to make with some degree of certainty.

As you can probably tell, I want to form some model to predict a food items probability of you know being sold. Now I'm going back to work soon so I'm starting with these variables. I can base a model on how many people have bought tickets, the pre-sales. However on holidays, there are usually lots more people. In addition, I can base it on weather, because we are out doors, there are less sails when it rains. In addition, certain items are more popular than others. I believe that using these factors, and hopefully others that you guys can bring up, will be enough to start some sort of model to predict all this stuff on.

Next, I was hoping you guys knew of any good free online texbooks I can get my hands on, or even cheap ones I can order online.

Thanks again and I can't wait to hear back from you guys.

Hi piano123,

Welcome to MHB!

This is a really interesting problem as it's directly from the "real world". These are types of problems that I try to think about each day. What you are trying to do is forecast the expected food demand for the next 1-2 days so you can buy appropriate supplies. This is part of a very interesting but unfortunately complicated part of statistics called time series.

My recommendation would be to do some analytics on your sales rather than build a model right now. Do you have a record of all your sales? If you have information with the time it was sold you can analyze it in Excel, looking at sales by time of day and day of the week. Those would be the first two places I'd start. Then add weather, food group, etc.
 
Awesome, this is really helpful. I think I'm going to start with one food item and try to analyze its sales. Do you know of any good textbooks or other sources I could start studying to grasp statistical analysis a little better?
 
piano123 said:
Awesome, this is really helpful. I think I'm going to start with one food item and try to analyze its sales. Do you know of any good textbooks or other sources I could start studying to grasp statistical analysis a little better?

I think this would depend on a few things. Usually students start with a lot of baseline concepts and work their way up slowly. I think that works well if you have a few years but in corporate, business environments I think the goals are a little different. I would recommend doing statistics simultaneously as you learn Excel, Python, or R. These tools are all very standard now in data analytics and will do a lot of things very fast. What type of learning style do you have? What is your main goal for studying stats?
 
So, I do know excel. I can do T-tests, I get p-values. I have some knowledge of standard curves and I have a good basic understanding of integration and differentiation. With this in mind, I know there is so much more to excel than the baseline I have right now. After this summer I'll be a senior and will be taking AP stats. This little summer project is really just for me. I want to see how far I can go in sort of undertanding stats in a business setting and ultimatley I'd like to obtain some model that can accuratley predict the food sales at my job. Since school is winding down I thought it would be a good time to get a jumpstart on challenging myself. I do like other types of math but I see the most utility in having a greater understanding of statistics. That is why I really want to hunker down and learn as much as I can about this topic. So If you know of any good resources that I can start taking a crack at, it would be super appreciated. Also, I plan on coming back here a lot.

Thank you very much for your quick responses and for your helpful insight.
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
Thread 'Imaginary Pythagoras'
I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...

Similar threads

Replies
11
Views
2K
Replies
3
Views
1K
Replies
14
Views
2K
Replies
18
Views
2K
Back
Top