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?

Reply to
Plastic Sturgeon
Loading thread data ...

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.

Reply to
Javahut

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

Reply to
michele

Sealed/Signed with a Guess?

Reply to
Steve Ackman

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.

Reply to
Moonraker

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...

Reply to
Javahut

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!

Reply to
Plastic Sturgeon

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..

Reply to
Javahut

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.
Reply to
Glassman

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

Reply to
michele

InspirePoint website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.