Inventory

[John Ross]

Since it is just for inventory purposes, why not just leave it as weight, either grams or ounces?
If it is a charge to customers, then just subtract the present weight, from the previous weight, and multiply, by your purchase price, times your mark-up.
It will be close enough, even if it won't tell you the exact inches used, or left.
John M. Ross
Windsor, Nova Scotia, Canada.
jrpiano at win.eastlink.ca
  ----- Original Message ----- 
  From: Joseph Garrett 
  To: pianotech 
  Sent: Wednesday, May 31, 2006 11:50 PM
  Subject: Re: Inventory



  Daniel asked: "hi list 
  i'm wanting to start keeping track of my inventory for tax purposes. the 
  only hangup i'm having though is how to keep track of stuff like piano wire. 
  how do i know exactly how much i have now and how in the heck do i keep 
  track of what i use? do i have to measure each piece of wire i cut and write 
  it down along with the size of wire every single time i change a string? and 
  what about glue and other supplies like that?"

  Daniel,
  There is a fairly simple way to figure how much wire you have left in a "roll". There is/was a chart in APSCO that said how many feet were in a 1 Pound Roll. When you get a new roll, weigh it....do the math. After each use, weigh it. If you use the canisters, as I do, you have to Tare the cannister weight. I use an olde postal scale, adjustable. However you could use one of them new fangled electronic scales that will allow you to Tare the "Brake" or the Cannister or whatever. K?


  Joe Garrett, R.P.T. (Oregon)
  Captain, Tool Police
  Squares R I


-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/20060601/96536486/attachment.html