{"success":true,"data":{"_id":382486117,"filings":[{"Organization":{"value":null,"Person":["DIANE DOVICO","ERIN SHAHLY","LORI PODSIADLIK"],"Title":["ADMIN","OFFICE","OFFICE"],"Hours":[40.0,40.0,40.0],"Total Compensation":[0,0,0],"Direct compensation":[0,0,0],"Other compensation":[0,0,0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2013,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2013-10-01T00:00:00","tax_period_end":"2014-09-30T00:00:00","address":"1500 N STEPHENSON HWY, ROYAL OAK, MI, 48067, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48067},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":446969,"Contributions":{"value":446969,"Other contributions":255843,"Contributions from gifts and grants":0,"Fundraising revenue":1773,"Dues":445,"Campaigns":0,"Grant revenue":188908,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":438942,"Grant expense":{"value":75,"Grants to domestic orgs":0,"Grants to domestic individuals":75,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":119290,"Current officers":104181,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":4000,"Other employee benefits":0,"Payroll taxes":11109},"Other expenses":{"value":319577,"Management services":17000,"Legal":0,"Accounting":4432,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":174,"Office expenses":8000,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":2269,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":3158,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":284544,"TRAINING":623,"OPERATIONS":32884,"OFFICE SUPPLIES SUPPLIES - GENERAL":1532,"ACTIVITES PROJECTS":249505},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":282638,"Management And General Expenses":156304,"Fundraising Expenses":0}},"Assets":{"value":0,"Non-interest bearing cash":0,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":0,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.643907395510113,"percentile":0.5100984427992556},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.017958739867865555,"percentile":0.44689350984647663},"Liabilities to Assets Ratio":{"score":null,"percentile":null},"Operating Reserve Ratio":{"score":0.0,"percentile":0.01998217959084195},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5527920931934491,"percentile":0.46555013885936336}},"source_xml":"201531359349300108_public.xml"},{"Organization":{"value":null,"Person":["ERIN SHAHLY"],"Title":["OFFICE"],"Hours":[40.0],"Total Compensation":[0],"Direct compensation":[0],"Other compensation":[0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2016,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2016-10-01T00:00:00","tax_period_end":"2017-09-30T00:00:00","address":"800 DEVILLEN, ROYAL OAK, MI, 48073, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48073},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":44864,"Contributions":{"value":44864,"Other contributions":14400,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":30464,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":48100,"Grant expense":{"value":3205,"Grants to domestic orgs":0,"Grants to domestic individuals":3205,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":6704,"Current officers":4769,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":1935},"Other expenses":{"value":38191,"Management services":0,"Legal":0,"Accounting":1123,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":1548,"Information technology":150,"Royalties":0,"Occupancy":14400,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":0,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":20970,"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":38725,"Management And General Expenses":9375,"Fundraising Expenses":0}},"Assets":{"value":107317,"Non-interest bearing cash":107317,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":107317,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.8050935550935551,"percentile":0.6319238236407724},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.07212910128388017,"percentile":0.2545520096179106},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.231122661122661,"percentile":0.6438919223912896},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.2742049919917231,"percentile":0.0679331037419848},"Revenue Growth":{"score":-0.268469042867786,"percentile":0.05392974119021202},"Asset Growth":{"score":0.5107795290476624,"percentile":0.9740506057624886},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5383435460783871,"percentile":0.42369234516636023}},"source_xml":"201830439349300633_public.xml"},{"Organization":{"value":null,"Person":["DENNIS YAGER"],"Title":["BOARD"],"Hours":[5.0],"Total Compensation":[0],"Direct compensation":[0],"Other compensation":[0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2017,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2017-10-01T00:00:00","tax_period_end":"2018-09-30T00:00:00","address":"800 DEVILLEN, ROYAL OAK, MI, 48073, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48073},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":36116,"Contributions":{"value":36106,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":36106,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":10,"Investment income total":10,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":37277,"Grant expense":{"value":4929,"Grants to domestic orgs":0,"Grants to domestic individuals":4929,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":32348,"Management services":24582,"Legal":0,"Accounting":696,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":191,"Information technology":2000,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":1345,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":3534,"ACTIVITIES PROJECTS":2523,"LICENSE FEES":545,"BANK CHARGES":466},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":29762,"Management And General Expenses":7515,"Fundraising Expenses":0}},"Assets":{"value":106156,"Non-interest bearing cash":106156,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":106156,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7984011588915417,"percentile":0.6228100102309619},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.03214641710045409,"percentile":0.3150562732960522},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.8477613541862272,"percentile":0.701031413270809},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.38050449674000847,"percentile":0.048686333602113455},"Revenue Growth":{"score":-0.38835521894329333,"percentile":0.032739327592332376},"Asset Growth":{"score":0.32142857142857145,"percentile":0.9293083180092558},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5428107652004641,"percentile":0.43641097091962755}},"source_xml":"201833099349300243_public.xml"},{"Organization":{"value":null,"Person":["DIANE DOVICO","ERIN SHAHLY","LORI PODSIADLIK"],"Title":["ADMIN","OFFICE","OFFICE"],"Hours":[40.0,40.0,40.0],"Total Compensation":[0,0,0],"Direct compensation":[0,0,0],"Other compensation":[0,0,0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2014,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2014-10-01T00:00:00","tax_period_end":"2015-09-30T00:00:00","address":"1500 N STEPHENSON HWY, ROYAL OAK, MI, 48067, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48067},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":574186,"Contributions":{"value":574186,"Other contributions":376393,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":155,"Campaigns":0,"Grant revenue":197638,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":506422,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":124816,"Current officers":112878,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":11938},"Other expenses":{"value":381606,"Management services":17665,"Legal":0,"Accounting":4326,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":3867,"Office expenses":0,"Information technology":1919,"Royalties":0,"Occupancy":8000,"Travel":3452,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":2444,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":339933,"TRAINING":1076,"OPERATIONS":4073,"OFFICE SUPPLIES SUPPLIES - GENERAL":22128,"ACTIVITES PROJECTS":312656},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":320596,"Management And General Expenses":185826,"Fundraising Expenses":0}},"Assets":{"value":67764,"Non-interest bearing cash":67764,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":67764,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.633060964965977,"percentile":0.5061200486574884},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.11801750652227676,"percentile":0.6527084816430828},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":0.1338093526742519,"percentile":0.08398266946010707},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6420304171298142,"percentile":0.7215751273452453}},"source_xml":"201641339349303044_public.xml"},{"Organization":{"value":null,"Person":["DIANE DOVICO","ERIN SHAHLY","LORI PODSIADLIK"],"Title":["ADMIN","OFFICE","OFFICE"],"Hours":[40.0,40.0,40.0],"Total Compensation":[0,0,0],"Direct compensation":[0,0,0],"Other compensation":[0,0,0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2015,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2015-10-01T00:00:00","tax_period_end":"2016-09-30T00:00:00","address":"1500 N STEPHENSON HWY, ROYAL OAK, MI, 48067, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48067},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":false,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":637288,"Contributions":{"value":637288,"Other contributions":438755,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":275,"Campaigns":0,"Grant revenue":198258,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":594499,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":162183,"Current officers":146446,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":4000,"Other employee benefits":0,"Payroll taxes":11737},"Other expenses":{"value":432316,"Management services":17000,"Legal":0,"Accounting":5863,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":6951,"Office expenses":0,"Information technology":1513,"Royalties":0,"Occupancy":8200,"Travel":2606,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":2100,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":388083,"TRAINING":1081,"OPERATIONS":4136,"OFFICE SUPPLIES SUPPLIES - GENERAL":23751,"ACTIVITES PROJECTS":359115},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":363251,"Management And General Expenses":231248,"Fundraising Expenses":0}},"Assets":{"value":110553,"Non-interest bearing cash":110553,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":110553,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.6110203717752258,"percentile":0.4989537431625756},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.06714232811538896,"percentile":0.5615052462164327},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":0.18595994274170352,"percentile":0.10876027305765523},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.12511265048086623,"percentile":0.7206994681238491},"Revenue Growth":{"score":0.1721364556997135,"percentile":0.8727444117909734},"Asset Growth":{"score":0.9299702215716954,"percentile":0.9957362664351257},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6770611649294772,"percentile":0.8045755695113754}},"source_xml":"201701359349300215_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["DENNIS YAGER"],"Title":["BOARD"],"Hours":[5.0],"Total Compensation":[0],"Direct compensation":[0],"Other compensation":[0]},"Basic":{"value":null,"mission":"Provide drug and alcohol prevention and education and intervention","year":2017,"name":"ROYAL OAK PREVENTION COALITION","phone":2485885050,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":2006,"state_legal_domicile":"MI","total_volunteers":null,"tax_period_begin":"2017-10-01T00:00:00","tax_period_end":"2018-09-30T00:00:00","address":"800 DEVILLEN, ROYAL OAK, MI, 48073, USA","city":"ROYAL OAK","state":"MI","country":"USA","zip_code":48073},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":0,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":0,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":36116,"Contributions":{"value":36106,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":36106,"Related organizations":0},"Program revenue":{"value":0,"Total revenue":0,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":10,"Investment income total":10,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":37277,"Grant expense":{"value":4929,"Grants to domestic orgs":0,"Grants to domestic individuals":4929,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":0,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":0,"Other employee benefits":0,"Payroll taxes":0},"Other expenses":{"value":32348,"Management services":24582,"Legal":0,"Accounting":696,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":191,"Information technology":2000,"Royalties":0,"Occupancy":0,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":0,"Insurance":1345,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":3534,"ACTIVITIES PROJECTS":2523,"LICENSE FEES":545,"BANK CHARGES":466},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":29762,"Management And General Expenses":7515,"Fundraising Expenses":0}},"Assets":{"value":106156,"Non-interest bearing cash":106156,"Savings and temp cash investments":0,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":0,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":106156,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7984011588915417,"percentile":0.6228100102309619},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.03214641710045409,"percentile":0.3150562732960522},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":2.8477613541862272,"percentile":0.701031413270809},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":-0.38050449674000847,"percentile":0.048686333602113455},"Revenue Growth":{"score":-0.38835521894329333,"percentile":0.032739327592332376},"Asset Growth":{"score":0.32142857142857145,"percentile":0.9293083180092558},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.5428107652004641,"percentile":0.43641097091962755}},"source_xml":"201833099349300243_public.xml"},"sector":"","donation_categories":[],"zakat_policy":null},"error":null}