Jake is a double health-entrepreneurship major in UAB. Recently he has come up with a business idea. The product that he has noticed many people need is a special type of flexible and sensor-based phone case that once put on any phone, can communicate with the phone to report all the user health information (obtained from the sensors' communicating with the user's hand pulse) with an app and report it to the patient periodically. This is his plan for the premium version of the case: in addition to reporting the user's health info to the user themselves (which is the primary feature of the regular version), the premium version can communicate this information with designated family members and communicate theirs back to the user. Also, if extreme symptoms are detected, it can trigger alerts to the designated primary care provider.

He figures that each regular case will cost him about $2 to make and each premium case will cost $2.2. After a little bit of field research, he discovers that the demand for each version depends on the price of that version itself as well as the price of the other version through the following relationships:

Regular Demand= 10,000 - 3,000[Regular Price] + 150[Premium Price]

Premium Demand= 8,000 - 2,200[Premium Price] + 50[Regular Price]

Jake needs to decide on the best price for each version, but his total profit is a non-linear one and tough to guess the best prices for.

Can you help him out? In a separate tab called "2", build a spreadsheet model for this problem and use solver to optimize it.