物料管理大全(請下載為EXCEL函數(shù)公式直接套用)

1、序號部品番號部品名稱部品用量部品單價（美元）上月庫存數(shù)庫存金額1801144400021片狀電阻50.00002802140200021片狀陶瓷電容10.00003802308100071片狀鉭電容20.12004803143000041疊層電感30.58005803340200011磁珠50.15006805000000551藍牙芯片20.85007805110000111基帶芯片30.12008805210000061收發(fā)芯片60.16009805310000121射頻功放20.420010806410000241NOR+(p)SRAM10.580011807300000171LED區(qū)動4

2、0.560012807600000211音頻功放51.000013808000000191濾波器類10.850014811000000011EM濾波器50.140015811110000023壓敏電阻30.160016811210000081TVS!10.160017812100000042肖特基二極管10.140018812200000021數(shù)字晶體管10.260019812220000024場效應三極管50.430020812300000042發(fā)光二極管30.130021812320000021晶體三極管10.530022813000000031射頻同軸開關20.1200238130000

3、00031射頻同軸開關10.120024813300000011卡座連接器10.250025813500000053數(shù)據(jù)連接器10.420026813600000252電池連接器10.260027814000000061低頻晶體類10.130028814100000121高頻晶體類20.120029815000002061屏蔽罩支架10.120030815300001191屏蔽蓋10.520031818400006371六層普通板120.3500八月565機種盤點總報表本月入庫數(shù)入庫金額本月出庫數(shù)出庫金額本月償卻數(shù)償卻金額個別制番數(shù)175200350.431000622530.50603912

4、3117.369007612.2839729438971.9890051663.4680567750329862.7500752436.912527702040444.9200970141.6207223061467.7300337286.787011864314593.0890075192.373021055333267.37400927146.4661212166351220.12300315132.615010611061543.800608352.642414247080068.1400859482.7580178760179296.2800377378.131019152316279

5、4.550014541235.9017724024778.1520018926.4222111474018014.180015223.864010141316023.25400785124.0329670013151.20016222.032012870333205.374009925.54201825007774500273116.29809632612329.7280000011083658299.73600456239.856015005418456.6420000012028414855.0740000010735327160.3090000010825845793.134000002

6、97537587.015000001150001437500526.50555006854.250000012896015862.0800000200400104809.2000001035602107653.1200000制番金額理論仕掛數(shù)理論金額實際在庫數(shù)實際金額盤點差異數(shù)差異金額0143947287.894900.18197.8940.3957880.02738353115.05900115.0590.3451770724278908.521008908.5211095.7482.905566993329422.93300329422.933191394.7027605040303.30

7、040303.35884.28207189361180.9430061180.94352064.98011789214500.7160014500.7161783.5881.89620961433119.0120033119.0125232.804012134851087.5080051087.50821507.8413.9210547861177.240061177.2435482.8014161179585.3820079585.38244726.980178383178918149179454.90190069161558.6500161558.65137324

8、.90.139817705024751.590024751.593460.272011458817990.3160017990.3162824.480.31610062615898.9080015898.9082512.02709653813129.1680013129.1681785.567012860433179.8320033179.8328560.397018222777628.7020077628.70233069.8309632612329.7280012329.7281578.205011038058059.880058059.8830539.5015005418456.6420018456.6422270.167012028414855.0740014855.0741834.602010735327160.3090027160.3096871.558010825845793.1340045793.13419370.50297537587.015007587.0151934.689011494814368.50014368.51796.0630555006854.