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

Required

Prepare an Excel spreadsheet that will calculate return on sales (ROS) for each division for 2022. 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 Current Cost Operating Net Book Gross Book Replacement Liquidation Region Income Value Value Cost Value North Atlantic Mid Atlantic South Atlantic $65,000 40,000 30,000 $250,000 $450,000 $990,000 290,000 100,000 310,000 180,000 380,000 650,000 $350,000 445,000 980,000