库存分析表

库存分析表,数据输入表,商品名称月初库存量进货量销售数量月末库存量进价售价月初金额进货金额销售金额月末金额,A611.0522.0862.0271.0375.01875.0229125.0195750.01616250.0101625.0,B899.0531.0409.01021.03184.0357802.0211338.01302256.0406358.0,C860.0695.0394.01161.03582.0342280.0276610.01411308.0462078.0,D936.0894.0699.01131.0372528.0355812.01391010.0450138.0,E561.0933.0648.0846.02990.0335478.0557934.01937520.0505908.0,F666.0901.0866.02240.0298368.0403648.01570240.0387968.0,G842.0641.0428.01055.0596.0250916.0191018.0255088.0314390.0,H556.0779.0345.0990.01788.0165688.0232142.0616860.0295020.0,I846.0700.0816.0730.0252108.0208600.0243168.0217540.0,J721.0512.0991.0242.0286958.0203776.01972090.096316.0,K972.0831.0445.01358.01592.0386856.0330738.0708440.0540484.0,L554.0993.0404.01143.03582.0220492.0395214.01447128.0454914.0,M542.0837.0745.0634.03184.0215716.0333126.02372080.0252332.0,N931.0687.0861.0757.0370538.0273426.01713390.0301286.0,O579.0638.0513.0704.04032.0259392.0285824.02068416.0315392.0,P945.0573.0817.04928.0423360.0256704.04026176.0314048.0,Q524.0397.0828.03588.0313352.0419198.01424436.0495144.0,X681.0592.0518.0755.04186.0407238.0354016.02168348.0451490.0,Y810.0638.0301.01147.0548.04384.0443880.0349624.01319584.0628556.0,Z576.0839.0427.0988.0548.06028.0315648.0459772.02573956.0541424.0,商品名称 月初库存量 进货量 销售数量 月末库存量,A611.0522.0862.0271.0,B899.0531.0409.01021.0,C860.0695.0394.01161.0,D936.0894.0699.01131.0,E561.0933.0648.0846.0,F666.0901.0866.0,G842.0641.0428.01055.0,H556.0779.0345.0990.0,I846.0700.0816.0730.0,J721.0512.0991.0242.0,K972.0831.0445.01358.0,L554.0993.0404.01143.0,M542.0837.0745.0634.0,N931.0687.0861.0757.0,O579.0638.0513.0704.0,P945.0573.0817.0,Q524.0397.0828.0,X681.0592.0518.0755.0,Y810.0638.0301.01147.0,Z576.0839.0427.0988.0,总计14612.014437.011721.017328.0,商品名称 进价 售价,A375.01875.0,B3184.0,C3582.0,D,E2990.0,F2240.0,G596.0,H1788.0,I,J,K1592.0,L3582.0,M3184.0,N,O4032.0,P4928.0,Q3588.0,X4186.0,Y548.04384.0,Z548.06028.0,总计8687.058027.0,商品名称 月初金额 进货金额 月末金额,A229125.0195750.0101625.0,B357802.0211338.0406358.0,C342280.0276610.0462078.0,D372528.0355812.0450138.0,E335478.0557934.0505908.0,F298368.0403648.0387968.0,G250916.0191018.0314390.0,H165688.0232142.0295020.0,I252108.0208600.0217540.0,J286958.0203776.096316.0,K386856.0330738.0540484.0,L220492.0395214.0454914.0,M215716.0333126.0252332.0,N370538.0273426.0301286.0,O259392.0285824.0315392.0,P423360.0256704.0314048.0,Q313352.0419198.0495144.0,X407238.0354016.0451490.0,Y443880.0349624.0628556.0,Z315648.0459772.0541424.0,总计6247723.06294270.07532411.0,商品名称 销售数量 销售金额,A862.01616250.0,B409.01302256.0,C394.01411308.0,D699.01391010.0,E648.01937520.0,F701.01570240.0,G428.0255088.0,H345.0616860.0,I816.0243168.0,J991.01972090.0,K445.0708440.0,L404.01447128.0,M745.02372080.0,N861.01713390.0,O513.02068416.0,P817.04026176.0,Q397.01424436.0,X518.02168348.0,Y301.01319584.0,Z427.02573956.0,总计11721.032137744.0,商品名称 销售数量,A0.0735432130364,B0.0348946335637,C0.0336148792765,D0.0596365497824,E0.055285385206,F0.0598071836874,G0.0365156556608,H0.0294343486051,I0.0696186332224,J0.0845490999062,K0.0379660438529,L0.0344680488013,M0.0635611295965,N0.073457896084,O0.0437675966214,P0.0697039501749,Q0.0338708301339,X0.0441941813838,Y0.025680402696,Z0.0364303387083,总计1.0,商品名称 销售金额,A0.0502913334551,B0.040521077024,C0.0439143456989,D0.0432827518945,E0.0602879903456,F0.0488596834924,G0.00793733374689,H0.0191942533365,I0.00756643030077,J0.0613636725714,K0.0220438621952,L0.0450289230009,M0.0738097857771,N0.0533139476125,O0.0643609582552,P0.125278737674,Q0.0443228373466,X0.0674704484546,Y0.0410602561275,Z0.0800913716906,总计1.0,商品名称 月初库存量 月末库存量,A0.04181494661920.0156394275162,B0.06152477415820.0589219759926,C0.05885573501230.0670013850416,D0.06405693950180.0652700831025,E0.03839310156040.0488227146814,F0.0455789761840.0499769159741,G0.05762387079110.0608841181902,H0.03805091705450.0571329639889,I0.05789761839580.0421283471837,J0.04934300574870.0139658356417,K0.06652066794420.0783702677747,L0.03791404325210.0659626038781,M0.0370928004380.0365881809788,N0.06371475499590.0436865189289,O0.03962496578150.0406278855032,P0.06467287161240.0404547553093,Q0.03586093621680.047783933518,X0.04660552970160.0435710987996,Y0.05543388995350.0661934441367,Z0.0394196550780.0570175438596,总计1.01.0,商品名称 月末金额,A0.0134916960851,B0.0539479324747,C0.0613452983381,D0.0597601485102,E0.0671641523544,F0.0515064831168,G0.0417382960117,H0.039166742229,I0.0288805270982,J0.012786875278,K0.0717544488743,L0.0603942084414,M0.0334994996954,N0.0399986139896,O0.041871321148,P0.0416928922227,Q0.0657351278362,X0.0599396395125,Y0.0834468538692,Z0.0718792429144,总计1.0