?

Log in

No account? Create an account

Previous Entry | Next Entry

*bonk, bonk, bonk*

Insert the gentle sound of someone beating their head against a wall here.

Oh, gods. I'm on week two of training for my new job as Inventory Planner, which involves tracking some 8000 items to make sure there's always adequate stock to do exciting things with. Some of these items are kits made up of other items, some of these items are out of stock and are getting back-orders stacked up against them, some of these are out of print and therefore are not worth tracking.

He's working on our monthly report now, which will, among other things, list:

1) total value of inventory (manufacturing cost)
2) total value of inventory (retail cost)
3) Total sales
4) Total back-orders
5) Total back-orders (value of)
6) Out of Print Stock

Since our system can cough up a nice report that lists on an item-by-item basis all of these, I'm thinking "five minutes with a pivot table and I can get all this info, no problem."

Then I watch, in agonized horror--there's been a lot of horror in my experience in this new job, but this time I literally can't help shouting "no--NO!"--as he saves four copies of the same report, so that he can work each one of these six lines out individually in its own report :(

Oh, gods. I do so need an aspirin.

Comments

( 12 comments — Leave a comment )
synj_munki
Mar. 28th, 2007 05:38 pm (UTC)
you should shoot him w/ a tab-gun.

who's him, anyway?
spottylogic
Mar. 29th, 2007 02:10 pm (UTC)
He's been doing his job for 15 years, but I'm taking it over and he's going to do some new stuff. So...that.
edthehyena
Mar. 28th, 2007 06:12 pm (UTC)
Your job sounds like a terrible scenario that I'd find in my Systems A&D class. At the beginning of every chapter, an employee would slowly go crazy, and the IT people would use soft, gentle voices to understand what exactly the new system needs. Then just as the employee chews his own wrist off (he didn't make it), the IT people save the day with a usable system! And the company goes bankrupt.

It's not a very happy book.
spottylogic
Mar. 29th, 2007 02:11 pm (UTC)
Wow! You always paint such beautiful pictures of my world :)
edthehyena
Mar. 29th, 2007 04:32 pm (UTC)
that's cuase I WUV you! YeshIDo!
prophetsurfer
Mar. 28th, 2007 08:42 pm (UTC)
zomg! Where'd you get the care bears emoticons??? And can I use them!?!? omgzZZZZ!
spottylogic
Mar. 28th, 2007 08:52 pm (UTC)
I'm glad you like them :) I made them myself, but I'd kind of rather keep them for just my use, at least at this phase. I've been toying with some other ideas, though, and if I go with them I'll let you know!
prophetsurfer
Mar. 28th, 2007 08:59 pm (UTC)
Aww ok that's cool. Honestly, I don't blame you! :)
jerseytude
Mar. 29th, 2007 05:56 am (UTC)
So are you going to be using your system or do the guys make you use their horribly inefficient one?

If it's the latter, I'll help you edit your resume & cover latter.
spottylogic
Mar. 29th, 2007 02:09 pm (UTC)
Thankfully, I'm free to develop whatever systems I need to, but all this guy's processes are tangled up in inefficient systems. So, I need to work out exactly what he's doing--which is, basically, learning a job, it could take a while--and then move forward with, if not better, at least more complicated methods.
rcaban
Mar. 31st, 2007 01:31 am (UTC)
not surprising
You'd be surprised at the number of times I encounter something just like this. Usually (and especially in your case) just see how he does it, wait until he moves on and then do it as best you know how using the tools you are familar with. Management will think you are brilliant OR they are used to allowing a week for that particular part of the job and you get 4.5 days of goof off time wherein you can make something of real value to the company.
spottylogic
Mar. 31st, 2007 01:09 pm (UTC)
Re: not surprising
I can see tons of ways of streamlining his processes, though this is one of those "constant maintanance" jobs" that the more obsessively you check things, the better you do. I'm hoping I can squeeze one free day every week or so for some projects from my old job, I think that's possible once I get the processes down.
( 12 comments — Leave a comment )