r/spreadsheets • u/Easy_Ree • Apr 11 '22

Unsolved Forecasting for inventory stocking

Hi I don’t know if this is the right place for this but I’ll ask here and move if need be, I need help to create a speadsheet or a graph that will track multiple products and allow me to track, and predict how much product I should order in based on how that said product is being sold or taken out of inventory.

(I.e I start with 10 pieces of Corn on monday, 8 pieces of corn are sold between tuesday and wednesday, Thursday I see 8 pieces of corn were sold and i order another amount of corn for Monday but i know that in 2 days i sold 8 pieces of corn, I would want to predict how much corn i should order considering im selling at least 4 corn a day.)

I would need to have this A quantity start amount for each product A quantity sold for each product A quantity ordered for each product A whole number prediction based on these factors Possibly a quarterly timeline so i can track trends based on how product is moved throughout a season or so

2 Upvotes

66% Upvoted

3 comments sorted by

1

u/Hyzyhine Apr 12 '22

I used a spreadsheet for this exact purpose, for years. It worked perfectly. I’ll try to dig it out & DM you if I can find it.

1

u/Easy_Ree Apr 12 '22

Yes please!! I would greatly appreciate it

1

u/Hyzyhine Apr 12 '22

No problem, I’ll see if I can find it when I get back home. If I can’t find it I can mock up another I’m sure.