This sample Excel project plan for pharmaceutical generic product development has been designed to show project flow from license requirement to milestones and WBS. It provides a real-time assessment from project inception for drug development in R&D to dossier submission with regulatory agencies.
60 items found
Project bugs and the forecasting of progress can be complex. An Excel spreadsheet can be employed to gauge the progress of the testing and resolution teams. Using this simplistic method in conjunction with test-estimation techniques can help the project manager determine the completion date for testing efforts. Use this template in conjunction with the article Software-Simplistic Prediction Model for Bug Forecasting.
This template can help project managers plan key planning and customer activities in preparation for go-live. It can be easily tailored for deployment planning for projects of all sizes.
The Project Completion Report is the final document produced for the project and is used by sponsor, steering committee and senior management to assess the success of the project, identify best practices for future projects, resolve all open issues and formally close the project.
This sample Project Charter and instructions contain sections (and explanations) for project and team details, your scope statement and risks, communication strategy and more.
The Pareto Chart is a simple yet powerful tool that allows one to distinguish between the critical few and trivial many. While this is a quality tool, it can be used by any project team for any project type. Microsoft Excel currently does not have built-in functionality to create a Pareto Chart; this Excel template has an in-built macro that can generate a Pareto chart with just a click of a button.
The Project Scope Statement documents the entire scope, including project and product scope. It describes the project’s deliverables in detail. It also provides a common understanding of the project scope among project stakeholders. Use this outline as a basis for your statement.
This sample risk register includes guidelines for each field; modify as needed for your own organizational needs.
The main objective of a lessons learned session is identifying how to sustain strengths and improve weaknesses on future projects. Customize this template to include only lesson categories applicable to your project. Distribute the customized template to participants of the lessons learned session at least one week prior to the date of the discussion to provide their feedback, then compile them all into a master copy. Use in conjunction with the other templates in the Lessons Learned Package.
Lessons learned should be captured and placed in a database log that will be available to the project management team. Use in conjunction with the other templates in the Lessons Learned Package.