solve on excel using the solver add on

3 You have 2 hrs to complete both Part A \& Part B and uplaod it on Canvas Q1. (25 points) Thompson Distributors packages and distributes industrial supplies. A standard shipment can be packed in class A, class K or class T container. Each shipment requires a certain amount of packing material and certain amount of time. Details on the resource requirement, their availability and profit per container is given in the table below. (i) Type out the objective function and constraints. This will enable me to give partial credit if Solver does not execute. (ii) Set up the problem in excel and solve it using Solver. The Answer Report must be downloaded. The solver dialog box should be populated when I open your submission and I should be able to execute solver