exercise: a company manufactures and sells four types of frames for paintings. each requires labor hours, metal, and glass. the unit costs of these resources are listed in rows 18-20, and the requirements per frame are listed in rows 24-26. also, the availabilities of these resources are listed in column j, and the company is not allowed to use more of these resources than are available. the company then sells the frames at the prices listed in row 27. however, it will not produce more frames than it can sell, and these maximum sales quantities are listed in row 33. 1. the company must decide how many of each frame type to produce (and sell). enter any values of these decision variables in row 31 (or leave the current values there). you will eventually use solver to find the optimal values. 2. based on these values, calculate the amounts of the resources used in column h, and calculate the profit in cell b35. 3. use solver to find the production quantities that maximize profit, while satisfying the resource availability constraints and the maximum sales constraints. make sure to make the changing cells nonnegative and use the simplex lp method.