3 Tab W E 4. Coleman Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a Class A container, Class K container, or a Class T container. A single class A container yields a profit of $8; a Class K container, a profit of $6; and a Class T container, a profit of 14. Each shipment prepared requires a certain amount packaging material and a certain amount of time. RESOURCES NEEDED PER STANARD SHIPMENT Class of Container A K T Total amount of resource Packing Material (pounds) Packing Time (hours) 2 2 1 6 3 4 120 pounds 240 hours available each week John Coleman, head of the firm, must decide the optimal number or each class of He is bound by the previously mentioned resource container to pack each week. restrictions, but also decide that he must keep his six full-time packers employed all 240 hours (6 workers x 40 hours) each week. Formulate the objective function for this problem (i) (ii) Formulate the functional constraints (iii) Use Excel solver to solve this problem.