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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!