Excel Solver Question - Please Show the formulas, solver parameters, etc.

German Motors (GM) produces four types of family vehicles: subcompact, compact, intermediate, and luxury, and two types of commercial vehicles: trucks and vans. Vendor capacities limit total production capacity to at most 1.2 million vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 vehicles. Intermediate and luxury vehicles are produced in another facility with capacity of 400,000; and the truck/van facility has a capacity of 275,000. GM's marketing strategy requires that subcompacts and compacts must constitute at least half of the product mix for the four vehicles types. The Corporate Average Fuel Economy (CAFE) standards in the Energy Policy and Conservation Act require an average fleet fuel economy of at least 27 mpg. Profit margins, market potential, and fuel efficiencies are summarized as follows: Type Profit Margin $/Vehicle Market Potential Fuel Economy 150 40 225 34 Subcompact Compact Intermediate Luxury Truck 250 15 600,000 400,000 300,000 225,000 325,000 100,000 500 12 400 20 Van 200 25 Excel Solver Your task is to use Excel Solver and determine how many vehicles from each type should GM produce to maximize profit? Be sure to select keep the Solver solution and generate answer report German Motors (GM) produces four types of family vehicles: subcompact, compact, intermediate, and luxury, and two types of commercial vehicles: trucks and vans. Vendor capacities limit total production capacity to at most 1.2 million vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 vehicles. Intermediate and luxury vehicles are produced in another facility with capacity of 400,000; and the truck/van facility has a capacity of 275,000. GM's marketing strategy requires that subcompacts and compacts must constitute at least half of the product mix for the four vehicles types. The Corporate Average Fuel Economy (CAFE) standards in the Energy Policy and Conservation Act require an average fleet fuel economy of at least 27 mpg. Profit margins, market potential, and fuel efficiencies are summarized as follows: Type Profit Margin $/Vehicle Market Potential Fuel Economy 150 40 225 34 Subcompact Compact Intermediate Luxury Truck 250 15 600,000 400,000 300,000 225,000 325,000 100,000 500 12 400 20 Van 200 25 Excel Solver Your task is to use Excel Solver and determine how many vehicles from each type should GM produce to maximize profit? Be sure to select keep the Solver solution and generate answer report