问题描述
亲爱的先生们/妈妈们,
我正在尝试进行先前的股票估值,但不了解如何做。
数据输入表:
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
推荐答案
这篇关于先进先出存货估价的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!