PLEASE SHOW ON EXCEL

A team of students has entered a robot competition, in which their robot must start from a base location, move to and grab objects, and return them to the base to score points. The point values assigned to the objects 10.9 There is a 4-minute time limit for the competition; only objects returned to the base will be counted in the scoring. The team has practiced retrieving all 10 objects; times for completing the round trip to the object and bringing it back to the base, along with the point values of each, are shown in Table P10.9. Table P10.9 Object Number Point Value Time to Retrieve, s 1 2 3 4 5 6 7 8 9 10 100 100 100 50 50 50 25 25 25 25 110 80 75 55 45 30 22 20 15 15 Use Excel Solver to determine the objects that should be retrieved within the 4-minute time limit in order to maximize the team's score. Hint: The independent variables in this problem will be the number of each object that is retrieved. Since there is only one of each, the value of each independent variable will be either one or zero. Therefore, the con- straints will be that each value is less than or equal to one, each value is an integer, and each value is non-negative. These constraints can be added in groups. For example, you can add a new constraint in Solver, select the range of cells containing all of the independent variables, and enter the constraint that all are less than or equal to one in one step