excel财务制作技巧---_进销存管理系统

1、进销存管理系统1、查看/修改期初库存2、本月出库/入库录入3、本月出库/入库汇总d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/11返回货货号号货货物物名名称称型型号号规规格格单单位位年年初初数数量量入入库库单单价价金金额额出出库库单单价价0101100101011001普通电阻1/4w 2M只300.061.800.090101100201011002普通电阻1/4w 1.2M只370.062.220.090101100301011003普通电阻1/4w 1M只1000.066.000.090101100401011004普通电阻1/4w 910K只10

2、30.066.180.090101100501011005普通电阻1/4w 800K只800.064.800.090101100601011006普通电阻1/4w 390K只2420.0614.520.090101100701011007普通电阻1/4w 270K只2830.0616.980.090101100801011008普通电阻1/4w 240K只1970.0611.820.090101100901011009普通电阻1/4w 100K只3380.0620.280.090101101001011010普通电阻1/4w 91K只3530.0621.180.0901011011010110

3、11普通电阻1/4w 47K只820.064.920.090101101201011012普通电阻1/4w 30K只290.061.740.090101101301011013普通电阻1/4w 20K只2360.0614.160.090101101401011014普通电阻1/4w 10K只230.092.070.090101101501011015普通电阻1/4w 8.2K只1000.066.000.090101101601011016普通电阻1/4w 5.1K只10420.0658.020.090101101701011017普通电阻1/4w 4.7K只2100.0612.600.0901

4、01101801011018普通电阻1/4w 3.3K只1300.067.800.090101101901011019普通电阻1/4w 2.4K只470.062.820.090101102001011020普通电阻1/4w 2.2K只930.065.580.090101102101011021普通电阻1/4w 2K只1400.068.400.09d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110101102201011022普通电阻1/4w 1.6K只5000.0525.000.080101102301011023普通电阻1/4w 1K只0.12010

5、1102401011024普通电阻1/4w 750只900.065.400.090101102501011025普通电阻1/4w 510只440.093.960.120101102601011026普通电阻1/4w 499只390.062.340.090101102701011027普通电阻1/4w 470只500.063.000.090101102801011028普通电阻1/4w 430只3370.0620.220.090101102901011029普通电阻1/4W 330只2990.0617.940.090101103001011030普通电阻1/4W 300只010110310101

6、1031普通电阻1/4W 200只1290.067.740.090101103201011032普通电阻1/4W 120只1840.0611.040.090101103301011033普通电阻1/4W 100只1060.066.360.090101103401011034普通电阻1/4W 51只1500.069.000.090101103501011035普通电阻1/4W 47只2000.0612.000.090101103601011036普通电阻1/4W 20只1250.067.500.090101103701011037普通电阻1/4W 33只1300.067.800.09010110

7、3801011038普通电阻1/4W 22只7590.0645.540.090101103901011039普通电阻1/4W 10只2350.0614.100.090101104001011040普通电阻1/4W 15只300.061.800.090101104101011041普通电阻1/4W 1.5只800.064.800.090101104201011042普通电阻1/4W 0.33只1020.066.120.090101104301011043普通电阻1/4W 250只6190.0637.140.090101104401011044普通电阻1/4W-270只620.095.580101

8、200101012001精密电阻910K 0.1%只500.7336密电阻0.1% 200只600.7343.800密电阻270K 0.1%只490.7335.770密电阻390K 0.1%只500.7336密电阻10 0.1%只500.7336.50d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1密电阻10K 0.1%只1220.760101200701012

9、007精密电阻50 0.1%只230.7316.790密电阻1K 0.1%只360.7326.280密电阻100K 0.1%只1020.7374.700密电阻91K 0.1%只500.7336.502.000101201101012011精密电阻510 0.1%只500.7336.502.000101201201012012精密电阻2K 0.1%只520.7338.200.030101201301012013精密电阻EE1/10 10R BC6只456.00270.002.7

10、70101201401012014精密电阻EE1/10 50R BC6只1385.66781.120.030101201501012015精密电阻EE1/10 510RBC6只495.00245.000密电阻EE1/10 1K BC6只614.24258密电阻EE1/10 2K BC6只454.00180.002.000101201801012018精密电阻EE1/10 10K BC6只6413.772418密电阻EE1/10 91K BC6只494.00196.000101

