One-Year Implementation Schedule for QMIS Rents in 2010 A 1-year implementation schedule is authorized by 400 DM 3, "DOI Housing Management Handbook" for QMIS Rents if the following conditions exist: 1 The Tenant is a federal employee, living in this Quarter on March 14, 2010 and 2 The monthly net rent increase (2009 to 2010) is $100.00 or more (see TENANT RENT NOTICE) OR the biweekly net rent increase (2009 to 2010) is $46.15 or more (see TENANT RENT NOTICE) OR the daily net rent increase (2009 to 2010) is $3.33 or more (see TENANT RENT NOTICE) OR the monthly, biweekly or daily increase is 25% or more. However, if the increase is 25% or more, QMIS will automatically print the four increments on the TENANT RENT NOTICE and you will not require this spreadsheet. Only increases that are +$100 per month -- but NOT 25% -- will require this spreadsheet. 1-year implementation is not authorized for non-federal tenants. Tenants moving into the housing units on March 15, 2010, or after, will pay the full 2010 rental rate immediately. Instructions: 1 Before you utilize this worksheet, you must have calculated and printed the 2010 rents (in draft or final form), and have the printed rent calculations in front of you. 2 On the TENANT RENT NOTICE, verify the "previous net bi-weekly" rent was effective on 3/1/2009 or after. If the previous new rent is not a 2009 rent calculation, this 1-year implementation does not apply. 3 If the increase on the TENANT RENT NOTICE is $46.15 or more bi-weekly, but is not 25%, the tenant is eligible. Create a list of TENANTS that are eligible for the 1-year Implementation. Units with a 25% or more increase are also eligible, but QMIS will print the 4 increments automatically on the TENANT RENT NOTICE. 4 Copy the attached worksheet for each eligible TENANT in your installation. Click on the "1-Yr Implementation" worksheet tab, then Edit Menu -- Move or Copy Sheet Click on "Move to End" and check the "Create a Copy" box. Repeat to copy a worksheet for each eligible tenant. Rename each worksheet with Tenant's Name. For example, double-click on "1-Yr Implementation (2)" and change worksheet name to JOHN DOE. Change "1-Yr Implementation (3)" to JANE SMITH, etc. DO NOT use the original "1-Yr Implementation" worksheet, as this is your template. SAVE the workbook in your C:/QMIS folder. 5 Go to the first eligible tenant's worksheet Enter the Tenant Name in A Enter the housing Installation in B Enter the eligible Quarter Number in C Enter the 2009 (previous year's) biweekly payroll deduction in D Enter whether the tenant's payroll deduction is biweekly or daily Enter the 2010 (new year's) payroll deduction in E - the QMIS 2010 Net Rent Double-check that the 09-10 Increase is eligible, according to the requirements above 6 Double-check the pay periods and effective dates in F. If necessary, adjust the dates to your agency's schedule. 7 Per OMB Circular A-45, you should implement the new rental rate on March 14, 2010 If you are unable to complete the rent calculations and payroll deduction forms in time, this will NOT extend the 1-year implementation period for your tenant. The timeline set out in the attached worksheet will remain, even if you are unable to complete the process on time. So, for example, if you do not implement the new rent until April 25, 2010, the tenant's 2nd increment will still take effect on June 20, 2010. 8 Therefore, DRAFT OR FINAL TENANT RENT NOTICES, AND A COPY OF THE ONE-YEAR EXCEL WORKSHEET, IF APPLICABLE, SHOULD BE PROVIDED TO YOUR TENANTS NO LATER THAN FEBRUARY 11, 2010, IN ORDER TO MEET THE EFFECTIVE DATE ESTABLISHED BY A-45 FOR 2010. AND THE 30-DAY NOTICE REQUIRED. You cannot back-charge tenants for your failure to meet this federal deadline. So, if you are unable to distribute rents by 2/11/2010, you cannot use 3/14/2010 as the effective date. 9 Submit the appropriate payroll deduction forms for your bureau/agency, and enter the four rental rates and effective dates indicated on each worksheet. 10 If you distribute DRAFT rents for Tenant signatures, you must remember to return to QMIS and calculate FINAL rents. You do not need to print FINAL rents, or redistribute FINAL rents to tenants, you simply need to run them in QMIS. QMIS does not save DRAFT rents. One-Year Implementation Schedule for QMIS Rents in 2010 Blue = Information to be entered/verified by Housing Manager. Figures provided are only examples. Installation: Tenant Name: Quarter #: Effective March 14, 2010: 2009 Rent: $400.00 biweekly 2010 Rent: $525.00 biweekly 09-10 Increase: $125.00 biweekly Effective + 09-10 Payroll Pay Period Date Increment 2009 Rent Increment = Deduction 1st increment = 25% of 09-10 7 14-Mar-10 increase $400.00 $31.25 $431.25 8 28-Mar-10 $431.25 9 11-Apr-10 $431.25 10 25-Apr-10 $431.25 11 9-May-10 $431.25 12 23-May-10 $431.25 13 6-Jun-10 $431.25 2nd increment = 50% of 09- 14 20-Jun-10 10 increase $400.00 $62.50 $462.50 15 4-Jul-10 $462.50 16 18-Jul-10 $462.50 17 1-Aug-10 $462.50 18 15-Aug-10 $462.50 19 29-Aug-10 $462.50 20 12-Sep-10 $462.50 3rd increment = 75% of 09-10 21 26-Sep-10 increase $400.00 $93.75 $493.75 22 10-Oct-10 $493.75 23 24-Oct-10 $493.75 24 7-Nov-10 $493.75 25 21-Nov-10 $493.75 26 5-Dec-10 $493.75 4th increment = 100% of 09- 10 increase (FULL 2010 1 19-Dec-10 RENT) $400.00 $125.00 $525.00 2 2-Jan-11 $525.00 3 16-Jan-11 $525.00 4 30-Jan-11 $525.00 5 13-Feb-11 $525.00 6 27-Feb-11 $525.00 7 13-Mar-11 NEW 2011 RENT ?
Pages to are hidden for
"Federal Employee Handbook"Please download to view full document