{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FY27 & FY26 SUMMARY","FY27 ES90","FY27 ES10 "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FY27 & FY26 SUMMARY","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,8],[32,0,32,8],[31,0,31,8],[34,0,34,2],[34,7,34,8]]}
[null,null,null,"      ATTACHMENT",null," "]
[null,null,null,null,"Commonwealth of Massachusetts "]
[null,null,null,null,"Wagner-Peyser 90% and 10% Funds"]
[null,"FISCAL YEAR 2027 AND FISCAL YEAR 2026 COMPARED"]
[]
[]
["MassHire","FY 2026","FY 2026","FY 2026","FY 2027","FY 2027","FY 2027","Change ","% Change "]
["Workforce","90%","10%","Total","90%","10%","Total","from","from"]
["Area",null,null,null,null,null,null,"FY 2026","FY 2026"]
[null,"Allocation","Allocation","Allocation","Allocation","Allocation","Allocation"]
[]
["Berkshire",169368.47400000002,14584.498500000002,{"$f":"B12+C12","v":183952.97250000003},177634.66049172005,15326.28189,{"$f":"E12+F12","v":192960.94238172006},{"$f":"G12 -D12","v":9007.969881720026},{"$f":"H12/D12","v":4.8968873725158339E-2}]
["Boston",1040435.66816,89593.016240000012,{"$f":"B13+C13","v":1130028.6843999999},1112382.9044207102,95772.937409999999,{"$f":"E13+F13","v":1208155.8418307102},{"$f":"G13 -D13","v":78127.157430710271},{"$f":"H13/D13","v":6.9137322361151096E-2}]
["Bristol",578213.70548,49790.593970000002,628004.29945000005,610131.7332621091,52517.9349,662649.6681621091,34645.368712109048,5.5167406883123445E-2]
["Brockton",387905.12923999998,33402.921109999996,421308.05034999998,405093.67697502003,34924.893120000001,440018.57009502006,18710.519745020079,4.4410544088764478E-2]
["Cape & Islands",388623.66215999995,33464.794739999998,422088.45689999993,406176.81514875003,34952.877810000005,441129.69295875006,19041.236058750132,4.5111956386102568E-2,null," "]
["Central MA",892315.23907999997,76838.209369999997,969153.44845000003,948829.04018748004,81696.638340000005,1030525.67852748,61372.230077479966,6.3325606667999426E-2]
["Franklin/Hampshire",336581.34924000001,28983.376110000001,365564.72535000002,354186.18280971004,30465.999180000003,384652.18198971002,19087.456639709999,5.2213617223147643E-2]
["Greater Lowell",442924.22139999998,38140.673349999997,481064.89474999998,468998.82922509004,40391.2359,509390.06512509007,28325.170375090092,5.8880144205513331E-2]
["Greater New Bedford",328164.24932,28258.570729999999,356422.82004999998,343354.80107241002,29570.489099999999,372925.29017241002,16502.470122410043,4.6300262480654379E-2]
["Hampden",644216.08655999997,55474.128839999998,699690.21539999999,670462.52953887009,57769.728389999997,728232.25792887004,28542.04252887005,4.0792399122736182E-2]
["Merrimack Valley",548753.85576000006,47253.775139999998,596007.63090000011,569730.67938197998,49029.176879999999,618759.85626198002,22752.225361979916,3.8174386001774786E-2]
["Metro North",1256714.07708,108216.97886999999,1364931.05595,1336592.50638282,115101.02997,1451693.53635282,86762.480402820045,6.3565467299322928E-2]
["Metro South/West",1385331.46976,119292.35863999999,1504623.8284,1458987.1200143099,125623.27341000001,1584610.3934243098,79986.565024309792,5.3160506642624825E-2]
["North Central",383491.28415999998,33022.840239999998,416514.12439999997,408343.09149621002,35195.411789999998,443538.50328621001,27024.378886210034,6.488226281675176E-2]
["North Shore",639494.29879999999,55067.530700000003,694561.82949999999,673711.94406005996,58012.262370000004,731724.20643005997,37162.376930059982,5.3504778626853669E-2]
["South Shore",842223.22979999997,72524.73345,914747.96325000003,888173.30245860014,76472.829539999992,964646.13199860009,49898.168748600059,5.4548543154244684E-2]
[]
[null,10264756,883909,{"$f":"SUM(D12:D28)","v":11148665},10832790,932823,11765612.816925852,616947.81692585163,5.5338268476615958E-2]
[]
["Note per 29 U.S. Code § 49f(c) and 20 CFR 652.205: WP90% and WP10% funds authorized under the Wagner-Peyser Act (Section 7) may be used per subsection 7(c) to provide additional funding for other activities authorized under the Workforce Innovation and Opportunity Act provided the activities meet requirements defined in subsection 7(c)(1)(A-D)."]
["1. Source for FY 2027 State Allotments: Training and Employment Guidance Letter (TEGL) 10-25, issued April 28, 2026"]
["2.Source for FY 2026 State Allotments: Training and Employment Guidance Letter (TEGL) 11-24, issued May 20, 2025"]
["SSTA /  Employment Service 90% Retained DCSL_FESS90C_RTND_EOL238",null,null,null,"Employment Service 10% Retained DCSL_FESS90C_RTND_EOL239"]
["MassHire Department of Career Services",null,null,null,null,null,"Date:","2026-06-08"]

{"sheet":"FY27 ES90","index":1,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,1],[37,0,37,11]]}
[null,null,null,null,null,"    ATTACHMENT "]
[null,null,null,null,"Commonwealth of Massachusetts"]
[null,null,null,null,null,"Wagner-Peyser 90% Funds"]
[null,null,null,null,null,"    Formula Allocations"]
[null,null,null,null,null,"   FISCAL YEAR 2027"]
[]
[null,null,null,null,null,null,null,null,"FY2027","FY 2027"]
["MassHire",null,"Final",null,null,null,null,"FY 2027","Hold","Hold","Final",null,"Change ","% Change"]
["Workforce","FY 2026","FY 2026","CY 2025","Labor","CY 2025",null,"Weighted","Harmless","Harmless","FY 2027","FY 2027","from  ","from "]
["Area","Allocation","Formula","Labor","Force","Number of","Unemployed","Formula","Upper","Lower","Formula","Allocation","FY 2026","FY 2026"]
[null,null,"Share","Force","Share","Unemployed","Share","Share","Share","Share","Share"]
[]
["Berkshire",169368,1.6500000000000001E-2,65335,{"$f":"ROUND(D13/$D$30,5)","v":1.6559999999999998E-2},2879,{"$f":"ROUND(F13/$F$30,5)","v":1.618E-2},{"$f":"ROUND((E13*2+G13)/3,5)","v":1.643E-2},{"$f":"ROUND(C13*1.1,5)","v":1.8149999999999999E-2},{"$f":"ROUND(C13*0.9,5)","v":1.485E-2},1.6400000000000001E-2,177634.66049172005,{"$f":"L13-B13","v":8266.6604917200457},{"$f":"M13/B13","v":4.880886880473316E-2},null,null,null,180636.05651830439]
["Boston",1040436,0.10136000000000001,408983,{"$f":"ROUND(D14/$D$30,5)","v":0.10369},17909,{"$f":"ROUND(F14/$F$30,5)","v":0.10063},{"$f":"ROUND((E14*2+G14)/3,5)","v":0.10267},{"$f":"ROUND(C14*1.1,5)","v":0.1115},{"$f":"ROUND(C14*0.9,5)","v":9.1219999999999996E-2},0.1027,1112382.9044207102,71946.904420710169,6.9150725677225869E-2,null,null,null,1073434.9565513034]
["Bristol",578214,5.6329999999999998E-2,215833,5.4719999999999998E-2,10580,5.9450000000000003E-2,5.6300000000000003E-2,6.1960000000000001E-2,5.0700000000000002E-2,5.6329999999999998E-2,610131.7332621091,31917.733262109105,5.5200554227516289E-2,null,null,null,579384.96059118211]
["Brockton",387905,3.7789999999999997E-2,143645,3.6420000000000001E-2,7027,3.9480000000000001E-2,3.7440000000000001E-2,4.1570000000000003E-2,3.4009999999999999E-2,3.7400000000000003E-2,405093.67697502003,17188.676975020033,4.43115633338576E-2,null,null,null,390547.61185164441]
["Cape & Islands",388624,3.7859999999999998E-2,139634,3.5400000000000001E-2,7405,4.1610000000000001E-2,3.7470000000000003E-2,4.165E-2,3.4070000000000003E-2,3.7499999999999999E-2,406176.81514875003,17552.815148750029,4.5166575272628628E-2,null,null,null,394492.53722388297]
["Central MA",892315,8.6929999999999993E-2,345720,8.7650000000000006E-2,15563,8.745E-2,8.7580000000000005E-2,9.5619999999999997E-2,7.8240000000000004E-2,8.7599999999999997E-2,948829.04018748004,56514.040187480045,6.333418152499963E-2,null,null,null,887608.20875373739]
["Franklin/Hampshire",336581,3.279E-2,131150,3.3250000000000002E-2,5602,3.1480000000000001E-2,3.2660000000000002E-2,3.6069999999999998E-2,2.9510000000000002E-2,3.27E-2,354186.18280971004,17605.182809710037,5.2305931736224082E-2,null,null,null,367500.94257172284]
["Greater Lowell",442924,4.3150000000000001E-2,169704,4.3029999999999999E-2,7801,4.3830000000000001E-2,4.3299999999999998E-2,4.7469999999999998E-2,3.884E-2,4.3299999999999998E-2,468998.82922509004,26074.829225090041,5.8869759202684981E-2,null,null,null,437056.20571382856]
["Greater New Bedford",328164,3.1969999999999998E-2,116276,2.9479999999999999E-2,6433,3.6150000000000002E-2,3.1699999999999999E-2,3.517E-2,2.877E-2,3.1699999999999999E-2,343354.80107241002,15190.801072410017,4.6290272767305421E-2,null,null,null,356081.42175734718]
["Hampden",644216,6.2759999999999996E-2,227686,5.7729999999999997E-2,12519,7.034E-2,6.1929999999999999E-2,6.9040000000000004E-2,5.6480000000000002E-2,6.1899999999999997E-2,670462.52953887009,26246.529538870091,4.0741815693602905E-2,null,null,null,675828.00455986313]
["Merrimack Valley",548754,5.3460000000000001E-2,202563,5.1360000000000003E-2,9781,5.4960000000000002E-2,5.2560000000000003E-2,5.8810000000000001E-2,4.811E-2,5.2600000000000001E-2,569730.67938197998,20976.679381979979,3.8226016360664306E-2,null,null,null,539831.89304320863]
["Metro North",1256714,0.12243,506597,0.12844,20162,0.11329,0.12339,0.13467000000000001,0.11019,0.1234,1336592.50638282,79878.506382819964,6.3561404092593837E-2,null,null,null,1251994.736557903]
["Metro South/West",1385331,0.13496,553066,0.14022000000000001,21993,0.12358,0.13467000000000001,0.14846000000000001,0.12146,0.13469999999999999,1458987.1200143099,73656.120014309883,5.3168607368426664E-2,null,null,null,1371380.6359809204]
["North Central",383491,3.7359999999999997E-2,144942,3.6749999999999998E-2,7062,3.968E-2,3.773E-2,4.1099999999999998E-2,3.3619999999999997E-2,3.7699999999999997E-2,408343.09149621002,24852.091496210021,6.4804888501190441E-2,null,null,null,387225.56943291699]
["North Shore",639494,6.2300000000000001E-2,245552,6.2260000000000003E-2,11042,6.2039999999999998E-2,6.2190000000000002E-2,6.8529999999999994E-2,5.6070000000000002E-2,6.2199999999999998E-2,673711.94406005996,34217.944060059963,5.3507842231608059E-2,null,null,null,647798.27165185031]
["South Shore",842223,8.2049999999999998E-2,327510,8.3040000000000003E-2,14212,7.986E-2,8.1979999999999997E-2,9.0260000000000007E-2,7.3849999999999999E-2,8.2000000000000003E-2,888173.30245860014,45950.302458600141,5.4558356229407343E-2,null,null,null,840891.9872403827]
[]
[null,10264756,{"$f":"SUM(C13:C28)","v":0.99999999999999989},{"$f":"SUM(D13:D28)","v":3944196},1,177970,1.0000100000000001,1,1.1000300000000003,0.89998999999999985,1.00013,10832790,568034,5.5338285683556435E-2,null,null,null,10381694]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Program Name","ES 90%"]
["* Labor force and unemployed data are for calendar year 2025 (CY25), January 2025 to December 2025, not seasonally adjusted. ",null,null,null,null,null,null,null,null,null,null,"Service Dates"," 7/1/2026-6/30/2027"]
["Note: The allocation methodology for ES Wagner Peyser 90% and 10% funds is based on two factors: ",null,null,null,null,null,null,null,null,null,null,"SSTA ","DCS_FESS90_EOL004"]
["1) Number of individuals in the local workforce area's labor force (2/3 weight). ",null,null,null,null,null,null,null,null,null,null,"Phase Code","K105"]
["2) Number of unemployed individuals in the local workforce area (1/3 weight).",null,null,null,null,null,null,null,null,null,null,"Appropriation",70026626]
["Hold Harmless:  Share cannot be less than 90% and not more than 110% of prior year's share.  "]
["Note per 29 U.S. Code § 49f(c) and 20 CFR 652.205: WP90% and WP10% funds authorized under the Wagner-Peyser Act may be used per Section 7(c) to provide additional funding for other activities authorized under the Workforce Innovation and Opportunity Act provided the activities meet requirements defined in Section 7(c)(1-4)."]
["MassHire Department of Career Services",null,null,null,"Based on 80% Local Share of State Wagner-Peyser 90% Allotment",null,null,null,null,null,"Date: June 6, 2026"]

