Utilizing the
Exercise Data MS Excel File
[XLSX, file size 18.2 KB], answer the following questions: .
TASKS
- Calculate the Purchase Probability for each of the four phone options (A through D), utilizing the data from the worksheet “Purchase Intent Survey,” located within the Exercise MS Excel file. Record your data in the worksheet. Each problem should be its own worksheet.
- Utilizing the data from the worksheet “Purchase Intent Survey,” located within the Exercise MS Excel file, select which phone your company should produce (you can only produce one because of manufacturing costs). Justify your answer with a brief explanation.
- If you were able to eliminate the adjustment for Phone B, would this change the phone you would select for production? Why or why not? What is the “Adjustment” factor used for?
- Using the data from Question # 1 and the worksheet “Value Curve,” located within the Exercise MS Excel file, which phone would you recommend for your company to produce? Why? Explain why a value curve and a purchase intent survey should be utilized in conjunction with each other to help determine which product to produce.
Guidelines for Submission: The answers to the questions that require an explanation should be submitted in a Word document. You will need to support all of your answers to the problems with appropriate calculations, which should be submitted in the Excel File (each problem should be its own worksheet). You can label each worksheet based on problem number (i.e. – “M2A3 Problem 1”). You will also need to fill in the “Purchase Intent Survey.” If you need to support your answers to the written questions with relevant resources, cite using APA format.
Compose your work in a or x file type using a word processor (such as Microsoft Word, etc.)
>Value Curve
0 5 2 5 0 1 3 2 1 3 4 9 7 7 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 Do not change this number Response Count Percentage Adjustment Purchase Probability (Overall) 0.2 Do not change this number Do not change this number Purchase Probability (Overall) Estimated number of Adopters = Response Count Percentage Adjustment Purchase Probability (Overall) 0.2 Do not change this number Do not change this number Purchase Probability (Overall) Estimated number of Adopters = Response Count Percentage Adjustment Purchase Probability (Overall) 0.5 0.2 Population Size 17500 Do not change this number Estimated number of Adopters =
2
Value Parameter
Phone A
Phone B
Phone C
Phone D
Affordability
1
1
0
4
Available Features
5
7
Color Options
6
9
Durability
3
8
Cost
10
Quality
Speed
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
Purchase Probability (Overall)
Estimated number of Adopters =
Phone B
Definitely Yes 20 0.5
Likely Yes
206
Possibly
292
Likely No
16
Definitely No
78
Population Size
55000
Awareness and Availability
0.03
Phone C
Definitely Yes 7 0.5
Likely Yes
84
Possibly
61
Likely No
46
Definitely No
166
Population Size
17500
Awareness and Availability
0.08
Phone D
Definitely Yes
158
Likely Yes
159
Possibly 5
Likely No
31
Definitely No 16
Awareness and Availability 0.08 Do not change this number
Purchase Probability (Overall)