Spreadsheet: 1acc295a-09f3-49e4-a55e-4bfae3d807ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Community Legal Services PA Food Stamp Estimator Worksheet | KEY
 | Revised on October 2012 | Enter Your Data
 |  | Calculated Data
 | www.clsphila.org | Based on Chart
 | 1.  HOUSEHOLD INFORMATION
 | 1.1  Total Number of Persons in the Household     (See 'Help' tab sheet for Definitions) | 1
 | 1.4  Is there at least one Elderly (60 or over) OR Disabled person in the Household? |  | << Enter 'y' or 'n' |  |  | 0 | HH_EldCode, 1=y, 0=n
 | 1.6  Is the Household Homeless? |  | << Enter 'y' or 'n' |  |  | 0 | HH_HomlessCode, 2=y, 0=n
 | 1.7  Is every member of the household receiving TANF, GA or SSI? |  | << Enter 'y' or 'n' |  |  | 0 | HH_EveryMemberISCode, 4=y, 0=n
 |  |  |  |  |  | 0 | HH_Status.  See the table on Data sheet for what this means. |  |  |  |  |  | HH_StatusTable
 | 2. INCOME INFORMATION |  |  |  |  | 0 | Household is Categorically Eligible 1=true, 0=false
 | 2.1  Monthly Gross Earned Income (GEI) before taxes (from any kind of job). |  |  |  |  |  | Gross Income for this HH (Used for Eligibility, not to calc the Benefit)
 | 2.2  Compute Monthly Earned Income Disregard (EID) (percentage is displayed) | 0 | 0.2 |  |  | 1490 | Gross Income Limit for a HH of this size/type
 | 2.3      (2.1  minus  2.2)  = | 0 |  |  |  |  | The Gross Inc Limit is calculated twice based on HH size on the Data sheet.
 | 2.4  Enter the total amount of all Unearned Income received per month (TANF, SSI, child support, pension, SS, worker’s compensation, etc). | 0 |  |  |  |  | Depending on if the HH is Eld/Dis, the appropriate number is returned and used as the GIL here.
 | 2.5  Total Gross Household Income | 0
 | (2.3  minus  2.4)            TOTAL UNADJUSTED INCOME | 0 |  |  |  | Gross income limit for a Eld/Dis family is...
 | Eligibility is based on Income. | P R O C E E D. | 1 |  |  | n
 | 2.6  The standard deduction for a household with 1 member is | 149 |  |  |  | ELIG: The Gross Income Limit for this family of 1 is  $1490
 | 2.7  Enter the monthly Dependent Care Costs. | 0 |  |  |  | Client is eligible for benefits based on income.  PROCEED...
 | Note:  These are the costs to care for dependents to enable a household member to 1) Work, 2) Look for work or 3) Attend job training.  Also, the CCIS co-pay may be deducted as a DC cost.
 | 2.8  Court ordered child support paid per month. | 0
 | 2.9  Monthly (unreimbursed) medical expenses for all Elderly and Disabled household members. | 0
 | 2.10  The Monthly medical expenses minus the  $35 monthly medical allowance is | 0
 | TOTAL ADJUSTED INCOME | 0
 | 3. EXCESS SHELTER COSTS
 | 3.1  Utility Expenses
 | Does Client pay any portion of  Heat or Cooling expenses? |  | << Enter 'y' or 'n'
 | Does Client pay 2 utilities (may include phone), but NOT Heat or [NAME]?
 | Does Client pay 1 utility (not the phone), but NOT Heat or [NAME]?
 | Does Client pay only the phone?
 | Client pays No Utility costs | 0
 | 3.2  Household's monthly rent/mortgage  (if any)
 | 3.3  Monthly fire insurance  (if not included in rent/mortgage payment)
 | 3.4  Property tax paid  (if not included in rent/mortgage payment)
 | 3.5  Unadjusted Shelter Costs   (3.1  +  3.2  +  3.3  +  3.4)  = | 0
 | 3.6  Total Adjusted Income (from [NAME]. 2) * 1/2 = | 0
 | 3.7  Unadjusted Shelter Costs minus Half of Total Adjusted Income (3.5 - 3.6) | 0
 | TOTAL EXCESS SHELTER DEDUCTION | 0
 |  | The Total Excess Shelter Deduction is capped at  $469
 | 4.  BENEFIT CALCULATION
 | 4.1  Total Net Income  (Total Adjusted Income - Total Excess Shelter Deduction) | 0 |  |  |  | 200 | Initial [NAME]
 | 4.2  Maximum Monthly Benefit for a household with  1  member | 200 |  |  |  | 200 | [NAME] (after Min test)
 | 4.3  30% of Total Net Income    (4.1 * .3) | 0
 | (4.2 minus 4.3)            ESTIMATED MONTHLY BENEFIT | 200
 |  | Based on data that was current as of
 |  | October 2012