Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Segment Disclosures to Forecast Revenue Following are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019
Use Segment Disclosures to Forecast Revenue Following are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions 2018 2017 Aerospace sales Commercial aviation original equipment 2550 2228 Commercial aviation aftermarket 4,836 4,593 Defense and space 4,199 3,648 Transportation systems 2,360 2,833 Total aerospace sales $13,945 $13,302 Honeywell building technologies sales Homes $3,535 $4,034 Buildings 4,833 4,766 Total Honeywell building technologies sales $8,368 $8,800 Performance materials and technologies sales UOP Russle LLP $2,561 $2,478 Process solutions 4,483 4,316 Advanced materials 2,563 2,512 Total performance materials and technologies sales $9,607 $9,306 Safety and productivity solutions sales Safety $2,050 $1,952 Productivity solutions 3,653 3,123 Total safety and productivity solutions sales $5,703 $5,075 Total consolidated sales $37,623 $36,483 a. Calculate historic (year-on-year) sales growth for each business unit, segment, and total lidated aloe b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sales for 2019. Note: Round your answer to the nearest whole dollar. Estimated total consolidated sales for 2019: $ 0 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. Note: Round your answer to the nearest whole dollar. Estimated total consolidated sales for 2019: $ 0 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. Note: Round your answer to the nearest whole dollar. Estimated total consolidated sales for 2019: $ 0 e. Which approach do we believe is more accurate in forecasting total consolidated sales? a. Calculate historic (year-on-year) sales growth for each business unit, segment, and total consolidated sales. Note: Round the percentage to two decimal places (for example, enter 14.56% for 14.55555%). Growth Rate 0 % 0 % 0 % 0 % 0% 0 % 0% 0% Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russle 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 0% 0 % 0% 0% 0% 0% 0 % 0 % b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sales for 2019
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started