Melnick Enterprises manufactures two products, boat wax and car wax, in two departments, the Mixing Department and the Packaging Department. The Mixing Department has 800 production hours per month available, and the Packaging Department has 1,200 hours per month available. Production of the two products cannot exceed 36,000 pounds. Data on the two products follow/;
Required:
Use Excel to calculate the optimal monthly production mix (per 100 pounds) of Boat Wax and Car Wax that Melnick should produce? Clearly show the objective function and the mixing constraints for the linear program that Melnick would use to determine the optimal monthly production of each wax.