Civic Intelligence

Shell Medical Plan

990 • Fiscal year 2019 • EIN 74-2200128

Jan 01, 2019 to Dec 31, 2019 • Filed on Nov 11, 2020

Organization ProfileN/A
PO Box 53456 S4101-22gPhoenix, AZ 85072

(888) 730-4933

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

23rd percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2019

Liabilities / Revenue

23rd percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2019

Net Margin

34th percentile

1.1%

Higher net margin than 34% of similar nonprofits.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2019

Top Officer Pay

29th percentile

$0

Higher top officer pay than 29% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2019

Asset Growth

72nd percentile

17%

Faster asset growth than 72% of similar nonprofits.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Annualized from 2018 to 2019

Revenue Growth

51st percentile

5.3%

Faster revenue growth than 51% of similar nonprofits.

2019 filings • 501(c)9 • $250M-$1B nonprofits • Annualized from 2018 to 2019

Balance Sheet
Liabilities / Assets23rd percentile

Assets

Up

$42,010,617

Up $6,064,108 (+17%) from 2018

Net Assets

Up

$42,010,617

Up $6,064,108 (+17%) from 2018

Liabilities

Flat

$0

Flat from 2018

Revenue And Expenses
Liabilities / Revenue23rd percentileNet Margin34th percentile

Revenue

Up

$574,863,871

Up $28,769,755 (+5.3%) from 2018

Expenses

Down

$568,815,435

Down $2,978,860 (-0.5%) from 2018

Net Income

Up

$6,048,436

