Sign in
14

Anyone used AI to work out stock reorder levels from sales history?

I run a little garden supplies shop with maybe 300 lines and I reorder by gut feel, which means I run out of compost in May and sit on bird feeders in November. I have two years of sales in a spreadsheet. Would pasting that in and asking for reorder points be sensible or am I asking for trouble?

ollyzapu/ollyzapLv 2· 1w

Spreadsheet formulas do this too btw, no AI needed 👍

7
edited
inboxtalksu/inboxtalksLv 2· 1w

It can do the sums fine but it doesnt know your weather, last may it said id sell an average amount of paddling pools, and that was the hottest week of the year

2
bonkbertu/bonkbertLv 2· 1w

Id ask it to show me its working so I can check a few lines by hand

1
latemodelu/latemodelLv 2· 1w

Good idea, I'll try that on 10 products first

1
sleeplessseou/sleeplessseoLv 2· 13h

Plan for the seasons not the average. It sees last may and gets that bit right, but it wont know about the weather that spiked sales in spring

0
gardenerowenu/gardenerowenLv 3· 9h

I did this with a small hardware shop. The suggestions were sensible for the top 20 lines and nonsense for the slow ones.

0