11、202001012020精密电阻EE1/10 100KBC6只363.77135.720.030101202101012021精密电阻EE1/10 270KBC6只494.00196.000密电阻EE1/10 390KBC6只495.50269.500密电阻EE1/10 910KBC6只487.00336.000密电阻2.2K 0.1%只100.737.300密电阻240K 0.1%只200.7314.600.7601012026010

12、12026精密电阻22 0.1%只100.737.300密电阻100 0.1%只100.737.306.030101202801012028精密电阻20K 0.1%只100.737.305.690101300101013001热敏电阻5K只5.030101300201013002热敏电阻7K只4.270101400101014001水泥电阻RX27-5W-120只480.4119.444.030101400201014002水泥电阻5W30KJM只90.211.893.800101500101015001精密电位器3006P501只31.975.914.

13、03d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110101500201015002精密电位器3006P102只201.9739.403.800101500301015003精密电位器3006P203只4.030101500401015004精密电位器67WR500只62.7416.445.530101500501015005可变电阻3323P1M只7.030101500601015006精密电位器1/2W510只16.220101500701015007精密电位器3006P103只81.9715.763.800101500801015008精密电位器

14、10K0.05%只0101500901015009精密电位器1M/0.25W T005只0.530101600101016001排阻A10K*5P只0.530101600201016002排阻A10K*9P只0.530101600301016003排阻A103J RP10K*5P只60.171.020101600401016004排阻A103G RP10K*9P只0101600501016005排阻10K*8(9)P只0.530101600601016006排阻200*9P只0.530101600701016007排阻100K*9P只90.343.060.530101600801016008排

15、阻1K*9P只30.341.020.760101600901016009排阻510*9P只60.342.040.240101601001016010排阻10K*4P只0101700101017001铂电阻PT100只5916.19955.380101800101018001碳膜电阻240K只1000.5050.000101800201018002碳膜电阻100K只1000.5050.000101800301018003碳膜电阻91K只1000.5050.000101800401018004碳膜电阻47只0101800501018005碳膜电阻510只0101800601018006碳膜电阻0.

16、33只70.503.500101800701018007碳膜电阻500只590.5029.500101800801018008碳膜电阻47只490.5024.500.710101900101019001贴片电阻6.8K只0.88d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110101900201019002贴片电阻1K只0.130101900301019003贴片电阻100K只0.120101900401019004贴片电阻3.6只0.090101900501019005贴片电阻390只0.460101900601019006贴片电阻10K只0.200

17、101900701019007贴片电阻130只0.330101900801019008贴片电阻S0805-100只0.330101900901019009贴片电阻S0805-2.2K只0.330102100101021001电解电容50V47UF只70.090.630.330102100201021002电解电容50V10UF只2380.0715.900.330102100301021003电解电容50V470UF只50.432.150.330102100401021004电解电容50V22UF只900.1715.300.330102100501021005电解电容50V1UF只90.302.

18、700.330102100601021006电解电容50V100UF只370.3011.100.330102100701021007电解电容50V330UF只40.301.200.120102100801021008电解电容50V2200UF只90.302.700102100901021009电解电容50V220UF只50.301.500102101001021010电解电容63V22UF只110.303.300102101101021011电解电容160V22UF只150.304.500.120102101201021012电解电容25V22UF只60.301.800.03010210130

19、1021013电解电容100V22UF只390.3011.700.280102101401021014电解电容50V4.7UF只270.092.430.280102101501021015电解电容150V100UF只0.580102101601021016电解电容50V2.2UF只0.530102101701021017电解电容25V22UF只0102101801021018电解电容25V10UF只200.091.800片电容105只730.3021.900片电容CT104/63只190.091.710.17d4a

20、757a880f7f3b55ec671a67d00bb0d.xls2022/1片电容CT103/63V只5880.1482.000.070102200401022004瓷片电容CBB224/63V只9260.0437.040片电容CT474/63只3160.54171.760片电容473只560.5530.800片电容222只80.554.400片电容105只1150.5563.250.03010

