Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[30 points] Cookie Co is a commercial bakery that produces specialty cookies. Their recipe must meet minimum nutrition standards that state that the cookie dough
[30 points] Cookie Co is a commercial bakery that produces specialty cookies. Their recipe must meet minimum nutrition standards that state that the cookie dough mix should have at most 40.5% sugar, at least 5.5% protein, at most 31.0% fat, and at least 8.0% fiber. The available ingredients and their compositions are shown in the table below, along with their costs (in $/kg ). Fruit is hard to keep fresh, so Cookie Co wants berries to account for no more than 15% of the total mixture. Furthermore, Cookie Co has a partnership with a sustainable oats manufacturer and wants the mixture to have at least 5% oats. Finally, the amount of money spent on protein powder should be less than or equal to the amount of money spent on seeds. Cookie Co wants to minimize the cost of ingredients of the cookie dough mix. MGMT 3106: Management Science and Operations Management a. What are decision variables for the problem? What is the objective function for this problem? b. What are the constraints for the problem? c. Solve the problem using Excel Solver or LP Solve. How should Cookie Co mix a 1kg bag of cookie dough mix to minimize the cost of the ingredients? d. How many kg of each ingredient should they use
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started