Part I How does shifting the sales mix at Ford Motor Company to more F-150 trucks affect Ford's break-even sales volume? Ford Motor Company (FORD) sales jumped 31.5 % during June 2022 in the United States as compared to the prior month. Sales of Ford's F-series trucks and the Explorer, Expedition, and Navigator SUV models drove the sales growth. According to a Bloomberg article earlier this year, the F-150 Series product line is Ford's most profitable product line. Ford has three categories of vehicles, Trucks, SUVs, and Cars. According to Ford's 2021 Form 10-K, the combined US unit sales of its vehicles in 2021 (both retail and wholesale) can be found in the attached Excel file. In addition, hypothetical average sales prices and average variable cost per unit are given. Questions 1. According to the unit sales and hypothetical sales and cost data given, what would Ford's weighted-average contribution margin be? 2. Assume that Ford's sales revenue is the same as last year's sales revenue, yet its profits increase. How might this be possible? 3. Assume that consumer demand for cars is expected to decrease significantly. What strategy might Ford use to deal with this trend so that its net income does not also decrease? Trucks SUVS Cars Total Unit sales 53,670 1,551,817 116,949 3,622,436 *Hypothetical costs % of total unit sales (Unit sales/ Total unit sales) Average sales price per unit* 52,000 45,000 31,000 Average variable cost per unit* 38,480 34,650 25,110

PLEASE HELP ASAP DUE TONIGHT 5/15 MIDNIGHT

Part I How does shifting the sales mix at Ford Motor Company to more F-150 trucks affect Ford's break-even sales volume? Ford Motor Company (FORD) sales jumped 31.5% during June 2022 in the United States as compared to the prior month. Sales of Ford's F-series trucks and the Explorer, Expedition, and Navigator SUV models drove the sales growth. According to a Bloomberg article earlier this year, the F-150 Series product line is Ford's most profitable product line. Ford has three categories of vehicles, Trucks, SUVs, and Cars. According to Ford's 2021 Form 10-K, the combined US unit sales of its vehicles in 2021 (both retail and wholesale) can be found in the attached Exeel file. In addition, hypothetical average sales prices and average variable cost per unit are given. Questions 1. According to the unit sales and hypothetical sales and cost data given, what would Ford's weighted-average contribution margin be? 2. Assume that Ford's sales revenue is the same as last year's sales revenue, yet its profits increase. How might this be possible? 3. Assume that consumer demand for cars is expected to decrease significantly. What strategy might Ford use to deal with this trend so that its net income does not also decrease