Explore BrainMass
Share

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

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.

#### Solution Summary

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

\$2.19