Share
Explore BrainMass

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.

Attachments

Solution Summary

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

$2.19