just need C & D

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.

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

Use Segment Disciosures to Forecast Revenue Following are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 rev 'ate. Then enter the answers into the 3. 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 the answers into the provided spaces below with two decimal places. Note: Use negative signs with answers, when appropriate. b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sale c. Refine the sales forecast by using the sales growth rates for each of the four segments (from 2017 to 2018 ) calculated in part d. Refine the sales forecast further by using the sales growth rates for each of the business units within each of the four segmen 2019 total consolidated sales