21、2200901022009瓷片电容CC20P只0.070102201001022010瓷片电容CC30P只5450.0421.800.060102201101022011瓷片电容104(红瓷片)只9380.0440.090102201201022012瓷片电容5P只0片电容30P只0102201401022014瓷片电容15P只8880.0435片电容20P只9200.0436.800102300101023001独石电容CKK104/63V只0102300201023002独石电容100nJ/63只180.254

22、.500102300301023003独石电容10NK/63只80.252.000.880102300401023004独石电容470nK/63只90.554.953.020102300501023005独石电容10nJ/50只260.5013.001.400102300601023006独石电容CT105/63V只1.310102300701023007独石电容CBB 100NJ50V只1000.099.005.030102400101024001起动电容450VAC-10UF只1.310102400201024002起动电容154J630V只1600.2438.801.3101025001

23、01025001贴片电容0.1UF只1.310102500201025002贴片电容1UF只1.140102500301025003贴片电容10PF只38.490102500401025004贴片电容S0805-104只1.570103100101031001普通电感2W330UH只380.6825.840103100201031002普通电感47UH只50.854.25d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110103100301031003普通电感470UH只250.102.5045.330104100101041001直插式集成电路0109

24、LUC只6.440104100201041002直插式集成电路TLP521-1只0104100301041003直插式集成电路6N137只72.9920.9328.240104100401041004直插式集成电路74HC125只101.3713.7025.670104100501041005直插式集成电路74HC245只41.285.1248.870104100601041006直插式集成电路74HC273只75.0035.0034.220104100701041007直插式集成电路74HC541只61.287.6812.250104100801041008直插式集成电路74HC573只11

25、.281.281.310104100901041009直插式集成电路74HC574只41.285.1210.290104101001041010直插式集成电路74HC595只41.114.440.030104101101041011直插式集成电路74HC922只438.46153.840104101201041012直插式集成电路74LS244只101.5415.400.880104101301041013直插式集成电路74LS393N只44.470104101401041014直插式集成电路74LS240只8.580104101501041015直插式集成电路80C196KC只645.302

26、71.8040.030104101601041016直插式集成电路PCA82C250只16.416.410104101701041017直插式集成电路AD586只6.030104101801041018直插式集成电路AD586JN只4028.211128.200104101901041019直插式集成电路AD648JN只5025.641282.000104102001041020直插式集成电路AD648KN只6348.843076.800104102101041021直插式集成电路AD694JN只234.1968.3820.540104102201041022直插式集成电路ADG508AKN只

27、312.2236.6621.400104102301041023直插式集成电路AT24C01只59.860104102401041024直插式集成电路AT29C010A只210.2620.520104102501041025直插式集成电路AT89C52只4.300104102601041026直插式集成电路ATF16V8B只6.870104102701041027直插式集成电路CD4052BCN只90.857.6553.02d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110104102801041028直插式集成电路DS1230-100Y只244.44

28、88.884.300104102901041029直插式集成电路DS1302只108.5585.500104103001041030直插式集成电路FM1808-70-P只540.00200.003.490104103101041031直插式集成电路HC273A只1.320104103201041032直插式集成电路HC373A只96.0054.000.030104103301041033直插式集成电路HM9114只0104103401041034直插式集成电路HT62WT08只0104103501041035直插式集成电路IC9362只2.170104103601041036直插式集成电路W7

29、8E516B-40只1020.51205.100.030104103701041037直插式集成电路ISPL1016E只221.3742.740.030104103801041038直插式集成电路MAX187只1059.83598.300104103901041039直插式集成电路MAX202CPE只0104104001041040直插式集成电路MAX232只74.2729.890104104101041041直插式集成电路MAX485只106.8468.400104104201041042直插式集成电路MAX543只6052.993179.560104104301041043直插式集成电路M

30、AX706只24.278.540104104401041044直插式集成电路MAX873只0104104501041045直插式集成电路MOC3083只183.4662.240104104601041046直插式集成电路OP07只601.2977.583.710104104701041047直插式集成电路SJA1000只0104104801041048直插式集成电路TLOT2CP只29.940104104901041049直插式集成电路TLP817B只0.030104105001041050直插式集成电路ULN2803只122.1425.680.030104105101041051直插式集成电

