One thing to keep in mind running those figures is that Coke doesn't get that potential $6.50. there's also the middleman and logistics bringing that down, and everyone taking their cut.
Believe it or not, you can easily play a dragon character in D&D! With thousands of options and dozens of different dragon types, we break down the specifics...
www.youtube.com
This is a podcast from a couple people who publish 3rd party RPG books, and they aren't afraid to talk about the business side of things. This section, if the timecode works, should put you right at where they were talking about the whole distributor price breakdown, using their products as an example. In Coke's case, they make it up some in volume, but they still have these issues because almost no one among the general public buys directly from Coke.
This was recorded before the dial-back-down to 30%, but it makes for a interesting conversation to hear from the manufacturer side of things. I think the full tariff discussion starts around 1:18:45 if you want to get the whole thing. They also discussed this in one or two of their other streams, but this was the most recent one that talks about the distributor and retailer issue for people making things.