What is the percent to quota PTQ to measure goal’s accomplishments?

What is Percent to Quota PTQ?


In this article, you will learn what is the percent to quota PTQ and how to calculate it as a metric to reach your objectives related to lean manufacturing activities.e

What is Percent to Quota PTQ?

A measuring metric used to determine how effective a person or group was able to accomplish a pre-assigned task or goal.

It is calculated by dividing the accomplished figure assigned to each production unit or operator by the required minimum amount or target figure for a specified period (month, quarter, year).

The calculated PTQ may be expressed either in dollar figures (monetary terms) or in the number of goods produced or services provided (volume terms).  An example of quota is the number of finished products that an operator accomplished divided by the expected (quota) amount of product assigned that he was supposed to complete each shift or hour.

The % percent to quota can be calculated using the following formula:


% Completion

                                                 _______________                                        _     

(Now Date – Start Date) / (Expected Completion Date – Start Date)


How to interpret the Percent to Quota PTQ?

It is an extraordinary mechanism to measure the performance of any process, activity or job.

The percent to quota is a normalized value that allows you to compare different outputs in terms of compliance with the due date and the expected results in a quantitative manner.

For example,

If the %PTQ value is equal to 100% means that the person reached the expected goal or assigned task on-time.

If the %PTQ value is below 100% means that the person could NOT reach the assigned goal on the expected time. So the completion is late.

Finally, if the %PTQ value is greater than 100% means that the goal was reached before the expected due date.  In other words, the job was completed before the end date.

How to Calculate the Percent to Quota PTQ?

You can calculate the PTQ using the following formula in MS Excel.

how to calculate percent to quota
how to calculate percent to quota


Percent To Quota Formula in MS Excel:

IIf([Start]>Now() And [% Complete]>0,100+[% Complete],IIf([Start]>now() And [% Complete]=0,100,IIf(Now()=[Start],100,IIf(now()>[Finish],[% Complete],[% Complete]*([Finish]-[Start])/(Now()-[Start])))))


Percent To Quota Workflow:

What is percent to quota PTQ
What is the percent to quota PTQ?


 brought to you by CIQA logo

CIQA is a quality and regulatory consultant with 25 years of experience developing products and managing projects in the medical device supply chain, and pharmaceutical industries. Rest assured of the safety or being in the right hands.

Our Lean Manufacturing team could provide you a broad range of professional expertise implementing these techniques and tools.


For more details about what is the percent to quota PTQ, follow us.

Quality procedures templates

Three (3) Options to Create Document Control Management DCM Procedures:

Bronze Option. You Can Create Your Own Quality Procedures, using a Template.

You can download samples of the Document Control Management DCM procedure templates in .pdf format. 

To see the complete list of the most popular quality procedures templates, click here.

In addition, you can request a quotation to buy online a full SOP template document in MS Word format that is completely editable, ready to fill, and adapt to your specific needs.

Silver Option. We Can Bring You Formal Training about what is the percent to quota PTQ.

This option is recommended if you want to learn more about how to build robust quality system procedures. One of our expert(s) can provide online step-by-step training to your team (unlimited assistance) on how to build reliable SOPs using our template(s). Also, you can improve your corporate quality procedures and policies by incorporating our template(s) and tools.  It includes a fully editable template from the Bronze option, plus training, exams, and a training certificate for each assistant.  Request a quote now.

Gold Option. We Can Create Customized Quality Procedures.

One of our expert(s) will create and prepare your customized SOPs with the inputs and specific information of your company. It includes a fully editable template from the Bronze option, plus online support in document creation, implementation, and training. Request a quote online.

Get in compliance today, CONTACT US (Hablamos Español)

REFERENCES: What is the percent to quota PTQ.



Picture of Ramon Cayuela, MS, BS, Chemical Engineering

Ramon Cayuela, MS, BS, Chemical Engineering

CIQA President and CEO.
I've been working in validation engineering since 1992 with many multinational pharmaceutical companies. I love sharing my passion and knowledge with others. If you have any questions about anything (or just have general questions). I will be more than happy to assist you. You can count on the BEST customer service on CIQA. I go to great lengths to make sure my clients are 100% satisfied with their purchases and check emails/messages consistently throughout the day. You can rest assured that everything being sold here is as-described or your money back. I look forward to working with you!