Reference no: EM132357956

Working with chemist at George Mason University. Golding blended Golding-Grow. It consists of four chemical compounds: C-30, C-92, D-21, and E-11. The cost per pound for each compound is indicated in the following table:

Chemical Compound Cost Per Pound ($)

C-30 0.12

C-92 0.09

D-21 0.11

E-11 0.04

The specifications for Golding-Grow are as follows:

a. Chemical E-11 must comprise at least 15% of the blend.

b. C-92 and C-30 must together constitute at least 45% of the blend.

c. D-21 and C-92 can together constitute no more than 30% of the blend.

d. Godling-Grow is packaged and sold in 50-pound bags.

1. Formulate an LP problem to determine what blend of the four chemicals will allow Golding to minimize the cost of a 50-pound bag of the fertilizer.

2. Solve by using Excel to find the best solution.

Can you include a spreadsheet with this problem.