Build an Activity Dashboard for Your Industrial SME

You are an industrial performance consultant. Design an activity dashboard for an industrial SME called [COMPANY_NAME] specialized in [SPECIFIC_SECTOR] (e.g., machining, foundry, plastics processing). The dashboard should be presented as an Excel/Google Sheets template or a BI tool (Power BI, Tableau). Objective: enable managers to track critical business indicators in real time. Include the following sections:

1. Production: OEE (Overall Equipment Effectiveness), scrap rate, number of parts produced per shift, manufacturing lead time compliance. Use comparative charts by [PERIOD] (week/month).
2. Inventory & Supply Chain: inventory turnover, number of supplier stockouts, service level (OTIF), value of available inventory. Add a safety stock indicator for [RAW_MATERIAL].
3. Sales & Commercial: revenue per customer (top 5), number of new orders, pipeline of outstanding quotes, quote-to-order ratio. Segment by [SALES_CHANNEL] (direct, distributor, e-commerce).
4. Financial: gross margin per product, operational expenses (fixed & variable), working capital requirement (WCR), net cash. Include a break-even point indicator.
5. Human Resources: hours worked, absenteeism rate, operator productivity.
   For each indicator, provide: a definition, a calculation formula, a target (industry benchmark or internal goal), and an alert threshold (red/green). The dashboard should be interactive: filters by [PERIOD] and by [WORKSHOP] or [TEAM]. Add automatic interpretive comments based on trends (e.g., "OEE has decreased by 5% over the last 3 months due to [PROBLEM_CAUSE]"). Output format: detailed description of each widget with its location on the dashboard, chart types, and required data sources. Also provide a textual mockup (block layout). Adapt content to the industrial sector: technical vocabulary (OEE, lead time, WIP, etc.) and constraints (subcontracting management, machine costs, maintenance). The result should be directly actionable by a CFO, production manager, or business owner.