In many cases, organizations face diverse choices and each of the options has one or more constraints. To understand the best course of action, advanced business analytics can work toward optimizing an outcome based on the diverse choices and constraints.

Please go to chapter 1, page 17 in the book available in the resources guide, Optimization Modeling with Spreadsheets. The problem for this assignment is 1.2 in chapter 1 on page 17. Please address both a and b in the prompt.

Please submit this project as a Microsoft Excel spreadsheet. The spreadsheet should contain the worked solution for both a and b.

.2 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.5 M/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