What goes in each box of an A3?

Background says why the problem matters to the business. Current condition says what is happening, in numbers, ideally after going to see. The goal is the number to reach and by when. Root cause analysis asks why until it reaches a cause you can act on. Countermeasures list what will be done, by whom and when. Effect confirmation checks the result with the same measure as the baseline. Follow-up says how the change is standardised and shared and what is still open.

How does the data box work out the improvement?

It averages the weeks you mark Baseline and the weeks you mark After; weeks marked Trial count in neither. When lower is better, the improvement is the baseline average minus the after average. In the example, changeovers averaged 74.0 minutes over five baseline weeks and 31.3 minutes over three after weeks, an improvement of 42.7 minutes or 57.7 percent.

How is the benefit estimate calculated?

Improvement x occurrences per year x the value of one unit of the metric, minus ongoing cost, gives the net annual benefit; payback in months is the investment divided by that, times 12. For a 40-minute cut in 480 changeovers a year at 2.50 per press minute (150 per hour), with 2,000 a year ongoing cost and 15,000 invested, the net benefit is 46,000 a year and payback is 3.9 months, the same answer as the Setup Reduction Payback calculator.

Can I use it for a quality or delivery problem, not a time problem?

Yes. Name any metric and its unit, such as scrap percent, defects per thousand or late orders, and choose whether lower or higher is better. The benefit estimate works for any unit as long as you can say what one unit is worth, for example the cost of one scrapped part.

Why is there a status date instead of today's date?

So the A3 you print or send stays the same. Countermeasure statuses are judged at the date on Setup; change it at each review and the overdue and due-soon words update.

Should I use an A3 or an 8D?

Use an A3 for improvement work and for problems you choose to attack, and an 8D when a customer or your procedure requires a formal corrective action with containment. Many plants use both: the 8D for the customer record and the A3 to work the problem. Track 8Ds in the CAPA and 8D Tracker template.

Quality Systems and Compliance

A3 Problem Solving Excel Template

Work one problem through on one sheet, from background to follow-up, with the data that proves the countermeasures worked and an estimate of what the fix is worth.

Overview

This A3 problem-solving template is a working Excel form for team leaders, engineers and managers who use A3 thinking to solve and report one problem at a time. It ships with a worked example, cutting mould changeover time on one injection press at a fictional moulder, so you can see a complete A3 before you start your own; overwrite the yellow cells and everything recalculates.

The A3 sheet follows the usual story in seven boxes: why the problem matters, what is happening in numbers, the goal, the root cause found by asking why, the countermeasures with owners and dates, the effect, and the follow-up. Unlike a blank form, it does the arithmetic: the data box averages the baseline weeks and the after weeks (trial weeks count in neither), works out the improvement and the gap still to go in the direction you choose, and charts the metric against the target. Countermeasures get a status at a date you type, and the benefit estimate turns the improvement into money per year and a payback; for a time metric in minutes it is the same model as the Setup Reduction Payback calculator on this site.

In practice, start the A3 when the problem is chosen, measure a baseline before changing anything, and update the data box and the countermeasure dates at each review. In the example, changeovers fell from an average of 74 minutes to 31.3 minutes, within 5 percent of the 30-minute target, with one countermeasure overdue and one due next week; the improvement is worth about 49,000 a year at the example values and pays back the 15,000 investment in under four months.

What this template includes

One printable A3 sheet with a header (title, owner, sponsor, area, dates) and the seven boxes: background, current condition, goal, root cause analysis, countermeasures, effect confirmation and follow-up
A 10-week data box: mark each week Baseline, Trial or After and type the measured value; the baseline and after averages, the improvement, the improvement in percent and the gap still to go are calculated in the direction you choose (lower or higher is better)
A chart of the metric by week with the baseline average and the target
Five whys and a root cause statement
A countermeasure list with owner, due and done dates and a status word (Complete, Overdue, Due soon, In progress) judged at a typed status date
A benefit estimate in your currency: improvement x occurrences per year x the value of one unit of the metric, less ongoing cost, and the payback on the investment
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference (Self-check: PASS)

Suggested use case

Use it for a kaizen or improvement project, a customer complaint that needs a structured answer, a problem-solving coaching session, or to report a finished improvement to management on one page.

How to use it

On Setup, type your organisation, your currency label and the status date for the countermeasures.
On the A3 sheet, fill in the header, the background and the current condition, naming the metric, its unit and whether lower or higher is better.
Type the weekly values in the data box, marking each week Baseline, Trial or After, and set the target and target date.
Work through the five whys to the root cause, then list the countermeasures with owners and due dates, and type the done dates as they finish.
Read the effect against the target and the benefit estimate, write the follow-up, and print the sheet or save it as PDF.

Frequently Asked Questions

What goes in each box of an A3?: Background says why the problem matters to the business. Current condition says what is happening, in numbers, ideally after going to see. The goal is the number to reach and by when. Root cause analysis asks why until it reaches a cause you can act on. Countermeasures list what will be done, by whom and when. Effect confirmation checks the result with the same measure as the baseline. Follow-up says how the change is standardised and shared and what is still open.
How does the data box work out the improvement?: It averages the weeks you mark Baseline and the weeks you mark After; weeks marked Trial count in neither. When lower is better, the improvement is the baseline average minus the after average. In the example, changeovers averaged 74.0 minutes over five baseline weeks and 31.3 minutes over three after weeks, an improvement of 42.7 minutes or 57.7 percent.
How is the benefit estimate calculated?: Improvement x occurrences per year x the value of one unit of the metric, minus ongoing cost, gives the net annual benefit; payback in months is the investment divided by that, times 12. For a 40-minute cut in 480 changeovers a year at 2.50 per press minute (150 per hour), with 2,000 a year ongoing cost and 15,000 invested, the net benefit is 46,000 a year and payback is 3.9 months, the same answer as the Setup Reduction Payback calculator.
Can I use it for a quality or delivery problem, not a time problem?: Yes. Name any metric and its unit, such as scrap percent, defects per thousand or late orders, and choose whether lower or higher is better. The benefit estimate works for any unit as long as you can say what one unit is worth, for example the cost of one scrapped part.
Why is there a status date instead of today's date?: So the A3 you print or send stays the same. Countermeasure statuses are judged at the date on Setup; change it at each review and the overdue and due-soon words update.
Should I use an A3 or an 8D?: Use an A3 for improvement work and for problems you choose to attack, and an 8D when a customer or your procedure requires a formal corrective action with containment. Many plants use both: the 8D for the customer record and the A3 to work the problem. Track 8Ds in the CAPA and 8D Tracker template.