The East Anglia Tea Firm imports three
sorts of tea from Asia: black tea, oolong tea, and inexperienced tea. The corporate
purchases 70 kilos of black tea each week, at a value of $2.70 per pound.
Additionally, it purchases 120 kilos of oolong tea at $three.00 per pound, and 150 kilos
of inexperienced tea at $2.10 per pound, each week. By mixing these teas in varied
combos, the corporate creates three tea blends, Mongolian, Manchu, and
Home, that it sells to a packaging firm for additional processing. Mongolian
mix is not less than 70% black tea however not more than 10% inexperienced tea. Manchu mix is
not less than 30% black tea and not less than 40% oolong tea. The companyâs Home mix
is not more than 60% inexperienced tea, however its oolong tea element have to be not less than
30%. The wholesale costs per pound that East Anglia prices the packaging
firm are $6.50 for Mongolian mix, $7.25 for Manchu mix, and $6.00 for
(a.) How a lot of every mix ought to the East Anglia Tea Firm make every
week to maximise its revenue? Create a linear programming mannequin, and resolve it
utilizing the Solver utility of Excel.
(b.)Focus on the sensitivity ranges of the choice variables. Level out
and clarify any fascinating info about these ranges.
(c.) Focus on the sensitivity ranges that pertain to the full quantities (of
the three tea varieties) bought every week. How would variations in these
quantities have an effect on the optimum product combine? What do the shadow costs indicate about
the relative values of the three assets (teas)?
Task 1. Linear Programming Case Examine
teacher will assign a linear programming undertaking for this task
in response to the next specs.
can be an issue with not less than three (three) constraints and not less than two (2)
determination variables. The issue can be bounded and possible. It’s going to even have
a single optimum answer (in different phrases, it wonât have alternate optimum
options). The issue will even embrace a element that includes sensitivity
evaluation and using the shadow value.
can be delivering two (2) deliverables, a brief writeup of the undertaking and the
spreadsheet exhibiting your work.
writeup ought to introduce your answer to the undertaking by describing the
drawback. Accurately establish what sort of drawback that is. For instance, you
ought to be aware if the issue is a maximization or minimization drawback, as nicely
as establish the assets that constrain the answer. Determine every variable
and clarify the factors concerned in organising the mannequin. This needs to be
encapsulated in a single (1) or two (2) succinct paragraphs.
the introductory paragraph, write out the L.P. mannequin for the issue. Embrace
the target perform and all constraints, together with any non-negativity
constraints. Then, you must current the optimum answer, based mostly in your work
in Excel. Clarify what the outcomes imply.
write a paragraph addressing the a part of the issue pertaining to sensitivity
evaluation and shadow value.
beforehand famous, please arrange your drawback in Excel and discover the answer
utilizing Solver. Clearly label the cells in your spreadsheet. You’ll flip within the
complete spreadsheet, exhibiting the setup of the mannequin, and the outcomes.