Bug Tracking Templates - Excel

W
Description

Bug Tracking Templates document sample

Document Sample
scope of work template
							Detection Costs
Test Budget                          $1,000,000
Future Value of Assets Created          100,000
Regression Test Costs                   500,000

Net Detection Costs                  $400,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   267

Internal Failure Costs
Pre-Release Bug Fix Costs              750,000    Assume 30 developers, burdened salary rate of $100,000 per year, three mont
Regression Test Costs                  500,000

Net Internal Failure Costs           $1,250,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   833

External Failure Costs
Sustaining Costs                      3,000,000   Assume 30 developers+10 testers+20 tech support, burdened salary rate of $1
Percentage Bug-Related                     50%

Net External Failure Costs           $1,500,000
Must-Fix Bugs Found After Testing        500

Approximate Cost per Bug               3,000


Return on Investment
Cost of Quality (w/testing)         3,150,000
Cost of Quality (w/o testing)       6,000,000
Net Benefit of Testing              2,850,000
Approximate Testing ROI                 713%
00,000 per year, three months (System Test period fixing bugs)




, burdened salary rate of $100,000 per year, six months after initial release.
Detection Costs
Test Budget                          $1,000,000
Future Value of Assets Created          100,000
Regression Test Costs                   500,000

Net Detection Costs                  $400,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   267

Internal Failure Costs
Pre-Release Bug Fix Costs              750,000    Assume 30 developers, burdened salary rate of $100,000 per year, three mont
Regression Test Costs                  500,000

Net Internal Failure Costs           $1,250,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   833

External Failure Costs
Sustaining Costs                      3,000,000   Assume 30 developers+10 testers+20 tech support, burdened salary rate of $1
Percentage Bug-Related                     50%

Net External Failure Costs           $1,500,000
Must-Fix Bugs Found After Testing        500

Approximate Cost per Bug               3,000

Bugs Not Fixed But Known
Known, Significant, Unfixed Bugs         500
Cost Per Support Call                     $6
Support Calls per Bug                    100    100   Assume that only one in 500 customers encounters the p
Cost Savings for Known Bugs             50%

Net Savings From Known Bugs         $150,000

Return on Investment
Cost of Quality (w/testing)         3,150,000
Cost of Quality (w/o testing)       6,000,000
Known Bug Savings                     150,000

Net Benefit of Testing              3,000,000

Approximate Testing ROI                750%
00,000 per year, three months (System Test period fixing bugs)




, burdened salary rate of $100,000 per year, six months after initial release.
ustomers encounters the problem and boths to call about it.
Detection Costs
Test Budget                          $1,000,000
Future Value of Assets Created          100,000
Regression Test Costs                   500,000

Net Detection Costs                  $400,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   267

Internal Failure Costs
Pre-Release Bug Fix Costs              750,000    Assume 30 developers, burdened salary rate of $100,000 per year, three mont
Regression Test Costs                  500,000

Net Internal Failure Costs           $1,250,000

Must-Fix Bugs Found During Testing        1,500

Approximate Cost per Bug                   833

External Failure Costs
Sustaining Costs                      3,000,000   Assume 30 developers+10 testers+20 tech support, burdened salary rate of $1
Percentage Bug-Related                     50%

Net External Failure Costs           $1,500,000
Must-Fix Bugs Found After Testing            500

Approximate Cost per Bug                   3,000

Bugs Not Fixed But Known
Known, Significant, Unfixed Bugs             500
Cost Per Support Call                         $6
Support Calls per Bug                        100    100   Assume that only one in 500 customers encounters the p
Cost Savings for Known Bugs                 50%

Net Savings From Known Bugs             $150,000

Tests that Pass
Number of Test Cases                         175
Percentage Tests Failed First Attempt       50%
Average Must-Fix Bugs Per Failed Test          1
Cost per Bug Shipped to Field             $3,000

Insurance Value (Expected Payout)       $262,500


Return on Investment
Cost of Quality (w/testing)             3,150,000
Cost of Quality (w/o testing)           6,000,000
Known Bug Savings                         150,000
Insurance Value                           262,500

Net Benefit of Testing                  3,262,500
Approximate Testing ROI   816%
00,000 per year, three months (System Test period fixing bugs)




, burdened salary rate of $100,000 per year, six months after initial release.
ustomers encounters the problem and boths to call about it.
Detection Costs
Test Budget                             $1,000,000
Future Value of Assets Created             100,000
Regression Test Costs                      500,000

Net Detection Costs                     $400,000

Must-Fix Bugs Found During Testing           1,500

Approximate Cost per Bug                      267

Internal Failure Costs
Pre-Release Bug Fix Costs                 750,000    Assume 30 developers, burdened salary rate of $100,000 per year,
Regression Test Costs                     500,000    three months (System Test period fixing bugs)

Net Internal Failure Costs              $1,250,000

Must-Fix Bugs Found During Testing           1,500

Approximate Cost per Bug                      833

External Failure Costs
Sustaining Costs                         3,000,000   Assume 30 developers+10 testers+20 tech support, burdened salary
Percentage Bug-Related                        50%    rate of $100,000 per year, six months after initial release.

Net External Failure Costs              $1,500,000

Must-Fix Bugs Found After Testing             500

Approximate Cost per Bug                     3,000

Bugs Not Fixed But Known
Known, Significant, Unfixed Bugs              500
Cost Per Support Call                          $6
Support Calls per Bug                         100    Assume that only one in 500 customers encounters the problem and
Cost Savings for Known Bugs                  50%     bothers to call about it.

Net Savings From Known Bugs             $150,000

Tests that Pass
Number of Test Cases                          175
Percentage Tests Failed First Attempt        50%
Average Must-Fix Bugs Per Failed Test           1
Cost per Bug Shipped to Field              $3,000

Insurance Value (Expected Payout)        $262,500

Good Project Tracking
Development Budget                      $3,000,000   Assume 30 developers+10 managers, $100,000 fully burden salarly
Testing Budget                          $1,000,000   rate, nine months of development.

Total Project Budget                    $4,000,000

Reduced Risk Due to Project Tracking         20%
Value of Good Project Tracking   $800,000

Net Value of Test Information    $200,000

Return on Investment
Cost of Quality (w/testing)      3,150,000
Cost of Quality (w/o testing)    6,000,000
Known Bug Savings                  150,000
Insurance Value                    262,500
Test Information                   200,000

Net Benefit of Testing           3,462,500

Approximate Testing ROI             866%

						
Related docs
Other docs by ysw82043
Building Contractor Estimate - PDF
Views: 69  |  Downloads: 1
Building Contractor Draw Schedule - PDF
Views: 213  |  Downloads: 0
Builder Document Templates
Views: 15  |  Downloads: 0
Budgeting Commercial Bank
Views: 21  |  Downloads: 0
Build Content Management
Views: 41  |  Downloads: 1
Building Budget Estimate Form - PDF
Views: 44  |  Downloads: 0
Budget Vs Expenses Non Profit - PDF
Views: 238  |  Downloads: 0
Budget Worksheets for a Hr Consultancy - DOC
Views: 181  |  Downloads: 0