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 (KPls) Return on Investment ROI Division East North South West Operating Income Average Total Assets Net Sales Profit Margin Ratio Asset Turnover Ratio 1,580,000.00 $ 650,000.00 275,050.00 2,300,000.00 12,000,750.00 $ 4,875,000.00 995,090.00 25,900,000.00 6,337,500.00 855,770.00 9,200,000.00 10 11 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 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,800,000.00