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.

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