I need assistance calculating total consolidated sales for b, c, and d. and assistance with the totals for a. please
Following are 2017 and 2018 revenue data for Honeyweil internationals four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spices below with two decirai places Honeywell International Segment Sales and Business-Unit Sales by Segment 5 miltions \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{ Commercial aviation aftermarket } & \multirow{2}{*}{5,373} & \multirow{2}{*}{5,801} \\ \hline & & \\ \hline Defense and space & 5,363 & 4,053 \\ \hline Transportation systems & 2,622 & 3,846 \\ \hline Total aerospace sales & $16,889 & $16,175 \\ \hline \multicolumn{3}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & $4,626 & $4,482 \\ \hline Buildings & 5,370 & 5,993 \\ \hline Total Honeywell building technologies sales & $9,996 & $10,475 \\ \hline \multicolumn{3}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & $3,543 & $2,753 \\ \hline Process solutions & 4,981 & 5,493 \\ \hline Advanced materials & 3,546 & 2,791 \\ \hline Total performance materials and technologies sales & $12,070 & $11,037 \\ \hline \multicolumn{3}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & $2,278 & $2,867 \\ \hline Productivity solutions & 4,757 & 3,470 \\ \hline Total safety and productivity solutions sales & $7,035 & $6,337 \\ \hline Total consolidated sales & $45,990 & $44,024 \\ \hline \end{tabular} a. Catculate tristoric (year-on-year) sales growth for each business unit, segment, and total consolidated sales. Note: Complete the entire question in Excel (template provided above). Using Excel, format oach answer to two decimal places, Use increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with_two decirnal places. Note: Use negative signs whth answers, when appropriate. \begin{tabular}{|c|c|} \hline \begin{tabular}{l} Honeywell International Segment Sales and Business-Unit Sales by Segment \\ \$ millions \end{tabular} & \begin{tabular}{l} 2017 to 2018 \\ % growth \end{tabular} \\ \hline \multicolumn{2}{|l|}{ Aerospace sales } \\ \hline Commercial aviation original equipment & 42.61% \\ \hline Commercial aviation aftermarket & (7.4)% \\ \hline Defense and space & 32.3% \\ \hline Transportation systems & (31.81)% \\ \hline Total aerospace sales & 35.7% \\ \hline \multicolumn{2}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & 3.21% \\ \hline Buildings & (10.4)% \\ \hline Total Honeywell building technologies sales & (7.19)% \\ \hline \multicolumn{2}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & 28.76% \\ \hline Process solutions & (9.31)% \\ \hline Advanced materials & 27.03% \\ \hline Total performance materials and technologies sales & 46.48% \\ \hline \multicolumn{2}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & (20.58)% \\ \hline Productivity solutions & 37.07% \\ \hline Total safetv and productivity solutions sales & (16.5)% \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|l|}{ Aerospace sales } \\ \hline Commercial aviation original equipment & 42.61% \\ \hline Commercial aviation aftermarket & (7.4)% \\ \hline Defense and space & 32.3% \\ \hline Transportation systems & (31.81)% \\ \hline Total aerospace sales & 35.7% \\ \hline \multicolumn{2}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & 3.21% \\ \hline Buildings & (10.4)% \\ \hline Total Honeywell building technologies sales & (7.19)% \\ \hline \multicolumn{2}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & 28.76% \\ \hline Process solutions & (9.31)% \\ \hline Advanced materials & 27.03% \\ \hline Total performance materials and technologies sales & 46.48% \\ \hline \multicolumn{2}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & (20.58)% \\ \hline Productivity solutions & 37.07% \\ \hline Total safety and productivity solutions sales & (16.5)% \\ \hline Total consolidated sales & 4.47% \\ \hline \end{tabular} 0, Use the historic growth in Total consolidated sales (from 2017 to 2018 ) calculated in Part a to estimate total consolicated sales for 2019 Estimated toeal consolidiatied cales for 2010 c. Refine the sales forecast by using the sales growth rates for each of the four segments (from 2017 to 2018 ) calculated in part a to estimate 2019 sales for each segment. Determine a forecast for totai consolidated sales for 2019. Ermated toul consolidated sales for 2019 d. Refine the sales forecast further by using the sales growth rates for each of the business units within each of the four segments. This means we use the separate historin growh for each fine item in the wable (calculated in part a) to estimate 2019 total consolidated sales. Estinated total consolidated sales for 2019 e. Which approach do we believe is more accurate in forecasting total consolidated sales? Following are 2017 and 2018 revenue data for Honeyweil internationals four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spices below with two decirai places Honeywell International Segment Sales and Business-Unit Sales by Segment 5 miltions \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{ Commercial aviation aftermarket } & \multirow{2}{*}{5,373} & \multirow{2}{*}{5,801} \\ \hline & & \\ \hline Defense and space & 5,363 & 4,053 \\ \hline Transportation systems & 2,622 & 3,846 \\ \hline Total aerospace sales & $16,889 & $16,175 \\ \hline \multicolumn{3}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & $4,626 & $4,482 \\ \hline Buildings & 5,370 & 5,993 \\ \hline Total Honeywell building technologies sales & $9,996 & $10,475 \\ \hline \multicolumn{3}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & $3,543 & $2,753 \\ \hline Process solutions & 4,981 & 5,493 \\ \hline Advanced materials & 3,546 & 2,791 \\ \hline Total performance materials and technologies sales & $12,070 & $11,037 \\ \hline \multicolumn{3}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & $2,278 & $2,867 \\ \hline Productivity solutions & 4,757 & 3,470 \\ \hline Total safety and productivity solutions sales & $7,035 & $6,337 \\ \hline Total consolidated sales & $45,990 & $44,024 \\ \hline \end{tabular} a. Catculate tristoric (year-on-year) sales growth for each business unit, segment, and total consolidated sales. Note: Complete the entire question in Excel (template provided above). Using Excel, format oach answer to two decimal places, Use increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with_two decirnal places. Note: Use negative signs whth answers, when appropriate. \begin{tabular}{|c|c|} \hline \begin{tabular}{l} Honeywell International Segment Sales and Business-Unit Sales by Segment \\ \$ millions \end{tabular} & \begin{tabular}{l} 2017 to 2018 \\ % growth \end{tabular} \\ \hline \multicolumn{2}{|l|}{ Aerospace sales } \\ \hline Commercial aviation original equipment & 42.61% \\ \hline Commercial aviation aftermarket & (7.4)% \\ \hline Defense and space & 32.3% \\ \hline Transportation systems & (31.81)% \\ \hline Total aerospace sales & 35.7% \\ \hline \multicolumn{2}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & 3.21% \\ \hline Buildings & (10.4)% \\ \hline Total Honeywell building technologies sales & (7.19)% \\ \hline \multicolumn{2}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & 28.76% \\ \hline Process solutions & (9.31)% \\ \hline Advanced materials & 27.03% \\ \hline Total performance materials and technologies sales & 46.48% \\ \hline \multicolumn{2}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & (20.58)% \\ \hline Productivity solutions & 37.07% \\ \hline Total safetv and productivity solutions sales & (16.5)% \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|l|}{ Aerospace sales } \\ \hline Commercial aviation original equipment & 42.61% \\ \hline Commercial aviation aftermarket & (7.4)% \\ \hline Defense and space & 32.3% \\ \hline Transportation systems & (31.81)% \\ \hline Total aerospace sales & 35.7% \\ \hline \multicolumn{2}{|l|}{ Honeywell building technologies sales } \\ \hline Homes & 3.21% \\ \hline Buildings & (10.4)% \\ \hline Total Honeywell building technologies sales & (7.19)% \\ \hline \multicolumn{2}{|l|}{ Performance materials and technologies sales } \\ \hline UOP Russell LLP & 28.76% \\ \hline Process solutions & (9.31)% \\ \hline Advanced materials & 27.03% \\ \hline Total performance materials and technologies sales & 46.48% \\ \hline \multicolumn{2}{|l|}{ Safety and productivity solutions sales } \\ \hline Safety & (20.58)% \\ \hline Productivity solutions & 37.07% \\ \hline Total safety and productivity solutions sales & (16.5)% \\ \hline Total consolidated sales & 4.47% \\ \hline \end{tabular} 0, Use the historic growth in Total consolidated sales (from 2017 to 2018 ) calculated in Part a to estimate total consolicated sales for 2019 Estimated toeal consolidiatied cales for 2010 c. Refine the sales forecast by using the sales growth rates for each of the four segments (from 2017 to 2018 ) calculated in part a to estimate 2019 sales for each segment. Determine a forecast for totai consolidated sales for 2019. Ermated toul consolidated sales for 2019 d. Refine the sales forecast further by using the sales growth rates for each of the business units within each of the four segments. This means we use the separate historin growh for each fine item in the wable (calculated in part a) to estimate 2019 total consolidated sales. Estinated total consolidated sales for 2019 e. Which approach do we believe is more accurate in forecasting total consolidated sales
