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.
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.