Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions Aerospace sales Commercial aviation original equipment 2018 2017 $3,591 $2,475 Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales Safety and productivity solutions sales Safety Productivity solutions Total safety and productivity solutions sales Total consolidated sales $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 $2,278 $2,927 4,817 3,470 $7,095 $6,397 $46,350 $44,324 a. Calculate historic (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 each 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 decimal places_. Note: Use negative signs with answers, when appropriate. Honeywell International Segment Sales and Business-Unit Sales by Segment Aerospace sales $ millions Commercial aviation original equipment Commercial aviation aftermarket 2017 to 2018 % growth 14.46 % 5.29% Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes 5.29% 15.1 % (16.71) % 4.83 % Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions (12.36) % 1.42 % (4.9) % 3.34 % 3.88 % Advanced materials 2.04% Total performance materials and technologies sales 3.24 % Safety and productivity solutions sales Safety Productivity solutions Total safety and productivity solutions sales Total consolidated sales 5.03% 16.97% 12.38% 3.31 % b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sales for 2019. Estimated total consolidated sales for 2019 43,110 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 total consolidated sales for 2019. Estimated total consolidated sales for 2019 43,225 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 historic growth for each line item in the table (calculated in part a) to estimate 2019 total consolidated sales. Estimated total consolidated sales for 2019 59,956 e. Which approach do we believe is more accurate in forecasting total consolidated sales? Part d

Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions Aerospace sales Commercial aviation original equipment 2018 2017 $3,591 $2,475 Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales Safety and productivity solutions sales Safety Productivity solutions Total safety and productivity solutions sales Total consolidated sales $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 $2,278 $2,927 4,817 3,470 $7,095 $6,397 $46,350 $44,324 a. Calculate historic (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 each 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 decimal places_. Note: Use negative signs with answers, when appropriate. Honeywell International Segment Sales and Business-Unit Sales by Segment Aerospace sales $ millions Commercial aviation original equipment Commercial aviation aftermarket 2017 to 2018 % growth 14.46 % 5.29% Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes 5.29% 15.1 % (16.71) % 4.83 % Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions (12.36) % 1.42 % (4.9) % 3.34 % 3.88 % Advanced materials 2.04% Total performance materials and technologies sales 3.24 % Safety and productivity solutions sales Safety Productivity solutions Total safety and productivity solutions sales Total consolidated sales 5.03% 16.97% 12.38% 3.31 % b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sales for 2019. Estimated total consolidated sales for 2019 43,110 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 total consolidated sales for 2019. Estimated total consolidated sales for 2019 43,225 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 historic growth for each line item in the table (calculated in part a) to estimate 2019 total consolidated sales. Estimated total consolidated sales for 2019 59,956 e. Which approach do we believe is more accurate in forecasting total consolidated sales? Part d

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 8PB: The following revenue data were taken from the December 31, 2017, General Electric annual report...

See similar textbooks