Dear Expert,

Will you please answer below question? and please do it in Excel file (or *.xls)

Thanks very much

2. Constrained Optimization (50%) An automobile company has two versions of the same model car for sale, a two-door coupe and the full-size four door. Determine how many cars of each design should be produced to maximize profit and what that profit is by using: a. Graphically Method b. Simplex Method Two Door Four Door Availability Profit $13,500/car $15,000/cat Production time 15 h/car 20 h/car 8000 h/year Storage 400 cars 350 cars Consumer demand 700/car 500/car 240,000 cars