Production flow dashboard Budget 90 $
Budget: $10 – $30 USD
Production Flow Dashboard – MODA Windows & Doors
Objective
This dashboard is designed to monitor and control the entire production workflow, ensuring that every department performs its tasks on time and every job progresses smoothly from sales confirmation to final QC completion.
The system includes 4 different users, each responsible for a specific stage of the process.
WORKFLOW STRUCTURE
User 1 – Sales
The first user is the Sales representative.
Once the order is confirmed by the customer, the Sales user must create or update the job in the system.
Sales must input:
Job Number / Order Number
Customer Name
Project Name / Location
Date of Order Confirmation
Total number of windows / doors
System type
Special notes / remarks
Required completion date (if any)
Current status = “Waiting for Measurement”
The Sales role is to officially initiate the production process.
User 2 – Technician / Measurement
The second user is the Technician responsible for site measurements.
After receiving the job, the Technician must update the system with the scheduled measurement date and confirm when the measurement is completed.
Technician must input:
Measurement scheduled date
Actual measurement completion date
Measurement status
Approved for production = Yes / No
Notes for production
Any technical issues or delay reasons
Current status = “Measurement Complete” or “Waiting for Cutting List”
Goal:
Track which jobs are pending measurement
Track scheduled measurement dates
Identify completed vs delayed measurements
User 3 – Stock / Storage
The third user is the Stock / Storage department.
After measurement is completed, the cutting list and required materials must be entered into the system. The Stock user is responsible for preparing the materials.
Stock / Storage must input:
Cutting list uploaded = Yes / No
Date cutting list received
Required materials
Materials availability = Yes / No
Missing materials
Estimated materials ready date
Actual materials ready date
Delay reason (if any)
Current status = “Materials Preparing” or “Ready for Production”
Goal:
Ensure all materials are available
Identify shortages
Track preparation time
Prepare jobs for production
User 4 – Production
The fourth user is the Production department.
Once materials are received, Production must define the completion timeline and finalize the job with QC.
Production must input:
Date materials received
Production start date
Estimated completion date
Actual completion date
QC completed = Yes / No
QC result = Pass / Fail
QC notes
Delay reason (if any)
Final status = “Completed”, “QC Issue”, or “Delayed”
QC CHECKLIST (MANDATORY)
Before marking a job as completed, Production must complete a QC checklist.
QC Checklist includes:
Profile correct
Glass correct
Hardware correct
Rubber installation correct
Silicone / sealing correct
Dimensions verified
Opening / closing function tested
Lock / handle tested
Frame alignment checked
Accessories complete
No scratches or damage
Proper packing
Ready for delivery / installation
Each item must be:
Yes / No
Comment required if “No”
A job cannot be marked as completed without QC approval.
MAIN JOB STATUS FLOW
Each job must have a clear status visible to the admin.
Status options:
Order Confirmed
Waiting for Measurement
Measurement Scheduled
Measurement Complete
Waiting for Cutting List
Materials Preparing
Materials Ready
In Production
QC Pending
Completed
Delayed
QC Issue
SLA / TARGET DAYS PER STAGE
Each stage must have a defined target timeline.
Example targets:
Sales update: same day
Measurement scheduling: within 1 day
Measurement completion: as scheduled
Cutting list submission: within 1 day after measurement
Material preparation: based on availability
Production start: same day after materials ready
Production completion: based on job size
QC completion: same day as production completion
Color Indicators:
Green = On track
Orange = Warning / slight delay
Red = Critical delay
ADMIN DASHBOARD REQUIREMENTS
1. Job Overview
Total active jobs
Completed jobs
Delayed jobs
Jobs with QC issues
2. Jobs by Stage
Sales stage
Measurement stage
Stock stage
Production stage
Completed jobs
3. Performance by User / Department
Number of jobs handled per user
On-time completion rate
Delayed jobs per user
Average days per stage
4. Delay Monitoring
Delays in measurement
Delays in stock
Delays in production
Delay reasons
5. Production Forecast
Jobs finishing today
Jobs finishing this week
Overdue jobs
6. QC Monitoring
Jobs pending QC
Jobs passed QC
Jobs failed QC
Common QC issues
REQUIRED DATA FIELDS (PER JOB)
Each job record must include:
Job Number
Customer Name
Project Name
Sales User
Order Confirmation Date
Number of Units
Measurement Scheduled Date
Measurement Completed Date
Technician User
Cutting List Status
Cutting List Date
Stock User
Materials Ready Date
Production User
Production Start Date
Estimated Completion Date
Actual Completion Date
QC Status
QC Completion Date
Delay Reason
Final Status
Remarks
AUTOMATION LOGIC
The system should include automation between stages:
Sales confirms order → Job appears for Technician
Technician completes measurement → Job moves to Stock
Stock prepares materials → Job moves to Production
Production completes + QC → Job marked as Completed
ADMIN CONTROL
The admin must be able to:
View all jobs in real time
Identify delays and responsible users
Detect bottlenecks in workflow
Compare expected vs actual completion dates
Filter by user, project, date, and status
Quickly identify problematic jobs
FINAL GOAL
The goal of this dashboard is:
To give the admin a clear, real-time overview of the entire production flow—from order confirmation to final QC—ensuring that:
No job is lost
Every user updates their stage
Every step has accountability
Every delay is visible
Every project is controlled
If you want next step, I can convert this into: Google Sheets structure (tabs + columns + formulas + dashboard layout) ready for direct implementation.
Objective
This dashboard is designed to monitor and control the entire production workflow, ensuring that every department performs its tasks on time and every job progresses smoothly from sales confirmation to final QC completion.
The system includes 4 different users, each responsible for a specific stage of the process.
WORKFLOW STRUCTURE
User 1 – Sales
The first user is the Sales representative.
Once the order is confirmed by the customer, the Sales user must create or update the job in the system.
Sales must input:
Job Number / Order Number
Customer Name
Project Name / Location
Date of Order Confirmation
Total number of windows / doors
System type
Special notes / remarks
Required completion date (if any)
Current status = “Waiting for Measurement”
The Sales role is to officially initiate the production process.
User 2 – Technician / Measurement
The second user is the Technician responsible for site measurements.
After receiving the job, the Technician must update the system with the scheduled measurement date and confirm when the measurement is completed.
Technician must input:
Measurement scheduled date
Actual measurement completion date
Measurement status
Approved for production = Yes / No
Notes for production
Any technical issues or delay reasons
Current status = “Measurement Complete” or “Waiting for Cutting List”
Goal:
Track which jobs are pending measurement
Track scheduled measurement dates
Identify completed vs delayed measurements
User 3 – Stock / Storage
The third user is the Stock / Storage department.
After measurement is completed, the cutting list and required materials must be entered into the system. The Stock user is responsible for preparing the materials.
Stock / Storage must input:
Cutting list uploaded = Yes / No
Date cutting list received
Required materials
Materials availability = Yes / No
Missing materials
Estimated materials ready date
Actual materials ready date
Delay reason (if any)
Current status = “Materials Preparing” or “Ready for Production”
Goal:
Ensure all materials are available
Identify shortages
Track preparation time
Prepare jobs for production
User 4 – Production
The fourth user is the Production department.
Once materials are received, Production must define the completion timeline and finalize the job with QC.
Production must input:
Date materials received
Production start date
Estimated completion date
Actual completion date
QC completed = Yes / No
QC result = Pass / Fail
QC notes
Delay reason (if any)
Final status = “Completed”, “QC Issue”, or “Delayed”
QC CHECKLIST (MANDATORY)
Before marking a job as completed, Production must complete a QC checklist.
QC Checklist includes:
Profile correct
Glass correct
Hardware correct
Rubber installation correct
Silicone / sealing correct
Dimensions verified
Opening / closing function tested
Lock / handle tested
Frame alignment checked
Accessories complete
No scratches or damage
Proper packing
Ready for delivery / installation
Each item must be:
Yes / No
Comment required if “No”
A job cannot be marked as completed without QC approval.
MAIN JOB STATUS FLOW
Each job must have a clear status visible to the admin.
Status options:
Order Confirmed
Waiting for Measurement
Measurement Scheduled
Measurement Complete
Waiting for Cutting List
Materials Preparing
Materials Ready
In Production
QC Pending
Completed
Delayed
QC Issue
SLA / TARGET DAYS PER STAGE
Each stage must have a defined target timeline.
Example targets:
Sales update: same day
Measurement scheduling: within 1 day
Measurement completion: as scheduled
Cutting list submission: within 1 day after measurement
Material preparation: based on availability
Production start: same day after materials ready
Production completion: based on job size
QC completion: same day as production completion
Color Indicators:
Green = On track
Orange = Warning / slight delay
Red = Critical delay
ADMIN DASHBOARD REQUIREMENTS
1. Job Overview
Total active jobs
Completed jobs
Delayed jobs
Jobs with QC issues
2. Jobs by Stage
Sales stage
Measurement stage
Stock stage
Production stage
Completed jobs
3. Performance by User / Department
Number of jobs handled per user
On-time completion rate
Delayed jobs per user
Average days per stage
4. Delay Monitoring
Delays in measurement
Delays in stock
Delays in production
Delay reasons
5. Production Forecast
Jobs finishing today
Jobs finishing this week
Overdue jobs
6. QC Monitoring
Jobs pending QC
Jobs passed QC
Jobs failed QC
Common QC issues
REQUIRED DATA FIELDS (PER JOB)
Each job record must include:
Job Number
Customer Name
Project Name
Sales User
Order Confirmation Date
Number of Units
Measurement Scheduled Date
Measurement Completed Date
Technician User
Cutting List Status
Cutting List Date
Stock User
Materials Ready Date
Production User
Production Start Date
Estimated Completion Date
Actual Completion Date
QC Status
QC Completion Date
Delay Reason
Final Status
Remarks
AUTOMATION LOGIC
The system should include automation between stages:
Sales confirms order → Job appears for Technician
Technician completes measurement → Job moves to Stock
Stock prepares materials → Job moves to Production
Production completes + QC → Job marked as Completed
ADMIN CONTROL
The admin must be able to:
View all jobs in real time
Identify delays and responsible users
Detect bottlenecks in workflow
Compare expected vs actual completion dates
Filter by user, project, date, and status
Quickly identify problematic jobs
FINAL GOAL
The goal of this dashboard is:
To give the admin a clear, real-time overview of the entire production flow—from order confirmation to final QC—ensuring that:
No job is lost
Every user updates their stage
Every step has accountability
Every delay is visible
Every project is controlled
If you want next step, I can convert this into: Google Sheets structure (tabs + columns + formulas + dashboard layout) ready for direct implementation.