Please help complete the Excel file using the "Solver" function. Also, please help provide answers for A and B.

Pricing in Two Markets: Global Products, Inc. has been making an electronic appliance for the domestic market. Demand for the appliance is price sensitive, and the demand curve is known to follow the linear function D=40005P, where D represents annual demand and P represents selling price in the home currency, which is the frank (F). The cost of manufacturing the appliance is 100F. For the coming year, Global is planning to sell the same product in a foreign market, where the currency is the marc (M). From surveys, the demand curve in the foreign country is estimated to follow a different linear function, D=20002P, where the price is denominated in marcs. All production will be carried out at Global's domestic plant, with the expectation that the unit cost will remain unchanged. The exchange rate is 1.5M/F, and Global plans to offer an equivalent price in both markets. (a) If Global were to operate exclusively in its domestic market, what would be its profit-maximizing price and its annual profit? (b) When Global sells in both markets at one equivalent price, what is its profit-maximizing price and its annual profit