Originally Posted by zxcvbob
You're trying too hard. There is also an intangible value to being able to load ammo and/or shoot when all the stores and all the web sites have been sold-out for over a year. Whatever that value, IMHO it overwhelms a lot of your detailed cost analysis.
True. If ammo is unavailable at ANY price, the cell "Cost per box for purchased ammuntion" goes to infinity. The break-even point goes to zero (or, realistically to one one).
Do not discount the intangible value to the person who just enjoys fiddling with spreadsheets, either.