{"sheet":"FY27 ES10 ","index":2,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,11,41,13]]}
[null,null,null,null,null,"    ATTACHMENT "]
[null,null,null,null,"Commonwealth of Massachusetts"]
[null,null,null,null,null,"Wagner-Peyser 10% Funds"]
[null,null,null,null,null,"    Formula Allocations"]
[null,null,null,null,null,"    FISCAL YEAR 2027"]
[]
[]
[null,null,null,null,null,null,null,null,"FY 2027","FY 2027"]
["MassHire",null,"Final ",null,null,null,null,"FY 2027","Hold","Hold","Final ",null,"Change","% Change"]
["Workforce","FY 2026","FY 2026","CY 2025","Labor","CY2025",null,"Weighted","Harmless","Harmless","FY 2027","FY 2027","from ","from"]
["Area","Allocation","Formula","Labor","Force","Number of","Unemployed","Formula","Upper","Lower","Formula","Allocation","FY 2026","FY 2026"]
[null,null,"Share","Force ","Share","Unemployed","Share","Share","Share","Share","Share"]
[]
["Berkshire",14584.4985,1.6500000000000001E-2,65335,{"$f":"ROUND(D14/$D$31,5)","v":1.6559999999999998E-2},2879,{"$f":"ROUND(F14/$F$31,5)","v":1.618E-2},{"$f":"ROUND((E14*2+G14)/3,5)","v":1.643E-2},{"$f":"ROUND(C14*1.1,5)","v":1.8149999999999999E-2},{"$f":"ROUND(C14*0.9,5)","v":1.485E-2},1.643E-2,{"$f":"K14*$L$31","v":15326.28189},{"$f":"L14-B14","v":741.78339000000051},{"$f":"M14/B14","v":5.0861083087635858E-2}]
["Boston",89593.016240000012,0.10136000000000001,408983,{"$f":"ROUND(D15/$D$31,5)","v":0.10369},17909,{"$f":"ROUND(F15/$F$31,5)","v":0.10063},{"$f":"ROUND((E15*2+G15)/3,5)","v":0.10267},{"$f":"ROUND(C15*1.1,5)","v":0.1115},{"$f":"ROUND(C15*0.9,5)","v":9.1219999999999996E-2},0.10267,{"$f":"K15*$L$31","v":95772.937409999999},{"$f":"L15-B15","v":6179.9211699999869},{"$f":"M15/B15","v":6.8977710868058456E-2}]
["Bristol",49790.593970000002,5.6329999999999998E-2,215833,5.4719999999999998E-2,10580,5.9450000000000003E-2,5.6300000000000003E-2,6.1960000000000001E-2,5.0700000000000002E-2,5.6300000000000003E-2,52517.9349,2727.3409299999985,5.477622804908263E-2]
["Brockton",33402.921109999996,3.7789999999999997E-2,143645,3.6420000000000001E-2,7027,3.9480000000000001E-2,3.7440000000000001E-2,4.1570000000000003E-2,3.4009999999999999E-2,3.7440000000000001E-2,34924.893120000001,1521.972010000005,4.5564039294286894E-2]
["Cape & Islands",33464.794739999998,3.7859999999999998E-2,139634,3.5400000000000001E-2,7405,4.1610000000000001E-2,3.7470000000000003E-2,4.165E-2,3.4070000000000003E-2,3.7470000000000003E-2,34952.877810000005,1488.0830700000079,4.4467120792506254E-2]
["Central MA",76838.209369999997,8.6929999999999993E-2,345720,8.7650000000000006E-2,15563,8.745E-2,8.7580000000000005E-2,9.5619999999999997E-2,7.8240000000000004E-2,8.7580000000000005E-2,81696.638340000005,4858.4289700000081,6.3229336157550914E-2]
["Franklin/Hampshire",28983.376110000001,3.279E-2,131150,3.3250000000000002E-2,5602,3.1480000000000001E-2,3.2660000000000002E-2,3.6069999999999998E-2,2.9510000000000002E-2,3.2660000000000002E-2,30465.999180000003,1482.6230700000015,5.115425699107768E-2]
["Greater Lowell",38140.673349999997,4.3150000000000001E-2,169704,4.3029999999999999E-2,7801,4.3830000000000001E-2,4.3299999999999998E-2,4.7469999999999998E-2,3.884E-2,4.3299999999999998E-2,40391.2359,2250.5625500000024,5.9006890868118417E-2]
["Greater New Bedford",28258.570729999999,3.1969999999999998E-2,116276,2.9479999999999999E-2,6433,3.6150000000000002E-2,3.1699999999999999E-2,3.517E-2,2.877E-2,3.1699999999999999E-2,29570.489099999999,1311.9183699999994,4.6425503346750455E-2]
["Hampden",55474.128839999998,6.2759999999999996E-2,227686,5.7729999999999997E-2,12519,7.034E-2,6.1929999999999999E-2,6.9040000000000004E-2,5.6480000000000002E-2,6.1929999999999999E-2,57769.728389999997,2295.599549999999,4.1381443891097956E-2]
["Merrimack Valley",47253.775139999998,5.3460000000000001E-2,202563,5.1360000000000003E-2,9781,5.4960000000000002E-2,5.2560000000000003E-2,5.8810000000000001E-2,4.811E-2,5.2560000000000003E-2,49029.176879999999,1775.4017400000012,3.7571638133460698E-2]
["Metro North",108216.97886999999,0.12243,506597,0.12844,20162,0.11329,0.12339,0.13467000000000001,0.11019,0.12339,115101.02997,6884.0511000000115,6.3613410500673429E-2]
["Metro South/West",119292.35863999999,0.13496,553066,0.14022000000000001,21993,0.12358,0.13467000000000001,0.14846000000000001,0.12146,0.13467000000000001,125623.27341000001,6330.9147700000176,5.3070580900369549E-2]
["North Central",33022.840239999998,3.7359999999999997E-2,144942,3.6749999999999998E-2,7062,3.968E-2,3.773E-2,4.1099999999999998E-2,3.3619999999999997E-2,3.773E-2,35195.411789999998,2172.5715500000006,6.5789966405385147E-2]
["North Shore",55067.530700000003,6.2300000000000001E-2,245552,6.2260000000000003E-2,11042,6.2039999999999998E-2,6.2190000000000002E-2,6.8529999999999994E-2,5.6070000000000002E-2,6.2190000000000002E-2,58012.262370000004,2944.731670000001,5.3474917661416058E-2]
["South Coastal",72524.73345,8.2049999999999998E-2,327510,8.3040000000000003E-2,14212,7.986E-2,8.1979999999999997E-2,9.0260000000000007E-2,7.3849999999999999E-2,8.1979999999999997E-2,76472.829539999992,3948.0960899999918,5.4437926238252062E-2]
[]
[null,883909,0.99997000000000003,{"$f":"SUM(D14:D29)","v":3944196},1,177970,1.0000100000000001,1,1.1000300000000003,0.89998999999999985,0.99997000000000003,932823,48914,5.5338275772732259E-2]
[]
["* Labor force and unemployed data are for calendar year 2025 (CY25), January 2025 to December 2025, not seasonally adjusted. ",null,null,null,null,null,null,null,null,null,null,"Program Name","ES 10%"]
["Note: The allocation methodology for ES Wagner Peyser 90% and 10% funds is based on two factors: ",null,null,null,null,null,null,null,null,null,null,"Service Dates","   7/1/2026-6/30/2027"]
["1) Number of individuals in the local workforce area's labor force (2/3 weight). ",null,null,null,null,null,null,null,null,null,null,"SSTA ","DCSL_FESS10_EOL118"]
["2) Number of unemployed individuals in the local workforce area (1/3 weight).",null,null,null,null,null,null,null,null,null,null,"Phase Code","K107"]
["Hold Harmless:  Share cannot be less than 90% and not more than 110% of prior year's share.  ",null,null,null,null,null,null,null,null,null,null,"Appropriation",70026626]
[]
["Note per 29 U.S. Code §  49f(c) 20 CFR 652.205: WP90% and WP10% funds authorized under the Wagner-Peyser Act may be used peer Secion 7(c) to provide  addition funding for "]
["other activities authorized under the Workforce Innovaiton and Opportunity Act provided the actifities meet requirements defined in Section 7(c)(1-4)         "]
[null," "]
["                      MassHire Department of Career Services",null,null,null,"Based on 62% Local Share of State Wagner-Peyser 10% Allotment",null,null,null,null,null,"Date: ","2026-06-08"]