BACKGROUND INFORMATIONFor this, the goal is for you to analyze various operational data from the Phone4U manufacturing plant and use the results of your analysis to make and justify a decision on whic

For this, the goal is for you to analyze various operational data from the Phone4U manufacturing plant and use the results of your analysis to make and justify a decision on which phone to produce. The recommendation will be made in the form of a business case analysis, a common industry tool used to provide business decision recommendations to organizational managers who will ultimately decide if the recommendation is worthwhile.

PROMPT

Please review the Process Flow Map worksheet[XLSX, file size 46.3 KB] (provided in the MS Excel file) to ensure you understand each step of the process (the process map is simplified for this project and does not contain all steps in the manufacturing of a phone in Shanghai). Do not forget to include any assumptions you made during your analysis, as this will be important to decision makers reviewing your documentation. In the first part of the final project, based on the data you received fromPhone4U, you will examine the :

1. Process Flow Map
2. Raw Data Year 1
3. Value Curve Information
4. and complete the Purchase Intent Survey
5. Recommendations: Based on your analysis, select a phone the company should produce. Justify your decision. Why should the company produce this phone?

TASKS

Your Business Case Analysis (BCA) should include the following:

1. MS Excel file that includes the Raw Data Year 1, Value Curve, and Purchase Intent Survey sheets.

2. A 3 to 4 page double-spaced BCA document using 12 pt. Times New Roman font. Use APA formatting. Appropriate tables, charts, and/or graphs should be incorporated into your BCA document. The MS Excel file is for your data analysis to support your BCA and will include raw and analyzed data. Your BCA should only include analyzed data (no raw data).

Note: The last two sheets on the provided MS Excel file will be used for other assignments.

Compose your work in a .doc or .docx file type using a word processor (such as Microsoft Word,etc.)