Binders Beverage & Landscaping Essay

To help Bill Binder pick the best route to carry his bottles from his plant to his w beho part we can use the shortest path pose. The shortest path model finds how to cristal items/people from on location to an separate while minimizing the extreme distance traveled, time taken or some other measures. In Bills case we pass on minimize the time it takes to transport his bottles from his plant at leaf lymph gland 1 to his warehouse at lymph gland 10. A road map for Binders Beverage with the nodes and distances stated in minutes is depicted below.Binders Beverage path MapThe solution of Bills problem shows that the shortest path (measured in terms of time) from the plant to the warehouse is 60 minutes and involves traveling through nodes 2, 4, 8 and 9. The Excel dissolving agent from Solver is attached separately. At node one which is the supply node the net flow is -1. At node 10 which is the demand node the net flow is 1. All other nodes are transshipment nodes and hence hav e a net flow catch to zero. Below you can find a screenshot from Excel.CASE STUDY, BALAKRISHNAN, CHAPTER 2GOLDING landscape gardening AND PLANTS1. LP Problem FormulationIn this case study there are four decision variables.C30 = Pounds of C-30 to put in a fifty lulu fertiliserC92 = Pounds of C-92 to put in a fifty bag plant foodD = Pounds of D-21 to put in a fifty bag fertilizerE = Pounds of E-11 to put in a fifty bag fertilizerThe objective is to minimize the cost of chemical compounds utilize and can be written asMinimize Total Cost = $0.12(C30) + $0.09(C92) + $0.11(D) + $0.04(E)subject to pursuit constraintsa) E= 0.15 (C30+C92+D+E)b) C92+C30= 0.45 (C30+C92+D+E)c) D+C92= 02. The Best solution is to use 7.5 of C-30, 15 of C-92 and 27.5 of E-11 and not to include D-21 in the mix at all. This will result in a cost of $3.35 per 50 bag.Excel Solution is attached as a separate file. Screenshots of solution and formulas are attached below.All constraints are binding with the except ion of constraint (a), which indicated that E-11 should at least(prenominal) comprise 15% of the blend. This would mean the lower bound of E-11 to be used was 7.5, where in fact we ended up using 27.5 of E-11. The difference of 20 is shown in the answer report as a slack of 20.