Here is my two cents: We use conversions from purchase pounds to stock
inches or feet to inches for raw material and it seems to work. The problem
is that many cut to length material are standard lengths which creates drops
that stay in inventory. Cycle count corrections can be completed, but I was
wanting to get it charged automatically to the job.
In the job, there is a scrap factor which I though was great. We clicked the
radio button to inch instead of percentage in the BOM thinking that if a
standard length is 144" and the actual part requires 142", we would enter 2"
in scrap so the job gets charged 2" drop and purchase suggestions show
accurate requirements. We found out later that scrap did not multiple times
the requirement when linked to the job. Meaning that if the finished part
requirement was for two, the raw material requirement would increase to 284"
and the scrap would stay at 2". Maybe I'm missing something in a job shop
environment.
-----Original Message-----
From: Sherer, Rhonda [mailto:
rhonda@...]
Sent: Thursday, January 24, 2002 8:22 AM
To: '
vantage@yahoogroups.com'
Subject: [Vantage] Raw Stock Inventory
Hi.
First, I never liked the weights. We always use particular lengths in
our requirements and changing all that to a weight seems to complicate
the inventory needlessly.
So for your other question, there is a button in the part master,
look for Inv/Purch, in there is a Purchasing section, and a Minimum
can be entered. Put your 144" there, and when a purchase is being made for
the material, you can see the Minimum in the top right corner of the field.
The software is deficient in this area, as there could be a lot more
purchasing
information loaded in the system for each part number. It is apparent the
programmers are not purchasing on a daily basis. Order Minimum is a start,
but there
is standard packaging to be considered, too. Which in this case would
apply,
because you would order full bars of Aluminum, 144" or 288", not 72" or
189".
I better not get started on the Purchasing wish list.
If you change the unit of measure (inventory and purchasing) from EA to IN
the PO is fairly clear to the vendors. You can also change the Factor from
1.00 to .0833, the system will calculate a 12"= 1 Ft, and you'll get the
Feet to show on the purchase order quantity, while you see the inches in
your inventory. Remember to change vendor unit of measure to FT. The
"Factor" can be a little tricky, but you get used to it.
We don't use this feature a lot. But that's the basic gist. Others may
have more info for you.
Hope this helped.
Rhonda Sherer, Purchasing
Reeder & Kline
Message: 1
Date: Wed, 23 Jan 2002 11:33:59 -0500
From: "Bruce Butler" <
kktech@...>
Subject: Raw Stock Inventory
We are setup here with a mechanical engineer. One of his
responsibilities is to create M.O.M.s. At the time the MOM is created,
the material requirements are entered. For example, he will enter a
requirement of 11.70" ea. of 6061T62.001.00 (T6 Aluminum 2.0" wide X
1.00" thick X 1.0" long), as our stocking unit of measure is 1.0" (is
this flawed?). He wishes to have purchasing purchase 142" length bars.
When the job requirement is generated for 100 pcs, a purchase
requirement is created for 1170" of 6061t62.001.00. The problem we are
going over is; Using Vantage, how do we communicate to purchasing that
the each part uses 11.7" of material, and the ideal length to purchase,
in this example, is 142" lengths of the 6061T62.001.00 material?
To further complicate the issue, we could put the purchase conversion in
as .1963 lbs (.1963 lbs / 1.0" of 6061T62.001.00). Purchasing would
then receive a suggestion of 229.671 lbs (.1963 * 1170) of
6061T62.001.00, and would still need to determine the ideal length for
this particular job.
Bruce Butler, MIS
Knappe & Koester
18 Bradco Street
Keene, NH 03431
p 603-355-1166 x316
f 603-355-2266
kktech@...
www.knappe-koester.com
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
begin 600 winmail.dat
M>)\^(CL.`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`06``P`.````T@<!`!@`
M"``M`#4`!`!@`0$@@`,`#@```-('`0`8``@`+0`U``0`8`$!"8`!`"$````R
M,S@V.31#1C<S,3!$-C$Q0CDY1C`P,3`U03$U,#=$,@#D!@$$@`$`(@```%)%
M.B!;5F%N=&%G95T@4F%W(%-T;V-K($EN=F5N=&]R>0#+"P$-@`0``@````(`
M`@`!`Y`&`$P3```T`````P`)60$````"`3$``0```"@!``!00T1&14(P.0`!
M``(`=0`````````XH;L0!>40&J&["``K*E;"``!%35--1$(N1$Q,````````
M```;5?H@JF81S9O(`*H`+\1:#````$%.1%))5%HM34%)3``O;SU/4D<P,#$O
M;W4]55-!4DPP,2]C;CU296-I<&EE;G1S+V-N/5)A;&5Y`"X`````````.YZU
MW)"_TA&Y-0`06A4'T@$`&Y<#$J^PTA&Y$0`06A4'T@```5;`O@```````"X`
M````````.YZUW)"_TA&Y-0`06A4'T@$`&Y<#$J^PTA&Y$0`06A4'T@````3N
MS```$````".&E,]S$-81N9\`$%H5!](B````4D4Z(%M686YT86=E72!287<@
M4W1O8VL@26YV96YT;W)Y``,`WC^O;P```P`V```````#``6`""`&``````#`
M````````1@````!2A0``)VH!`!X`"8`((`8``````,````````!&`````%2%
M```!````!````#DN,``+`#B`""`&``````#`````````1@`````&A0``````
M``,`"H`((`8``````,````````!&``````&%````````"P``@`@@!@``````
MP````````$8``````X4````````+`!.`""`&``````#`````````1@`````.
MA0````````,``H`((`8``````,````````!&`````!"%`````````P`4@`@@
M!@``````P````````$8`````$84````````#`!:`""`&``````#`````````
M1@`````8A0```````!X`)8`((`8``````,````````!&`````#:%```!````
M`0`````````>`":`""`&``````#`````````1@`````WA0```0````$`````
M````'@`G@`@@!@``````P````````$8`````.(4```$````!``````````(!
M"1`!````<PP``&\,``"<%@``3%I&=9O>L^X#``H`<F-P9S$R->(R`T-T97@%
M00$#`??_"H`"I`/D!Q,"@`_S`%`$5C\(50>R$24.40,!`@!C:.$*P'-E=#(&
M``;#$27V,P1&$[<P$BP1,PCO"?>V.Q@?#C`U$2(,8&,`4#,+"0%D,S864`NF
M($@)!)!E(`0`(&UY("!T=V\@8PGP='/H.B!7'2!U%!`=T`(@/G8$D`"0`B`$
M(`-2('"7"'`3T1Z1<`A@;F0$($IT'<!S(-!C:QTP;O<3T`>1!;%F">`%0"#1
M(67S`A`%P')A!^``P`ZP!R(Z(`!P9!TP!4`4$&5M@R"S';!R:RX@5"&0WQ_`
M`V`"8"20'3)T$^`%0#,#@1V`8W4B,R7@;F?_)E`C:1T1(0`D`0L1)U4$(-QW
M:`W@)[`%`&4C@00@^F0#8'`F-2BA'8`+@"%1%Q[P`C`%L'DE0$-Y8S\EX!ZQ
M((`%0`6A&"!C=-4?,V,#D6(>HFT+4!0@[0F`+"X@)P%))/`@("]AZP(P"X!G
M(,)G(B$D01/2>S!@)"!A)P`#<2V0+?!LWFP=@1W`)E`=(&HEP"5`^PJB"H!)
M`Z`R92[P,F$=%.9A(/`%`&%P'W``T"P1[RFE+U`F4`A@9R>P+W()P=\C@"5`
M'E$LD`W@:S$A,F+](S!D'S`O`B#0,V$B9"%1YR$`*C`D(&]F'\`$D!WBCF$P
M8"N",F)"3TTF0?T+@&LO\R9B!I`TDBB\'3)P,30T(B/S,F(U,76/(]$*L05`
M&"!Q=6D8(&D]PC(B+O!W'2`=L'5^;"0@'?$2@4`@*X(TQ'/_,D<P4BW1,.5!
M42J2(_,?U]YS-D`P8"$`'S-S-B`'X/\`T";P(S`.L#]F!X`>`3<3_P(0(($A
MP"<!"V!!$BKT--/S.$`D(&YO)H%`L"V0+I'_'9`'<S?C1I@IH0GP)U`[H7LW
MLC))32HP`P`[Z3)B9O\+@`0`(9!$,3\Y2V0O@2+R_QVA,_,C+$K[0*,A82HA
M'I'Y(-$R.#X)-,1`E"M#)G%/0"!-$2M@+C%))Q^P;?\$`2_R0A`'@#N",!`K
MD32@[T*"1:$U``GP=C^P`B!&\E8N,O19BBU:HD\%$&=_"X`CT4TP!!`ZD5JC
M,O1&JP-A'C!3-")R+O!2-B`Y*-$@6P#``Q`@T#IR+5V30`G1!(%K3`%E+OTN
M85TR]`9@`C`>,"5@"'#J<RC@>2[P2@!P/N`L,"U!0#0N\`'0,!1`.#I2,A1`
M04TR]%1>4"",)W8OP3J10'EA-B!>;PG`"&`JP%^2)U_E=4QB:BUQ'C!;5F.$
M77L'\"-!4R$3,U`KY5F/"O1(:5EU1C^P(0`N\"]0OU]P'O%+\3>F0&!;$&A'
M(O<>0@=`+W!Y!"`>@C\B#>#_0+`*P2DV"X$S`PAA1GLC\_\3T2>`+_(QX29$
M(-$TH&KT_R1H+F,QP0ZP,O0R8BO':>'?"8`EX`00,@!9>U,=P"+R[GEN(DF0
M-"$@/Y!%)"[P_S0*.(4ZU3\C`,`YD5U0,O2=%[!O(4`B\F<A+U`?XO]VT3K4
M-$9Z@R`@5P,M="[PVR0"-*!-3H%)P&TR]"WU_T#S"8!K87J`!4!UHSWC-!/_
M?01+LS2@']<=02XP+_(`P/\!`"+B<H@C=B[P=:$MXR1Q_S)3?84ZQB#0-0!;
M`7$A!:'W7W!UT4X694#`67LE8D(0_P&`+W`=%`$!#>`(D"T!.M/_-'(J(7T!
M2I,=$2S10,$N,?\TH!>P)H$%L')U']4O\3+T_PN`(O$QDCC!%[""D5+R5%3_
M;``.L!^P(O(J,"GA/R-A8+<&T`20:V%),($T@7`*L9]+<C)AC14#8`G`86T'
M@/\4`"A328*->"'`5_(HX`,0_1V`8GPQ:U):\`2!A3@T@_\!D``@>44O$C03
MCA5%@2BV_PJP(3`ZD"_U+C,`@02!+M+](-!O:V(IPXIV+?`>D4"3_S+TDE$R
M`)@6!9`Q4!Z1A$+W0)0%L):R9D"P`R"6$)0!_3GQ00I`5L"182[P/>-K</L%
ML5/0.$`Q27,!P*(1@N;X,3@Y5?`R]2XA`D`2@?])@C!BE\,Q(3C")7%[Z0/Q
M[R>P-W`A`%E[23H`A$-O@O^$Y""`)$$Y\0>`("`(<!T@+BAS*$09+_$I'W1%
M0<D@PDE.<HA03QTR-2"_/[`R`2R1"L$R-2OA9`6PO6M26815!T!"$:DY1C4T
M.P-2HZ4N8A`@PK+@.#/^,U#$D!4#\'`1,=%LPD91\S2@#B`B/3W0L;!IH2/S
MW76A)W`1,&*2YT8B%46CWZ9%']>@%#^0+\)T81$IL7\LH81"A,8A96VF=:,K
MR5)_1N&1@G&CJ42OI*G?(-%&[E1K825A,O0BL<0^$"WU^XQQ)$!T2B(%$"$P
M81$O$O^$0C!B'H%,4R1`67L>4:_0_&XGQ`.*E"(`(X"JHHQS;6MA0IB3(X`G
M2I26$F/_,%"GPI9Q-!(=42M@,O03X+\>\(S#(5$"$'5667M(*K#[QD4AD&PZ
M((?V785=!GOHP\VU7O,@)B!+7U)GO[]9U5N%'C`:\PJ`HB%$(X$S'C(NX3(S
M83)A]#$Q`CJS@#HU.2`M,(XU8A#3!URD(D)R&M"/.R$G`"7@P;$\:VL.L#D3
MT$!K6T"28%O@:V_W12&1H2YA/F3]9H]GG&N2_RAR%"!D<,TQ'1$#\">A-*!_
M!X!O<C'"0.%;(0G@D;)/?U]P.>**L3+T/\$@8`"!8G\#$"1`")!M@7&4*B,%
MT"[L3R[B(&M209+#2D.$]/\[49T"*B,NX(,/4=N4%'[(^D:0DGB3P"Z1+O!J
MPK2"/4#T8=_F2Q@Y\=4`+C<^,#X0*C`E0#GQ'#`V,=A4-C*RX;+3*.O`H3??
M04"RX#X0`_""H5BR>(`B_S>![=`]T.U2%["L48LS;B+_(0,O\JGN/;+M4JK@
MW]7&9.,+8$!@9#\I:V$<\*=3_TJ"'<#*<Y2Y']=``B=6H,+_67LRY9Q02]%"
M1DKZ'4$P8!>'`>1B(N,QLO%P8W/??0$?Q^E?X_GZ]#'JTNM5?G3KU\"4)9=`
M82AATP1GCF^5(VH2!``[(%56\_]E]>A!1<&OT$!2+F%)P-XR_T91(-&4N292
M<HB0R!Z!/<'_ZK'^PX.H/C:;<2/1)V4$Z/^`@(X6BI3GUSVS]H>@\S)B^^N-
M(W8_,N4RY6,@H&%LD/]V$G'HNV1;H!D`0$.+Y/70'^+4]=<>R&V7+X$N,3E2
M-M10;&)[H"@5*"__[R3K7_/"IKJ=F#)AE7`M83]P\,J1-*%$]SGB8G`Y+NPV
M-[70%8DJ_G.L<#GP_],$ZXR`E545M()SPDQBB=#_(Y&A<;M5"5J"V9EQ;'DR
MHX\//#+EUNHN\$U)4],$_DO84]!BV,2CICLP."&&T'?:D5[A!?5+WN#?4"[P
M3L!((#`S-#/2]8T5@>MQ,RTS-34MU0#J-NR0>"GP-M,$ZV(K%+]B<"N0TP37
MW]CFTP1W+Y">+BX?`,#WVS%Z6TZ58/HMX?!XE)&0D$5$AT.9<7]*<5NR],2;
M`!FSRL"]$&0_7]59[S=/6J"P,&0"(2!^1V13SG#@<I"1-W]:HGZO6J#99CF$
M0V%B8:!6Y8'^4X:`E7`X<``B9?#LP-]C[E36\/!@TP1$L/"$0A^6<[[@2/!Y
M<(:P<`)UI&[?7U+"T0,`6[!\LW,/(&E@]T?`<HC,P'+&L+'@B0'LP,..XXIV
M1E)%13CP_0`?@J*LHCRV676&H'1P.IPO+VPP7Y`1`6LN8_,!7Y(O=D-U=5-!
M0"]59&E$04B`>26&@$9(X5!HYY!L0OPO5&*U.C]+?TR/39\[,3_99=,$`I")
MX",`:D%N:_^N09"1Y1(XE#D%9?7'H(]`]YH!YK'3T"@I@)2`TL&P,]^%@/!@
M-+2TT.'!9&&@4"*?/%%UHP"P7A&U4&1DX$'?<9.7H&/S"3$_E&$`D;50+F/7
M$%N@ZS`ITP0H,?^L<!`16!2Q=+JQ.5%\I`TR_VXB40G+4[V@,S+'H;JPT#+]
M?2)#O6"9H:"@7'1O%'7TVB<!H&](L+OP)\-`Z!'_G4(!H*\PT]!&E61%1YAD
M0UM((`,$+XGP=`$O(X<H_C)9(_8P;/"<@=V0.1&&D/>C<)_A<8!GR#%@;V%_
M8HC3-$7?U2@S62-VX1#:@/]0)*\Q/+"OPW`T`&%J((*A^U'6]C!R:B!8,68/
M9Q]B>?]0)#7JL$&_(;EBZH`XG)ER?]GD])-&I`/`^Y!'B8YR+Q<@,F-@,6M]
M=K``'@!P``$````>````6U9A;G1A9V5=(%)A=R!3=&]C:R!);G9E;G1O<GD`
M```"`7$``0```!L````!P:3BG,[/E(2A$',1UKF?`!!:%0?2``+2!I```P`F
M```````#`"X```````L``@`!````'@!"$`$````P````/$%&,S8W130S-$(Y
M-$0R,3%!-38P,#!!,$,Y14,P.#0Y,C0T-$,T0$9!3$-/3CX``P#]/^0$``!`
M`#D`X-G*TN6DP0$#`/$_"00``!X`,4`!````!@```%)!3$59`````P`:0```
M```>`#!``0````8```!204Q%60````,`&4```````P"`$/____\+`/(0`0``
M``(!1P`!````-0```&,]55,[83T@.W`]3U)',#`Q.VP]04Y$4DE46BU-04E,
M+3`R,#$R-#$T-#4U,UHM,C0Y,C$``````@'Y/P$```!(`````````-RG0,C`
M0A`:M+D(`"LOX8(!`````````"]//4]21S`P,2]/53U54T%23#`Q+T-./5)%
M0TE0245.5%,O0TX]4D%,15D`'@#X/P$````-````4F%L97DL(%-T979E````
M`!X`.$`!````!@```%)!3$59`````@'[/P$```!(`````````-RG0,C`0A`:
MM+D(`"LOX8(!`````````"]//4]21S`P,2]/53U54T%23#`Q+T-./5)%0TE0
M245.5%,O0TX]4D%,15D`'@#Z/P$````-````4F%L97DL(%-T979E`````!X`
M.4`!````!@```%)!3$59````0``',"XSNM+EI,$!0``(,`;U_-+EI,$!'@`]
M``$````%````4D4Z(``````>`!T.`0```!X```!;5F%N=&%G95T@4F%W(%-T
M;V-K($EN=F5N=&]R>0```!X`-1`!````.````#PQ0CDW,#,Q,D%&0C!$,C$Q
M0CDQ,3`P,3`U03$U,#=$,C`Q,SDW,48X0$%.1%))5%HM34%)3#X`"P`I``$`
M```+`",```````,`!A"/('FV`P`'$,T/```#`!`0``````,`$1``````'@`(
M$`$```!E````2$5214E335E45T]#14Y44SI7155314-/3E9%4E-)3TY31E)/
M35!54D-(05-%4$]53D135$]35$]#2TE.0TA%4T]21D5%5%1/24Y#2$531D]2
M4D%734%415))04Q!3D1)5%-%10`````"`7\``0```#@````\,4(Y-S`S,3)!
M1D(P1#(Q,4(Y,3$P,#$P-4$Q-3`W1#(P,3,Y-S%&.$!!3D12251:+4U!24P^
#`#Q0
`
end