Need help with 1 and 2 ASAP

12 A x X A Editing Styles Dictate Sensitivity A 21 Paragraph Styles Voice Sensitivity Marketing Analytics Spring 2021 Due date: 3/31st before class (3:45PM) 1- The New York Times wants to price home subscriptions and web access. Of course, people can buy both home subscriptions and web access, or they can choose to buy them separately. Assume there are three market segments whose size and willingness to pay (per month) for each product combination are given in the table. The cost to provide a home subscription is $5 and the cost to provide web access is $1 Segment Home 1 Web 35 15 40 30 45 35 Home+Web 45 45 40 Size 25% 35% 40% 2 3 What prices maximize monthly profits? (you need to use Excel solver to find the best prices for a mixed bundling strategy) (follow the computer/monitor example in class) 2- Describe (in words) a situation in which a bank can benefit from a bundling strategy. (this question is not related to question 1) Submit one Excel file with answers to questions 1 and 2 in separate sheets. BI W g 1 L.99+ DII * PrtScn FB F4 F6 Home F9 F5 F7 End F10 . % A & ) 5 6 7 8 9 0 12 A x X A Editing Styles Dictate Sensitivity A 21 Paragraph Styles Voice Sensitivity Marketing Analytics Spring 2021 Due date: 3/31st before class (3:45PM) 1- The New York Times wants to price home subscriptions and web access. Of course, people can buy both home subscriptions and web access, or they can choose to buy them separately. Assume there are three market segments whose size and willingness to pay (per month) for each product combination are given in the table. The cost to provide a home subscription is $5 and the cost to provide web access is $1 Segment Home 1 Web 35 15 40 30 45 35 Home+Web 45 45 40 Size 25% 35% 40% 2 3 What prices maximize monthly profits? (you need to use Excel solver to find the best prices for a mixed bundling strategy) (follow the computer/monitor example in class) 2- Describe (in words) a situation in which a bank can benefit from a bundling strategy. (this question is not related to question 1) Submit one Excel file with answers to questions 1 and 2 in separate sheets. BI W g 1 L.99+ DII * PrtScn FB F4 F6 Home F9 F5 F7 End F10 . % A & ) 5 6 7 8 9 0