[求助]如何计算每日平均成本

luo_by

<p>选择任一日期，即生成本日的库存数量和库存成本，一直想不到最佳的解决方法。请各位高手帮忙想想。</p><p>&nbsp;&nbsp;&nbsp; </p><br/> 0rWgZFYo.rar (32.94 KB, 下载次数: 27)

2008-3-14 12:42 上传

点击文件名下载附件
[求助]如何计算每日平均成本

<br/>

[此贴子已经被作者于2008-3-14 12:42:57编辑过]

kowloon

AfOFfP0G.rar (34.25 KB, 下载次数: 39)

2008-3-14 13:45 上传

点击文件名下载附件
[求助]如何计算每日平均成本

<br/>

xrczld

得到这种结果很危险.我觉的这个数据没有多大意思

luo_by

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>kowloon</i>在2008-3-14 13:46:04的发言：</b><br/><br/></div><p>谢谢<strong>kowloon</strong>，你这数量是对的，但是金额不对。本日的成本应该这样理解：(上日库存数量+本日购进数量-本日销售数量)*(上日库存金额+本日购进金额)/(上日库存数量+本日购进数量)。但这公式怎么编我就觉得难度在这。因为每日每种品种的购进和销售都很多，每天的价格变化大，所以每天的成本价就是销售的参考。</p>

[此贴子已经被作者于2008-3-14 17:34:15编辑过]

xrczld

<p>也不知道我这个是否可以。</p><p><a href="http://club.excelhome.net/viewthread.php?tid=229259&amp;px=0">http://club.excelhome.net/viewthread.php?tid=229259&amp;px=0</a></p><p>出库就是销售价格与移动加权价两种。出库的单价为销售价。移动加权价无需输入的。</p><p></p>

kowloon

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">我楼上的解答</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">只是客观性用</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">Excel</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">计算结果</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">而楼主要的结果是有主观性、策略性的需要</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">再细看各表</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">发觉铜出表有多行是<span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">没有重量但有</span>负金额</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">成因可能是磅差</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">汇率</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">存货减值</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">提成</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">利润</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">或其它</span><span lang="ZH-CN" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">
                        </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN;">则不得而知</span></p><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">由于存货金额有机会出现负值</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">, </span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">本人技浅</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">, </span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">应无能为力</span>

luo_by

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>kowloon</i>在2008-3-14 22:05:08的发言：</b><br/><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">我楼上的解答</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">只是客观性用</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">Excel</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">计算结果</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">而楼主要的结果是有主观性、策略性的需要</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">再细看各表</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">发觉铜出表有多行是<span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">没有重量但有</span>负金额</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">, </font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">成因可能是磅差</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">汇率</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">存货减值</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">提成</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">利润</span><span lang="EN-US" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman">/</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">或其它</span><span lang="ZH-CN" style="mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun;"><font face="Times New Roman"><br/>&nbsp;&nbsp;&nbsp;</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-hansi-font-family: &quot;Times New Roman&quot;;">则不得而知</span></p><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">由于存货金额有机会出现负值</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">, </span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">本人技浅</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-fareast-font-family: SimSun; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">, </span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-fareast-language: ZH-CN; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">应无能为力</span></div><p><strong><em>kowloon兄，铜出的负金额与成本价没有关系，只是销售额的抵减。而上日的库存金额和本日的购进金额才是形成成本的关键。</em></strong></p>