Hans Hultgren, the sales manager for DVD Sales, wants to maximize his profit on the sale of portable DVD players. The four portable models he plans to sell are listed on this spreadsheet. Hans needs your help in calculating his maximum profit. 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. Use Excel Solver to maximize the total profit for Hans with the constraints mentioned above and limiting the number of units to positive integers.

Item # Products Purchase Quantit y Total Cost Total Profit Panasonic DVD-LS50 Audiovox DVD1500 Mintek MDP-1810 Toshiba SD-P2600 349.95 $329.00 $199.99 $279.00 Retail Price Wholesale Cost Profit per Unit 157.48 148.05 90.00 125.55 192.47 $ 180.95 $ 109.99 $ 153.45 $ 4 Totals Constraint Number of Players Loan to purchase DVDs >=100 rchase DVDs 200,000.00