Up $31,748,615 (+124%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth72nd percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$100M$50M$0Assets 2010: $26,353,018Liabilities 2010: $0Net Assets 2010: $26,353,0182010Assets 2011: $27,119,360Liabilities 2011: $0Net Assets 2011: $27,119,3602011Assets 2012: $16,477,327Liabilities 2012: $0Net Assets 2012: $16,477,3272012Assets 2013: $22,654,258Liabilities 2013: $0Net Assets 2013: $22,654,2582013Assets 2014: $93,391,180Liabilities 2014: $0Net Assets 2014: $93,391,1802014Assets 2015: $52,549,065Liabilities 2015: $0Net Assets 2015: $52,549,0652015Assets 2016: $58,427,273Liabilities 2016: $0Net Assets 2016: $58,427,2732016Assets 2017: $61,665,299Liabilities 2017: $0Net Assets 2017: $61,665,2992017Assets 2018: $35,946,509Liabilities 2018: $0Net Assets 2018: $35,946,5092018Assets 2019: $42,010,617Liabilities 2019: $0Net Assets 2019: $42,010,6172019Assets 2020: $75,038,733Liabilities 2020: $0Net Assets 2020: $75,038,7332020Assets 2021: $59,819,611Liabilities 2021: $0Net Assets 2021: $59,819,6112021Assets 2022: $88,722,408Liabilities 2022: $0Net Assets 2022: $88,722,4082022Assets 2023: $34,783,734Liabilities 2023: $0Net Assets 2023: $34,783,7342023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2019

Assets$42,010,617
Liabilities$0
Net Assets$42,010,617
Open 2019 Filing

Operations Trend

Revenue Growth51st percentile

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$800M$600M$400M$200M$0-$200MRevenue 2010: $441,766,966Expenses 2010: $443,407,976Net Income 2010: -$1,641,0102010Revenue 2011: $463,092,245Expenses 2011: $462,329,062Net Income 2011: $763,1832011Revenue 2012: $488,765,569Expenses 2012: $499,406,328Net Income 2012: -$10,640,7592012Revenue 2013: $536,920,747Expenses 2013: $530,745,476Net Income 2013: $6,175,2712013Revenue 2014: $618,775,202Expenses 2014: $548,037,487Net Income 2014: $70,737,7152014Revenue 2015: $571,185,918Expenses 2015: $612,027,816Net Income 2015: -$40,841,8982015Revenue 2016: $617,181,215Expenses 2016: $611,289,900Net Income 2016: $5,891,3152016Revenue 2017: $579,961,309Expenses 2017: $576,676,411Net Income 2017: $3,284,8982017Revenue 2018: $546,094,116Expenses 2018: $571,794,295Net Income 2018: -$25,700,1792018Revenue 2019: $574,863,871Expenses 2019: $568,815,435Net Income 2019: $6,048,4362019Revenue 2020: $535,906,788Expenses 2020: $502,878,672Net Income 2020: $33,028,1162020Revenue 2021: $509,542,348Expenses 2021: $524,763,374Net Income 2021: -$15,221,0262021Revenue 2022: $481,084,441Expenses 2022: $452,121,857Net Income 2022: $28,962,5842022Revenue 2023: $342,743,076Expenses 2023: $396,521,621Net Income 2023: -$53,778,5452023Revenue 2024: $137,927,620Expenses 2024: $172,932,187Net Income 2024: -$35,004,5672024

Highlighted filing

2019

Revenue$574,863,871
Expenses$568,815,435
Net Income$6,048,436
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Nov 11, 2020
Return Version
2019v5.0
Gross Receipts
$574,863,871
Mission and Program Overview

Mission

Provide certain health wellness accident, life, disability, and other welfare benefits for eligible employees and their dependents

Balance Sheet Detail
LineBeginningEndChange
Assets
Savings and Temporary Cash Investments$35,946,509$42,010,617▲ $6,064,108
Cap Stk Tr Prin Current Funds$35,946,509$42,010,617▲ $6,064,108
Total Assets$35,946,509$42,010,617▲ $6,064,108
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Total Net Assets Fund Balance$35,946,509$42,010,617▲ $6,064,108
Total Liabilities and Net Assets / Fund Balance$35,946,509$42,010,617▲ $6,064,108
Compensation and Service Providers
Top Officer Pay29th percentile

Board Members and Trustees

NameTitle
Marvin E OdumPresident
-Trustee
Candida WolframAsst. Secretary
Hector PinedaAsst. Secretary
John M EsquivelAsst. Secretary
Lynn S BorogemierAsst. Secretary
Stephanie J PaulAsst. Secretary
Tabatha R BakerAsst. Secretary
A M NolteController
Julian DalzellSenior VP
William C LowreySenior VP
Richard MennitiTreasurer
T T ColesVP
Cynthia a DeereVP Finance
B P MalnakVP Gov/t Affairs
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$573,727,217
Investment Income
$1,136,654
Other Revenue
$0
Change in Net Assets
$6,048,436
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$18,070,848
Salaries, Compensation, and Employee Benefits$56,600
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Benefits to Members$550,687,987--$550,687,987
Other Expenses$17,853,873--$17,853,873
Fees for Services Accounting$186,000--$186,000
Current Officers, Directors, Trustees, and Key Employees$56,600$0-$56,600
Fees for Services Legal$30,975--$30,975
Total Functional Expenses$568,815,435$0$0$568,815,435
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
Yes
Business relationship with 35% controlled entity
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 11-description of Process for Review

“The sole trustee receives and reviews the form 990”

EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 12C

“The organization complies with the same policy and enforcement as its trustee”

Form 990, Page 6, Part VI, Line 19

“No documents available to the public”

Filing and Contact Details

Filer

Filer Name
Shell Medical Plan
EIN
74-2200128
Phone
8887304933
Address
PO BOX 53456 S4101-22G, PHOENIX, AZ 85072

Signing Officer

Name
-
Title
Trustee
Phone
8887304933
Signed
2020-11-11
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Wells Fargo Bank
Formed
2002
Legal Domicile
TX
Voting Board Members
1
Independent Board Members
0
Employees
0

Preparer

Firm
Pricewaterhousecoopers Llp
Address
600 GRANT STREET, PITTSBURGH, PA 15219
Preparer
Joseph J Castriano
Phone
4123556000
Supplemental Narrative

Additional Explanations

Part IV, Line 12B

“The organization was included in consolidated independent audited financial statements but did not obtain separate independent audited financial statements for the year. The orgnization opts out of completing schedule d, parts xi and xii.”

Explanation for Form 990, Part XI, Line 9

“Mutual fund timing difference $15,672”

Raw XML Appendix371 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd0false
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/AnnualDisclosureCoveredPrsnInd0true
IRS990/AuditCommitteeInd0true
IRS990/BackupWthldComplianceInd0true
IRS990/BenefitsToMembersGrp/ProgramServicesAmt0550687987
IRS990/BenefitsToMembersGrp/TotalAmt0550687987
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0WELLS FARGO BANK NA
IRS990/BooksInCareOfDetail/PhoneNum08887304933
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0100 N MAIN ST MAC D4001-117
IRS990/BooksInCareOfDetail/USAddress/CityNm0WINSTON SALEM
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0NC
IRS990/BooksInCareOfDetail/USAddress/ZIPCd027101
IRS990/BusinessRlnWith35CtrlEntInd0false
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt035946509
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt042010617
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt00
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt056600
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt056600
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0true
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt0550687987
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt01136654
IRS990/CYOtherExpensesAmt018070848
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt0573727217
IRS990/CYRevenuesLessExpensesAmt06048436
IRS990/CYSalariesCompEmpBnftPaidAmt056600
IRS990/CYTotalExpensesAmt0568815435
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0574863871
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/DescribedInSection501c3Ind0false
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0true
IRS990/DonorAdvisedFundInd0false
IRS990/DonorRstrOrQuasiEndowmentsInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ProgramServicesAmt0186000
IRS990/FeesForServicesAccountingGrp/TotalAmt0186000
IRS990/FeesForServicesLegalGrp/ProgramServicesAmt030975
IRS990/FeesForServicesLegalGrp/TotalAmt030975
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt101.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt111.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt121.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt131.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt141.0
IRS990/Form990PartVIISectionAGrp/BusinessName/BusinessNameLine1Txt0WELLS FARGO BANK
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd10X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd11X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd12X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd13X
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt100
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt110
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt120
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt130
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt140
IRS990/Form990PartVIISectionAGrp/PersonNm0MARVIN E ODUM
IRS990/Form990PartVIISectionAGrp/PersonNm1JULIAN DALZELL
IRS990/Form990PartVIISectionAGrp/PersonNm2WILLIAM C LOWREY
IRS990/Form990PartVIISectionAGrp/PersonNm3T T COLES
IRS990/Form990PartVIISectionAGrp/PersonNm4CYNTHIA A DEERE
IRS990/Form990PartVIISectionAGrp/PersonNm5B P MALNAK
IRS990/Form990PartVIISectionAGrp/PersonNm6RICHARD MENNITI
IRS990/Form990PartVIISectionAGrp/PersonNm7A M NOLTE
IRS990/Form990PartVIISectionAGrp/PersonNm8LYNN S BOROGEMIER
IRS990/Form990PartVIISectionAGrp/PersonNm9JOHN M ESQUIVEL
IRS990/Form990PartVIISectionAGrp/PersonNm10HECTOR PINEDA
IRS990/Form990PartVIISectionAGrp/PersonNm11STEPHANIE J PAUL
IRS990/Form990PartVIISectionAGrp/PersonNm12CANDIDA WOLFRAM
IRS990/Form990PartVIISectionAGrp/PersonNm13TABATHA R BAKER
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt140
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt140
IRS990/Form990PartVIISectionAGrp/TitleTxt0PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt1SENIOR VP
IRS990/Form990PartVIISectionAGrp/TitleTxt2SENIOR VP
IRS990/Form990PartVIISectionAGrp/TitleTxt3VP
IRS990/Form990PartVIISectionAGrp/TitleTxt4VP FINANCE
IRS990/Form990PartVIISectionAGrp/TitleTxt5VP GOV/T AFFAIRS
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt7CONTROLLER
IRS990/Form990PartVIISectionAGrp/TitleTxt8ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt9ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt10ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt11ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt12ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt13ASST. SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt14TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr02002
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedBasisGrp/ConsolidatedBasisFinclStmtInd0X
IRS990/FSAuditedInd0true
IRS990/FundraisingActivitiesInd0false
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0574863871
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InvestmentIncomeGrp/ExclusionAmt01136654
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt01136654
IRS990/InvestmentInJointVentureInd0false
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0TX
IRS990/LoanOutstandingInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0PROVIDE CERTAIN HEALTH WELLNESS ACCIDENT, LIFE, DISABILITY, AND OTHER WELFARE BENEFITS FOR ELIGIBLE EMPLOYEES AND THEIR DEPENDENTS
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt035946509
IRS990/NetAssetsOrFundBalancesEOYAmt042010617
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501cInd0X
IRS990/OrgDoesNotFollowFASB117Ind0X
IRS990/OtherChangesInNetAssetsAmt015672
IRS990/OtherExpensesGrp/Desc0ADMINISTRATIVE EXPENSES
IRS990/OtherExpensesGrp/ProgramServicesAmt017853873
IRS990/OtherExpensesGrp/TotalAmt017853873
IRS990/PartialLiquidationInd0false
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0WELLS FARGO BANK
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgramServiceRevenueGrp/BusinessCd0525100
IRS990/ProgramServiceRevenueGrp/Desc0EMPLOYER CONTRIBUTIONS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0573727217
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0573727217
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYBenefitsPaidToMembersAmt0553904981
IRS990/PYExcessBenefitTransInd0false
IRS990/PYInvestmentIncomeAmt01183606
IRS990/PYOtherExpensesAmt017832714
IRS990/PYProgramServiceRevenueAmt0544910510
IRS990/PYRevenuesLessExpensesAmt0-25700179
IRS990/PYSalariesCompEmpBnftPaidAmt056600
IRS990/PYTotalExpensesAmt0571794295
IRS990/PYTotalRevenueAmt0546094116
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReconcilationRevenueExpnssAmt06048436
IRS990/RegularMonitoringEnfrcInd0true
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/SavingsAndTempCashInvstGrp/BOYAmt035946509
IRS990/SavingsAndTempCashInvstGrp/EOYAmt042010617
IRS990/ScheduleBRequiredInd0false
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0THE ORGANIZATION WAS INCLUDED IN CONSOLIDATED INDEPENDENT AUDITED FINANCIAL STATEMENTS BUT DID NOT OBTAIN SEPARATE INDEPENDENT AUDITED FINANCIAL STATEMENTS FOR THE YEAR. THE ORGNIZATION OPTS OUT OF COMPLETING SCHEDULE D, PARTS XI AND XII.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1THE SOLE TRUSTEE RECEIVES AND REVIEWS THE FORM 990
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2THE ORGANIZATION COMPLIES WITH THE SAME POLICY AND ENFORCEMENT AS ITS TRUSTEE
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3NO DOCUMENTS AVAILABLE TO THE PUBLIC
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4MUTUAL FUND TIMING DIFFERENCE $15,672
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Part IV, Line 12b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 11-DESCRIPTION OF PROCESS FOR REVIEW
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 12c
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PAGE 6, PART VI, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4EXPLANATION FOR FORM 990, PART XI, LINE 9
IRS990ScheduleR/AssetExchangeInd0false
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd0false
IRS990ScheduleR/AssetSaleToOtherOrgInd0false
IRS990ScheduleR/DivRelatedOrganizationInd0false
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd0false
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd0false
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/DirectControllingNACd0N/A
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/EntityTypeTxt0C corp
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/LegalDomicileStateCd0TX
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/PrimaryActivitiesTxt0OIL AND GAS
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/RelatedOrganizationName/BusinessNameLine1Txt0SHELL OIL COMPANY
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/AddressLine1Txt0909 FANNIN STREET
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/CityNm0HOUSTON
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/StateAbbreviationCd0TX
IRS990ScheduleR/IdRelatedOrgTxblCorpTrGrp/USAddress/ZIPCd077010
IRS990ScheduleR/LoansOrGuaranteesFromOthOrgInd0false
IRS990ScheduleR/LoansOrGuaranteesToOtherOrgInd0false
IRS990ScheduleR/PaidEmployeesSharingInd0false
IRS990ScheduleR/PerformOfServicesByOtherOrgInd0false
IRS990ScheduleR/PerformOfServicesForOthOrgInd0false
IRS990ScheduleR/ReceiptOfIntAnntsRntsRyltsInd0false
IRS990ScheduleR/ReimbursementPaidByOtherOrgInd0false
IRS990ScheduleR/ReimbursementPaidToOtherOrgInd0false
IRS990ScheduleR/RentalOfFacilitiesToOthOrgInd0false
IRS990ScheduleR/RentalOfFcltsFromOthOrgInd0false
IRS990ScheduleR/SharingOfFacilitiesInd0false
IRS990ScheduleR/TransferFromOtherOrgInd0true
IRS990ScheduleR/TransferToOtherOrgInd0false
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/SubjectToExcsTaxNetInvstIncInd0false
IRS990/SubjectToProxyTaxInd0false
IRS990/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt035946509
IRS990/TotalAssetsEOYAmt042010617
IRS990/TotalAssetsGrp/BOYAmt035946509
IRS990/TotalAssetsGrp/EOYAmt042010617
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt00
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0568815435
IRS990/TotalFunctionalExpensesGrp/TotalAmt0568815435
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt035946509
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt042010617
IRS990/TotalOtherCompensationAmt00
IRS990/TotalProgramServiceRevenueAmt0573727217
IRS990/TotalReportableCompFromOrgAmt00
IRS990/TotalRevenueGrp/ExclusionAmt01136654
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0573727217
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0574863871
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt035946509
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt042010617
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UponRequestInd0X
IRS990/USAddress/AddressLine1Txt0PO BOX 53456
IRS990/USAddress/CityNm0PHOENIX
IRS990/USAddress/StateAbbreviationCd0AZ
IRS990/USAddress/ZIPCd085072
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt00
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0true
ReturnHeader/BuildTS02022-01-07 14:23:13Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0-
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08887304933
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-11-11
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SHELL MEDICAL PLAN
ReturnHeader/Filer/BusinessNameControlTxt0SHEL
ReturnHeader/Filer/EIN0742200128
ReturnHeader/Filer/PhoneNum08887304933
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 53456 S4101-22G
ReturnHeader/Filer/USAddress/CityNm0PHOENIX
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AZ
ReturnHeader/Filer/USAddress/ZIPCd085072
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0BF706D79D1127CDA8AA19DAFBE9E2A0858F12806
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId02E6D5429276B38A147B6EA548DCB22578CFA4E96
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0155.201.150.21
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0134008324
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PRICEWATERHOUSECOOPERS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0600 GRANT STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015219
ReturnHeader/PreparerPersonGrp/PhoneNum04123556000
ReturnHeader/PreparerPersonGrp/PreparationDt02020-11-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JOSEPH J CASTRIANO
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02020-11-11T23:00:25-06:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2019 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$42,010,617
Liabilities
$0
Net assets
$42,010,617
Revenue
$574,863,871
Expenses
$568,815,435
Net income
$6,048,436
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$138$173$35.0
2023Detailed filing. Detailed filing data is available for this year.$34.8$0.00$34.8$343$397$53.8
2022Detailed filing. Detailed filing data is available for this year.$88.7$0.00$88.7$481$452$29.0
2021Detailed filing. Detailed filing data is available for this year.$59.8$0.00$59.8$510$525$15.2
2020Detailed filing. Detailed filing data is available for this year.$75.0$0.00$75.0$536$503$33.0
2019Detailed filing. Detailed filing data is available for this year.$42.0$0.00$42.0$575$569$6.05
2018Detailed filing. Detailed filing data is available for this year.$35.9$0.00$35.9$546$572$25.7
2017Summary only. Only limited summary data is available for this year.$61.7$0.00$61.7$580$577$3.28
2016Summary only. Only limited summary data is available for this year.$58.4$0.00$58.4$617$611$5.89
2015Summary only. Only limited summary data is available for this year.$52.5$0.00$52.5$571$612$40.8
2014Summary only. Only limited summary data is available for this year.$93.4$0.00$93.4$619$548$70.7
2013Summary only. Only limited summary data is available for this year.$22.7$0.00$22.7$537$531$6.18
2012Summary only. Only limited summary data is available for this year.$16.5$0.00$16.5$489$499$10.6
2011Summary only. Only limited summary data is available for this year.$27.1$0.00$27.1$463$462$0.76
2010Summary only. Only limited summary data is available for this year.$26.4$0.00$26.4$442$443$1.64