G28 B 1 Responsibility Accounting and Performance Evaluation 2 Using Excel for key performance indicators (KPIs) 4 The US Solar Company has data for the four divisions for the year, and wants the results for the three specified key performance indicators (KPIs)) 5 6 7 Division East 8 North 9 10 South West $ Operating Income 1,650,000.00 $ Average Total Assets 12,700,250.00 $ Net Sales 26,700,000.00 Profit Margin Ratio Asset Turnover Ratio 560,000.00 4,300,000.00 264,050.00 2,260,000.00 11 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 1,015,290.00 13,240,000.00 5,760,000.00 869,870.00 9,360,000.00 12 ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. 13 14 15 Requirements 16 1 Create an Excel table from the data, 17 a. Rename the table as Solar KPL 18 19 b. Select another table style for the table 2. Use table arithmetic for the formulas (rounded to three decimal places) for 20 Profit Margin Ratio 21 b Asset Turnover Ratio 22 c. Return on Investment (ROI) Return on Investment (ROI)