Answer this using both graphical analysis and MS Excel. Dorian Auto manufactures luxury cars and trucks. You may assume they can produce partial cars and trucks. The company believes that its most likely customers are high-income women and men. To reach these groups, Dorian Auto has embarked on an ambitious TV advertising campaign and has decided to purchase 1-minute commercial spots on two types of programs: comedy shows and football games. Each comedy commercial is seen by 6 million high-income women and 3 million high-income men. Each football commercial is seen by 3 million high- income women and 9 million high-income men. A 1-minute comedy ad costs $60,000, and a 1minute football ad costs $95,000. Dorian would like the commercials to be seen by at least 30 million high-income women and 30 million high-income men. income women and 9 million high-income men. A 1-minute comedy ad costs $60,000, and a 1minute football ad costs $95,000. Dorian would like the commercials to be seen by at least 30 million high-income women and 30 million high-income men. 1. Find the range of values on the cost of a comedy ad for which the current basis remains optimal. 2. Find the range of values on the cost of a football ad for which the current basis remains optimal. 3. Find the range of values for required HIW (high-income women) exposures for which the current basis remains optimal. Determine the new optimal solution if 30+ million HIW exposures are required. 4. Find the range of values for required HIM (high-income men) exposures for which the current basis remains optimal. Determine the new optimal solution if 30+ million HIM exposures are required. 5. Find the shadow price of each constraint. 6. IF 21 million HIW exposures are required, determine the new optimal z-value. Answer this using both graphical analysis and MS Excel. Dorian Auto manufactures luxury cars and trucks. You may assume they can produce partial cars and trucks. The company believes that its most likely customers are high-income women and men. To reach these groups, Dorian Auto has embarked on an ambitious TV advertising campaign and has decided to purchase 1-minute commercial spots on two types of programs: comedy shows and football games. Each comedy commercial is seen by 6 million high-income women and 3 million high-income men. Each football commercial is seen by 3 million high- income women and 9 million high-income men. A 1-minute comedy ad costs $60,000, and a 1minute football ad costs $95,000. Dorian would like the commercials to be seen by at least 30 million high-income women and 30 million high-income men. income women and 9 million high-income men. A 1-minute comedy ad costs $60,000, and a 1minute football ad costs $95,000. Dorian would like the commercials to be seen by at least 30 million high-income women and 30 million high-income men. 1. Find the range of values on the cost of a comedy ad for which the current basis remains optimal. 2. Find the range of values on the cost of a football ad for which the current basis remains optimal. 3. Find the range of values for required HIW (high-income women) exposures for which the current basis remains optimal. Determine the new optimal solution if 30+ million HIW exposures are required. 4. Find the range of values for required HIM (high-income men) exposures for which the current basis remains optimal. Determine the new optimal solution if 30+ million HIM exposures are required. 5. Find the shadow price of each constraint. 6. IF 21 million HIW exposures are required, determine the new optimal z-value
