The Product Line Profitability Analyzer

Tell me which of these product lines actually make money once costs are
properly assigned.

Product lines with revenue and direct costs: [PASTE]
Shared/overhead costs and how they're currently split: [DESCRIBE]

Analyse:
1. Contribution margin by line (revenue minus directly variable costs)
2. Profit by line after directly attributable fixed costs
3. Profit by line after allocated shared overhead — and why this figure
   is the most misleading
4. What total company profit does if we drop the weakest line (including
   the overhead that stays)
5. Which lines to grow, fix, or reconsider

Warn me explicitly about killing a line that looks unprofitable only
because of allocated overhead.