31、路WT8E516B-40只8.150104105201041052直插式集成电路AT29C011A只0104105301041053直插式集成电路BT151只0104105401041054直插式集成电路AD421BN只1.000104105501041055直插式集成电路AD704AQ只d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110104105601041056直插式集成电路AD704BQ只0104105701041057直插式集成电路74HC04只3.450104105801041058直插式集成电路74HC11只0.9201041059010

32、41059直插式集成电路74HC08只0.290104106001041060直插式集成电路74HC32只0104106101041061直插式集成电路TLP521-4只83.6829.440104106201041062直插式集成电路LM358只0.280104106301041063集成电路7289BP只98.5576.950.170104106401041064集成电路24C64只0.150104106501041065集成电路W78E58B只0.330104106601041066集成电路89C2051只0.030104106701041067集成电路82C55只1010.26102.

33、600.030104106801041068集成电路90B只0.030104106901041069集成电路24C16只103.2532.501.800104107001041070集成电路TLP521-2只92.3921.511.810104107101041071集成电路74LS125只1.830104107201041072集成电路74LS373只101.5415.401.740104107301041073集成电路MAX1243BCPA只0.760104107401041074集成电路74LS373只1.480104107501041075集成电路89C4051只48.5534.200

34、.530104107601041076集成电路MAX1241只141.0341.030.880104107701041077集成电路ISO 4-20mA只2片式集成电路DAC8512只129.9129片式集成电路MAX749只0104200301042003贴片式集成电路SED1335F只0104200401042004贴片式集成电路W24257S-70LL(62256)只18.128.120.030104200501042005贴片式集成电路LM111T-3.3只6.010104200601042006贴片式集成

35、电路74HC244只5.59d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110105100101051001二极管IN4007只6340.0425.286.350105100201051002二极管IN5819只60.130.786.010105100301051003二极管IN5822只30.260.781.310105100401051004二极管1.5KE18CA只153.8057.000.880105100501051005二极管6KE18CA只73.8026.600.030105100601051006二极管IN4148只2160.037.0

36、00.030105200101052001稳压管1/2W5.1V只40.200.800.050105200201052002稳压管P1.5KE18只0压管5v6只104.8048.000压管8v2只0105200501052005稳压管5.1V 1W只230.184.210压器3KV只0.080105300101053001发光二极管#红只0.060105300201053002发光二极管#绿只620.2314.260.710105300301053003发光二极管#白只13

37、0.232.991.280105300401053004发光二极管#黄只140.233.220.030105300501053005发光二极管L610-06V只698.72602.000.760105300601053006发光二极管&3HR红只3160.1340.440.350105300701053007发光光电二极管S1227-33BR只30.030105400101054001三极管C1384只260.5815.100.030105400201054002三极管C9013H只20.090.181.140105400301054003三极管S8550D只180.091.620.5

38、50105400401054004三极管3DG130D只0.670105400501054005三极管C32725只130.303.901.140105400601054006三极管C32740只20.501.001.640105400701054007三极管LM385-1.2V只141.7123.940.870105500101055001场效应管IRF540只42.5610.2410.680105600101056001可控硅只1.50d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110105600201056002可控硅BTA08-600C只12.

39、092.090.460105600301056003可控硅BTA16-600B只374.10151.700.030105600401056004可控硅L7805只24.809.600.030105600501056005可控硅L7824CT只60.855.108.680105600601056006可控硅IR401G只44.8019.208.450105600701056007可控硅LM2575-5.0只0105600801056008可控硅LM393只0105700101057001晶振8MHz只20.851.700105700201057002晶振12MHz只010570030105700

40、3晶振32768Hz只120.516.120105700401057004晶振11.0592Hz只50.562.800106100101061001继电器0.5A 120VAC 1A 28VDC只0106100201061002继电器0.5A 120VAC 1A 24VDC只0106100301061003继电器6VDC只0.030106100401061004继电器5VDC只1.310106100501061005继电器946H-K-24V只0106100601061006继电器946-1C-24D只2.120106100701061007继电器4100-5V只4.1301061008010

