jagomart
digital resources
picture1_Cost Tracking Spreadsheet 41277 | Confcostsubform


 228x       Filetype XLSX       File size 0.38 MB       Source: ojp.gov


File: Cost Tracking Spreadsheet 41277 | Confcostsubform
department of justicesponsored conference request and report a red cell indicates that your entry exceeds the doj meal threshold and cannot be submitted unless within the meal threshold ayellow cell ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                                                                                                                                                                                                                                                
                                                                                                                   Department of Justice-Sponsored Conference
                                                                                                                                        Request and Report
                  A RED cell indicates that your entry exceeds the DOJ meal threshold AND cannot be submitted unless within the meal threshold. 
                  AYELLOW cell indicates that your entry exceeds the DOJ threshold, and additional justification must be provided. 
                  AGREY box indicates that no entry is required.
                  JMD FINANCE STAFF USE ONLY: 
                  JMD Tracking Number 
                  Date  Received 
                  COMPONENT USE ONLY: 
                            Component Internal Tracking Number For Federal Use Only
                                                         (Optional):
                                              CA/Contract Number
                                            CA/Contract Recipient                                                                   CA/Contract PoC 
                                                                                                                                    Name
                                           CA/Contract PoC Phone                                                                    CA/Contract PoC 
                                                                                                                                    Email
                                                                      Request Cost per           #DIV/0!          Actual Cost per          #DIV/0!        OJP Average Cost                           DOJ Average 
                                                                          Attendee                                    Attendee                            per Attendee                               Cost per Attendee
                  A.  GENERAL CONFERENCE INFORMATION:
                  1.  Name of Requestor 
                  2.  Component Name  (Drop Down)                    OJP - Office of Justice Programs 
                  3.  Is this submission for a conference request    Conference Request
                  or report? (Drop Down)
                  4.  JMD Tracking # (Report Only)
                  5.  If this is a Re-Submission of a previously 
                  disapproved conference, indicate original JMD 
                  Tracking Number. 
                  6. Official Title of the Conference  
                  (No Abbreviations) 
                  7.  Is this a blanket request? (Y/N)                                                                                                                                                                                      If Yes, please enter the length of the 
                  (Drop Down) If "YES" Skip A9-13,A16 and            N/A                                                                                                                                                                    conferene below (days). 
                  Sections C,D,& E1, If "NO" Skip A8 
                  8.  If this is a Blanket Request, indicate for 
                  each: 1) Number of occurrences this fiscal year,                                                                                                                                                                                                                        0
                  2) Locations, and 3) Start and End Dates
                  9.  Conference Start Date (MM/DD/YYYY)
                  10. Conference End Date (MM/DD/YYYY)
                  11. Location: Country  (Drop Down)                 United States (Continental)                                                                                                                                             States 
                  12. Location: State / Territory / Possession 
                  (Drop Down) 
      DOJ-Sponsored Conference Request and Report Form_Version 2                                            Return To:  JMD Finance Staff, TSG at   Conference.and.Non-Federal.Center@usdoj.gov                                                                                            Attachment 1
      Release Date: 4/1/13                                                                                                                                                                                                                                                         SUBMISSION FORM
                                                                                                                                                                                                                                                                                                 1 of 70
                 13. Location: City                                                                                                                                                                                                                                                           
                 14. Justification that conference is essential to 
                 accomplishing core mission
                 15. Funding Appropriation Symbol 
                 16. Facility Name  (Specific)
                 17. Facility Type (Federal/Non-Federal) 
                 (Drop Down)
                 18. Cooperative Agreement (Y/N)  
                 (Drop Down)
                 19. Reporting Period (Required when reporting                                                                                                                                                               #DIV/0!
                 actuals) (Drop Down)
                                                                Conference REQUEST Information                                                  Conference REPORT Information
                 20. Number of DOJ Federal Attendees 
                 21. Number of Other Federal Attendees 
                 22. Number of Non-Federal Attendees 
                 23. Total Number of Attendees                  0                                                                               0
                 (Auto-populates)
                 24.  Total number of attendees whose travel 
                 expenses are paid for by DOJ (required)
                 25. Total Cost                                 $0                                                                              $0
                 (Auto-populates from entries below)
                 26. Predominately Internal Event held at a Non-
                 Federal Facility (Y/N) (Auto-populates based on  PLEASE PROVIDE NUMBER OF ATTENDEES
                 Facility Type and Number of Attendees)
                 Competitive Contracting:
                 27. Were Federal procurement regulations 
                 followed as appropriate?  (Drop Down)
                 28. Were all market research documents used in 
                 conference planning decisions retained? (Drop 
                 Down)
     DOJ-Sponsored Conference Request and Report Form_Version 2                                      Return To:  JMD Finance Staff, TSG at   Conference.and.Non-Federal.Center@usdoj.gov                                                                                 Attachment 1
     Release Date: 4/1/13                                                                                                                                                                                                                                        SUBMISSION FORM
                                                                                                                                                                                                                                                                              2 of 70
                            When REPORTING quarterly conferences, only complete the request information if JMD approved your request and you have a JMD tracking number                                                                                                                                                                                                                                                                                                
                                                                                                                                     Conference REQUEST Information                                                                                                                                          Conference REPORT Information 
                                                                                                                                                                                                                                                                                                                                                                                   VARIANCE JUSTIFICATION 
                            B.  TOTAL CONFERENCE COSTS:                                                      ESTIMATED                         ESTIMATED                        ESTIMATED                     % OF TOTAL                            ACTUAL                          ACTUAL                           ACTUAL                     VARIANCE                        (Provide justification if  variance is 
                                                                                                           DIRECT COST  INDIRECT COST  TOTAL COST                                                                    COST                    DIRECT COST  INDIRECT COST TOTAL COST  (Between Actual and  >$1,000 and >10% as indicated by a light 
                                                                                                                                                 (Funding from                  (Auto-populates)               (Auto-populates)                                                   (Funding from                  (Auto-populates)                   Estimate)              yellow cell OR exceeds cost thresholds, as 
                                                                                                                                          Cooperative Agreement )                                                                                                          Cooperative Agreement )                                             (Auto-populates)
                                                                                                                                                                                                                                                                                                                                                                                  indicated by a bright yellow cell)
                            1.  Conference Meeting Space (including rooms                                                                                                     $                      -                          0.00%                                                                          $                      -     $                      -   
                            for break-out sessions)
                            2.  Audio-visual Equipment and Services                                                                                                                                   -                         0.00%                                                                                                  -                             -   
                            3.  Printing and Distribution                                                                                                                                             -                         0.00%                                                                                                  -                             -   
                            4.  Meals Provided by  DOJ
                                      a.   Breakfast                                                                                                                                                  -                   #NAME?                                                                                                       -                             -   
                                      b.   Lunch                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                                      c.   Dinner                                                                                                                                                     -                   #NAME?                                                                                                       -                             -   
                            5.   Refreshments Provided by DOJ                                                                                                                                         -                   #NAME?                                                                                                       -                             -   
                            6.   M&IE for Attendees                                                                                                                                                   -                   #NAME?                                                                                                       -                             -   
                            7.   Lodging                                                                                                                                                              -                   #NAME?                                                                                                       -                             -   
                            8.   Common Carrier Transportation                                                                                                                                        -                   #NAME?                                                                                                       -                             -   
                            9.   Local Transportation                                                                                                                                                 -                   #NAME?                                                                                                       -                             -   
                            10.  Conference Planner - Logistical                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                            11.  Conference Planner - Programmatic                                                                                                                                    -                   #NAME?                                                                                                       -                             -   
                            12.  Conference                                                                                                                                                           -                   #NAME?                                                                                                       -                             -   
                            Trainer/Instructor/Presenter/Facilitator
                            13.  Other Costs: (Itemize Below)
                                                                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                                                                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                                                                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                                                                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                                                                                                                                                                                                      -                   #NAME?                                                                                                       -                             -   
                            14.  Total Conference Cost:                                                    $                        -     $                           -     $                      -                            0.00%  $                      -     $                           -     $                      -     $                      -   
                            (Auto-populates)
         DOJ-Sponsored Conference Request and Report Form_Version 2                                                                                                   Return To:  JMD Finance Staff, TSG at   Conference.and.Non-Federal.Center@usdoj.gov                                                                                                                                                                                         Attachment 1
         Release Date: 4/1/13                                                                                                                                                                                                                                                                                                                                                                                                         SUBMISSION FORM
                                                                                                                                                                                                                                                                                                                                                                                                                                                           3 of 70
                       C.  MEALS & REFRESHMENTS THRESHOLD CALCULATOR                                                                                                                                                                                                                                                                                                                          
                       CONFERENCE LOCATION:                                                                                     PER DIEM RATE 
                                                                                                            (Use the link to choose the appropriate per diem rate)
                       1.  Continental United States MI&E                                               GSA Per-Diem Rates                                             $59                                    YES
                       2.  Hawaii, Alaska, US Territories &                                            DOD Per-Diem Rates                                                                                      NO
                       Possessions MI&E
                       3.  Foreign Country MI&E                                                  State Department Per-Diem Rates                                                                               NO
                                                                                           NUMBER OF                   NUMBER OF                  PER PERSON                TOTAL JMD 
                       D.  MEALS                                                        TIMES MEAL IS                  ATTENDEES                  THRESHOLD  THRESHOLD ($)
                                                                                              SERVED                                                      ($)
                       1.  Breakfast                                                                                            0                $                19.50            N/A 
                       2.  Lunch                                                                                                0                $                22.50            N/A 
                       3.  Dinner                                                                                               0                $                34.50            N/A 
                       E.  OTHER THRESHOLDS CALCULATOR
                                                                                           NUMBER OF                  PER PERSON                   TOTAL JMD 
                       COST CATEGORY:                                                      ATTENDEES                THRESHOLD ($) THRESHOLD 
                                                                                                                                                          ($)
                       1.  Conference Space & Audio-visual                                          0               $                          25   $                      -                                            0.00                         0.00
                       Equipment and Services
                       2.  Logistical Conference Planner                                            0               $                          50   $                      -   
                       3.  Programmatic Conference Planner                                          0               $                        200   $                      -   
                       F. JUSTIFICATION IF SUBMITTING CONFERENCE REQUEST FORM WITH ESTIMATED COSTS OVER THRESHOLD (Complete if cells turn YELLOW): 
                       1. Conference Space & Audio-visual 
                       Equipment and Services
                       2. Refreshments
                       3. Logistical Conference Planner
                       4. Programmatic Conference Planner
       DOJ-Sponsored Conference Request and Report Form_Version 2                                                                         Return To:  JMD Finance Staff, TSG at   Conference.and.Non-Federal.Center@usdoj.gov                                                                                                                                            Attachment 1
       Release Date: 4/1/13                                                                                                                                                                                                                                                                                                                                    SUBMISSION FORM
                                                                                                                                                                                                                                                                                                                                                                                 4 of 70
The words contained in this file might help you see if this file matches what you are looking for:

...Department of justicesponsored conference request and report a red cell indicates that your entry exceeds the doj meal threshold cannot be submitted unless within ayellow additional justification must provided agrey box no is required jmd finance staff use only tracking number date received component internal for federal optional cacontract recipient poc name phone email cost per div actual ojp average attendee general information requestor drop down office justice programs this submission or if resubmission previously disapproved indicate original official title abbreviations blanket yn yes please enter length skip na conferene below days sections c d e each occurrences fiscal year locations start end dates mmddyyyy location country united states continental state territory possession dojsponsored form version return to tsg at conferenceandnonfederalcenter usdojgov attachment release city essential accomplishing core mission funding appropriation symbol facility specific type federaln...

no reviews yet
Please Login to review.