Question 12 5 Points Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max 3X1 + 3X2 Subject to: 2X1 + 3X2 10 3X1 + 2X2 = 20 X1 25 X1, X220 (constraint #1) (constraint #2) (constraint #3) (non-negativity) A B D E F X1 X2 Total Profit 3 Number to make: Unit Profits: $3 S3 Slack/ Surplus L.H.S. Constraints 1 2 3 2. 3 R.H.S. 10 20 5 2 3 1 0 Refer to the spreadsheet above. Which cell(s) specifies the "changing cells" in Solver? B1:01 B D6:D8 B3:03 D D3 E B2:02 Question 13 5 Points The objective of transportation problems is typically to either minimize total shipping costs or distances. A True B False Question 14 5 Points The marketing research problem has which of the following objectives? A maximizing audience exposure B minimizing advertising costs C minimizing interview costs maximizing profit E minimizing the total number surveyed Question 15 5 Points The objective function of a transportation problem is to: A maximize transportation cost B maximize supply quantities (c minimize total demand minimize total shipping cost E minimize production cost Question 16 5 Points Diet and feed mix problems are special classes of the general product mix problem. A True B False Question 20 5 Points A company produces two products, X 1, and X 2. The constraint that illustrates the consumption of a given resource in making the two products is given by: 2X 1+3X 23 10. This relationship implies that each unit of X1 consumes 3 units of that resource. A True B False