Stock Control - Shortages

[adrianh]

Maybe you should offer fat reward for an employee who catches a thief. (Make it really worth their while) People are always motivated by reward.

[AmithS]

Hi,

I looked around at stock control software looked at the costs, the features i would use how use full would all the features be used by me.

So in the end i developed a excel spread sheet that is specific to my store and accomodates for my specific needs in terms of how i would like to count my stock for input in the easiest way i know and easily adapts to my sales reports, etc...

it takes me about 15 mins to input the whole weeks data and get out the report.

It took me about 4 hours to complete and test the spreadsheet.

Hope this helps.

[bjsteyn]

My Order & Stock Management System does the following in regards to managing stock. This system is for rep and delivery based sales.
-> Calculates the On Hand Value of Floor Stock At Any Time.
-> Add and Keep Track Off Stock Purchases
- > Print Stock Take Sheets
- > Stock Takes overwrite the Calculated Stock Value
- > Low Stock Warnings
- > Suggested Stock Purchases based on Sales Trends
-> Stock Variances Report to view the differences between calculated value and the value of stock that was accounted for in a stock take
-> Busy adding so that stock take sheets can be arranged by rack numbers

I am thinking of creating a simple stock management system for store owners and maby even store mangement software for store owners using till based sales. Just wondering why you didn't decide to use stock management software. What i get from your response is that what you whould get out of it wasn't worth spending money for or that the features werent really meeting your needs .

If their was worthwile SM software, what feautures whould it have out of your needs? The software whould be developed in microsoft access and whould be very customizeable.

Thanx
BJ

[AmithS]

Hmmm as a small business owner i want just the basics, to be able to see if stock is going missing or not to be able to track when it was, narrow down the shift and find the suspects. All in all to keep shrinkage to a min and know whats going on in my business at a glance. Reason being is a small business that i feel does not require more effort than that. If it was a larger investment then yes by all means i would like more features.

[Pap_sak]

One thing that has worked for me is that if a staff member wants an item, they get it at cost price, not only that, they each have account. When they get a bonus (last month my staff in the one shop got an extra 70% of their monthly pay - just for january! - did about the same for December) I expect quite a bit to come of their account. I also found out that in the last couple of weeks, they have at least on 3 occasions kept the shop open for an extra hour or two, because they new customers where coming from other towns to shop...I've said they can open the shop late one morning this week and I'll sponsor breakfast at the local Spur.

On a side point, I have 4 full time staff, and work the holiday and sick leave cycle from Feb to Feb. Between them they have had 3 days sick leave over the whole year, pretty good I think. What I tell them though, is they officially get 16 days leave, but am very flexible and happily give them around 20 - 22 if they do not abuse the sick days. Unplanned sick days are a bit of a pain when the shops are 75km away.

[bjsteyn]

Hmmm as a small business owner i want just the basics, to be able to see if stock is going missing or not to be able to track when it was, narrow down the shift and find the suspects. All in all to keep shrinkage to a min and know whats going on in my business at a glance. Reason being is a small business that i feel does not require more effort than that. If it was a larger investment then yes by all means i would like more features.

Sounds like I whould be wasting my time from what i gather, will look into a different project.

-->> Once a thief, always a thief -->> Maybe do some background checks

A Variance Report may be of value. Just not sure how it whould be implemented as you whould need to now your sales per item between stock takes.
-->> Previous Stock Take minus New Sales plus New Stock purchases -->> Will give you the amount of stock you should have on hand -->> Minus Current Stock Take -->> Will Give You The Variance -->> If it is a minus then stock is missing -->> If it is a plus then Father Christmas has been visiting your store

Can be done on stock count aswell as value.

Hope this is usefull.

Cheers
BJ

[sterne.law@gmail.com]

Couple of pointers -
There is a balance between control and staff morale. regretfully stealing is a BIG problem in many businesses and particularly restaurants.

Keep all stores locked. Only you should open them. Do not stand outside of a freezer go in with the staff or issue yourself.
If you have a manger that has keys, have some checks over the manager (managers also steal).
Never leave the back door or any store room unattended!!!!
You can ban bags - it makes sense to have facilities for people to keep stuff.
Have a set entry and exit point for staff if possible. Make it a disciplinary offence to leave by any other exit/entrance.
Use searching. If you do not want to search every day or every person use random system. (Bag with 2 different colour objects, if you draw red you get searched)
SEARCH YOUR DUSTBINS!!!! every day - this is a common method of stealing but also checking your bins may point you in the direction of other problems. Go with staff to empty out bins.
If you can, have your outside dustbins locked - in this way the bin method is almost eliminated. Even if they get it out the bins being locked creates a problem.

If doing any stock variances, do daily. End of the week tells you what you already know - there is shrinkage!
Weigh and portion - if you issue bulk stock before packing away balance it up. Eg if I give 2kg mince for burgers, when they are finished prepping, check that you get 2kg back. Also if it is 200 gram portions that this also balances, i.e 10 portions(variances often picks up other problems)
As to if there are stock shortages - if you do not take action, it will continue. Obviously catching people who are stealing bulk stock is very different from a person eating a burger, but it all starts small.
You can charge the staff on duty. Many will now say who must pay, but the fact remains that it is almost impossible for people to steal/eat without colleagues seeing, hence they are as guilty. (This being said, having a confidential method to report stuff helps - the fact is we must understand the fear to report people - a shoe box or post box concept can work)

On incentives a simple method i have used is notice board. At the beginning of the month an amount is put on board, say R3000. Every time there is a food problem (complaint/burnt/etc) deduct the SELLING VALUE from the R3000. Likewise brocken plates and glasses etc. you can develop it to any level (amount over budget for cleaning, shrinakge etc) at the end of the month the balance is paid out to ALL staff preferably equally.

[roryf]

I worked in casino surveillance as a CCTV Tech and used to do all the covert work for the Investigations department.You will not believe how much stuff gets stolen even when good controls are in place.

I then took over a food manufacturing company that was battling, and used some of my experience to sort out the stock losses.Some of the things I used are as follows:

1)Undercover agent for 3 months to find out who the suspects were.
2)Took keys away from likely suspects
3)Made a list of the guilty people and worked them out 1 at a time on various different charges eg.Clocking,poor work performance.
4)Installed cameras.
5)Changed bin liners from black plastic to clear.
6)Got our security company to do 'stop and searches'.
7)I took away staff discount as it was being ABUSED badly.
8)Offered rewards to informants.
9)Started proper stocktaking.
10)Introduced basic Stock Control forms to our shopkeepers,so that they are able to tell me how much stock they should have at any one time.
11)Introduced a security guard.He gets tested often by us!

I saw quite a big change in my GP over just a few months.I don't think any of us actually realise just how bad the theft situation is in SA.I think many of would be shocked as to how much stock marches out of our premises with us watching!

Look sharp and watch your GP increase!