Need formula

  • Thread starter Thread starter needinhelp
  • Start date Start date
N

needinhelp

I need a formula to provide the perfect score in a catagory
Using a relative index of 5 and weights

Category-Performance
Relativity Index-5
Weights-as noted below

Scope Of Work-8 (weight)
Service Level-6 (weight)
Estimate Turn Time-8 (weight)
Timeliness of Repairs-8 (weight)
Ingate To Available-6 (weight)
Inventory Reporting-4 (weight)
Staus Response-8 (weight)

Sub-total (perfect score) 137 (is this correct)
What should the formula be for this?

needinhelp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Formula Help 1
How to equally weight variables 2
Formula to calulate the weighted average 4
Formula for weighted voting/scoring 5
Need help about function 3
need help with formula 1
Challenge experts will LOVE!!, can you get the formula?? 1
Simplify Weighted Average Formula 4

Back
Top