Transport Corporation is organized into four operating segments. The internal reporting system generated the following segment information: Autos 54,010,000 $110,000 53,610,000 Trucks $3,510,000 $210,000 54,010,000 SUVs $2,610,000 S0 $2,009,000 Motarcycles $510,000 556,000 51,030,000 Percentage threshold 10% Required: Note: Use cells A2 to D9 from the given information to complete this question. Formulas for losses must return negative values. 13 14 15 16 17 Calculate the profit or loss per segment and determine which segments should be reported separately. Autos $4,010,000 @ $3,610,000 & Trucks [ $3510,000 @ $210,000 @[ 4,010,000 @ " SUVs I s2:610,000 @ F$2,009,000 @] $601,000 @ r Motoreycles $910,000 2 $56,000 @)/ $1,030,000 @[ (564,000) @ 21 22 23 24 25 Total 751,111,000 @/ ($354,000) & Percentage threshold 10% & Absolute value of profit or loss * 10% 535,4000