Responsibility Accounting and Performance Evaluation

Using Excel for key performance indicators $($KPIs$)$

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$).$

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

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.

Requirements

Create an Excel table from the data.

Rename the table as Solar$\_$KPI.

Select another table style for the table.

Calculate Operating Income in the table.

Use table arithmetic for the formulas $($rounded to three decimal places$)$ for

a$.$ Profit Margin Ratio

b$.$ Asset Turnover Ratio

c$.$ Return on Investment $($ROI$)$

Excel Skills

$1$ Excel tables

a$.$ Create an Excel table.

b$.$ Change the name of an Excel table.

c$.$ Change the style of the table.

d$.$ Create a calculated column.

$2$ Use the Excel function ROUND to round your answers to three decimal places.

Excel Hints

An Excel table will allow you to create the formula once and have it automatically replicate down the rows of the table. An Excel table has a header row, rows of data, and formula columns.Requirement $1$

Create an Excel table from the data.

a$.$ Rename the table as Solar$\_$KPI.

b$.$ Select Medium $7$ table style for the table.

c$.$ Calculate Operating Income in the table.

Requirement $2$

Use table arithmetic for the formulas $($rounded to three decimal places$)$ for

a$.$ Profit Margin Ratio

b$.$ Asset Turnover Ratio

c$.$ Return on Investment $($ROI$)$

$($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.$)$

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.

Requirements

Create an Excel table from the data.

Rename the table as Solar$\_$KPI.

Select another table style for the table.

Calculate Operating Income in the table.

Use table arithmetic for the formulas $($rounded to three decimal places$)$ for

a$.$ Profit Margin Ratio

b$.$ Asset Turnover Ratio

c$.$ Return on Investment $($ROI$)$

Excel Skills

$1$ Excel tables

a$.$ Create an Excel table.

b$.$ Change the name of an Excel table.

c$.$ Change the style of the table.

d$.$ Create a calculated column.

$2$ Use the Excel function ROUND to round your answers to three decimal places.

Excel Hints

An Excel table will allow you to create the formula once and have it automatically replicate down the rows of the table. An Excel table has a header row, rows of data, and formula columns.