Retley Manufacturing makes three products: Ghizmos, Whizmos, and Gadgets. The products sell for $50, $90, and $100, respectively. Each product requires processing on each of two machines. The grinding machine is operated 8 hours a day for 25 days a month. Gizmos require 2 hours of grinding. Whizmos require 3 hours, and Gadgets require 6 hours. The finishing machine can theoretically be operated 8 hours per day for 25 days, but the firm usually loses 25% of this time due to breakdowns. Gizmos and Gadgets each use 2 hours of finishing time, and Whizmos use 4 hours. Final assembly is done by hand. Four Gizmos can be assembled by a laborer per hours, while it takes 2 hours to put together one Whizmo, and 30 minutes to assemble a Gadget. All three products use the same raw materials. Each Gizmo needs 3 pounds, each Whizmo needs 5 pounds, and a Gadget requires 8 pounds. Labor is paid $14 per hour, and raw materials cost $6 per pound. The firm used regression analysis to estimate following cost function for overhead: Overhead = $200 + $6 per direct labor hour.

REQUIRED: A. Write out the target cell equation and the constraint equations to solve for the optimal product mix.

B. Use Excel Solver to solve for the optimal product mix.