THE AUTO MAKER PRODUCT MIX PROBLEM Changing Cells Number of Trucks Number of SUVs Number of Sedans Number of Compacts Number of Electrics Constants 1 1 1 Average Selling Prices: Trucks $ 60,000 SUVS $ 55,000 Sedans S 40,000 Compacts S 30,000 Electrics $ 35,000 Average Cost of Manufacture: Trucks $ 30,000 SUVS $ 28,000 Sedans S 33,000 Compacts $ 27,000 Electrics $ 37,000 Average MPG: Trucks 28 SUVS 33 Sedans 40 Compacts 55 Electrics 100 Max Production Capacity: Trucks 30,000 SUVS 90,000 Sedans 50,000 Compacts 20,000 10,000 Electrics Calculations Revenue: Trucks SUVS Sedans Compacts Electrics Cost of Manufacture: Trucks SUVS Sedans Compacts Electrics Total number of autos made Fleet MPG Income Statement Total Revenue Total Cost of Manufacture Gross Margin Gross Margin Percentage