Google Form-Linked Production Dashboard

I run a batch-manufacturing unit and need a streamlined, three-tier data flow:

• Supervisors (three junior posts) will complete a daily Google Form that captures the Batch Manufacturing Record, shift details, and all raw-material movements—material name, quantity received, supplier, quantity issued, production batch, date, time, inward/outward entries, and remaining stock.

• The Plant Manager will monitor the live Google Sheet fed by that form; he must see clean, well-validated rows with filters for date, shift, batch, and material.

• As the Owner, I want an automatically refreshed summary in Excel—pivot tables or a dashboard view—that pulls from the same Sheet and condenses key KPIs: daily production totals, material consumption vs. receipts, stock on hand, and any variances.

What I need you to build:

1. A user-friendly Google Form with the fields above, locked to prevent supervisors from editing the sheet directly.
2. A connected Google Sheet with data-validation rules, drop-downs, and colour alerts for missing or inconsistent entries.
3. A read-only manager view with slicers or simple filters.
4. An Excel dashboard (Power Query or similar) that links to the Sheet and presents high-level metrics, charts, and a printable summary page.
5. Clear instructions so the team can maintain the system without you.

Acceptance criteria: the form submits correctly from any phone, all Sheet formulas refresh without manual clicks, and the Excel file updates in under 30 seconds when opened.

If you have experience with Google Forms, Google Sheets, Power Query, and dashboard design, let’s get this running quickly.