please do in excel

and HB (3) Consider a soft (cola) drinks market where two firms-Firm A and Firm B-compete for market shares given by the multinomial logit (MNL) functions below: 0-02-PA 6-03 PB HA = 0 -0.2.PA+,-b8PR -0.25PA+BPB where ua and Ug respectively denote the market shares of Firms A and B when its corresponding products are priced at PA and Po; moreover, price sensitivity parameter for Firm B's customers, i.e, bp, is unknown to you-Firm A's marketing/pricing specialist. However, your past marketing/pricing data suggest that bg is between 0.2 and 0.8. a) (2 pts) Use the data set given in the table below to determine the value of bb. Price of Firm A Price of Firm B Market Share of Firm A Market Share of Firm B 1 1 0.549833997 0.450166003 2 2 0.59868766 0.40131234 Table 1: Market shares of Firms A and B under two different price combinations b) (2 pts) As a newly hired marketing/pricing manager of Firm A, your goal is to increase your market share up to 70% when both firms price the product at $2.50. You decide to launch a new marketing/branding campaign to improve the product awareness and brand loyalty of your product, and thereby reduce the value of ba to increase the market share (un). What is the target value of bA that takes your firm's market share to 70%? and HB (3) Consider a soft (cola) drinks market where two firms-Firm A and Firm B-compete for market shares given by the multinomial logit (MNL) functions below: 0-02-PA 6-03 PB HA = 0 -0.2.PA+,-b8PR -0.25PA+BPB where ua and Ug respectively denote the market shares of Firms A and B when its corresponding products are priced at PA and Po; moreover, price sensitivity parameter for Firm B's customers, i.e, bp, is unknown to you-Firm A's marketing/pricing specialist. However, your past marketing/pricing data suggest that bg is between 0.2 and 0.8. a) (2 pts) Use the data set given in the table below to determine the value of bb. Price of Firm A Price of Firm B Market Share of Firm A Market Share of Firm B 1 1 0.549833997 0.450166003 2 2 0.59868766 0.40131234 Table 1: Market shares of Firms A and B under two different price combinations b) (2 pts) As a newly hired marketing/pricing manager of Firm A, your goal is to increase your market share up to 70% when both firms price the product at $2.50. You decide to launch a new marketing/branding campaign to improve the product awareness and brand loyalty of your product, and thereby reduce the value of ba to increase the market share (un). What is the target value of bA that takes your firm's market share to 70%