Alex Chunn, Inc., has the following financial data for 2016 for its three regional divisions:

Required
Prepare an Excel spreadsheet that will calculate return on sales (ROS) for each division for 2016. The sales in the North Atlantic, Mid Atlantic, and South Atlantic regions are $2,350,000, $1,450,000, and $500,000, respectively. Calculate investment (asset) turnover (AT) and return on investment (ROI) for each of the four measures of investment.

Transcribed Image Text:

Historical Cost Current Cost Operating Income Net Book Value Gross Book Value Replacemen Liquidation Region North Atlantic Mid Atlantic South Atlantic Cost Value $65,000 40,000 30,000 S250,000 290,000 100,000 S450,000 310,000 180,000 $990,000 380,000 650,000 $350,000 445,000 980,000