Question: whats the correct way to enter this into excel using solver? The Queen City Nursery manufactures bags of potting soil from compost and topsoil. Each

The Queen City Nursery manufactures bags of potting soil from compost and topsoil. Each cubic foot of compost costs 12 cents (enter as .12) and contains 4 pounds of sand, 3 pounds of clay, and 5 pounds of humus. Each cubic foot of topsoil costs 20 cents (enter as .20) and contains 3 pounds of sand, 6 pounds of clay, and 12 pounds of humus. Each bag of potting soil must contain at least 12 pounds of sand, at least 12 pounds of clay, and at least 10 pounds of humus. Formulate the problem as a linear program and find the best combination of compost and topsoil that meets the stated conditions at the lowest cost per bag. a. Is this a maximization or minimization problem? b. How many cubic feet of compost is in the mix? c. How many cubic feet of topsoil is in the mix? c. What is the overall cost? cents d. Are there any unused resources? if so, in what constraint and by how much? Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A6 F^fx SAND MOD BiLINRAR PROGRAMMING - 3 variable Minimination Problem Step 1: Enter the L.P medd: Step 2 ic Colculate the L.its in Contraiats Step 3: Riun the Solver from the 'Data' tab in the Tee Ribbea Optimal Solution \begin{tabular}{|c|c|c|c|c|c|} \hlinex1 & x2 & x3 & x4 & x & Popfit \\ \hline 0.0000 & 15 & 0 & 0 & 0 & 57.00 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
