Tableau DA 13-2: Exercise, Computing profit margin and return on assets LO P3 As consultants in advisory services, we are hired by Sayko Corp to help analyze its regional operations in the contiguous U.S. Sayko wishes to draw on our expertise in financial statement analysis to help identify further expansion of operations. A Tableau Dashboard is provided to aid our analysis. Regional Accounting Data for Contiguous U.S. West Midwest Northeast Regional Accounting Data for Contiguous U.S. a + Canada 1 Columbia askatchewan Manitoba Quebec Newfou and La Ontario ces dwest West Net Sales: Net Income: Average Total Assets: $137,500 Current Liabilities: $70,000 $110,000 $22,000 Northeast Southwest Southeast Prey 1 Regional Accounting Data for Contiguous U.S. Q Canada + IGA Columbia Saskatchewan Manitoba Alberta Quebec Newfou and tal Ontario West Midwest Net Sales: Net Income: Average Total Assets: $20,000 Current Liabilities: $2,900 $15,000 $1,800 lortheast Southwest Southeast jional Accounting Data for Contiguous U.S. Canada Alberta Quebec West Midwest Nortlaasti Northeast Net Sales: $52,000 Net Income: $9,360 Average Total Assets: $78,000 Current Liabilities: $21,000 Southwest 1 South Mexico British Columbia Saskatchewan Queber West Midwest Northeast Southwest Southeast Southwest Net Sales: $80,000 Net Income: $17,600 Average Total Assets: $176,000 Current Liabilities: $64,000 Mexico British Slumbia Saskatchewan Manitoba Alberta Quebec Ontario West Midwest Northeast Southwest Southeast Southeast Net Sales: Net Income: Average Total Assets: $35,000 Current Liabilities: $8,000 $65,000 $4,550 Mexico ** tableau koO 1. Compute profit margin for the company's (a) West region and (b) Southwest region. 2. In which region examined in part 1 has the company best performed on profit margin? 3. Compute return on total assets for the company's (a) West region and (b) Southwest region. 4. In which region examined in part 3 has the company best performed on return on total assets? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute profit margin for the company's (a) West region and (b) Southwest region. (Enter your answers as a whole percentage (i.e., 0.12 should be entered as 12).) Profit Margin (a) West region (b) Southwest region Required 2 > por US performed on rem UH Uld asses! Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute return on total assets for the company's (a) West region and (b) Southwest region. (Enter your answers as a whole percentage (l.e., 0.12 should be entered as 12).) Return on Total Assets (a) West region (b) Southwest region Required 2 Required 4 >