# Strayer MAt540 week 8 assignment

Question # 00032742 Posted By: neil2103 Updated on: 11/21/2014 01:10 PM Due on: 11/25/2014
Subject Mathematics Topic General Mathematics Tutorials:
Question
Strayer MAt540 week 8 assignment

East Anglia Tea Company

The East Anglia Tea Company imports three varieties of tea from Asia: black tea, oolong tea, and green tea. The company purchases 70 pounds of black tea every week, at a cost of \$2.70 per pound. Also, it purchases 120 pounds of oolong tea at \$3.00 per pound, and 150 pounds of green tea at \$2.10 per pound, every week. By mixing these teas in various combinations, the company creates three tea blends, Mongolian, Manchu, and House, that it sells to a packaging company for further processing. Mongolian blend is at least 70% black tea but no more than 10% green tea. Manchu blend is at least 30% black tea and at least 40% oolong tea. The company’s House blend is no more than 60% green tea, but its oolong tea component must be at least 30%. The wholesale prices per pound that East Anglia charges the packaging company are \$6.50 for Mongolian blend, \$7.25 for Manchu blend, and \$6.00 for House blend.

(a.) How much of each blend should the East Anglia Tea Company make each week to maximize its profit? Create a linear programming model, and solve it using the Solver utility of Excel.

(b.)Discuss the sensitivity ranges of the decision variables. Point out and explain any interesting facts about those ranges.

(c.) Discuss the sensitivity ranges that pertain to the total amounts (of the three tea varieties) purchased each week. How would variations in those amounts affect the optimal product mix? What do the shadow prices imply about the relative values of the three resources (teas)?

Tutorials for this Question
1. ## Solution: Strayer MAt540 week 7 assignment

Tutorial # 00032105 Posted By: neil2103 Posted on: 11/21/2014 01:10 PM
Puchased By: 3
Tutorial Preview
The solution of Strayer MAt540 week 7 assignment...
Attachments
Solution-00032105.zip (71 KB)
Recent Feedback
Rated By Feedback Comments Rated On
ya...010 Excellent team support and best services 12/23/2014
2. ## Solution: Strayer MAt540 week 8 assignment

Tutorial # 00032903 Posted By: neil2103 Posted on: 11/26/2014 07:24 PM
Puchased By: 4
Tutorial Preview
The solution of Strayer MAt540 week 8 assignment...
Attachments
East_Anglia_Tea_Company.docx (30.06 KB)
EAST_ANGLIA_TEA_COMPANY.xlsx (20.31 KB)
Recent Feedback
Rated By Feedback Comments Rated On
ro...now Good-quality and satisfactory content 01/21/2015
ya...010 Perfect work with effective services 12/29/2014

Great! We have found the solution of this question!