Company X manufactures Product A and Product B. The units made of Product B is always twice the number of units made of product A. Product A sells at $40 and product B sells at $50. Cost of making Product A is 12 and B is 15. The constraint is you can make only 200 units all together. Use Solver in MS Excel to maximize profit. How many units of A and B are manufactured.

Below is the dollar cost of transporting materials between factories and market places.

use solver in excel.