Please show solution with excel solver.

150 Metropolitan Microwaves, Inc. is planning to expand its operations into other electronic appliances. The company has identified seven new product lines it can carry. Relevant information about each line follows below. Initial Floor Space Exp. Rate Product Line Invest. (Sq.Ft.) of Retum 1. Black & White TVS $ 6,000 125 8.1% 2. Color TVs 12,000 9.0 3. Large Screen TVs 20,000 200 11.0 4. VHS VCRS 14,000 10.2 S. Beta VCRS 15,000 40 10.5 6. Video Games 2,000 20 7. Home Computers 32,000 100 13.2 Metropolitan has decided that they should not stock large screen TVs unless they stock either B&W or color TVs. Also, they will not stock both types of VCRs, and they will stock video games if they stock color TVs. Finally, the company wishes to introduce at least three new product lines. If the company has $45,000 to invest and 420 sq. ft. of floor space available formulate the problem for Metropolitan to maximize its overall expected rate of return. 40 14.1