Stained GLass Inventory

Anybody have a good system for managing their stained glass inventory? It
makes me a bit crazy, since the glass comes in sheets of so many sizes, and
each with a different color and price, then add to this the fact that the
amount consumed by a project may or may not leave usable pieces. Sometimes I
feel like the sorcerer's apprentice where the brooms turn into more broom.
Only in myu case, its sheet of invetory truning into sub-sheets of
inventory.
Every year about this time my accountant tells me to get this in order:
Anybody got it figured out?

"Plastic Sturgeon" wrote in message
ink.net...
Anybody have a good system for managing their stained glass inventory? It
makes me a bit crazy, since the glass comes in sheets of so many sizes,
and
each with a different color and price, then add to this the fact that the
amount consumed by a project may or may not leave usable pieces. Sometimes
I
feel like the sorcerer's apprentice where the brooms turn into more broom.
Only in myu case, its sheet of invetory truning into sub-sheets of
inventory.
Every year about this time my accountant tells me to get this in order:
Anybody got it figured out?

Yup, tell your accountant, "OK".

If you want to spend more time with paperwork and less time with glass work,
you can drive yourself nuts doing this. Or you can use the SWAG method.

Ok Java, i'll bite. What's SWAG ? m

"Javahut" wrote in message
...

"Plastic Sturgeon" wrote in message
ink.net...
Anybody have a good system for managing their stained glass inventory? It
makes me a bit crazy, since the glass comes in sheets of so many sizes,
and
each with a different color and price, then add to this the fact that the
amount consumed by a project may or may not leave usable pieces.
Sometimes
I
feel like the sorcerer's apprentice where the brooms turn into more
broom.
Only in myu case, its sheet of invetory truning into sub-sheets of
inventory.
Every year about this time my accountant tells me to get this in order:
Anybody got it figured out?

Yup, tell your accountant, "OK".

If you want to spend more time with paperwork and less time with glass
work,
you can drive yourself nuts doing this. Or you can use the SWAG method.

In , on Mon, 20
Mar 2006 16:04:00 GMT, michele wrote:
Ok Java, i'll bite. What's SWAG ? m

Sealed/Signed with a Guess?

"michele" wrote in message
...
Ok Java, i'll bite. What's SWAG ? m

"Javahut" wrote in message
...

"Plastic Sturgeon" wrote in message
ink.net...
Anybody have a good system for managing their stained glass inventory?
It
makes me a bit crazy, since the glass comes in sheets of so many sizes,
and
each with a different color and price, then add to this the fact that
the
amount consumed by a project may or may not leave usable pieces.
Sometimes
I
feel like the sorcerer's apprentice where the brooms turn into more
broom.
Only in myu case, its sheet of invetory truning into sub-sheets of
inventory.
Every year about this time my accountant tells me to get this in order:
Anybody got it figured out?

Yup, tell your accountant, "OK".

If you want to spend more time with paperwork and less time with glass
work,
you can drive yourself nuts doing this. Or you can use the SWAG method.


Scientific Wild Ass Guess.

And the solution to the inventory problem (if you want to be anal) is by
weight. Toss out any too small to be useful scraps and weigh each
color/texture. I wouldn't waste the time, personally. Easier to get an
accountant with a grasp of reality than it is to be fanatical about costing
every job out to the nth degree.

Scientific Wild Ass Guess.

And the solution to the inventory problem (if you want to be anal) is by
weight. Toss out any too small to be useful scraps and weigh each
color/texture. I wouldn't waste the time, personally. Easier to get an
accountant with a grasp of reality than it is to be fanatical about
costing
every job out to the nth degree.


I knew you would know that, and I posted it because I wanted someone to ask!

If you charge full sheets or 1/2 sheets off the job, then that's all you
have to count, everything else has been used on the project and therefore
does not technically "exist", if you charge off full sq ft to each job, ie 4
colors = 4 sq ft, then anything smaller does not exist, don't count it.

I buy the glass I need for each job, and write all of it off to the job, and
this roomful of glass I have left over after 28 years, doesn't exist...

That systems is so obvious, but brilliant! Thanks. Just cost the job the
same way my wholesaler makes me order: by half-sheet or whole. Thanks. Now I
just need to to one more physical inventory and switch over. And if the IRS
ever comes knocking and asks what this room full of inventory is that
"doesn't exist" I'll tell them our trash pickup doesn't accept sheet glass!
;-)

Thanks!

"Plastic Sturgeon" wrote in message
ink.net...
That systems is so obvious, but brilliant! Thanks. Just cost the job the
same way my wholesaler makes me order: by half-sheet or whole. Thanks. Now
I
just need to to one more physical inventory and switch over. And if the
IRS
ever comes knocking and asks what this room full of inventory is that
"doesn't exist" I'll tell them our trash pickup doesn't accept sheet
glass!
;-)

Thanks!

In order for the IRS to "come knocking" they must feel that they will make
$1000 per hour on the job, be it there or in an audit. I know of no single
person glass studio that can give them that kind of return on their time.
Do you think you have a worry? Nahhhh What room? It's all written off the
books, I donate it to charity every time they ask..

"Plastic Sturgeon" wrote in message
ink.net...
Anybody have a good system for managing their stained glass inventory? It
makes me a bit crazy, since the glass comes in sheets of so many sizes,
and
each with a different color and price, then add to this the fact that the
amount consumed by a project may or may not leave usable pieces. Sometimes
I
feel like the sorcerer's apprentice where the brooms turn into more broom.
Only in myu case, its sheet of invetory truning into sub-sheets of
inventory.
Every year about this time my accountant tells me to get this in order:
Anybody got it figured out?



Count all your sheets. Let's say you have about 300 ranging from full,
(8 sq ft), to 1/4, (2 sq ft) sheets. Then multiply by 4 sq ft. Now you have
1200 sq ft of glass at an average cost of $3 a sq ft. or about $3600 in
inventory. Plus or minus 20%. I guarantee that this is close enough. Why? If
you do custom work at $100 sq ft, then that same 1200 sqft inventory
potentially can be $120,000. So the difference is so great, it doesn't
really matter. Just tell your accountant to pick a number he likes.

--

JK Sinrod
www.sinrodstudios.com
www.MyConeyIslandMemories.com

better yet, tell them you donate it to any charitable entity that wants it
for mosaics, etc. so it's a tax deductible donation! m


"Plastic Sturgeon" wrote in message
ink.net...
That systems is so obvious, but brilliant! Thanks. Just cost the job the
same way my wholesaler makes me order: by half-sheet or whole. Thanks. Now
I just need to to one more physical inventory and switch over. And if the
IRS ever comes knocking and asks what this room full of inventory is that
"doesn't exist" I'll tell them our trash pickup doesn't accept sheet
glass! ;-)

Thanks!