财会玩转Excel第7期-正式课03-5简易材料核算表.xlsx

文档说明：1、本文档为ExcelHome在线培训中心培训课程专用课件，版权归ExcelHome所有；2、本文档仅作为学员学习课程之用途，不得用于转让、出售、商业培训等任何营利性质的用途；也不得发布到互联网上(包括但不限于网站、论坛、微博、博客、网盘）提供收费下载；3、本文档中的单位名称或相关数据均为虚拟的信息，如有雷同，实属巧合；4、门 户：http:/ 技术论坛：http:/ 培训中心：http:/5、ExcelHome在线培训课程报名咨询QQ：4000049448财会玩转Excel第7期培训中心课程官方微信:iexcelhome财会玩转Excel第7期官方微信:iexcelhome合计363218.27704352.54729946.51号码货物名称12月余额收料发料数量金额数量金额数量1减水剂（粉）53.3135 188,248.36 131.7570 614,719.26 136.74802减水剂（液）3氨基磺酸12.318030,171.4511.940032,238.0013.33704纤维素239.97001,051.725硅酸钠0.1130429.406红糖1.13152,069.747矾石粉(生熟料)74.950018,063.9760.000016,685.2870.80008石膏粉29.940012,052.0729.94009编织袋6,347.00007,933.75140.000010辅料0.0000-1,331.7011引气剂0.56624,916.6312糊精2.9670-15,523.79-0.232022,635.0013葡钠付产物（废盐）23.44903,296.1129.50007,375.0024.664014糖钙4.577012,586.7515硫酸钠1.00001,100.0016汽油1,126.64506,687.4917三乙醇胺2.048515,212.370.808018配件0.000090.0019柠檬酸2.538011,964.8520早强剂24.790014,874.002.330021亚钠0.73601,434.365.000010,700.005.642022粉煤灰21.68302,528.3023亚硝酸钙24.160045,362.442.220024柴油0.00000.00合计30,171.45704352.54337624.3269954450858.511月结余收料发料金额数量金额数量金额数量金额636,548.1748.3225 166,419.45 50.0000 232,000.0088.7200 375,738.6636,546.7110.921025,862.747.300021,710.0014.920039,862.74239.97001,051.720.1130429.401.13152,069.7415,881.8664.150018,867.3915.00004,411.6512,052.070.00000.00 62.000016,244.0038.00009,956.00175.00 6,207.00007,758.750.0000-1,331.700.56624,916.630.16001,389.372.73507,111.211.31003,406.005,066.4828.28505,604.6318.10003,586.524.577012,586.751.00001,100.001,126.64506,687.49545.00003,237.306,000.291.24059,212.080.14001,039.650.000090.0090.002.538011,964.851,398.0022.460013,476.0012,092.360.094042.0021.68302,528.3015.67001,827.124,185.5721.940041,176.870.00000.001,830.00006,313.50729946.51337,624.30269954450858.51729946.51发料156719.792月结余数量金额9.602522,680.793.30107,710.00239.97001,051.720.1130429.401.13152,069.7449.150014,455.7424.00006,288.006,207.00007,758.750.0000-1,331.700.40623,527.261.42503,705.2110.18502,018.114.577012,586.751.00001,100.00581.64503,450.191.10058,172.430.00000.002.538011,964.8522.460013,476.000.094042.006.0130701.1821.940041,176.87-1,830.0000-6,313.50156,719.79