Minnie Mouse runs a Fat automobile factory in Europe. Minnie's factory produces four

different models: the sedan, the convertible, the wagon, and the SUV. She wants to use Excel to help her optimize her operations. Minnie has asked you to use Excel to help her figure out the numbers of each model to produce in order to maximize the expected total factory profit. However, there are several constraints on the numbers of each model to be produced:

At least $10,000$ units of each model must be produced to utilize parts inventory.

Due to contractual obligations to supply a rental car company with cars for its fleet, at least $30,000$ units of the sedan, and $18,000$ units of the SUVs must be produced.

The factory is not currently capable of producing more than $180,000$ cars of all models combined in a year.

It is estimated that no more than $40,000$ units of the wagon could be sold in a year, so no more than $40,000$ wagons should be produced.

No more than $41,000$ units of the convertibles should be produced because that is the most convertible tops that the supplier can guarantee to deliver for the year.

The following table includes the estimated cost and price per unit for each models

$\backslash$table$[[$Model$,$Unit Cost,Retall Price$],[$Sedan$,$$$20,000,$$$29,000$