ࡱ> im  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghklRoot Entry FejWorkbookSummaryInformation(DocumentSummaryInformation8D `\p Ba==hx! 8@"1Arial1Arial1Arial1Arial1Arial1Arial1Tahoma1Arial1Arial1Arial1xArial1xArial1Arial1Arial1xArial1Arial1Arial1Arial1 Arial1Arial1Arial1dArial1Arial1xArial1Arial1Arial1Arial1h8Cambria1,8Arial18Arial18Arial1Arial1Arial1<Arial1>Arial1?Arial14Arial14Arial1 Arial1 Arial1Arial1Arial1 Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_),'[<=9999999]###\-####;\(###\)\ ###\-#### 000\-00\-0000 ##\-######## m/d/yy;@ mm/dd/yy 0.0%                                        +  +  +  +  +  +  +  +  +  +  +  +  !  %   ' ff + ) , * )    P  P    #   & ` "      $    * a> (    @ @   @ @    @ @  0 (0  @ @        #<@ @   $@ @   $@ @   0  0a@ @   # # + $@ @   @ @   @ @  + $@ @   @ @  + $@ @  , $a@ @       "8@ @  "8@ @  "8@ @  "8  (`@ @  "8`@ @       " # + $a@ @    8@ @    (@ @      `a@ @  X X  00@ @  !x  x (x )x  ( , d @ @  + da@ @  , da@ @  #|@ @  , t @ @  , l`@ @    (8@ @  (8@ @   J8 !t@ @  !t@ @  !t@ @  #8 +8  h@ @ A  (  (  )x  (x  (@ @  "x@ @  *x@ @   <0@ @    $0@ @    $0@ @   "8@ @    <0@ @   8   !x  x   ,3@ @  , <"@ @      8  8 "8@ @   "<`@ @  + 4@ @  + 4@ @  !0@ @  # #      "8 !8@ @  !8 !8 @ @  ! "8 - !8 @ @  !8 @ @  !8 @ @  " !0@ @   x@ @ A  x@ @ A  x@ @ A  x@ @ A  xA  |@ @ A  x@ @ A  x@ @ A #8@ @  #8@ @  +8@ @   (8@ @  +8@ @   8@ @  "0@ @   8@ @  "8@ @  "8@ @  "8 @ @  "8`@ @   8`@ @   8`@ @  "8`@ @  "8@ @   8@ @   8@ @  !0@ @   <@ @   8@ @  " "  8`@ @  x@ @  p0@ @   8a@ @   4@ @   0@ @   0@ @   0@ @   0@ @   0@ @  "     8@ @  0@ @  0@ @  0@ @  0@ @  0@ @     4@ @   0@ @  !p@ @  !p@ @   x@ @ A "8@ @  "8@ @  "8@ @  #8  p@ @   p@ @    8@ @    8@ @    8@ @  8@ @  8@ @  8@ @  8@ @  0@ @   8  8@ @  "8@ @  !p  8   " !0@ @  !8  # # -8@ @   (@ @    #8a@ @    !  8@ @   8@ @   8@ @   8@ @   8  <@ @   8@ @   8@ @  "8 "  8@ @   0  4@ @   0@ @    P P  P   -   ( ||}-}; )\ ###\-}<}1 )\ ###\-_)?_);_(}<}2 )\ ###\-?_)?_);_(}<}3 )\ ###\-23_)?_);_(}(}4 )\ ###\-}<}0 a)\ ###\-_)?_);_(}<}( )\ ###\-_)?_);_(}<}7 e)\ ###\-_)?_);_(}}5 ??v)\ ###\-̙_)?_);_(   }}9 ???)\ ###\-_)?_);_(??? ??? ??? ???}}) })\ ###\-_)?_);_(   }<}6 })\ ###\-_)?_);_(}}* )\ ###\-_)?_);_(??? ??? ??? ???}(}= )\ ###\-}x}8)\ ###\-_)?_);_(  }(}/ )\ ###\-}P}< )\ ###\-_)?_);_( }<}" )\ ###\-_)?_);_(}<} )\ ###\-ef_)?_);_(}<} )\ ###\-L_)?_);_(}<} )\ ###\-23_)?_);_(}<}# )\ ###\-_)?_);_(}<} )\ ###\-ef_)?_);_(}<} )\ ###\-L_)?_);_(}<} )\ ###\-23_)?_);_(}<}$ )\ ###\-_)?_);_(}<} )\ ###\-ef_)?_);_(}<} )\ ###\-L_)?_);_(}<} )\ ###\-23_)?_);_(}<}% )\ ###\-_)?_);_(}<} )\ ###\-ef_)?_);_(}<} )\ ###\-L_)?_);_(}<} )\ ###\-23_)?_);_(}<}& )\ ###\-_)?_);_(}<} )\ ###\-ef_)?_);_(}<} )\ ###\-L_)?_);_(}<}  )\ ###\-23_)?_);_(}<}' )\ ###\- _)?_);_(}<} )\ ###\-ef _)?_);_(}<} )\ ###\-L _)?_);_(}<}! )\ ###\-23 _)?_);_( 20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L湸  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  Lմ  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23ٗ  60% - Accent3H( 60% - Accent3 23֚  60% - Accent4H, 60% - Accent4 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1<Accent1 O  #Accent2<!Accent2 PM  $Accent3<%Accent3 Y  %Accent4<)Accent4 d  &Accent5<-Accent5 K  'Accent6<1Accent6  F (Bad4Bad  ) Calculation| Calculation  } * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text  0Good6Good  a1 Heading 1B Heading 1 I}O2 Heading 2B Heading 2 I}?3 Heading 3B Heading 3 I}234 Heading 44 Heading 4 I} 5InputpInput ̙ ??v 6 Linked CellF Linked Cell } 7Neutral<Neutral  e"Normal 8Noteb Note   9OutputrOutput  ???????????? ???:$Percent ;Title1Title I}% <TotalHTotal OO= Warning Text: Warning Text XTableStyleMedium9PivotStyleLight16`mhMPR-170,Continuation Sheet Instructions _Col2; _Col2; _Col3; _Col3;" Business;" Business; Class; Class;! Column3;! Column3;  Locals;  Locals; neap:neap:Neaprate:Neaprate:  ;)   ;3   ;.   States;  States; Type; Type;"vn( S AA@A@   Address'Local Union No. Where Work is Performed#Employer's Federal Registration No.@This Transmittal Covers ALL Payroll Weeks Ending As Shown Below *CLASSIFICATIONS TO BE USED IN COLUMN NO. 3All Other Outside Workers'Other (Including non-bargaining admin.)Column 1Column 2Name of EmployeeColumn 3ClassColumn 4Column 5Gross EarningsHours Total ClockLast Name and InitialsMNNDSDWINE!Missouri Valley Line ConstructorsP.O. Box 20166Kansas City, MO 64195(816) 891-9066Total Number Pages This ReportGrand Total All Pages Firm NameDate%First report in this Local Union area%Final report in this Local Union areaSingle Proprietorship Corporation Partnership11 Outside Journeymen12 Outside Apprentices13 All Other Outside Workers*26 Other (Including non-bargaining admin.)Social Security Number 27 Alumni9MONTHLY PAYROLL REPORT FOR OUTSIDE ELECTRICAL CONTRACTORS NATIONAL ELECTRICAL BENEFIT FUND!Total Number Employed This Period*Journeyman Lineman Wage Rate Per Hour $ AgreementUtility CommercialOutside JourneymanOutside ApprenticeALUMNINameTotal Check AmountNECA Members OnlyStaple Continuation Sheets HereThis report and payment shall be mailed to reach the office of the appropriate Local Collection Agent not later than fifteen (15) days following the end of each calendar month. NATIONAL ELECTRICAL BENEFITGENERALjIndicate type of business organization in the appropriate space in the lower left hand corner of page one.NAME OF EMPLOYER LOCAL UNION&EMPLOYER'S FEDERAL REGISTRATION NUMBERThis is the number used by the employer in the name and address section of the Federal Quarterly Withholding and Social Security Report.(TOTAL NUMBER OF MEN EMPLOYED THIS PERIODWAGE RATE PER HOURCOLUMN 1Enter the Social Security Number for each employee which would be used in reporting his withholding on your quarterly Social Security Report.COLUMN 2@Enter last name first followed by his first and second initials.COLUMN 3Enter Classification CodeCOLUMN 4COLUMN 5TOTAL THIS PAGECOMPUTATION OF CONTRIBUTIONISee summary sheet for amount of contributions and for where to send them. SIGNATUREsThe report should be signed in the name of the employer by his authorized agent giving title of authority and date.If the report is either a first or final report for the Local Union area indicated in the heading of page one, check the appropriate space provided at the bottom of page one.:ASSEMBLING REPORT AND FORWARDING WITH CHECK TO LOCAL BOARDYou are required to file a MPR report whether or not you have a payroll for a particular period unless your last report indicated it to be a final report.MLiquidated damages are provided for failure to file or pay the contributions.tThis should be the employer's complete name and the complete address of the main office, not the address of the job.The number of the local union having jurisdiction where work is performed should be entered here. When the employer is working away from his home local, a separate report must be made for that job.AThis is the total names reported on the completed monthly report.qEnter the Building Construction Journeyman's Effective Hourly Wage Rate for the area where the work is performed.FEnter for each bargaining unit employee the actual elapsed clock hours from the time record (include vacation, sick leave, or other hours for which the employee has been compensated). Do not adjust their hours for premium pay hours (time and one-half or double time). For covered non-bargaining employees or covered "alumni" whose wage rate is greater than the journeyman's rate in this local union jurisdiction, enter normal straight time hours. For covered non-bargaining or covered "alumni" whose wage rate is less than the journeyman's, enter actual hours worked/compensated.Enter the actual gross earnings subject to withholding taxes for each bargaining unit employee. For covered non-bargaining or "alumni" whose wage rate is greater than the journeyman's rate in the reporting local union, enter earnings calculated by multiplying the normal straight-time hours by the journeyman's rate. For covered non-bargaining or "alumni" whose wage rate is less than the journeyman's rate, enter actual gross earnings.With regard to the NEAP, the employer should report pursuant to the NEAP and the applicable collective bargaining agreement. The following instructions are applicable to the NEBF, although they do provide guidance applicable to the NEAP with regard to the preparation of the form. The completed report is to cover all pay periods falling in a calendar month and is due at the Local Collections Agent's office not later than fifteen (15) calendar days from the last day of each month.IMPORTANT - Only employees who are covered by the bargaining agreement and employees covered pursuant to Article 6 of the Restated Employees Benefit Agreement and Trust for the National Electrical Benefit Fund should be entered on the report.  SignatureTitleForm MPR-170 is for use by an employer for employees engaged in "all outside electrical construction, line clearance and maintenance work for electrical and telephone utilities, REA CO-ops, Railroads, and Municipalities," where the employer recognizes the Brotherhood or a Local Union of the Brotherhood as the collective bargaining agency of its employees and who agrees with the Brotherhood or a Local Union of the Brotherhood to participate in the National Electrical Benefit Fund (NEBF) and the National Electrical Annuity Plan Agreement and Trust. Form MPR-170 is designed for reporting employees of the bargaining unit and other employees covered pursuant to Article 6 of the Restated Employees Benefit Agreement and Trust for the NEBF of the National Electrical Annuity Plan Agreement and Trust. When the employer has to report on more than nine employees for any one month, he should insert the number of lines needed.QRVINSTRUCTIONS FOR MPR-170LThe Excel version of this MPR is available for download at www.mvswneca.org.CONTINUATION SHEETTotal This PageCheck Type of Business Entity: Tree Trimmers TT ForemanOther Tree ClassificationsMAIL THREE COPIES TO:DEnter the total of the hours and gross pay in columns four and five.When the report consists of more than one page, the sets of pages should be collated in page number sequence. The sets should then be stapled in the upper left hand corner as indicated on page one.The employer should retain a copy of the entire report, and mail three copies with his check for the contribution (see above) to the board indicated on page one.The board will forward a copy to the Local Union having jurisdiction so that they will be promptly advised that you have complied with our Agreement with them covering the 3% Benefit Fund Assessment.Tree TelephoneStreet LightingOtherMarket Recovery - Tree*One NEAP Rate Per MPRMarket Recovery - OtherCity, State, Zip Phone #/Email;Remit One Check Payable to: National Electrical Trust Fund All Line Work.The employer reporting herein recognizes that it is bound by the Restated Employees Benefit Agreement and Trust for the National Electrical Benefit Fund (NEBF) and the National Electrical Annuity Plan Agreement and Trust (NEAP) as provided for therein. The employer acknowledges having received a copy of the above Agreements. The employer certifies that the information contained in this report is a full and accurate statement of hours worked and wages earned of all employees subject to employer contributions (pursuant to Article 6 of the Agreements). The employer further certifies that if contributions are made on behalf of non-bargaining unit employees, it is making such contributions in accordance with Article 6 of the Agreements and it is either covering all such non-bargaining unit employees or alumni employees only, except those who may be excluded pursuant to Section 6.3 of the NEBF Agreement and Section 6.2 of the NEAP Agreement<. The employer further certifies that if it is reporting on behalf of a related organization as defined in Article 6 of the Agreement, either all employees of the organization or alumni employees only are covered, except those who may be excluded pursuant to Section 6.3 of the NEBF Agreement and Section 6.2 of the NEAP Agreement.Phone # / Email$National LMCC - 1 per hour (Col. 4)!National Electrical Annuity Plan* ENational Electrical Industry Fund for 0.8% of gross earnings (Col. 5)&*BNational Electrical Benefit Fund for 3% of gross earnings (Col. 5)%',AMF Fund for 0.2% of gross earnings (Col. 5) FOR LOCAL #953 ONLY Local 953QLocal #953 - NECA Joint Safety Training Trust for 0.5% of gross earnings (Col. 5)26CLocal #953 - VEBA Retiree Fund for 1.25% of gross earnings (Col. 5)#(12 Outside ApprenticeVEBAContribution RateCApprenticeship Training Program for 1.5% of gross earnings (Col. 5)$(Updated 1/27/10hC D'DGEEFsGW-HIKFLv PI R[>\^_hfkgccB  Um}q  dMbP?_*+%V&?'?()MSHARP AR-M257 PCL6_T157 PCL6_T odXXLetterSCPIt 0SF0ESHARP AR-M257 PCL6_T1( odXXLetterH@$$dd**** o****d{"ArialddXdddd$$ddd 222222< Username unknownJobname unknownq< $@"WXX&U} }  } m }  }  } $} m}  } I} } I} } } W} $W} IW} $ W} } p} m!p} 2WU@,@,@,@@@@J@J@ J@ J@ ,@ ,@ ,@ ,@,@,@ @@@@,@ ,@0,@ ,@,@ ,@,@ ,@ ,@ ,@ , 8  +__ $ ,  lm ~5 N & lm ~   ' lm t / w A A * lm z  t e lm -  . f lm g lm   9  CCCCDD lm {|||} CCCCDD lm  [[ lm~ W&@ 2 ~ W(@ 3 ~ W*@  WW lm~ W:@  W~ W;@ W4 WWW lm    X Y X  X  A lm (   Z [ Z   A lm ) \ ]\~  ?  A lmPxQR' RDD A K lmByST' T DD A K lmByST' T DD A K lmByEO' O DD A K lm  L  h5r DDDDZ(5s DDDDZ(5 s D D D D Z(  K lm ~g lm h+q Q?DA lm   }  7 lm ~ q lm    lm +q  Q?DA lm r  | ~ 'u DDA ln { k+u {Gz?DA K lm  Mb`?'u DDA K lm ~ ?' !DDA Dl4:HLdxZb8b@:hz____BcVBLcw ,@ !,@ ",@#,@$,%,&,'(,),@*,@+,@,,@-,@.,@/V@0 V@1 V@2 V@3 V@4 V@5 V@6 V@7 V@8 V@9 V@: V@; V@< V@= V@> V@? V@  ~ ?  D  K lm !^ !VV@ !>6!AF!v 0DDDDDDDD ! K !lm "^ "VV@ "v" "lm# #lm $x$$ $%% % &y&& &'' '(( ( )^d )>> )M) )lm *! *c *] * *M*J *lm +" +d +N^+ +lm ,#,@ ,lm -a- -lm .. . FFFFFFFFw .lm/ FFFFFFFGw /lm0 FFFFFFFFw 0lm1 FGGGGGGGw 1lm 2lm 3lm 4lm 5lm 6lm 7lm 8lm 9lm :lm ;lm <lm =lm >lm ?lmD;liL*J>J>>J`J66T***@V@AV@BV@CV@DV@EV@FV@GV@HV@IV@JV@KV@LV@MV@NV@OV@PV@QV@RV@SV@TV@ @lm Alm Blm Clm Dlm Elm Flm Glm Hlm Ilm Jlm Klm Llm Mlm Nlm Olm Plm Qlm Rlm Som Tom.$ m( G( T<(  ~  <))A@i ]6    "<Traveling Contr.<B ~~  <())A@i >]6 (   "<Permanent Contr.<J P>@PdjM.. ++**,,--++,,****     ))##++ &'(( "" $%7v& + #/  %. DateM/D/Yr 6 NECA Members Only ! When it is necessary to use a continuation sheet, the first set used should be numbered "page number 2" and the second set would be "page number 3", etc. Upon completion of the report, the total number of pages should be entered in the space provided.  The number used by the employer in the name and address section of the Federal Quarterly Withholding and Social Security Report.agnuf AThis is the total names reported on the completed monthly report.Fera qEnter the Building Construciton Journeyman's Effective Hourly Wage Rate for the area where the work is performed.y po Insert or delete as many rows here as you need. To format the rows do the following: Select an original row - Copy - Select all the rows you just inserted - Paste Special - Format - OK That will format the inserted rows like the original.ovedE  Enter the % you are paying here.yone }Enter the % of NEAP you are paying in the cell to the left (titled neap) to automatically calculate the NEAP amount due here.e ws The number of the local union having jurisdiction where work is performed shold be entered here. When the employer is working away from his home local, a separate report must be made for that job. e se.beofggD  .be  dMbP?_*+%V &R&"Arial,Italic"&8Updated &D&?'?(?)?MSHARP AR-M257 PCL6_T157 PCL6_T odXXLetterSCPIt 0SF0ESHARP AR-M257 PCL6_T1( odXXLetterH@$$dd**** o****d{"ArialddXdddd$$ddd 222222< Username unknownJobname unknownq< $@"]XX??&U} }  }  }  } $}  } $} } } I} } } } } $W} m} $"} W.,@@@@V@V@ V@V@ V@  V@ V@ V@ V@J@J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ J@ z8  b      ` ~5 N~ @  W$ " 1 W0 ~  ~ J@  W% W1 t a/ w A A~ K@  W& Wm u       H~ W@  W' Wn  9  CCCCDD~ d@  W* WoIJJJ? CCCCDD~ z@ We Wp    X Y X  X  A ~ P@ Wf Wq (   Z [ Z   A ~ ȍ@ Wg Ws )   \ ] \~ ? A ~ @ PxQR' (D D A K~ H@ ByST' D D A K~ ̠@ ByST' D D A K ByST' D D A KByST' DD A KByST'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KByEO'  DD A KD|l8v\z__QQQQQQQQQQQQQQQQQQQ J@!J@"J@#J@$J@%J@&J@'J@(V@ )V@*V@+V@,V@-V@ ByEO'  D D A K!ByEO'! D!D A! K"ByEO'" ! D"D A" K#ByEO'# " D#D A# K$ByEO'$ # D$D A$ K$ FFFFFFF%ByEO'% $ D%D A% K&ByEO'& % D&D A& K'ByEO'' & D'D A' K ( (L (c (h#(b( % '#(U( % '#( U % '  )a) *A* FFFFFFFF+ FFFFFFFG, FFFFFFFF- FGGGGGGG QQQQiQQQ(*$  G( G( T  <(   ~  <))A@ ]6 @  "<Traveling Contr.<~~  <())A@ ]6 (@  "<Permanent Contr.<P>@d  Q%%%%""""####''$$$$**''&&))((((&&         !!!!    7x/ & %+ #. DateM/D/Yr The number used by the employer in the name and address section of the Federal Quarterly Withholding and Social Security Report.  Insert or delete as many rows here as you need. To format the rows do the following: Select an original row Copy Select all the rows you just inserted Paste Special Format OK That will format the inserted rows like the original. E  Enter the % you are paying here.yone The number of the local union having jurisdiction where work is performed shold be entered here. When the employer is working away from his home local, a separate report must be made for that job. edow.beof/  be% 'ggD  4%  dMbP?_*+%&?'?(?)?MSHARP AR-M257 PCL6_T1 odXXLetterSCPIt 0SF0ESHARP AR-M257 PCL6_T1( odXXLetterH@$$dd**** o****d{"ArialddXdddd$$ddd 222222< Username unknownJobname unknownq< $@"bXX??&U} m4     @ 4@ @ *@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @  @  @ @ @ ` : ;  _  Z  [  \   <   e= T  e> U  f? @  iA V  jB W  jC D  jE F  eG H  eI X  Dxl********666666666 @! @" # @$ @% @& @' @( @) * @+ @, @- @. @/ @0 @1 @2 @3  eJ Y  ! "jK "i" # $fL $M$ % &eN &O& 'g 'P' ( )Q) * +k+ , -j- . /l/ 0 1R1 2 3S3 ,|66662*****> @d 4.. 33 && // '' 22 00 11 ++               -- (( %%  ,, ** )) $$   "" ## !!           7ggD  Oh+'0HP\h   Microsoft Excel@1@Q@tC՜.+,0 PXl t|  Mo Valley MPR-170Continuation Sheet Instructions'Continuation Sheet'!_Col2_Col2'Continuation Sheet'!_Col3_Col3'Continuation Sheet'!Business Business'Continuation Sheet'!ClassClass'Continuation Sheet'!Column3Column3'Continuation Sheet'!LocalsLocals'Continuation Sheet'!neapneap'Continuation Sheet'!Neaprate Neaprate 'Continuation Sheet'!Print_AreaInstructions!Print_Area'MPR-170'!Print_Area'Continuation Sheet'!StatesStates'Continuation Sheet'!TypeType  Worksheets Named Ranges F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjr