Operations Management - Calculate the Purchase Probability

Operations Management

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.

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 .doc or .docx file type using a word processor (such as Microsoft Word, etc.)

Value Curve

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