Explore BrainMass

Product-Mix Decision Model-Professor Tillerman's Tonic Tea

Product-Mix Information
Prepared by the Marketing Department

Professor Tillerman's Tonic Tea produces its three blends in the manner outlined below. Since their introduction, the two new flavors have been extremely popular with customers (especially the Kyoto Blend), and account for 85 percent of our current production.

See attached file for full problem description.


Solution Summary

This problem builds and solves a quantitative decision model using Excel Solver add-in "Product-Mix Decisions Model" for Professor Tillerman's Tonic Tea. Would help students to build modeling skills in Excel.