Hello! Could anyone show me how to solve these questions in
excel using the "solver" tool?
CarPro is an automobile dealer selling only new cars. CarPro
sells three types of vehicles: sedans, SUVs and trucks. CarPro
places orders to the car manufacturers only when customers have
decided to purchase. The ordering cost (per unit) of sedan, SUV and
truck are $18,000, $20,500 and $19,000, respectively. The sales
price (per unit) of sedan, SUV and truck are $20,000, $23,000, and
$21,500,...