A B D G H K L M N o P Q R S E F QUESTION 3. Island 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 magazines free to businesses, hotels, and stores on Hilton Head Island in South Carolina. The company's profits come exclusively from the paid advertising in the magazines. Each of the restaurant and entertainment guides distributed generates $0.5 per magazine in advertising revenue, whereas the real estate guide generates $0.8 per magazine.. The real estate magazine is a more sophisticated publication that includes color photos,and accordingly it costs $0.41 per magazine to print, compared with only $0.32 for the restaurant and entertainment guide. The publishing company has a printing budget of $6,000 per month. There is enough rack space to distribute at most 15,000 magazines each month. In order to entice businesses to place advertisements, Island Publishing promises to distribute at least 4,000 copies of each magazine. The company wants todetermine the number of copies of each magazine it should print each month in order to maximize advertising Replace the image below with a screenshot of your solver settings Rest. and Entertainement Number of magazines Solver Parameters Real Estate guide Number of magazines Set Objective: To: oMax Min Value Of: 0 By Changing Variable Cells: Subject to the Constraints: Add Change Delete Reset All 2 Total revenue $ 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 INFO Load/Save Make Unconstrained variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Q1 Q2 Q3 04 ANSWERS + + A20 fx A B C D E E F G H 1 J K Numerical Question: STUDENT ANSWERS 0% Correct Answers 0.00% Type A chocolate 10.00 Type B chocolate 2.00 Profit $ $ 70.40 0.00% Tetra Toys 90.00 OZ Ultra Toys 0.00 Ozan Profit $ S 1,350.00 0.00% Rest. and Entertainement 4,000.00 1 SOLUTION SHEET 2 Q1 3 4 5 6 7 8 9 9 Q2 10 11 12 13 14 15 16 Q3 17 18 19 20 21 22 23 Q4 24 25 26 27 28 29 30 31 82 33 34 35 Real Estate guide 11,000.00 Total revenue $ $ 10,800.00 0.00% Egg (mg) 2.00 Bacon (mg) 3.00 Cereal (mg) 0.00 Cost $ $ 0.17 A B D G H K L M N o P Q R S E F QUESTION 3. Island 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 magazines free to businesses, hotels, and stores on Hilton Head Island in South Carolina. The company's profits come exclusively from the paid advertising in the magazines. Each of the restaurant and entertainment guides distributed generates $0.5 per magazine in advertising revenue, whereas the real estate guide generates $0.8 per magazine.. The real estate magazine is a more sophisticated publication that includes color photos,and accordingly it costs $0.41 per magazine to print, compared with only $0.32 for the restaurant and entertainment guide. The publishing company has a printing budget of $6,000 per month. There is enough rack space to distribute at most 15,000 magazines each month. In order to entice businesses to place advertisements, Island Publishing promises to distribute at least 4,000 copies of each magazine. The company wants todetermine the number of copies of each magazine it should print each month in order to maximize advertising Replace the image below with a screenshot of your solver settings Rest. and Entertainement Number of magazines Solver Parameters Real Estate guide Number of magazines Set Objective: To: oMax Min Value Of: 0 By Changing Variable Cells: Subject to the Constraints: Add Change Delete Reset All 2 Total revenue $ 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 INFO Load/Save Make Unconstrained variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Q1 Q2 Q3 04 ANSWERS + + A20 fx A B C D E E F G H 1 J K Numerical Question: STUDENT ANSWERS 0% Correct Answers 0.00% Type A chocolate 10.00 Type B chocolate 2.00 Profit $ $ 70.40 0.00% Tetra Toys 90.00 OZ Ultra Toys 0.00 Ozan Profit $ S 1,350.00 0.00% Rest. and Entertainement 4,000.00 1 SOLUTION SHEET 2 Q1 3 4 5 6 7 8 9 9 Q2 10 11 12 13 14 15 16 Q3 17 18 19 20 21 22 23 Q4 24 25 26 27 28 29 30 31 82 33 34 35 Real Estate guide 11,000.00 Total revenue $ $ 10,800.00 0.00% Egg (mg) 2.00 Bacon (mg) 3.00 Cereal (mg) 0.00 Cost $ $ 0.17
