Image 12-18-23 at 8

.jpeg

School

Boston University *

*We aren’t endorsed by this school

Course

212

Subject

Chemistry

Date

Jan 9, 2024

Type

jpeg

Pages

1

Uploaded by neliekyara

Report
C-30 A2 C-92 .09 D-21 1 E-11 .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 consitute at least 45% of the blend c. DI-21 and C-92 can together constitute no more than 30% of the blend d Golding-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 3. Please submit your Excel spreadsheet template with solver 4. Which combination of the components used is the optimal solution to minimize cost in this case? Tell me English the Cost and the combinations used. hints: This is a minimize cost template - use the Holiday Meat Turkey ranch example as a template The model should give you the # of Ibs for each C-30, C-92, D-21 and E11 The cost is given to you. Here are the constraints 50 Ibs bugs on the RHS you put =50 E-11 >=15% on the RHS your calculation should be =.15*50 (which will give you 7.5) C-92 and C-30 >=22.5 (45% for both) - On the RHS you put =.45*50 (that will give you 22.5) D-21 and C=92 <=30% On the RHS you put =.3*50 (that will give you 15) Use solver chapter 13 Looking for 5 answers. Final hints: Use the template attached but insert 2 additional columns since you have 4 products. You are looking for minimizing cost. | gave you the constraints...
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help