RE: [U2] Moving Average Cost

2007-08-29 Thread Brutzman, Bill
PROTECTED] Behalf Of Kate Stanton Sent: Tuesday, August 28, 2007 9:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Moving Average Cost Average cost is fraught. I don't think there is a way around the scenario: - 100 in stock @ $5 each average cost (value $500) - adjust all of them out

RE: [U2] Moving Average Cost

2007-08-29 Thread Baker Hughes
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Tuesday, August 28, 2007 4:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Moving Average Cost Don't use absolute value, or you'll screw up your average costs. When you're adjusting inventory out, you're

[U2] Moving Average Cost

2007-08-28 Thread Baker Hughes
Hey, I have a distribution/manufacturing question. Could some of you share your formula for calculating Moving Average Cost. Consider: Assume you are receiving stock into the warehouse, and recalculating your new average cost upon each receipt (which later serves as basis for your cost-plus

RE: [U2] Moving Average Cost

2007-08-28 Thread Brutzman, Bill
to a little database. I guess that we could talk about it... --Bill 973.471.7770 x145 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baker Hughes Sent: Tuesday, August 28, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Moving Average Cost Hey, I

RE: [U2] Moving Average Cost

2007-08-28 Thread Larry Hiscock
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, August 28, 2007 11:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Moving Average Cost Hey, I have a distribution/manufacturing question. Could some of you share your formula for calculating Moving

Re: [U2] Moving Average Cost

2007-08-28 Thread MAJ Programming
@listserver.u2ug.org Sent: Tuesday, August 28, 2007 9:55 PM Subject: Re: [U2] Moving Average Cost Average cost is fraught. I don't think there is a way around the scenario: - 100 in stock @ $5 each average cost (value $500) - adjust all of them out (no effect on average cost) - receive 1 at $10, so