Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

[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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Warren R. Plunkett, Gemmy S. Allen

10th edition

1111221340, 978-1111221348

More Books

Students also viewed these General Management questions