WEILL商品库存盘点表模板.xls

品名货号账面进价可用数量金额单价数量金额上衣16101059905299502156.40510782.00上衣16101265902131802372.4024744.80上衣16101376909692102768.40924915.60上衣16101569902139802516.4025032.80上衣16102879903239702876.4038629.20上衣16102975904303602732.40410929.60上衣16103372902145802624.4025248.80上衣16103667902135802444.4024888.80上衣16104361903185702228.4036685.20上衣16104455904223602012.4048049.60上衣16105472903218702624.4037873.20裙子16200429904119601076.4044305.60裙子16200927905139501004.4055022.00裙子16201029906179401076.4066458.40裙子16201549904199601796.4047185.60裙子1620202790127901004.4011004.40裙子1620263290398701184.4033553.20裙子16203227906167401004.4066026.40裙子1621014290285801544.4023088.80裤子16300229906179401076.4066458.40裤子16301032904131601184.4044737.60裤子16301129906179401076.4066458.40裤子1630122390511950860.4054302.00裤子1630142590615540932.4065594.40裤子163017239049560860.4043441.60裤子1630232990389701076.4033229.20连衣裙16500152903158701904.4035713.20连衣裙16502258904235602120.4048481.60连衣裙16502371905359502588.40512942.00连衣裙16502443906263401580.4069482.40上衣16600195902191803452.4026904.80围巾1681032790383701004.4033013.20围巾1681042890128901040.4011040.40针织开衫16900328906233401400.4068402.40针织开衫16900529906179401076.4066458.40背心1690061990611940716.4064298.40针织开衫1690173390267801220.4022440.80针织开衫16902233903101701220.4033661.20针织开衫16902438907272301400.4079802.80针织开衫16902749906299401796.40610778.40针织开衫16903435904143601292.4045169.60针织开衫16903548906293401760.40610562.40Wde weill裤子36301027905139501004.4055022.00Wde weill裤子363012239024780860.4021720.80合计总金额 181790390181284540.40使用说明：需人工输入“货号”、“颜色”、“单价”，单价为0也要输入0，不可让表格为空，在尺码的相应类别下输入库存货物相应的件数销售数量销售金额差异数量差异金额5 8985.000 1797.002 3954.000 790.809 20763.000 4152.602 4194.000 838.803 7191.000 1438.204 9108.000 1821.602 4374.000 874.802 4074.000 814.803 5571.000 1114.204 6708.000 1341.603 6561.000 1312.204 3588.000 717.605 4185.000 837.006 5382.000 1076.404 5988.000 1197.601 837.000 167.403 2961.000 592.206 5022.000 1004.402 2574.000 514.806 5382.000 1076.404 3948.000 789.606 5382.000 1076.405 3585.000 717.006 4662.000 932.404 2868.000 573.603 2691.000 538.203 4761.000 952.204 7068.000 1413.605 10785.000 2157.006 7902.000 1580.402 5754.000 1150.803 2511.000 502.201 867.000 173.406 7002.000 1400.406 5382.000 1076.406 3582.000 716.402 2034.000 406.803 3051.000 610.207 8169.000 1633.806 8982.000 1796.404 4308.000 861.606 8802.000 1760.405 4185.000 837.002 1434.000 286.80上期合计上期总金额差异总数差异总金额181 237117.000 47423.40