A production dashboard that answers one question per tab

Your production dashboard is down to four tabs, and each answers one question. Completions is what you built and how long it took. Stalled Orders is what's been open too long. Hours is where the time went. Plan vs Actual is whether finished work is keeping pace with the plan and the hours. Nothing appears on two tabs any more, and the Trends tab is gone, with its charts moved to the tab they belong on.

Every tab now has Phase, Stage and Tags filters under the dates. Tags follow the work down: tag a release and every order under it counts, tag one order and only that order does. That makes a tag the way to tell kinds of order apart inside one project, say "Large Skid" or "Rack". Until you've set up phases or tags, the filters say No phases yet and No tags yet.

Completions leads with the Completions table, by project, release and order, with a Qty and a Duration for each order: the calendar days from the first time anyone clocked in on it or recorded progress, to the day it was done. Under it, Orders Completed per Week with a 3-week average line, and Duration per Order, one point per order with the running average.

Stalled Orders counts stages open past a number of days you choose, seven to start, on the same clock as Duration. Stalled Stages per Week shows whether that number is rising or falling, built from your history, so it has weeks to show from the start. Click a card to open the orders behind it.

Hours moves Production Rate per Week, Hours by Phase and Hours per Order to the top. Hours per Order counts every hour booked on each order finished in your dates, including hours from before them. New charts show Utilization by Project and Headcount by Skill. Click any card to open a page with the detail behind it. Exporting a chart to Excel now gives you the names you see on screen, with no internal IDs.

Plan vs Actual is one table: Planned, Earned, Spent, Earn − Plan, Earn − Spent, % Earned and % Earn − Spent, with a Total row. Group it by project, phase, stage or order, and open a project down to each order. Earn − Plan above zero means ahead of schedule; Earn − Spent above zero means the work finished was worth more than the hours it took. Charts below compare Earned with Spent and with Planned, by project and by week.