# Product Compliance Test Plan and Budget Worksheet

> Source: https://netray.co/tools/product-compliance-test-plan-budget-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Plan every test needed to sell a product in each market, with cost, lead time and a running total you can export to Excel.

## Category

compliance-legal

## Audience

- Compliance engineer
- Product manager
- Test lab coordinator

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Regulation or standard

**Key:** regulation

**Type:** text

#### Market

**Key:** market

**Type:** select

**Options:**

- EU
- UK
- US
- Canada
- China
- India
- Japan
- Korea
- Global

#### Test scope

**Key:** scope

**Type:** text

#### Number of tests

**Key:** tests

**Type:** number

#### Cost per test

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** tests * unit_cost

**Format:** currency

#### Lead time (weeks)

**Key:** weeks

**Type:** number

#### Target date

**Key:** due

**Type:** date

**Rows:**

**Regulation:** EN 55032 / FCC Part 15

**Market:** EU

**Scope:** Radiated and conducted emissions

**Tests:** 2

**Unit cost:** 3200

**Weeks:** 3

**Due:** 2026-12-04

**Regulation:** IEC 62368-1

**Market:** Global

**Scope:** Product safety evaluation

**Tests:** 1

**Unit cost:** 9500

**Weeks:** 8

**Due:** 2027-01-22

**Regulation:** RoHS (EN IEC 63000)

**Market:** EU

**Scope:** Technical documentation and XRF screen

**Tests:** 12

**Unit cost:** 150

**Weeks:** 2

**Due:** 2026-11-20

**Regulation:** REACH SVHC screen

**Market:** EU

**Scope:** Candidate List check on key articles

**Tests:** 6

**Unit cost:** 320

**Weeks:** 3

**Due:** 2026-11-27

**Regulation:** IEC 60068-2 series

**Market:** Global

**Scope:** Environmental: vibration and temperature

**Tests:** 3

**Unit cost:** 2100

**Weeks:** 4

**Due:** 2026-12-18

**Totals:**

#### Total test budget

**Key:** ext

**Agg:** sum

**Format:** currency

#### Longest lead time (weeks)

**Key:** weeks

**Agg:** max

**Format:** number

#### Total tests

**Key:** tests

**Agg:** sum

**Format:** integer

**Summary:**

#### Average cost per test

**Key:** avg_cost

**Expr:** sum_ext / sum_tests

**Format:** currency

#### Budget with 15% contingency

**Key:** contingency

**Expr:** sum_ext * 1.15

**Format:** currency

**Primary:** true

**Notes:** Costs are example figures. Replace them with lab quotes. The longest lead time is a floor for the schedule only if tests can run in parallel; some tests depend on earlier results.

## Content

**Intro:** A compliance test plan turns a list of markets into tests, costs and dates. This worksheet lets you build the plan row by row, see the total and the longest lead time, and export it for the project file or a lab request for quote.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per regulation or standard and market. State the scope in plain words so the lab can quote it, then enter the number of tests and the cost per test. The extended cost is calculated for you. Add the lead time in weeks and a target date. The totals update as you edit, and the summary adds a contingency line, which is useful because test programs rarely run to the first quote.

**Bullets:**

- One row per standard and market
- Split a row if the cost differs by sample type
- Keep the quote reference in the scope field

#### What belongs in the plan

**Body:** Start from the markets and the product category. For electronics, the typical set covers safety, EMC, radio if applicable, environmental stress, and substance restrictions such as RoHS and REACH. For other products, add the sector rules that apply, for example food contact, battery transport tests or machinery safety. Add documentation tasks as rows too, such as technical file preparation, because they cost time and money. The plan should name who owns each row.

**Bullets:**

- Safety, EMC and radio standards by market
- Substance restrictions and declarations
- Environmental and reliability tests
- Technical file and declaration of conformity

#### Reading the totals

**Body:** The total test budget is the sum of extended costs, and the contingency line adds 15%. The longest lead time is a rough schedule driver, but real critical paths depend on sample availability and on whether failed tests need design changes. Compare the average cost per test across plans to spot rows that are far from market. If a row is much higher than average, ask the lab whether the scope can be reduced by using existing reports.

#### Common mistakes

**Body:** Plans often omit retest allowance, sample costs, shipping to the lab and the time to fix failures. Another mistake is planning all markets at once when the first launch needs only one or two. Order the rows by launch date, and keep a column for the report number once the test is finished so evidence is easy to find during an audit or a customer request.

**Cta:** Netray can help you connect product and market data in your ERP to this kind of plan, so required evidence follows the item through its lifecycle.

**Faq:**

#### How much contingency should I add?

**Answer:** Fifteen percent is a common starting point for a first-time design. Use less for a derivative product with known results, and more for new technology, a new lab or a market you have not entered before.

#### Can existing reports cover a new product?

**Answer:** Sometimes. If the new product is a minor variant and the differences do not affect the tested characteristics, labs can often issue a delta report or accept a technical rationale. Ask the lab and the certification body early.

#### Should RoHS be in a test plan?

**Answer:** RoHS is demonstrated through technical documentation, which may include supplier declarations and test data such as XRF screening. Include the effort and any lab analysis you plan to use.

#### What is the lead time for certification?

**Answer:** It varies widely by standard, body and queue. A simple EMC test can take days, a full safety evaluation weeks, and some national schemes months. Take current figures from your quotes.

## Search terms

compliance test plan template, product certification test plan excel, regulatory test budget, emc safety test plan, compliance project plan worksheet, test lab quote comparison, market access test matrix, certification schedule template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json