only 28,29,32

A LP Product Mix problem has been modeled in Excel and solved by Excel Solver. Examine the Excel Output below after Solver has found a solution and answer the questions that follow the output. (Note that the output is presented in slightly different format than the format that we used in class.) Activity Activity Activity 2 3 Unit Profit 20 40 30 Resource Resource Resource Usage per Unit of Activity 5 1 3 3 Resource 1 Resource 2 Resource 3 Used 400 100 200 Available 400 100 200 1 1 1 2 Activity 1 Activity 3 Total Profit Activity 2 Level of Activity 50 50 0 3,000 26 The English names od decision variables X1, X2, X3 are: A) Resource 1 Used, Resource 2 Used, and Resource 3 Used B) Unit Profit of Activity 1, Unit Profit for Activity 2, Unit Profit for Activity 3 C) Resoutee Usage per Unit of Activity 1, Resource Usage per Unit of Activity 2. Resource Usage per Unit of Activity 3 D) Level of Activity 1, Level of Activity 2, Level of Activity 3 27 Algebraically state the objective function. A) Max Total Profit=20X1+40X2+30X3 B) Min Total Cost = 20X1+40X2+30X3 C) Min Total Cost - 400X1+100X2-200X3 D) Max Total Profit=50X1+50X2+0X3 28 Algebraically state the constraint on Resource 2. A) 100 = 100 B) X1+X2+X3 =100 C) X1+X2+X3 >=100 D) X1+X2+X3 RHS for all three resources B) No, because LHS = RHS for all three resources C) Yes, because Resource Used = Resource Available for all three resources D) No, because Resource Used Resource Available for all three resources 31 How much profit is made through the production of Activity 1? A) 1,000 B) 9,000 C) 3,000 I D) 2,000 32 Which resource(s), if any, would you recommend buying more of? Why? A) Resource 2 because it has the smallest Usage per Unit of Resource for any Activity B) None of them individually because in the optimal solution, all Resources are fully utilized C) Resource 2 because it has the greatest Profit per Usage of resources for all Activities D) All Resources because Level of Activity 3 equals zero in the optimal solution