Different solving method please read and help // NEW TYPE OF QUESTON !!

Dorian Auto manufactures luxury cars and trucks. To reach the potential customers, the advertising team of Dorian Auto has embarked on an ambitious TV advertising campaign and has decided to purchase 1-minute commercial spots on two types of programs: football matches and comedy shows. The company allocated a maximum budget of $600,000 for the advertisement campaign. The advertising team categorizes the potential customers into three groups: high-income men (HIM), high-income women (HIW), and low-income people (LIP). The estimated number of potential audience and advertising costs of a 1-minute ad of each type are given in the following table. Millions of viewers Ad HIM LIP HIW Cost Football match 7 10 5 $100,000 Comedy show 3 5 4 $60,000 . The advertising team has three goals: HIM goal: Reaching at least 45 million HIM. LIP goal: Reaching at least 40 million LIP. HIW goal: Reaching at least 40 million HIW . Suppose the team also determines the following penalty costs: The penalty for each million exposures below the HIM goal is $200,000. The penalty for each million exposures below the LIP goal is $100,000. The penalty for each million exposures below the HIW goal is $200,000. The advertising team of Dorian Auto now thinks that there are major differences between their goals. They determine that the HIW goal the most important goal, and the HIM goal is the least important goal (HIW goal > LIP goal > HIM goal). Formulate the problem as a preemptive goal programming to determine how many football ads and comedy show ads to purchase for Dorian Auto. Solve it using Excel