Chapter 8. In Problem Set 6, we worked on a problem for Flor's Flours, a small business that produces two types of ready-to-use multigrain flours using organic products such as bulgur wheat, garbanzos, and jasmine rice and sells them at a Farmer's Market every weekend. The first blend is called Pancake-Me and is priced at $6.50 per Ib. and the second blend is called the Bake-Me and is priced at $4.50 per Ib. These healthier versions of the traditional flour used for cooking and baking are fairly popular and Flor realizes that she needs to have a more formalized method of how to blend the flours if she hopes to minimize her costs and maximize her profits by continuing to sell the flours on a larger scale. The costs of obtaining the components - bulgur wheat, garbanzos, and jasmine rice are different. After running the original model, Flor found that she had more Jasmine rice left on hand than she really needed and made the following changes to her blends and bulk-grain purchases. With a lot of painstaking trial-and-error, Flor updated some of the following guidelines to minimize any wasted product: Pancake-Me Blend should have: • At least 50% wheat • At least 20% garbanzos • At least 15% jasmine rice Bake-Me Blend should have: • At the most 60% wheat • At least 25% garbanzos • At the most 10% jasmine rice Moreover, Flor now purchases 175 lbs. of bulgur wheat at $1.25 per Ib., 125 lbs. of garbanzos at $0.87 per lb. and 40 lbs. of rice at $1.79 per Ib. for the next month's production by ordering whole grains in bulk on the internet. She still needs to have at least 100 pounds of the Bake-Me blend available to cover the next month's demand at the Farmer's Market. Based on this NEW information, answer the following questions:
Chapter 8. In Problem Set 6, we worked on a problem for Flor's Flours, a small business that produces two types of ready-to-use multigrain flours using organic products such as bulgur wheat, garbanzos, and jasmine rice and sells them at a Farmer's Market every weekend. The first blend is called Pancake-Me and is priced at $6.50 per Ib. and the second blend is called the Bake-Me and is priced at $4.50 per Ib. These healthier versions of the traditional flour used for cooking and baking are fairly popular and Flor realizes that she needs to have a more formalized method of how to blend the flours if she hopes to minimize her costs and maximize her profits by continuing to sell the flours on a larger scale. The costs of obtaining the components - bulgur wheat, garbanzos, and jasmine rice are different. After running the original model, Flor found that she had more Jasmine rice left on hand than she really needed and made the following changes to her blends and bulk-grain purchases. With a lot of painstaking trial-and-error, Flor updated some of the following guidelines to minimize any wasted product: Pancake-Me Blend should have: • At least 50% wheat • At least 20% garbanzos • At least 15% jasmine rice Bake-Me Blend should have: • At the most 60% wheat • At least 25% garbanzos • At the most 10% jasmine rice Moreover, Flor now purchases 175 lbs. of bulgur wheat at $1.25 per Ib., 125 lbs. of garbanzos at $0.87 per lb. and 40 lbs. of rice at $1.79 per Ib. for the next month's production by ordering whole grains in bulk on the internet. She still needs to have at least 100 pounds of the Bake-Me blend available to cover the next month's demand at the Farmer's Market. Based on this NEW information, answer the following questions:
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:Chapter 8. In Problem Set 6, we worked on a problem for Flor's Flours, a small business that produces two types of ready-to-use multigrain flours using organic products
such as bulgur wheat, garbanzos, and jasmine rice and sells them at a Farmer's Market every weekend. The first blend is called Pancake-Me and is priced at $6.50 per Ib.
and the second blend is called the Bake-Me and is priced at $4.50 per Ib. These healthier versions of the traditional flour used for cooking and baking are fairly popular
and Flor realizes that she needs to have a more formalized method of how to blend the flours if she hopes to minimize her costs and maximize her profits by continuing to
sell the flours on a larger scale. The costs of obtaining the components - bulgur wheat, garbanzos, and jasmine rice are different. After running the original model, Flor
found that she had more Jasmine rice left on hand than she really needed and made the following changes to her blends and bulk-grain purchases.
With a lot of painstaking trial-and-error, Flor updated some of the following guidelines to minimize any wasted product:
Pancake-Me Blend should have:
• At least 50% wheat
• At least 20% garbanzos
• At least 15% jasmine rice
Bake-Me Blend should have:
• At the most 60% wheat
• At least 25% garbanzos
• At the most 10% jasmine rice
Moreover, Flor now purchases 175 lbs. of bulgur wheat at $1.25 per Ib., 125 Ibs. of garbanzos at $0.87 per Ib. and 40 Ibs. of rice at $1.79 per Ib. for the next month's
production by ordering whole grains in bulk on the internet. She still needs to have at least 100 pounds of the Bake-Me blend available to cover the next month's demand
at the Farmer's Market. Based on this NEW information, answer the following questions:
Transcribed Image Text:1. Flor's new profit for the month would be $
(round to two decimal places)
2. Fill in the following table to show how much of each component Flor should use for each blend and what her total monthly production of each flour is (you can write
whole numbers):
Component
Wheat
Garbanzo
Rice
ТOTAL
Pancake-
Me
Bake-Me
ТОTAL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Maybe I'm missing something obvious but where are you getting the numbers for 150 pounds of wheat/100 pounds of garbanzo/75 pounds of rice can be obtained?
Solution
by Bartleby ExpertRecommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.