41、61008继电器946H-1C-24D只434.830106100901061009继电器946H-1C-5D只481.2861.440电器及底座24V只849.40789.604态继电器只247.0094.000.030106400101064001散热器YW20只500.3015.000106400201064002散热器YA25只850.8572.250106400301064003散热片1/2-30只0106400401064004散热器YI-25只0106500101065001逆变器PCU-554只21

42、5.3830.760106500201065002适配器只d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110107100101071001保险丝BLX520/0.1A只3780.1350.200.160107100201071002保险丝BLX520/1A只3040.012.130.040107100301071003保险丝BLX520/3A只1630.012.370.040107100401071004保险丝BLX520/10A只2410.0716.870.100107100501071005保险丝2.5A只500.105.000.130107100

43、601071006保险丝BLA5*20/0.5A只970.1514.550.180107100701071007保险丝5A只3070.0721.350险丝JK185/60V只0107200201072002自恢复保险丝JK250 800V只1661.71283.861恢复保险丝X72 X090只510.010.510.040107300101073001保险丝管250VAC 10A只1630.2642.380.290107400101074001保险丝架5*20W只3200.2683.200.03010750010

44、1075001万用表电池9V(松下)只42.008.000.030107500201075002电池3.6V只113.8542.350.030107500301075003电池1.5V,5号,南浮板57.5037.5070.970107500401075004光电池S1226-8BK只86217.2118680.000.030108100101081001弯插针IDC2*40L(双排)条480.9746.320108100201081002弯插针IDC2*30L条0.030108100301081003弯插针IDC2*10L条0108100401081004接插件1*40P条773.42263

