|
Hi Bill,
Have you looked at Maximo or any other off-the-shelf CMMS systems? It's quite expensive (around £4,000 per User) but it does everything you could ever want when it comes to a full Maintenance system (Work Planning, Resource Scheduling, Asset Management, Inventory Management etc.). It can also do the Serial Number tracking on Parts while treating them under a common SKU (my background is in the pharma industry where this is a particular bugbear).
I was working on developing a system last year which was put on the back burner which predicts spares usage and recommends stocking levels based on historical &/or estimated failure rates. I would hope to get it finished by the end of the year. If you have any interest in that, let me know.
Dec.
Declan O'Brien
Aldolex Irl ltd
|
|
|
|
|
Declan OBrien wrote: Hi Bill,
It's Roger. 
/ravi
|
|
|
|
|
Ha!!
I obviously had "Bill" on the brain after reading BillWoodruff's post!!
Sorry Roger 
|
|
|
|
|
Declan OBrien wrote: I obviously had "Bill" on the brain
I forgive you, and, please, don't worry, it's usually not fatal.
cheers, Bill
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
We use Microsoft Dynamics NAV (with an LS Retail POS add-on) for our retail stores. It handles inventory and sales. It will cover your requirements, but it's not cheap to buy or implement.
|
|
|
|
|
Have you checked Upwork.com or one of the other freelancer sites?
|
|
|
|
|
To be honest, this sounds pretty simple to make. Am I missing something?
I could prolly do that for you.
|
|
|
|
|
What do your competitors use?
Do you have a budget?
Do you have a staff to maintain the data?
Would you consider RFID tagging all 1,000 pieces of inventory.
setting up sensors on the egress locations to ALARM who ever is trying to remove the device,
to remind them to take the RFID off, and fill in the 3-5 Fields of info (who they are, why
they are taking it, what job, etc)?
I would want to bullet-proof the exiting of the inventory. Most of the time, people are too busy trying to avoid the alligators to remember they need to drain the swamp.
Most systems fail, not because the system does not work. But because it does not "flow" (catching things when they need to be caught, helping people to do the right thing), and then because of users or lack of ability to keep the information up to date.
Once the information is there, doing the things you suggested are a matter of:
- Do they need to be automated?
- Is it okay if it is a report or dashboard that shows the status?
Email me if you want to dig deeper.
We implement these kinds of solutions. We use tools that let you dump just about everything to Excel, and perform additional ad hoc analysis as you wish.
|
|
|
|
|
Hmm ... that's just the kind of application that I write for my business "Simple Software By Design". I put a copy of your post in my idea folder! If, at some point, you'd like to discuss development of something like this I'd be glad to talk to you. Might take a few months to do with our present work load but on the surface seems like exactly what we do.
Send to "postmaster@simplesoftwarebydesign.com" if you'd like to talk.
-Clockmeister
|
|
|
|
|
As a matter of fact...
One of the companies I work for imports and distributes auto parts. We have about 10,000 SKUs and have developed a system in-house that does almost everything in your requirements list. The only thing missing is serial number tracking. Not only does it suggest orders - based on your historical usage of a SKU - but, it allows you to enter quotes from multiple vendors for the same SKU, and suggests which vendor to buy from based on price. It is a Microsoft Access Front-end and SQL Server back-end. We don't sell it, but here is the good part: We have an Access-only version for customers.
In addition to the inventory control and purchasing features, it also has job tracking. Not only that, it allows you to create and save custom jobs that can be called up with the click of a mouse, that have a list of parts (and quantities) that you have specified for that particular job.
It also includes a complete, searchable catalog. Search for parts in the catalog, and with the click of a button you can add them to a job or a suggested PO.
Obviously the program is geared towards automotive repair shops, but since it doesn't care what you enter into inventory or the catalog, it could actually be adapted to virtually any business. You could actually have some fun with it - naming jobs after exotic cars, etc. Email me if you'd like to take a look at it.
Ron Hinds
|
|
|
|
|
I could build you a MS based solution utilising Access as the main hub and using Excel and Word to generate forms and letters. I build systems and tools like the one you describe for my company tracking activity, assets, forecasting and automating reporting and admin processes. I have also integrated data capture using smartphones into a central database using a third party company, which is much easier than getting people to sit in front of a computer. Depending on the scope it shouldn't take more than a few weeks, if your interested then I can put a prototype together this week.
Peter Deacon
|
|
|
|
|
The Professor is in his laboratory putting his hypothesis to the final test. His subject,
Ctenocephalides canis (dog flea), there on the microscope stage, before him as he peers
down the 3.5 macular objective ... In his notebook he takes notes on observed behavior.
He makes a scribble "Day 01, subject cC_01, have observed reticence in previous subjects
to respond to my command after six tests have been conducted. Assert/confirm/advise/conclude."
He goes on, on a new line.
"Today cC_02 ... full battery ... Experiment begin Ti:09:21:00"
The test subject has been fastened to the stage floor by a hair tether and two drops of
crazy glue. This is to locate him in less grandiose motion patterns while the experiment
ensues. Reaching onto the stage with two forceps, one in each hand, the Dr. grasps the
abdomen of cC_02 with the left and the right forelimb with the right ... and slowly pulls
the right forelimb off of the subject.
"Jump flea!" he says to the insect. And the flea jumps. The Dr. marks down in his
notebook:
- test 01 ... loss of right forelimb results in no loss of ability to perform command.
Subject jumps. -
The experiment continues. The Dr. now again grabs the abdomen of cc_02 with his left
forcep and proceeds to grasp the middle leg of the right side of the subject and
gently pulls the entire leg off then lowers his head close to the stage and says "Jump
flea!" And the flea jumps. He makes a mark in his notebook:
- test 02 ... loss of thoracic leg right results in no loss of ability to perform
command. Subject jumps. -
The experiment continues. This time the Dr. with his left forcep again grasps
the flea but this time by the pronotum of the thorax and with his other forcep grasps the
rear right leg and gives it a tug so as to completely dissarticulate the coxa removing it
entirely from the thorax, then commands the flea to jump. "Jump flea!" And
the flea jumps. The Dr. marks down in his notebook:
-test 03 ... loss of right rear leg results in absolutely no change in behavior and the
subject obeys the command. Subject Jumps. -
And the experiment continues to the left side. The Dr. takes the left forelimb of the
flea into his left forcep and grasps the abdomen again with the right forcep and gives
the leg a yank removing it from the now only two-limbed flea. He lowers his head close to
the stage and says "Jump flea"! And the flea still jumps. The Dr. marks down
in his notebook:
-test 04 ... loss of left thoracic forelimb results in no change in behavior. Subject
responds to command to jump with positive jump twitch. Subject jumps. -
Continuing, to the second-to-last remaining limb, the left middle appendage, the Dr.
grasps it with his left forcep and quickly snatches it from the thorax. He lowers his
head and speaks to the flea "Jump flea!" And the flea jumps. He writes down in his
notebook:
-test 05 ... loss of left middle thoracic appendage results in no change in behavior.
Subject responds to command to jump. Subject jumps. -
Finally, the last test in the battery. The Dr. is primed to finish and knows with only
one more limb available, this is it, experimentally. So, he grasps the remaining limb,
the left rear leg with his left forcep and goes back to grasping the elytra of the thorax
with his right forcep, and seperates the leg from the insect. He leans in to the stage
and issues the final command "Jump flea!" And the flea just sits there. The Dr. marks
down in his notebook:
-test 06 ... loss of left rear leg results in marked change in Ctenocephalides canis
cC_02 behavior. Subject does not repsond to command to jump. -
The doctor jots down a few page width slashes and scribbles on a new line under a another
new line entitled "Experimental conclusions":
"End experiment T0:10:00:00"
"Scientific method applied to subject with respect to elliciting behaviors through
issuance of verbal commands at microscope stage height of little variance results in
skewed test result, the induction of which lead this experimenter to make a singlar
conclusion about the jumping observed in Ctenocephalides canis (dog flea):
When all limbs from Ctenocephalides canis have been removed, subject goes completey
deaf."
|
|
|
|
|
Was this a joke?
If it's not broken, fix it until it is
|
|
|
|
|
No. This is proof that a flea's ear is on it's left rear leg.
Within you lies the power for good - Use it!
|
|
|
|
|
Congratulations. You just wrote all that simply to show that the deductive method used in science is often wrong.
Marc
|
|
|
|
|
Besides that, I first heard that joke in 1964 or so, about a frog, and it was much shorter and funnier.
Will Rogers never met me.
|
|
|
|
|
I think all frogs are both shorter and funnier than all dogs. 
I, too, probably heard it around that time - but it was the sixties, so who remembers?
(I was also 5 years old)
PooperPig - Coming Soon
|
|
|
|
|
I was ten, so I remember clearly. And my teacher, Mrs. Lute, wasn't nearly as hot as my 5th grade teacher, but she was awfully nice, and gave me my first tropical fish to put in the aquarium my parent bought me that year for Christmas. They were delicious.
Will Rogers never met me.
|
|
|
|
|
Maxxx wrote: I think all frogs are both shorter and funnier than all dogs.
Then you think wrong. The goliath frog grows to lengths of 12" while chihuahuas can be up to (no wait .. down to) 6" nose to tail.
|
|
|
|
|
D'you know, when I write that, I thought "I bet some twonk goes and looks up the biggest frog and smallest dog ..."
PooperPig - Coming Soon
|
|
|
|
|
Always a pleasure, never a chore! 
|
|
|
|
|
Too much spare time we have...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Now that was funny! 
You have just been Sharapova'd.
|
|
|
|
|
|
Thumbs up for number 1 alone!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
