Columbia, MO
#232 of 422 U.S. rack markets by terminals
- terminals
- 1
- pipeline systems delivering
- 1
- refineries confirmed
- 0
- more per research or by route
- 7
- people in the trade area
- 394,958
- gal/day gasoline · estimated demand
- 599,693
- gal/day diesel · estimated demand
- 172,663
Terminals in this market
| Terminal | TCN | Location | Delivered by |
|---|---|---|---|
| Magellan Pipeline Company, L.P. | T-43-MO-3708 | Columbia, MO | Magellan Midstream |
Pipelines delivering to this market
Each system with a tariff delivery point at one of this market’s terminals, and how many running refineries can ship on it to here.
| Pipeline system | Terminals here | Delivery points | Refineries confirmed | All reachable |
|---|---|---|---|---|
| Magellan Midstream | 1 | 1 | 0 | 6 |
Refineries that can supply this market
| Refinery | Location | Via | Link |
|---|---|---|---|
| CHS McPherson Refinery | Mcpherson, KS | Magellan Midstream | per research |
| Flint Hills Resources Pine Bend Refinery | Saint Paul, MN | Magellan Midstream | per research |
| Phillips 66 Ponca City Refinery | Ponca City, OK | Magellan Midstream, Phillips 66 Pipeline | per research |
| Valero Ardmore Refinery | Ardmore, OK | Magellan Midstream | per research |
| Borger Refinery (WRB Refining / Phillips 66) | Borger, TX | Phillips 66 Pipeline | inferred (same city) |
| CVR Wynnewood Refinery | Wynnewood, OK | Magellan Midstream | inferred (same city) |
| HF Sinclair El Dorado Refinery | El Dorado, KS | Magellan Midstream | inferred (same city) |
Trade area
- people in the trade area · 2025 estimate
- 394,958
- rank of 422 rack markets by people
- #237
- gallons of gasoline a day · estimate, 2025
- 599,693
- gallons of diesel a day · estimate, 2025
- 172,663
- counties wholly in this market
- 2
- counties shared with other markets
- 24
| County | State | Share here | People counted here | Gasoline gal/day | Diesel gal/day | County population | Miles |
|---|---|---|---|---|---|---|---|
| Boone County | MO | 100% | 191,746 | 242,526 | 52,479 | 191,746 | 5 |
| Callaway County | MO | 58% | 26,754 | 62,843 | 26,450 | 45,765 | 21 |
| Randolph County | MO | 100% | 24,513 | 36,876 | 7,968 | 24,513 | 37 |
| Audrain County | MO | 71% | 17,408 | 22,744 | 4,954 | 24,528 | 32 |
| Phelps County | MO | 31% | 14,085 | 27,951 | 10,988 | 45,247 | 78 |
| Pettis County | MO | 28% | 12,564 | 17,683 | 3,702 | 44,254 | 55 |
| Cooper County | MO | 66% | 11,272 | 31,162 | 17,980 | 17,136 | 28 |
| Camden County | MO | 25% | 11,210 | 18,898 | 3,892 | 44,047 | 66 |
| Saline County | MO | 39% | 8,987 | 19,233 | 9,805 | 23,265 | 50 |
| Morgan County | MO | 39% | 8,696 | 12,081 | 3,181 | 22,418 | 46 |
| Cole County | MO | 11% | 8,391 | 12,444 | 2,145 | 77,908 | 29 |
| Howard County | MO | 78% | 7,918 | 9,348 | 2,250 | 10,180 | 26 |
| Moniteau County | MO | 41% | 6,353 | 8,417 | 2,314 | 15,428 | 25 |
| Miller County | MO | 21% | 5,535 | 9,766 | 2,541 | 25,817 | 49 |
| Benton County | MO | 25% | 5,142 | 7,288 | 1,953 | 20,536 | 68 |
| Chariton County | MO | 67% | 4,979 | 6,312 | 1,637 | 7,377 | 54 |
| Texas County | MO | 16% | 4,055 | 6,242 | 1,667 | 25,994 | 112 |
| Gasconade County | MO | 26% | 3,789 | 4,942 | 1,274 | 14,784 | 54 |
| Macon County | MO | 24% | 3,696 | 7,956 | 2,116 | 15,190 | 64 |
| Monroe County | MO | 36% | 3,195 | 4,090 | 976 | 8,959 | 43 |
| Linn County | MO | 27% | 3,174 | 5,850 | 1,586 | 11,815 | 78 |
| Montgomery County | MO | 26% | 3,063 | 11,190 | 7,017 | 11,590 | 45 |
| Osage County | MO | 20% | 2,785 | 4,501 | 1,260 | 13,611 | 40 |
| Pike County | MO | 13% | 2,325 | 4,272 | 1,232 | 17,955 | 67 |
| Livingston County | MO | 13% | 1,971 | 3,230 | 764 | 14,708 | 89 |
| Carroll County | MO | 16% | 1,359 | 1,857 | 534 | 8,417 | 73 |
Fuel demand is an estimate: each state’s taxed gallons for the year (FHWA) are split among its counties by where the driving happens (EPA county vehicle miles, weighted by how much fuel each vehicle type burns), then shared to markets as above. Every state adds back to its FHWA total. Gasoline includes the ethanol blended into it; diesel is FHWA’s special fuels. Expect diesel to be least reliable along long-haul corridors, where trucks buy fuel in one county and burn it in another. Population: U.S. Census Bureau county estimates.
How good is it? Checked in October 2026 against the county retail sales Iowa and California publish: for gasoline, about 3–5% of gallons landed in the wrong rack market and a typical market was within 5–6%. For diesel, 14–21% landed in the wrong market and a typical market was 30–45% off, with truck-stop corridors such as Bakersfield and Stockton under-counted. Treat gasoline as a working estimate and diesel as a rough guide.
Cost to serve this market by pipeline
What it costs to move a gallon here from each pipeline origin at filed tariff rates: line-haul, the cost of financing the product on the way and in the tank, pipeline loss, and terminaling. It is a cost at filed rates, not a market price: add it to the origin spot price for a delivered cost. Lines marked "estimate" are placeholders until the pipeline or terminal figure is on file; in the routes table, * marks a figure taken from the tariff.
Gasoline: product adder
- ¢/gal · lowest adder
- 13.14
- ¢/gal · line-haul tariff · published
- 10.92
- ¢/gal · carrying cost · calculated
- 0.56
- ¢/gal · pipeline loss · published
- 0.16
- ¢/gal · terminaling · estimate
- 1.50
- days financed
- 10.6
Lowest route: from Kansas on Magellan Midstream to Columbia, MO (FERC No. 160.59.0 item 201).
How the lowest adder is worked, line by line
| Line | ¢/gal | Basis | Source or working |
|---|---|---|---|
| Line-haul tariff | 10.917 | published | Magellan Midstream FERC No. 160.59.0 item 201: Kansas (Coffeyville/El Dorado/Kansas City Jct.) → Columbia, MO, 458.52 ¢/bbl |
| Carrying cost | 0.560 | calculated | $3.260000/gal × 5.9000% ÷ 365 × 10.617 days (3.117 in transit, 2.50 waiting on the cycle, 5.00 in terminal inventory); transit estimated: 299 pipeline miles at 4.0 mph (general estimate) |
| Pipeline loss | 0.163 | published | Magellan Midstream FERC No. 157.39.0 (Central rules), tender deduction: 0.05% of volume at $3.2600/gal = 6.85 ¢/bbl |
| Terminaling | 1.500 | estimate | Flat estimate: no fee on file for this terminal |
| Product adder | 13.140 | Sum of the lines above, over the origin spot price |
Every published route, lowest adder first (7 of 7). Origins are priced at the same index here. "Origin must be cheaper by" is how far below the lowest route's origin a route's own origin price has to be before that route wins.
| Origin | Pipeline | Delivery point | Terminals | Line-haul | Carrying | Loss | Terminaling | Adder ¢/gal | Days | Origin must be cheaper by | Tariff |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Kansas (Coffeyville/El Dorado/Kansas City Jct.) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 10.92 | 0.56 | 0.16* | 1.50 | 13.14 | 10.6 | — | FERC No. 160.59.0 item 201 |
| Oklahoma Central (Ponca City) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 10.92 | 0.59 | 0.16* | 1.50 | 13.17 | 11.1 | 0.03 | FERC No. 160.59.0 item 200 |
| McPherson, KS | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 11.54 | 0.58 | 0.16* | 1.50 | 13.78 | 11.0 | 0.64 | FERC No. 160.59.0 item 255 |
| Wynnewood, OK | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 13.52 | 0.65 | 0.16* | 1.50 | 15.83 | 12.3 | 2.69 | FERC No. 160.59.0 item 204 |
| Wichita - Kansas City Interconnect (Phillips 66 Carrier) | Magellan Midstream joint rate | Columbia, MO | Magellan Pipeline Company, L.P. | 12.82 | 0.57 | 0.98* | 1.50 | 15.87 | 10.9 | 2.73 | FERC No. 160.59.0 item 240 |
| Wynnewood, OK / Ardmore, OK (Valero Partners Wynnewood) | Magellan Midstream joint rate | Columbia, MO | Magellan Pipeline Company, L.P. | 14.23 | 0.65 | 0.65 | 1.50 | 17.03 | 12.3 | 3.89 | FERC No. 197.9.0 item 200 |
| Minneapolis (Pine Bend/St Paul Park/Roseville/Rosemount) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 16.18 | 0.65 | 0.16* | 1.50 | 18.50 | 12.4 | 5.36 | FERC No. 160.59.0 item 205 |
Diesel: product adder
- ¢/gal · lowest adder
- 13.53
- ¢/gal · line-haul tariff · published
- 10.92
- ¢/gal · carrying cost · calculated
- 0.86
- ¢/gal · pipeline loss · published
- 0.25
- ¢/gal · terminaling · estimate
- 1.50
- days financed
- 10.6
Lowest route: from Kansas on Magellan Midstream to Columbia, MO (FERC No. 160.59.0 item 201).
How the lowest adder is worked, line by line
| Line | ¢/gal | Basis | Source or working |
|---|---|---|---|
| Line-haul tariff | 10.917 | published | Magellan Midstream FERC No. 160.59.0 item 201: Kansas (Coffeyville/El Dorado/Kansas City Jct.) → Columbia, MO, 458.52 ¢/bbl |
| Carrying cost | 0.858 | calculated | $5.000000/gal × 5.9000% ÷ 365 × 10.617 days (3.117 in transit, 2.50 waiting on the cycle, 5.00 in terminal inventory); transit estimated: 299 pipeline miles at 4.0 mph (general estimate) |
| Pipeline loss | 0.250 | published | Magellan Midstream FERC No. 157.39.0 (Central rules), tender deduction: 0.05% of volume at $5.0000/gal = 10.50 ¢/bbl |
| Terminaling | 1.500 | estimate | Flat estimate: no fee on file for this terminal |
| Product adder | 13.525 | Sum of the lines above, over the origin spot price |
Every published route, lowest adder first (7 of 7). Origins are priced at the same index here. "Origin must be cheaper by" is how far below the lowest route's origin a route's own origin price has to be before that route wins.
| Origin | Pipeline | Delivery point | Terminals | Line-haul | Carrying | Loss | Terminaling | Adder ¢/gal | Days | Origin must be cheaper by | Tariff |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Kansas (Coffeyville/El Dorado/Kansas City Jct.) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 10.92 | 0.86 | 0.25* | 1.50 | 13.53 | 10.6 | — | FERC No. 160.59.0 item 201 |
| Oklahoma Central (Ponca City) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 10.92 | 0.90 | 0.25* | 1.50 | 13.57 | 11.1 | 0.04 | FERC No. 160.59.0 item 200 |
| McPherson, KS | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 11.54 | 0.89 | 0.25* | 1.50 | 14.18 | 11.0 | 0.65 | FERC No. 160.59.0 item 255 |
| Wynnewood, OK | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 13.52 | 0.99 | 0.25* | 1.50 | 16.26 | 12.3 | 2.73 | FERC No. 160.59.0 item 204 |
| Wichita - Kansas City Interconnect (Phillips 66 Carrier) | Magellan Midstream joint rate | Columbia, MO | Magellan Pipeline Company, L.P. | 12.82 | 0.88 | 1.50* | 1.50 | 16.70 | 10.9 | 3.18 | FERC No. 160.59.0 item 240 |
| Wynnewood, OK / Ardmore, OK (Valero Partners Wynnewood) | Magellan Midstream joint rate | Columbia, MO | Magellan Pipeline Company, L.P. | 14.23 | 0.99 | 1.00 | 1.50 | 17.72 | 12.3 | 4.20 | FERC No. 197.9.0 item 200 |
| Minneapolis (Pine Bend/St Paul Park/Roseville/Rosemount) | Magellan Midstream | Columbia, MO | Magellan Pipeline Company, L.P. | 16.18 | 1.00 | 0.25* | 1.50 | 18.93 | 12.4 | 5.41 | FERC No. 160.59.0 item 205 |
Inputs and assumptions behind these figures
- Product value (for carrying cost and loss only): the prior day's spot price. Gasoline: OilPriceAPI GASOLINE_RBOB_USD, 2026-10-07. Diesel: OilPriceAPI ULSD_DIESEL_USD, 2026-10-07. These are the New York Harbor futures benchmarks, not a Gulf Coast price.
- Interest rate: SOFR 3.90% (2026-10-06) + 2.0 points.
- Transit (estimate): straight-line miles between the tariff origin and delivery point × 1.15, at 4.0 mph unless the pipeline has its own figure.
- Days financed (estimate): transit, plus half a 5-day shipping cycle waiting to lift, plus 5 days of stock at the terminal.
- Pipeline loss: the charge or volume deduction the tariff states, where it states one (marked *; a deduction is costed at the product value above). Otherwise an estimate of 0.10% of product value per pipeline, two for a joint rate; that includes pipelines that share out actual losses without publishing a figure.
- Terminaling: the carrier's terminal charge where its tariff states one (marked *), otherwise a flat 1.5¢/gal estimate.
- Rates used: each pipeline's ordinary filed rate. Committed, volume-tier, discount and bid rates are left out, as are conditional fees (shown on each pipeline page), additives, taxes and the value of line space.
- Assumption set in force from 2026-10-01; review by 2027-01-01.
Published line-haul rates, all products and rate types
- ¢/gal · cheapest gasoline · from Oklahoma Central on Magellan Midstream
- 10.92
- ¢/gal · cheapest diesel · from Oklahoma Central on Magellan Midstream
- 10.92
- ¢/gal · cheapest jet fuel · from Wynnewood, OK / Ardmore, OK on Magellan Midstream
- 14.23
| Origin | Pipeline | Delivery point | Product | ¢/bbl | ¢/gal | Refineries at the origin | Tariff |
|---|---|---|---|---|---|---|---|
| Oklahoma Central (Ponca City) | Magellan Midstream | Columbia, MO | gasoline, distillate | 458.52 | 10.92 | Phillips 66 Ponca City Refinery | FERC No. 160.59.0 item 200 |
| Kansas (Coffeyville/El Dorado/Kansas City Jct.) | Magellan Midstream | Columbia, MO | gasoline, distillate | 458.52 | 10.92 | HF Sinclair El Dorado Refinery | FERC No. 160.59.0 item 201 |
| McPherson, KS | Magellan Midstream | Columbia, MO | gasoline, distillate | 484.68 | 11.54 | CHS McPherson Refinery | FERC No. 160.59.0 item 255 |
| Wichita - Kansas City Interconnect (Phillips 66 Carrier) | Magellan Midstream | Columbia, MO | gasoline, distillate | 538.49 | 12.82 | FERC No. 160.59.0 item 240 | |
| Wynnewood, OK | Magellan Midstream | Columbia, MO | gasoline, distillate | 567.65 | 13.52 | CVR Wynnewood Refinery | FERC No. 160.59.0 item 204 |
| Wynnewood, OK / Ardmore, OK (Valero Partners Wynnewood) | Magellan Midstream | Columbia, MO | gasoline, distillate, jet fuel | 597.59 | 14.23 | Valero Ardmore Refinery; CVR Wynnewood Refinery | FERC No. 197.9.0 item 200 |
| Minneapolis (Pine Bend/St Paul Park/Roseville/Rosemount) | Magellan Midstream | Columbia, MO | gasoline, distillate | 679.76 | 16.19 | Flint Hills Resources Pine Bend Refinery | FERC No. 160.59.0 item 205 |
Supply resilience
- pipeline supply
- One pipeline
- pipeline systems delivering
- 1
- terminals on two or more pipelines
- 0
- terminals with no pipeline tariff
- 0
One pipeline system delivers here: Magellan Midstream. An outage on it leaves the market to truck, rail or water.
If a pipeline system goes down
| Pipeline system | Terminals it reaches here | With no other pipeline | Which |
|---|---|---|---|
| Magellan Midstream | 1 | 1 | Magellan Pipeline Company, L.P. |
Counts pipeline systems with a tariff delivery point here, not capacity, storage or contracts. A system with two lines into the market still counts once, and a terminal with one pipeline may also receive by truck, rail or water. For a refinery or pipeline outage across every market it touches, open that facility’s page.
Delivered ethanol cost
- ¢/gal over Chicago ethanol · lowest in the market
- -2.56
- ¢/gal over Chicago ethanol · highest
- -2.56
An estimate for each terminal: the cheapest of published rail rates and trucking from the nearest plants, plus basis, transload, terminaling and carrying cost. Each terminal page shows the build-up line by line.
| Terminal | ¢/gal over Chicago | By | From | Miles |
|---|---|---|---|---|
| Magellan Pipeline Company, L.P. | -2.56 | truck | Big River Resources West Burlington LLC (West Burlington, IA) | 176 |
Nearby rack markets
Rack markets within 75 miles (straight line): where a buyer here could also lift.
| Rack market | Miles | Terminals | Pipelines |
|---|---|---|---|
| Jefferson City, MO | 26 | 1 | 1 |
| Mexico, MO | 32 | 0 | — |
| Carrollton, MO | 69 | 0 | — |
Rates are pipeline line-haul transcribed from published FERC tariffs; every figure cites its tariff and item. Cost to serve (netback) adds origin spot price and destination fees. "Confirmed" links match a tariff delivery point to the facility; "same city" means the point is in the facility's city — plausible, not proof; "per research" means the facility's research profile names the pipeline as an outlet.