Reference no: EM131027275
Grandma’s Little Bakery is trying to figure out how much grain to order for the next month to mix into its most favorite flourless multi-grain bread. The grains that can be bought from local suppliers have the following composition and price:
In order for the dough to bake smoothly, the amount of starch in the mixture should be kept within 20 to 30 percent. Because of taste considerations, the amount of grain #2 in the mix cannot exceed 20%. Finally, for proper nutritional balance, the mixture should have at least 15% protein, at least 40% fiber, and no more than 12% gluten.
To satisfy the demand for next month, the bakery needs to produce exactly 150 kilograms of multi-grain dough mix. Help Mama’s Little Bakery find the least costly mix of grains that will satisfy demand.
a. Formulate the problem as a linear program (i.e., define the variables, and write down the objective function and all constraints in algebraic form).
b. Create a spreadsheet model for this problem and solve it with Solver.
c. What is the optimal solution? What is the optimal value?
|
Suppliers has bid on new line of molded plastic parts
: One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecasted demand of 220,000 parts in year 1; 330,000 in year 2; and 490,000 i..
|
|
Ways to minimize negative effects from culture difference
: What are the ways to minimize negative effects from culture difference? Did you (your friends, relatives and etc.) have any culture difference issues in business? How did you /them solve the problems? Did these issues affect your /their business?
|
|
The percentage increase in productivity
: Charles lackey operates a bakery in Idaho, Falls Because of its excellent product location, demand has increased by 35% in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. After increasing ..
|
|
Case study assuming demand continued to grow
: Mayu LLC Case Study Assuming demand continued to grow, how would Kate scale operations in Peru? She had already accepted a full-time job in Chicago and would be working on Mayu on a part-time basis.
|
|
Find the least costly mix of grains that will satisfy demand
: Grandma’s Little Bakery is trying to figure out how much grain to order for the next month to mix into its most favorite flourless multi-grain bread. To satisfy the demand for next month, the bakery needs to produce exactly 150 kilograms of multi-gra..
|
|
Choose a brand name in a very competitive market
: For this assignment, choose a brand name in a very competitive market. Analyze the brand versus its top 3 competitors and prepare a report on how they attempt to differentiate their product. Present the top three competitors and a brief analysis of t..
|
|
Product functionality is the key to brand success
: This activity will allow you to identify how marketers go to great lengths to differentiate and stress form and not function, even in low-end product categories. The form versus function discussion applies in many areas, including marketing. Consider..
|
|
Two major methods of investigation
: Psychological research includes two major methods of investigation: co relational and experimental. In at least 500 words, define these methods, provide an example of a situation where researchers have used each method, and then share a way in which ..
|