先进先出存货估价 [英] FIFO Stock Valuation

问题描述

亲爱的先生们/妈妈们，

我正在尝试进行先前的股票估值，但不了解如何做。



数据输入表：

DocNo日期InnQty InnRate OutQty OutRate

1 12/02 12 12.50

2 12/03 13？

20 12/04 50 10.20

10 12/10 100 11.25

11 12/25 25？

14 12/29 150？





我们需要根据FIFO方法填充数据如下：



for 1st OutQty（13 Pcs）= 12 Pcs @ 12.50 + 1Pcs * 10.20 = 160.20 / 13 = 13封电子邮件@删除



for 2nd OutQty（25 Pcs） ）= 25 Pcs @ 10.20（因为第二InnQty仍然有足够的左（50-1-25）= 24Pcs为下一个outqty）



for 3rd OutQty（150 Pcs） = 24 Pcs @ 10.20 + 100Pcs * 11.25 + 26 Pcs * 11.25（来自Last InnQty，因为没有更多InnQty了）电子邮件@删除





CTE&的数据输出查询运行总方法：



DocNo Date InnQty InnRate OutQty OutRate

1 12/02 12 12.50

2 12/03 13 12.32

20 12/04 50 10.20

10 12 / 10 100 11.25

11 12/25 25 10.20

14 12/29 150 11.08







请帮助我。



问候 -

Sanjeeb

Dear Sirs/Mams,
I am trying for FIFO Stock Valuation as follows, but not understanding how to do.

Data Input Table:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 ?
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 ?
14 12/29 150 ?


We need to populate the data according to FIFO method as following:

for 1st OutQty(13 Pcs)=12 Pcs @12.50+1Pcs*10.20=160.20/13=13 email@removed

for 2nd OutQty(25 Pcs)=25 Pcs @ 10.20 (Because 2nd InnQty has still sufficient Left(50-1-25)=24Pcs for next outqty)

for 3rd OutQty(150 Pcs)=24 Pcs @10.20+100Pcs*11.25+26 Pcs*11.25 (From Last InnQty as there is no more InnQty left) email@removed


Data Output Query by CTE & Running Total Approach:

DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 12.32
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 10.20
14 12/29 150 11.08



Kindly help me out.

Regards-
Sanjeeb

推荐答案

这篇关于先进先出存货估价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！