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 lb. and the second blend is called the Bake-Me and is priced at $4.50 per lb. 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 20% 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 lb., 125 lbs. of garbanzos at $0.87 per lb. and 40 lbs. of rice at $1.79 per lb. 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: Flor’s new profit for the month would be $________ (round to two decimal places) 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 TOTAL Pancake-Me ________ ________ _______ _______ Bake-Me _________ ________ _______ _______ TOTAL ________ _______ _______

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...
icon
Related questions
Question

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 lb. and the second blend is called the Bake-Me and is priced at $4.50 per lb. 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 20% 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 lb., 125 lbs. of garbanzos at $0.87 per lb. and 40 lbs. of rice at $1.79 per lb. 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:

  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

TOTAL

Pancake-Me

________

________

_______

_______

Bake-Me

_________

________

_______

_______

TOTAL

________

_______

_______

 

Expert Solution
Step 1 : Introduction

From the given data:

Let the decision variables be as shown below (all in lbs):

   Wheat   Garbanzo   Rice 
 Pancake-Me   X1 X2   X3 
 Bake-Me   y1   y2  y3
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.