Skip to content
Shop | Excel tracker

Ramp-Up and Issue Tracker

Track workstreams, open issues and the ramp-up curve of a new product or line against plan.

Screenshot of the Ramp-Up and Issue Tracker workbook with example data
Example data from the workbook.

How it works

  1. Open 07 Lists. Check the workstreams, the aging limits per priority, the full rate per week and the exit rule. Enter the review date or leave it empty to use today.
  2. In 02 Workstreams, enter the lead, the reported light and the level of each workstream every week. The rule light calculates from the issue list.
  3. Enter every open point in 03 Issue List with workstream, priority, owner and due date. Enter the closing date when it is closed.
  4. In 04 Ramp-Up, enter planned output and first pass yield target per week before the start of production. Add actual output and right first time units every week.
  5. Read 05 Dashboard in the weekly status: attainment, first pass yield, the gap in good units, issues past their limit, lights.
  6. Agree actions in 06 Action Plan, with owner and date.

Definitions used in the workbook

  • Output attainment: Actual output divided by planned output, added up over the weeks with actual data.
  • First pass yield: Units right first time, without rework or scrap, divided by units started. Actual output counts every unit started in the week.
  • Good unit attainment: Right first time units divided by planned good units (planned output times target first pass yield).
  • Age: Days from raised to closed, or to the review date while open. Past the limit: launch manager. Past twice the limit: sponsor.
  • Rule light: Red if an issue of the workstream is past its limit. Amber if more than two issues are open or one is overdue. Otherwise green.

Sheets in the workbook

  1. Start
  2. Workstreams
  3. Issue List
  4. Ramp-Up
  5. Dashboard
  6. Action Plan
  7. Lists

Who it is for

Launch and project managers who bring a new product into series production.

The method behind the numbers

This workbook is part of the Launch Management toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.