jagomart
digital resources
picture1_House Building Spreadsheet 32762 | F01715


 221x       Filetype XLSX       File size 0.02 MB       Source: www.dhs.wisconsin.gov


File: House Building Spreadsheet 32762 | F01715
calculating expenses for a clts foster home using actual expenses person completing this form date completed demographic information participant name age foster home name number of occupants in home type ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
                  CALCULATING EXPENSES FOR A CLTS FOSTER HOME USING ACTUAL 
                                                          EXPENSES
                      Person completing this form:
                                  Date Completed:
                                                    Demographic Information 
                    Participant Name:                                                           Age:
                  Foster Home Name:
                   Number of Occupants in Home:
                       Type of Home:Place an 'x' next to type of home          Facility Total Monthly
                                                                                                   1
                                 Foster Home:                                Room and Board Rate :             #DIV/0!
                                                                             1
                                                                              This rate is calculated automatically in Section 3.
                   Level 5  Treatment Foster Home:
                                                                Child Welfare Rates:           Basic:
                                                                                      Supplemental:
                                                                                        Exceptional:
                              1. Calculation of Housing and Food Expenses: Using Actual Expenses
                                                                    Total Household        Total         Individual
                               Type of Expense                            Cost          Occupants         Amount
                    Rent, or Depreciation and Mortgage Interest, 
              Insurance (Title, Mortgage, Property and Casualty), 
                     Building and/or Grounds Maintenance Costs                               0                 #DIV/0!
                                  Food Budget for the Household                              0                 #DIV/0!
                                          Furnishings Supplied by
                                   Facility and Used by Residents                            0                 #DIV/0!
                                              Household Supplies                             0                 #DIV/0!
                                                         Electricity                         0                 #DIV/0!
                                                 Water and Sewer                             0                 #DIV/0!
                                                      Heating Fuel                           0                 #DIV/0!
                                                 House Telephone                             0                 #DIV/0!
                                                  Cable Television                           0                 #DIV/0!
                                                                                            1. Total=          #DIV/0!
                                                                                                                              1 of 3
                                           2. Calculation of Participant- Specific Expenses
                             Complete this section only if this child has participant-specific expenses.
                                     If no specific expenses are needed, continue to Section #3.
                                                     Special Dietary Needs, Exceptional Utility Costs,
                                                          Personal Supplies, Other Personal Expenses
                                                                                               2. Total= 
                                                   3. Total Monthly Rate Summary
                                                                        Room and Board Expenses 1.=                 #DIV/0!
                                                      (If Applicable) Participant-Specific Expenses 2.=               $0.00
                                                                                                       2
                                                                               3. Total Monthly Rate =              #DIV/0!
                                                 2
                                                  This total is automatically placed in the "Facility Total Monthly Room & Board Rate."
                                4. Calculation of Housing and Food Expenses: Using the Basic Rate
             Use the Uniform Foster Care brochure to determine the percentage of Housing expenses and the percentage of Food expenses 
                                             applied to the Basic Rate based upon the child's age.
                                                                                                          Room and Board 
                                                                                                          Portion of Basic 
                                                                          Percentage        Basic Rate          Rate 
                                                             Housing                               $0.00              $0.00
                                                                Food                               $0.00              $0.00
                                                                 4.Total Basic Rate Room and Board =                  $0.00
                                                 5. Foster Care Checks and Balances
                                                                                                             Child Welfare 
                                                                                          Basic Rate Room   portion of Basic 
                                                                           Basic Rate         & Board            Rate
                                Child Welfare portion of Basic Rate
                                 (= Basic Rate minus Basic Rate Room & Board)      $0.00           $0.00              $0.00
                                                                                           Monthly Rate - 
                                                                                          Reduced Excep.    CLTS portion of  
                                                                        Exceptional Rate        rate          Excep. Rate
                                   CLTS portion of Exceptional Rate
                (= Exceptional Rate minus the difference between the Monthly Rate- $0.00         #DIV/0!            #DIV/0!
                                                     Household Expenses)
                                                  Supplemental rate                                                   $0.00
                                                                                                                                    2 of 3
                                                             6. Balancing of Expenses
                In the section below, the Foster Care/Child Welfare total should equal the CLTS Waiver Expenses total. This assures that the 
                               CLTS Waivers are not paying more for foster care than the total calculated by Child Welfare.
                                CLTS Waiver Expenses                                        Foster Care/Child Welfare
                                         Room & Board=              #DIV/0!                            Basic Rate=                 $0.00
                Child Welfare portion of Basic Rate=                   $0.00                 Supplemental Rate=                    $0.00
                                    Supplemental Rate=                 $0.00                   Exceptional Rate=                   $0.00
                  CLTS Allowable portion of Exceptional Rate        #DIV/0!
                                                    TOTAL           #DIV/0!                                  TOTAL                 $0.00
                                                      *The two totals above must match.*
                                                            7.  Information for the ISP
                                                                                                                             CLTS
                                                    Expense                                            Amount            Allowable?
                                                                                  Room & Board              #DIV/0!            N
                                                         Child Welfare portion of Basic Rate                  $0.00            N
                                                                            Supplemental Rate                 $0.00            Y
                                                CLTS Allowable portion of Exceptional Rate                  #DIV/0!            Y
                                                                    CLTS Administrative Costs3                                 Y
                                                         Child Welfare Administrative Costs3                                   N
                                                               3
                                                                 Administrative costs are only used for Level 5 and Treatment Foster Homes.
                                                                                                                                                   3 of 3
The words contained in this file might help you see if this file matches what you are looking for:

...Calculating expenses for a clts foster home using actual person completing this form date completed demographic information participant name age number of occupants in type homeplace an x next to facility total monthly room and board rate div is calculated automatically section level treatment child welfare rates basic supplemental exceptional calculation housing food household individual expense cost amount rent or depreciation mortgage interest insurance title property casualty building andor grounds maintenance costs budget the furnishings supplied by used residents supplies electricity water sewer heating fuel house telephone cable television specific complete only if has participantspecific no are needed continue special dietary needs utility personal other summary applicable placed use uniform care brochure determine percentage applied based upon s portion checks balances minus reduced excep difference between balancing below carechild should equal waiver assures that waivers not...

no reviews yet
Please Login to review.