Many pharmaceutical products are used to treat multiple issues. One example of this is diphenhydramine. Formerly sold under patent as Benadryl, diphenhydramine is now an over-the- counter allergy relief medicine available in generic form. One of the side effects of diphenhydramine is drowsiness. More recently, it has been sold as a nighttime sleep aid (i.e. ZzzQuil). Walmart sells two generic versions of diphenhydramine; one is pink, sold as allergy relief medication, and one is blue, sold as a nighttime sleep aid. Walmart sells each version in a bottle of 100 pills with 25mg of diphenhydramine each. The allergy relief medication sells for $4 per bottle and the nighttime sleep aid sells for $4.98 even though these are chemically identical products. Suppose you are developing a pricing strategy for a firm in a similar situation to Walmart. You are selling a generic version of a medication which can be used to help keep someone awake but it also acts as a diuretic. Demand for this medicine from people who need to stay awake is Q = 8800 - 700P while demand for individuals who use the medicine as a diuretic is Q = 9300 - 1100P. The cost to your company of each bottle sold is $1.75; assume there are no fixed costs. The demand functions and the cost value are mothered halom Q= 8 800 700 P Q= Unit cost 9 300 $1.75 1 100 P a) Set up formulas to calculate quantity demanded, total revenue, total cost, profit from each kind of customer, and combined profit. Using solver, solve for the profit maximizing price for customers who use this medication to stay awake. Suppose you charge customers who use the medication as a diuretic the same price. How many bottles will you sell to each kind of customer? What is your combined profit? Stay Awake Price Quantity Demanded Total Revenue Total Cost Profit Diuretic Price Quantity Demanded Total Revenue Total Cost Profit Combined Profit b) Set up formulas to calculate quantity demanded, total revenue, total cost, profit from each kind of customer, and combined profit. Using solver, solve for the profit maximizing price for customers who use this medication as a diuretic. Suppose you charge customers who use the medication to stay awake the same price. How much will you charge per bottle? How many bottles will you sell to each kind of customer? What is your combined Diuretic Price Quantity Demanded Total Revenue Total Cost Profit Stay Awake Price Quantity Demanded Total Revenue Total Cost Profit Combined Profit from cach c) Set up formulas to calculate quantity demanded, total revenue, total cost, profit from each kind of customer, and combined profit. Suppose you charged customers differently based on their use of the medication. How much will you charge per bottle to each kind of customer? How many bottles will you sell to each kind of customer? What is your Stay Awake Price Quantity Demanded Total Revenue Total Cost Profit Diuretic Price Quantity Demanded Total Revenue Total Cost Profit Combined Profit d) Which plan would you pursue if you were making the decision and your goal is to maximize One would pursue