45、.3415.410108100501081005直插针IDC40(单排)条510.8945.504.730108100601081006直插针IDC40(#长)条70.261.820108100701081007直插针IDC24条0108100801081008直插针SI15条0108100901081009插座FC-20T只2000.2550.000108101001081010接插件FC-16P只2000.1734.1949.240108101101081011插座CH2510-4P只500.147.0029.520108101201081012插座XH-8S 针只400.124.8047

46、.89d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110108101301081013插座XH-10P只10.860108101401081014插座XH-20S 针只600.3018.000108101501081015插座DC3-40S40AA只17.100108101601081016芯片插座ICS-40P只202.7454.800108101701081017芯片插座ICS-32P只0108101801081018芯片插座ICS-28P只82.0916.6950.030108101901081019芯片插座ICS-20P只181.7130.78

47、12.850108102001081020芯片插座ICS-16P只101.8018.000.030108102101081021芯片插座ICS-08P只-260108102201081022插座DC2-10L10AA只180.7313.140108102301081023插座DC2-20L20AA只31.454.350108102401081024插座DC2-20S20AA只100.505.000.070108102501081025插座DC2-34L34AA只60.855.100.160108102601081026插座DC2-34S34AA只12.912.910.2901081027010

48、81027插座DC3-26S26AA只3.830108102801081028插座DC3-26L26AA只3.830108102901081029插座DC3-40S40AA只0.230108103001081030插座DC3-10S10AA只0108103101081031插座9001-364S针 两排针,直只35.9817.944.830108103201081032插座9001-364L孔 三排孔,弯只215.56116.760108103301081033插座9001-396S针 三排针,直只116.3269.570.210108103401081034插座9001-396L孔 三排孔,

49、弯只0108103501081035插座PLCC68只11.281.280108103601081036插座PLCC44只30.852.550.260108103701081037插座4芯(白色)只0.260108103801081038插座8芯(白色)只0.260108103901081039插座20芯(白色)只9.000108104001081040插座双排插针座20P只200.6813.600.14d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110108104101081041插座双排插孔头(FC-20P)只200.8517.000.030108

50、104201081042插座DB-25孔只0.610108104301081043菲尼克斯端子MKDS1.5/2-5.08只0.120108104401081044接线端子DGB-5.0-03P 3座只380.269.880.120108104501081045接线端子DGB-5.0-02p 2座只950.1716.150108104601081046接线端子(COD)DT3.5-2只150.172.550.330108104701081047插座DB15焊线针只200.6813.600.530108104801081048插座DB15焊线孔只681.2585.041.740108104901

51、081049插座DB9孔只2.590108105001081050插座DB9针只110.738.031.000108105101081051微力开关6*6*6只1.330108105201081052复位开关6*6*L只11360.22245.280.400108105301081053跳线冒JMP-02只5420.0210.844.290108105401081054拔码开关只380.030108105501081055串口37针只60.201.2011.570108105601081056转接头SDP-UNIV-44只22接片279-402只2601

52、.11288.609轨端子排279-101只3241.61521.4019板片280-301只1390.84116.7319板249-116只1761.47258.720.030108200501082005两针接线端250-102只800.4334.4019离片2.5mm2只1620.2642.1217离片6mm2只240.6214.8819子2.5mm2

53、只931.38128.340.030108200901082009端子(weidmuller) SAK 6/EN(进口)只2982.33694.340.030108201001082010端子SAK-2.5只4020.93372.760.030108201101082011端子SAK-6只2780.73202.9421定端子只2581.24319.9238.49d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1片APSAK4-10只1000.5353.0050.0801082014

54、01082014插簧+护套6.3只17350.0586.750簧+护套4.8只47500.03142.500.030108201601082016连接器2孔(银色)套0.030108201701082017连接器3孔(银色)套1接器5.08 4T只3260.32104.30175压接头E1008只50000.02100.00106压接头QE1508/黑VE1508/红E1508只6压接头15008

55、只21针U型SV1-3只2.030108202301082023电缆旋紧件PG9只4510.52235.958缆旋紧件PG7只2320.52121缆旋紧件M-20缆螺旋接头只780.5039.008记牌66301块510.6553.256料垫7*5只0108202901082029压线头包0.030108300101083001转接头DIP44-PLC44只

56、3.080108400101084001按键+按键帽TP801B只875.030108400201084002按键冒只7500.1397.5075.240109100101091001线路板17082(光电池板)只500.9748.5075.240109100201091002线路板17083(发光二极管板)只511.3066.3075.240109100301091003线路板(17084)反馈板只690.3725.53149.610109100401091004线路板8*8(15007、电机板)只1804.26767.280.030109100501091005线路板19.8*19（149

57、99，母板）只322.4867.44120.660109100601091006线路板22.1*14.9（15003、继电器板+键盘板）只719.83138.81641.060109100701091007线路板22.1*14.92（15002，主板）只619.74118.440.030109100801091008线路板22.2*14.92（17081、AD板+LCD板）只319.8359.490.03d4a757a880f7f3b55ec671a67d00bb0d.xls2022/1/110109100901091009线路板22.67*12.75（1500，可控硅板）只717.26120

58、.820.030109101001091010线路板22.23*14.92（15001、光电板）只2319.74454.020.030109101101091011线路板16355KKG.DDB只921.90197.100.030109200101092001线路板(等比例)DBLPCB-1（152.5*127)块1211.54138.4857路板(等比例)DBLPCB-2(152.5*101.5)块0109400101094001线路板100*101(留样器板)块311.5634.680.030109500101095001停电检测板(JIANCEL)

59、100*100.3*1.6(等比例)块75.9841.861470.120109600101096001线路板15522D 200*121只94.389.030109600201096002线路板152*120块0.030109600301096003线路板20*12只0.030109600401096004线路板6.49*4.4只0109600501096005线路板15.7*13.02只0201100102011001微波炉WP702117P-6只39252.209835.9133.890201100202011002蠕动泵只0.030201100302011003滤波器20A只5233.

60、861760.720.880201100402011004滤波器15A只40.590201100502011005滤波器消噪250V2A,只0.540201100602011006电磁铁12*4只1150.6676.253.880201100702011007搅拌子B100只505.13256.5093.360201100802011008变压器电源变压器DB-050只2.030201100902011009变压器24V,R30只0.030201101002011010变压器高压变压器只48.030201101102011011变压器19V,19V,9V220V,25V,48V只48.03020110