Ok, I'm going to jam the link in here for my google Sheet for Profitability analysis.
https://docs.google.com/spreadsheets/d/1DdY9WTogzAWUKkO-svaqqEexOliXE4yVRsVlhV40MJgI've updated it to some of the 98B items like Pimpcraft, Cave Hunts, and Hellerium Distilling.
I've not done any work with Ship construction, but I think its a great idea if someone would like to tackle it.
Overall, I use column "Q" which is profitability per hour, as my benchmark.
X-Grog makes $22.50 per hour, and anything that makes more than that is probably worthwhile.
It can get tricky to manage the figures for items that have multiple components and multiple outputs like Cave Hunts so I have altered the sales price formulas and component formulas to account for those.
I have some columns for labor/hour cost as well as facility/per hour costs. The Facility/Hour is deceptive in that it only accounts for a single runt (730 hours/mo) which is unrealistic.
I'd love more discussion on what should be published to the Bootypedia page and how far down the math vortex this number crunching should go.