Required to work on a linear programming case study (see the attachment). You must submit: 1. A Word file to explain your mathematical models, to report your answers, and to write recommendations for decision makers based on the solutions, and 2. An Excel file to demonstrate how you use Solver to identify the solutions.. Determine the amount of potatoes and green beans Maria should purchase each week for the casserole to minimise the ingredient costs while meeting nutritional, taste, and demand requirements. Before she makes her final decision, Maria plans to explore the following questions independently, except where otherwise indicated. b. Maria is not very concerned about the taste of the casserole; she is only concerned about meeting nutritional requirements and cutting costs. She therefore forces Edson to change the recipe to allow only for at least a one-to-two ratio in the weight of potatoes to green beans. Given the new recipe, determine the amount of potatoes and green beans Maria should purchase each week. c. Maria decides to lower the iron requirement to 65 mg since she determines that the other ingredients, such as the onions and cream of mushroom soup, also provide iron. Determine the amount of potatoes and green beans Maria should purchase each week given this new iron requirement. To answer this part, first conduct sensitivity analysis to check whether the part-a solution still remains optimal. If it is not, then you must find a new one. d. Maria learns that the wholesaler has a surplus of green beans and is therefore selling the green beans for a lower price of $0.50 per lb. Using the same iron requirement from part c and the new price of green beans, determine the amount of potatoes and green beans Maria should purchase each week. To answer this part, first conduct sensitivity analysis to check whether the part-c solution still remains optimal. If it is not, then you must find a new one. e. Maria decides that she wants to purchase lima beans instead of green beans since lima beans are less expensive and provide a greater amount of protein and iron than green beans. Maria again wields her absolute power and forces Edson to change the recipe to include lima beans instead of green beans. Maria knows she can purchase lima beans for $0.60 per lb from the wholesaler. She also knows that lima beans contain 22.68 g of protein and 6.804 mg of iron per 10 ounces of lima beans and no vitamin C. Using the new cost and nutritional content of lima beans, determine the amount of potatoes and lima beans Maria should purchase each week to minimise the ingredient costs while meeting nutritional, taste, and demand requirements. The nutritional requirements include the reduced iron requirement from part c. f. Will Edson be happy with the solution in part e? Why or why not? g. An All-State student task force meets during Body Awareness Week and determines that All-State University's nutritional requirements for iron are too lax and that those for vitamin C are too stringent. The task force urges the university to adopt a policy that requires each serving of an entrée to contain at least 120 mg of iron and at least 500 mg of vitamin C. Using potatoes and lima beans as the ingredients for the dish and using the new nutritional requirements, determine the amount of potatoes and lima beans Maria should purchase each week. In each part you must: • Define decision variables and describe the mathematical model; and • Except part f, write a recommendation to the problem by including the total cost, the amount of each casserole’s ingredient, and the amount of each nutrient
good excellent job.. I am extremely satisfied. Very fast response and professional team.
MyAssignmenthelp.com is acknowledged for providing best assignment help at affordable price. With our urgent assignment help, students never miss their deadlines. Our highly skilled and qualified experts are capable of crafting premium quality online assignment help solutions within shortest deadlines. Hence, MyAssignmenthelp.com has emerged as the one-stop solution for all those who need assignment help within short period of time.
Just share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Really nice work and helpful, looking forward for more work in future thanks team
Australia
I am very pleased with the assignment and how fast it was able to be done. I received great remarks for this assignment. I received an A for the assignment.
Australia
It is not graded yet but his time management was good and he kept all our plan. It is not graded yet but his time management was good and he kept all our plan.
Australia
Excellent job, it turned out to be just what I needed. I will definitely recommend!
Australia