Calculate profit margin by product, customer or job

Calculate the profit margin of each {{unit}} from the data below, for {{reader}}, so we can see which ones make money once their direct costs are counted and which do not.

Sales by {{unit}} for {{period}}:
"""
{{sales_data}}
"""

Direct costs by {{unit}} (materials, direct labor, shipping, payment fees, commissions, discounts):
"""
{{direct_costs}}
"""

Shared costs and how we want them split, if at all: {{shared_costs}}

Produce:
1. A table with the columns Name, Revenue, Direct costs, Contribution (revenue minus direct costs), Contribution margin %, Share of total contribution, sorted from highest contribution to lowest. Under the table, show one worked line, for example "Revenue 12,000 - direct costs 7,800 = 4,200; 4,200 / 12,000 = 35%".
2. If I have given a way to split shared costs, a second table with each line's share and its profit after shared costs. Apply my method across every line that has the figure it needs, so the shares add up to the total shared costs, and put lines with incomplete cost data together on one row, "Incomplete lines", with no profit figure. If I have given no method, leave shared costs out and say so.
3. Findings: up to 6 bullets, such as lines with negative contribution, a few lines making most of the profit, or high revenue with a thin margin.
4. Questions to answer before acting: up to 4, for example whether a low-margin product brings in customers who buy other things.

Rules:
- Use only the figures given. Make sure the contributions add up to total revenue minus total direct costs, and say if any totals in the data differ.
- If a line is in another currency and I have not given a rate, list it as incomplete rather than converting it.
- Do not split shared costs by a method I have not chosen, because a different split can turn a profitable line into a loss on paper.
- Do not recommend dropping a product or customer. Show the numbers and the questions, and leave the decision to us.

Keep the text outside the tables under 300 words. If a {{unit}} has sales but no direct cost data, or the reverse, list it as incomplete instead of treating the missing figure as zero. If it is unclear whether revenue is before or after discounts, treat it as before, show how the totals change if it is after, and ask.