Apple (Asia) 3-month plan Production Power Mac G4 Powerbook G4 iMac iBook Revenue $3,750 $5,000 $ 2,500 $ 3,125 Production Production $ 2,625 8 $ 3,750 10 $ 1,500 7 $2,250 5 Minimum 5,000 5,000 5,000 5,000 Market 25,000 15,000 25,000 15,000 Used Hours Budget (hours) 300,000 $0 Production Cost Budget (money) $158,250,000 Revenue Production Cost Profit $0 $0 $0 The marketing department reports that for price change less than $300, every $100 drop in the price of any product increases the market demand by 3500 units and vice versa (i.e. elasticity = 35). Price and price change values should be integers! Use the Solver tool to find the optimal production levels with the given constraints. b) When they see the effect of price change in Powerbook G4, the board approved price changes for each product. What is the new price of iBook in the optimal production? Apple (Asia) 3-month plan Production Power Mac G4 Powerbook G4 iMac iBook Revenue $3,750 $5,000 $ 2,500 $ 3,125 Production Production $ 2,625 8 $ 3,750 10 $ 1,500 7 $2,250 5 Minimum 5,000 5,000 5,000 5,000 Market 25,000 15,000 25,000 15,000 Used Hours Budget (hours) 300,000 $0 Production Cost Budget (money) $158,250,000 Revenue Production Cost Profit $0 $0 $0 The marketing department reports that for price change less than $300, every $100 drop in the price of any product increases the market demand by 3500 units and vice versa (i.e. elasticity = 35). Price and price change values should be integers! Use the Solver tool to find the optimal production levels with the given constraints. b) When they see the effect of price change in Powerbook G4, the board approved price changes for each product. What is the new price of iBook in the optimal production