# FIFO Cost method in E10

There is a weighted FIFO average, I believe it uses this.

KenÂ Williams
Intermountain ElectronicsÂ - Power, Automation, and Process Systems
Office:Â 435-613-4817Â |Â Â Mobile:Â 801-918-7318
kwilliams@...www.ie-corp.com

On Wed, Jun 8, 2016 at 10:57 AM, ckrusen1@... [vantage] wrote:
Â
``````<div>

<p>I see that FIFO was introduce in E9. Â </p><div><br></div><div>So what cost is used when <b>estimating </b>a job?</div><div><br></div><div>For example, I received 100 pc&#39;s at \$1.00 each (call this lot 1), and then another 100 pc&#39;s at \$1.50 each (lot 2).</div><div><br></div><div>Would the cost used be \$1.00 or \$1.50? Or even \$1.25? Â </div><div><br></div><div>Does it matter on how many I need for a job? Â </div><div><br></div><div>If the estimate required 50, it would use 50 from lot 1, at \$1.00 each?</div><div><br></div><div>If theÂ estimateÂ required 150, would it use 100 from lot 1 at \$1.00, Â and 50 from lot 2 at \$1.50?</div><div>Â </div><div>We&#39;re still on V8, so I can&#39;t even look in the help.</div><p></p>

</div><span class="ygrps-yiv-1388174188">

<div style="color:#fff;min-height:0;"></div>
``````

We're currently on V8, and and will be changing to E10 in a few months (not a migration, but rather a fresh install).

Someone asked if E10 has the ability to use a FIFO cost method.  I'm guessing that this method would track quantities for specific costs.  Kind of like how Lot serializing does.

I ran a quick Excel simulation to see if there's much of a difference between FIFO and AVG, And there is.

Calvin

I see that FIFO was introduce in E9.

So what cost is used when estimating a job?

For example, I received 100 pc's at \$1.00 each (call this lot 1), and then another 100 pc's at \$1.50 each (lot 2).

Would the cost used be \$1.00 or \$1.50? Or even \$1.25?

Does it matter on how many I need for a job?

If the estimate required 50, it would use 50 from lot 1, at \$1.00 each?

If the estimate required 150, would it use 100 from lot 1 at \$1.00,  and 50 from lot 2 at \$1.50?

We're still on V8, so I can't even look in the help.