Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
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. 2018 2017 2266 1980 4,298 4,082 3,732 3,242 2,098 2,518 $12,394 $11,822 Honeywell International Segment Sales and Business Unit Sales by Segment $ millions Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total serospace 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 $3,142 $3,586 4296 4,236 57,438 57,822 52.276 52,202 3,985 3,836 2.278 2,233 58,539 58,271 51.822 51.735 3.247 2.776 $5.069 $4511 $33,440 532 426 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%). 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 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 UDP 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 b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Port a to estimate total consolidated sales for 2019, Note: Round your answer to the nearest whole dollar. Estimated total consolidated sales for 2019: 5 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 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.5 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 turc powth for each line item in the table calculated in part as to estimate 2019 total consolidated sales Note: Round your answer to the nearest whole dollar Estimated total consolidated sales for 2019:5 Which approach do we believe is more accurate in forecasting total consolidated sales 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. 2018 2017 2266 1980 4,298 4,082 3,732 3,242 2,098 2,518 $12,394 $11,822 Honeywell International Segment Sales and Business Unit Sales by Segment $ millions Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total serospace 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 $3,142 $3,586 4296 4,236 57,438 57,822 52.276 52,202 3,985 3,836 2.278 2,233 58,539 58,271 51.822 51.735 3.247 2.776 $5.069 $4511 $33,440 532 426 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%). 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 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 UDP 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 b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Port a to estimate total consolidated sales for 2019, Note: Round your answer to the nearest whole dollar. Estimated total consolidated sales for 2019: 5 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 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.5 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 turc powth for each line item in the table calculated in part as to estimate 2019 total consolidated sales Note: Round your answer to the nearest whole dollar Estimated total consolidated sales for 2019:5 Which approach do we believe is more accurate in forecasting total consolidated sales

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Concept And Objectives Of Quality Auditing ISO 9001Total Quality Management

Authors: Mahmoud Fadhel Idan

1st Edition

6202795158, 978-6202795159

More Books

Students also viewed these Accounting questions