Question: please solve using excel solver only. thanks Marcel has been watching the price of older American muscle cars rise significantly over the past two years,
please solve using excel solver only. thanks

Marcel has been watching the price of older American muscle cars rise significantly over the past two years, and he has decided to start a dealership selling these cars in a small town in Canada. His bank has given his company financing to purchase up $500,000 of cars. At a large auction next month, Marcel plans to buy a mix of cars for his business - Pontiacs, Chryslers, and Fords. He wants to buy at least twice as many Pontiacs as Chryslers and Fords combined. Studying recent data, the cost per car is expected to be $35,000 per Pontiac, $28,000 per Chrysler and $26,000 per ford. Selling prices, he expects, will be $43,500 per Pontiac, $37,000 per Chrysler and $34,000 per Ford. Marcel's dealership can store no more than 15 cars. Lastly, he must prepare the cars for sale with a wash and service per car. Pontiacs will need 4 hours, Chryslers 3 hours, and Fords 5 hours each. With 1 employee, there are only 40 hours available for the prep work. Prepare a Linear Programming Model reflecting this information to determine the optimal mix of cars he should purchase with the objective of maximizing his profits. Prepare and solve an integer only solution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
