Department of Defense in Michigan

A thick Defense file on MI

The pair is 097 × MI. $33,885,695,368.10 is the obligation sum. 135,301 is the award count. One hundred thirty-five thousand records under $33.89 billion pulls the mean to about $250,000. Many small actions can sit beside fewer large contracts inside the same total.

The join does not identify tanks, ships, or research labs. Those nouns are not in the packet. Ranking Michigan against Ohio or Indiana would require other facts.

135,301 award records and $33,885,695,368.10 are the only two published facts that define this pair. Subtracting either key changes the number. The mean is arithmetic on those two facts. Readers who need a distribution have to leave this narrative for the overlay table.

Agency 097 versus Michigan’s full mix

The Department of Defense hub without Michigan will not equal $33,885,695,368.10. The Michigan hub without 097 includes civilian awarding agencies. Overlay /states/mi/agencies/097/ is the both-keys table for 135,301 awards.

The architecture is simple. One hub is the agency without geography. One hub is the geography without this agency. One overlay is both. $33,885,695,368.10 and 135,301 belong to the overlay. The hubs answer different questions.

Questions

How much has DoD obligated in Michigan?

USAspending records $33,885,695,368.10 in obligations for agency 097 with Michigan place of performance, on 135,301 awards. That is an obligation join, not an outlay total. The pair is awarding agency 097 (Department of Defense) and place-of-performance Michigan. It is not Department of Defense nationwide and not Michigan from every awarding agency.

What is the average award?

About $250,000 ($33,885,695,368.10 ÷ 135,301). A high award count pulls the mean down. The mean is not a typical prime contract. That ratio uses only $33,885,695,368.10 and 135,301 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Does this include Ohio or Indiana?

No. Place of performance is Michigan only. Other states are outside $33,885,695,368.10 and outside the 135,301 awards. Only place-of-performance Michigan plus awarding agency 097 (Department of Defense) enter $33,885,695,368.10. Adjacent state codes are other filters, if they exist as ties at all.

Are these outlays?

No. The aggregate is obligations. The 135,301 figure is an award-record count. USAspending’s source note for this aggregate is that obligations are not outlays. Place of performance Michigan is a geography tag, not a roster of residents, vendors, or named facilities.