Assignment: BACKGROUND INFORMATION
In this module, you focus on the concept and principles of learning rates and customer value determination. In this assignment, you will be able to practice and develop your analysis of an alternative skill set. This activity will allow you to explore new product selection using data. You will have to decide which data should drive your decision and be able to support/justify your choice.
This activity addresses the following Module Outcome:
• Analyze customer value curves and purchase intent surveys to forecast sales for a variety of new products and recommend the best option for a business to pursue.(CO#1)
PROMPT
Utilizing the Exercise Data MS Excel File [XLSX, file size 18.2 KB], answer the following questions: .
TASKS
1. 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.
2. 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.
3. 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?
4. 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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Excercise-Data.rar