Attachment A: Project Budget Spreadsheet Environment and Natural Resources Trust Fund M.L. 2020 Budget Spreadsheet Legal Citation: Project Manager: Lisa Daniels Project Title: Executive Director Organization: Windustry Project Budget: 2,187,669 Project Length and Completion Date: 3 Year Project -June 2023 Today's Date: April 15, 2019 ENVIRONMENT AND NATURAL RESOURCES TRUST FUND BUDGET Budget Amount Spent Balance BUDGET ITEM Personnel (Wages and Benefits) $605,817 Windustry Project Manager 80% FTE;$82,048 (78% salary, 22% benefits) x 3 yrs Windustry New Hire, Workforce Outreach & Program Specialist, 100% FTE, $66,560 (78% salary, 22% benefits) x 3 yrs Windustry New Hire K-12 Education and Outreach Coordinator, 100% FTE, $53,331(78% salary, 22% benefits) x 3 yrs Professional/Technical/Service Contracts Robert Blake -Solar Bear; 50% FTE, Key partner on outreach, working with Tribal Communities and developing demonstration projects $192,000 Collaborating MN entities with expertise teaching K-12 students and teachers about sustainable energy -Kidwind, ReCharge Labs, Just-B-Solar -instructors, materials, books all inclusive $138,000 Collaborating entity MREA with expertise training solar and wind installers for NABCEP certification -instructors, materials, books all inclusive-One 7-day course per year $76,185 MN entities with expertise training adults in sustainable energy concepts, solar and wind installation, energy efficiency -instructors, materials, equipment, books all inclusive-Six 5­day workshops per year $186,651 Legal Counsel on contracts and finance for demonstrations' at Tribal Communities $90,000 - Equipment/Tools/Supplies Lending library of Tools used in training workshops ($1500x3=4500) $4,500 Capital Expenditures Over $5,000 Purchase and installation of Small Wind turbines, Solar panels, energy efficiency measures, batteries for storage or other equipment as indicated by each respective collaborative team of Windustry Partners and MN Tribal Community members -Four demonstration projects per year x $70,000 =$280,000 x3 years $840,000 Printing $6,900 Outreach Materials design (100 x 18 workshops x 3 =5400) Signage and display materials for workshops and open houses (500 x 3 =1500) $ - Travel expenses in Minnesota $34,116 Travel to MN Tribal Communities (28 Tribal communities visits/year x 300 miles x .58=$4872 x 3= $14,616) Meals and overnight stays for Windustry staff (6 5-day courses =30 x125=3750x3 = 11,250) Meals and overnight stays for Windustry staff (22 visits x 1 night x 125=2750 x 3=8250) Other Meeting supplies for open houses, training sessions, workshops and classes at Tribal Communities -childrens prizes, meeting refreshments, markers certificates (18 workshops X $200x 3yrs) $13,500 COLUMN TOTAL $2,187,669 SOURCE AND USE OF OTHER FUNDS CONTRIBUTED TO THE PROJECT Status (secured or pending) Budget Spent Balance Non-State: $ - $ - $ - State: $ - $ - $ - In kind: $ 36,000 $ - $ 36,000 Partner IPS-Solar has committed to providing expertise for 2 trainings per year (instructor 10 days/year x3 = $24000) Technical assistance on demonstration installs ($4000 x 3 yrs = 12,000) secured $ 24,000 $12,000 secured Other ENRTF APPROPRIATIONS AWARDED IN THE LAST SIX YEARS Amount legally obligated but not yet spent Budget Spent Balance N/A $ - $ - $ -