The following chart details parts needed, available, and the profit per unit for your Toy Car Company.For example a deluxe car sells for a $50 profit, and needs 1 large wheel, 1 small wheel, 1 driver, 2 orange fins, 1 gray base, etc.Your job is to set up an appropriate excel spreadsheet, and use the solver to find the maximum profit possible given the constraints. In addition, you will be meeting with the vice president in charge of production, and who knows what questions they might ask? For example, they could change the profit per car, redesign a car to use different pieces/quantities, or find a supply of some of the parts. So your spread sheet must be extremely flexible, so that you can quickly change it and re solve the problem under any new scenario. If you do well, you could be in line for a very nice promotion!

WHAT IS THE MAXIMAL PROFIT?

\f