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

Required

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

Transcribed Image Text:

Historical Cost Gross Book Value Current Cost Net Book Operating Replacement Cost Liquidation Value Value Reglon North Atlantic Mid Atlantic South Atlantic Income $65,000 $250,000 290,000 100,000 $450,000 310,000 $990,000 $350,000 445,000 980,000 40,000 380,000 30,000 650,000