Content Bb UTF-8*2022 Content C office Editing for Docs, Sheets \& Slide X UTF-8"2022FallProject3MBA641.XIsX File Edit Insert Format Help Content Bb UTF-8*2022 Content UTF-8"2022FallProject3MBA641.xIsX File Edit Insert Format Help A fx A 39 Required: 40 1. Develop a customer profitability analysis for Aeronautics Company that shows the sales, cost of goods sold, gross profit on sales, and each cost as a line item that can be assigned to ea 41 The customer profitability analysis should show column information for each customer along with a total column for the company. 42 Include the customer profitability ratio for each customer and the company. The customer profitability ratio should be shown in percentage terms taken out to 2 decimal places. Make sure you use cell r 43 2. Provide a detailed recommendation to management on what type of actions the company should take as a result of this analysis in the textbox provided below. 44 In your recommendation you need to specifically identify the different customers. For example, provide information explicitly identifying the results from each customer based 45 on the results of the customer profitability analysis. Provide a discussion of an outside reference other than the textbook on the importance and usace of customer profitability analysis. \begin{tabular}{|l|l|l|l|l|} \hline Project 3 Introduction & Part 1 InstructionsAndSolution & Part 2 Instructions & Part 2 Response & Part 3 InstructionsAndSolution \end{tabular} 68 Make sure you include the reference in APA style. Enter your response in the textbox below. Content Bb UTF-8*2022 Content C office Editing for Docs, Sheets \& Slide X UTF-8"2022FallProject3MBA641.XIsX File Edit Insert Format Help Content Bb UTF-8*2022 Content UTF-8"2022FallProject3MBA641.xIsX File Edit Insert Format Help A fx A 39 Required: 40 1. Develop a customer profitability analysis for Aeronautics Company that shows the sales, cost of goods sold, gross profit on sales, and each cost as a line item that can be assigned to ea 41 The customer profitability analysis should show column information for each customer along with a total column for the company. 42 Include the customer profitability ratio for each customer and the company. The customer profitability ratio should be shown in percentage terms taken out to 2 decimal places. Make sure you use cell r 43 2. Provide a detailed recommendation to management on what type of actions the company should take as a result of this analysis in the textbox provided below. 44 In your recommendation you need to specifically identify the different customers. For example, provide information explicitly identifying the results from each customer based 45 on the results of the customer profitability analysis. Provide a discussion of an outside reference other than the textbook on the importance and usace of customer profitability analysis. \begin{tabular}{|l|l|l|l|l|} \hline Project 3 Introduction & Part 1 InstructionsAndSolution & Part 2 Instructions & Part 2 Response & Part 3 InstructionsAndSolution \end{tabular} 68 Make sure you include the reference in APA style. Enter your response in the textbox below