NOTE: All Linear Programming models must be in "complete" and written in the standard form, and describe every term and coefficient in all Excel Solver spreadsheets.

. XYZ Publishing Company publishes two types of magazines on a monthly basis: a restaurant and entertainment guide, and a real estate guide. The company distributes the magarines free to businesses, hotels, and stores near the beach in the sea resort where it is located. The company's profits come exclusively from the paid advertising in the magarines. Each of the restaurant and entertainment guides distributed generates $0.50 per magazine in advertising revenue, whereas the real estate guide generates S0.75 per magazine. The real estate guide is a more sophisticated publication that includes color photos, and accordingly it costs $025 per magazine to print compared with only SO.17 for the restaurant and entcrtainment guide. The publishing company has a printing budget of $4,000 per month. There is enough rack space to distribute at most 18,000 magarines each month. In order to entice businesses to place advertisements, the company promises to distribute at least 8,000 copies of each magazine. Formulate a LP model and answer the following questions: a) How many copies of each magazine should the company print each month in order to maximize its advertising revenue? b) What would be the effect on the optimal solution if the local real estate agents insisted that 12,000 copies of the real estate guide be distributod inslead of the curent 8,000 copics if they are going to continue advertising? c) How mach would it be worth to the company to obtain enough additional rack space to distribute 18,500 copies instead of the current 18,000 copies