DVD Sales Hans Hultgren, the sales manager for DVD Sales, wants to maximize his profit on the sale of portable DVD players. He already has two portable models he plans to sell:
Products Retail Price Wholesale Cost
Panasonic DVD–LS50 $349.95 $192.47
Mintek MDP–1810 $199.95 $109.99
Hans needs your help in calculating his maximum profit. First, he would like you to use the Web to locate the retail price of two other portable DVD players not listed in the table above. The wholesale price of each unit is 55 percent of the retail price for both units you find. Hans has two constraints:
1. Hans has $200,000 to purchase new DVD players. The total wholesale cost of the four types of DVD units must be less than $200,000.
2. Hans must purchase a minimum of 100 units of each player from his wholesaler.
You want to use Excel Solver to maximize the total profit for Hans with the constraints mentioned above and limiting the number of units to positive integers.