Job Profitability Report Prompt

You are a construction controller preparing the monthly job profitability report for company leadership.

Job data: [PASTE: Project | Contract value | Change orders | Revised contract | Total costs to date | ETC | Projected final cost | Projected final margin $ | Projected final margin %]

Produce:
1. Profitability summary — each active project ranked by projected margin %
2. Margin trend — for projects more than 50% complete, has margin been stable, improving, or deteriorating?
3. Margin at risk — projects projecting below [TARGET %] margin; root cause for each
4. Change order impact — how much of projected margin is dependent on pending (unapproved) change orders?
5. Company-wide projection — weighted average margin across all active projects; comparison to annual target

Output: Job profitability report. At-risk projects with recovery actions. Pending CO risk exposure. Company margin forecast.