Purchase Solution

3 Tea Blends: Operations Research for current product mix and optimal mix

Not what you're looking for?

Ask Custom Question

In the attached excel file, there are 3 spreadsheets.

SCENARIO - If filtration time for Kyoto Blend was reduced by 10%

There are TWO (2) required calculations:

CURRENT PRODUCT MIX spreadsheet - If filtration time was reduced by 1% - 20% for
Kyoto blend, what would be the effects on weekly profits and number of units produced weekly
for all 3 tea blends? Let the solver table show 1% incremental reduction in filtration time changes.
Show any changes in filtration/blending/bottling/finishing times used at each interval.

OPTIMAL PRODUCT MIX spreadsheet - If filtration time was reduced by 1% - 20% for
Kyoto blend, what would be the effects on weekly profits and number of units produced weekly
for all 3 tea blends? Let the solver table show 1% incremental reduction in filtration time changes.
Show any changes in filtration/blending/bottling/finishing times used at each interval.

Basically it is the same scenario to be used on both sheets. It is important to show
all calculations - similar to the Solver Table layout on Optimal sheet for
sensitivity to profit decreases in New Delhi Blend.

Purchase this Solution

Solution Summary

Using Excel solver, the solution presents the sensitivity table layout for the optimal mix.

Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Introduction to Finance

This quiz test introductory finance topics.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.