Using Geradlinig Programming to assist Golding Grow
Kenneth and Patricia Golding have a gardening business in Va. Kenneth discerned the need for a high quality commercial fertilizer he may blend himself, both to include in his gardening shop and to sell off to his customers. This individual wants an exceptional product that was especially suited to the northern Va climate. The fertilizer this individual created, in conjunction with George Mason University was " Golding GrowвЂќ and consists of four chemical compounds: C-30, C-92, D21, and E-11. A challenge is usually to maintain an excellent product and minimize costs so as to increase profits. Based upon the effects shown listed below, Ihave concluded that the blend of the 4 chemicals that would minimize costs is found in the subsequent equation:. 12(7. 5) +. 09(15)+. 11(0) +. 04(27. 5) = 3. 35 based on the first objective function to minimize price. This was considered to be. 12X1 &. 09X2 +. 11X3 &. 04X4 at first. Thus, Golding will use six. 5 pounds of substance C-30, 15 pounds of C-92, zero pounds of D-21, and 27. your five pounds in the compound E-11. In checking the constraints that have been presented by the Goldings, we see that this answer also meets all of the restrictions that were provided. These are presented below.
Excel formulas are as follows:
Excel Solver is downloaded and the answers are as follows:
The final outcome is that Golding should make use of 7. five pounds of C-30, 15 pounds of C-92, 0 pounds of D-21 and 27. five pounds of E-11. The hazards the Goldings face is the might be the most cost-efficient solution, but it might not be the highest quality solution. The quality of the formula cannot be determined by price alone. The reputation of their very own business is in stake in the event they provide an inferior product.