Operations management.. if you can do my prior one you can do this one..

profilepcwc0506
BUS520actdata.xlsx

Value Curve

Value Parameter Phone A Phone B Phone C Phone D
Affordability 1 10 4 0
Available Features 5 5 2 7
Color Options 5 6 0 9
Durability 3 8 1 3
Cost 2 1 10 3
Quality 4 9 7 7
Speed 7 2 7 2

Phone Options Value Curves

Phone A Affordability Available Features Color Options Durability Cost Quality Speed 1 5 5 3 2 4 7 Phone B Affordability Available Features Color Options Durability Cost Quality Speed 10 5 6 8 1 9 2 Phone C Affordability Available Features Color Options Durability Cost Quality Speed 4 2 0 1 10 7 7 Phone D Affordability Available Features Color Options Durability Cost Quality Speed 0 7 9 3 3 7 2

Value Score

Purchase Intent Survey

Phone A
Response Count Percentage Adjustment Purchase Probability (Overall)
Definitely Yes 77 0.5
Likely Yes 259 0.2
Possibly 95
Likely No 21
Definitely No 20
Population Size 20000 Do not change this number
Awareness and Availability 0.075 Do not change this number
Purchase Probability (Overall)
Estimated number of Adopters =
Phone B
Response Count Percentage Adjustment Purchase Probability (Overall)
Definitely Yes 20 0.5
Likely Yes 206 0.2
Possibly 292
Likely No 16
Definitely No 78
Population Size 55000 Do not change this number
Awareness and Availability 0.03 Do not change this number
Purchase Probability (Overall)
Estimated number of Adopters =
Phone C
Response Count Percentage Adjustment Purchase Probability (Overall)
Definitely Yes 7 0.5
Likely Yes 84 0.2
Possibly 61
Likely No 46
Definitely No 166
Population Size 17500 Do not change this number
Awareness and Availability 0.08 Do not change this number
Purchase Probability (Overall)
Estimated number of Adopters =
Phone D
Response Count Percentage Adjustment Purchase Probability (Overall)
Definitely Yes 158 0.5
Likely Yes 159 0.2
Possibly 5
Likely No 31
Definitely No 16
Population Size 17500 Do not change this number
Awareness and Availability 0.08 Do not change this number
Purchase Probability (Overall)
Estimated number of Adopters =