how to solve on excel

- B.9 Spitzfire, Inc., manufactures specialty cars and trucks. It has just opened a new factory where the Cl car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type Tl and a car of type Cl in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A Tl truck and a Cl car yield profits of $300 and $220, respectively, per vehicle sold. a) Define the objective function and constraint equations. b) Graph the feasible region. c) What is a maximum-profit daily production plan at the new factory? d) How much profit will such a plan yield, assuming whatever is produced is sold