您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 信息化管理 > Mmult物料需求计算
用MMULT计算物料需求,你真的理解了吗?MMULT(ARRAY1,ARRAY2)--矩阵乘积函数②MPSArray2日期成品料号1月11日1月12日1月13日1月14日A1100010005001000B2100010005001000C3100010005001000①BOMArray1成品料号配比原料A1B2C3转换区M00110310M00230110001000M003002M004524M005111③MRP结果区域=MMULT($B10:$D10,D$4:D$6)=SUMPRODUCT($B10:$D10,TRANSPOSE(D$4:D$6))-数组公式物料需求下列高亮结果为两数组数据乘积的和--{1,0,3}*{1000;1000;1000}高亮结果右拖下拉可得出全部结果;结果区域为:ARRAY1的行数,ARRAY2的列数--“去同存异”MMULT($BOM,M$PS)日期原料1月11日1月12日1月13日1月14日注:调换数组1,2的位置无法正确计算M0014000M002M003M004M005【Array1的列数必须=Array2的行数】1月15日1月16日1000500100050010005003转置-TRANSPOSE1000=MMULT($B10:$D10,D$4:D$6)=SUMPRODUCT($B10:$D10,TRANSPOSE(D$4:D$6))-数组公式下列高亮结果为两数组数据乘积的和--{1,0,3}*{1000;1000;1000}高亮结果右拖下拉可得出全部结果;结果区域为:ARRAY1的行数,ARRAY2的列数--“去同存异”1月15日1月16日成品PNPART|DESCRIPTION11-Jan12-Jan13-Jan14-JanECT147970PW088ASSY,BULKPACKOUTVIP211K504073925600ECT157474PW202ASSY,BULKPACKOUTVIP222(DN21392672336114ECT158031PW254ASSY,BULKPACKOUTVIP722DVR0000ECT158904PW103FG,DTVPALDVRSTANDALONEREC0000ECT158904PW507FG,DTVPALDVRSTANDALONEREC0000ECT158904PW517FG,DTVPALDVRSTANDALONEREC0000ECT160189PW342ASSY,BULKRECEIVERVIP222K126721267203000ECT160259PW617ASSY,BULKPACKOUTVIP722KDVR68741248010000ECT162010PW538ASSY,BULKPACKOUTVIP211,E0/0000ECT162088PW120ASSY,BULKRECEIVER,VIP612DV1968576115211800ECT162088PW133ASSY,BULKRECEIVER,VIP612DV0000ECT162838PW350ASSY,BULKRECEIVERVIP922DVR0001060ECT162838PW406ASSY,BULKRECEIVERVIP922DVR0000ECT162838PW406-AASSY,BULKRECEIVERVIP922DVR0000ECT162838PW406-BASSY,BULKRECEIVERVIP922DVR0000ECT163544PW431ASSY,BULKRECEIVERDISHDVR620000ECT163544PW434ASSY,BULKRECEIVERDISHDVR620000ECT164355PW062ASSY,BULKPACKOUTEXPRESSVU64964256414412600ECT164502PW128ASSY,BULKRECEIVER,EXPRESSV97441017614880ECT164502PW340ASSY,BULKRECEIVER,EXPRESSV0000ECT167876PW072ASSY,BULKPACKOUTTELUS6131224000ECT167901PW289ASSY,BULKRECEIVER,TELUS92414433648015-Jan16-Jan17-Jan18-Jan19-Jan20-Jan21-Jan22-Jan23-Jan24-Jan49001260050000116006800005200000000000000000000001350000000000000000000000000000000000001930025500001000001850021000210002970011300980035300353000000000000160001600800080002400400080008000440000000000002060206017602060206020601800206020602060000000000000000000000000000000000000000000000000007700008900138005200480096009600440011000126008000056004000003600000000000000103003700000000004000000000025-Jan26-Jan27-Jan28-Jan29-Jan30-Jan31-Jan8000000900090000000000000000000000000000000000000006200286000019400308000244001720045800458002640088004580000000001200260000004000000000018002060206020602060180021000000000000000000000000000000000000016001080010800108001800080006400340060004800001000000000000000240088000000000ECT147970PW088ECT157474PW202ECT158031PW254原料PNPART|DESCRIPTIONDP311VIP211KVIP211KECT142521COVER,TOP,VIP612DVR000ECT143349CABLE,POWERCORD,ROUND,3CO000ECT144332TOPCOVER,VIP211K011ECT144335-MCABLE,POWERCORD,3COND.,7011ECT147358COVERTOPEXPRESSVU9242000ECT152858FRAME,FPBMOUNT,VIP612DVR000ECT153501BRACKETHARDDRIVEVIP722KDVR000ECT155462FRAMEFRONTPANELBOARD722KD000ECT155658BRACKET,HARDDRIVE,VIP612DV000ECT156117ASSY,BEZEL,VIP211K011ECT157795ASSY,BEZEL,VIP612DVR000ECT160046ASSY,CABLE3CONDPWRCORD7000ECT160314COVER,TOP,VIP222K000ECT161524ASSY,ART/CHASSIS,VIP612DVR000ECT161792ASSY,ART/CHASSIS,VIP211K011ECT163012ASSY,ART/CHASSIS,VIP722KDVR000ECT164255ASSY,ART/CHASSIS,9241EXVU000ECT164268ASSY,ART/CHASSIS,EXPRESSVU000ECT164398ASSY,BEZEL,EXPRESSVU6131000ECT164459ASSY,BEZEL,VIP722KDVR000ECT164461ASSY,BEZEL,VIP222K000ECT164651ASSY,BEZEL,EXPRESSVU9241000ECT166422ASSY,ART/CHASSIS,VIP922DVR000ECT167307ASSY,BEZEL,VIP922DVR000ECT167886ASSY,BEZEL,TELUS6131000ECT167903ASSY,BEZEL,TELUS9241000ECT158904PW103ECT158904PW507ECT158904PW517ECT160189PW342ECT160259PW617ECT162010PW538ECT162088PW120ECT162088PW133ECT162838PW350VIP222VIP722TR-50TR-50TR-50VIP222KVIP722KVIP211VIP612000000001000000001000000000000000000010000100000000001000000100000001100000000001000000000000000001000001100000001000000000001000000000000001100000000000000000000000000000000000100000001000000000000000000000000000000000000000000000000ECT162838PW406ECT162838PW406-AECT162838PW406-BECT163544PW431ECT163544PW434ECT164355PW062ECT164355PW574ECT164490PW891ECT164502PW128VIP612VIP922VIP922VIP922VIP922DP625DP625EV6131EV6131100000000100000000000000011000000011011110000100000000011110000000000000100000000000000000100000000000000000000000000100000000000000000000000000000000000000000011000000011000000000000000000000000000011110000011110000000000000000000000ECT164502PW340ECT167876PW072ECT167901PW289DP322EV9241EV9241011011000000000011000000011000000000000000000000011000000000000011000000000000原料PNPART|DESCRIPTION11-Jan12-Jan13-JanECT142521COVER,TOP,VIP612DVR36833648ECT143349CABLE,POWERCORD,ROUND,3CO36833648ECT144332TOPCOVER,VIP211K11136108481824ECT144335-MCABLE,POWERCORD,3COND.,711136108481824ECT147358COVERTOPEXPRESSVU924219685761152ECT152858FRAME,FPBMOUNT,VIP612DVR36833648ECT153501BRACKETHARDDRIVEVIP722KDVR19685761152ECT155462FRAMEFRONTPANELBOARD722KD19685761152ECT155658BRACKET,HARDDRIVE,VIP612DV36833648ECT156117ASSY,BEZEL,VIP211K1392672336ECT157795ASSY,BEZEL,VIP612D
本文标题:Mmult物料需求计算
链接地址:https://www.777doc.com/doc-11306883 .html