1、U.Ling 2022/2/11頁次： 1/5存存貨貨發發出出計計價價測測試試（加加權權平平均均法法計計價價）客戶單位：ABC公司編制：存貨明細：產品A復核：序號日期本期入庫本期出庫期末應存實際結存數量單價金額數量單價金額數量單價金額金額上上期期結結存存2526.11652.6411432.64457.00-3928.451,109.642-3528.45995.83428.45113.8132627.39712.03-3027.53825.844-3027.53825.840-55027.781,389.00-5027.781,389.006-4027.781,111.201027.7827

2、7.80-合合計計9028.422,558.0310527.932,932.871027.78277.80U.Ling 2022/2/11頁次： 2/5單位：元備注差異652.641,109.64113.81825.84-1,389.00277.80-277.80存存貨貨發發出出計計價價測測試試（加加權權平平均均法法計計價價）實際結存11:57 2022/2/11存存貨貨發發出出計計價價測測試試（計計劃劃成成本本法法計計價價）2005年12月客戶單位：ABC公司編制：存貨明細：產品A復核：單位：元月份本期入庫本期出庫期末結存比較數量計劃單價計劃成本實際成本成本差異 數量計劃單價計劃成本成本差異

3、 數量計劃單價計劃成本成本差異實際成本差異率賬面結存差異期期初初結結存存1009.98998.0026.001,024.002.61%1,000.0024.001359.98349.30340.00-9.30509.98499.006.19859.98848.3010.51858.811.24%858.8129.98-9.98-859.98848.3010.51858.811.24%858.8139.98-9.98-859.98848.3010.51858.811.24%858.8149.98-9.98-859.98848.3010.51858.811.24%858.815409.98399.

4、20415.0015.809.98-1259.981,247.5026.311,273.812.11%1,273.8169.98-9.98-1259.981,247.5026.311,273.812.11%1,273.817259.98249.50280.0030.509.98-1509.981,497.0056.811,553.813.79%1,553.8189.98-9.98-1509.981,497.0056.811,553.813.79%1,553.819509.98499.00560.0061.009.98-2009.981,996.00117.812,113.815.90%2,11

5、3.81109.98-9.98-2009.981,996.00117.812,113.815.90%2,113.8111609.98598.80580.00-18.809.98-2609.982,594.8099.012,693.813.82%2,693.81129.98-9.98-2609.982,594.8099.012,693.813.82%2,693.81合合計計 2109.982,095.802,175.0079.20509.98499.006.192609.982,594.8099.012,693.813.82%-2,693.812022/2/11 MS U.Ling存存貨貨發發出

6、出計計價價測測試試（先先進進先先出出法法計計價價）客戶單位：ABC公司編制：U.Ling存貨明細：產品A復核：單位：元序號日期本期入庫本期出庫期末結存備注數量單價金額數量平均單價金額數量平均單價金額上上期期結結存存4000567.362,269,432.13備備注注：本表只考慮期初結存中批次在3批及以下，如果在3批以上，只需在第11行處插入，并更新第M列至第Z列的相應公式。1000580.10580,098.462000560.171,120,333.671000569.00569,000.0011月1日2000579.301,158,603.572500568.141,420,348.713500573.622,007,686.9921月1日1000578.80578,800.003000572.681,718,036.101500578.97868,450.8931月2日2500590.201,475,504.382000581.781,163,551.772000590.201,180,403.50-2022/2/11 MS U.Ling存存貨貨發發出出計計價價測測試試（先先進進先先出出法法計計價價）客戶單位：ABC公司編制：U.Ling存貨明細：產品A復核：單位：元序號日期本期入庫本期出庫期末結存備注數量單價金額數量平均單價金額數量平