Chapter 9. Fresh Egg Delivery service brings fresh eggs from two different egg suppliers to two Farmer's Markets in the North San Antonio area. With the costs of fuel rising to $5 per mile driven by the delivery trucks, whether they are empty or loaded, the owner of Fresh Egg wants to make sure that he is minimizing his costs of transportation. The distance in miles from Egg Supplier A to the First Farmer's Market is 5 miles and to the Second Farmer's Market is 6 miles. The distance in miles from Egg Supplier B to the First Farmer's Market is 4 miles and to the Second Farmer's Market is 7 miles. The maximum number of truckloads that Egg Supplier A can provide is 20 truckloads per month, whereas Egg Supplier B can provide 30 truckloads a month. Both the Farmer's Markets have a steady demand of 25 truckloads per month, each. As we can see the total supply available is the same as the total demand available in this system, so applying a simple transportation model can help the Fresh Egg Delivery owner determine the lowest transportation cost solution. Based on this information, answer the following questions by creating a Linear Programming model, drawing the network diagram, and solving it using Solver in Excel (you can round all answers to a whole number): 1. The minimized value of the Total Costs of Transportation = $ 2. The number of truckloads going from Egg Supplier A to the First Farmer's Market = 3. The number of truckloads going from Egg Supplier A to the Second Farmer's Market = 4. The number of truckloads going from Egg Supplier B to the First Farmer's Market = 5. The number of truckloads going from Egg Supplier B to the Second Farmer's Market =
Chapter 9. Fresh Egg Delivery service brings fresh eggs from two different egg suppliers to two Farmer's Markets in the North San Antonio area. With the costs of fuel rising to $5 per mile driven by the delivery trucks, whether they are empty or loaded, the owner of Fresh Egg wants to make sure that he is minimizing his costs of transportation. The distance in miles from Egg Supplier A to the First Farmer's Market is 5 miles and to the Second Farmer's Market is 6 miles. The distance in miles from Egg Supplier B to the First Farmer's Market is 4 miles and to the Second Farmer's Market is 7 miles. The maximum number of truckloads that Egg Supplier A can provide is 20 truckloads per month, whereas Egg Supplier B can provide 30 truckloads a month. Both the Farmer's Markets have a steady demand of 25 truckloads per month, each. As we can see the total supply available is the same as the total demand available in this system, so applying a simple transportation model can help the Fresh Egg Delivery owner determine the lowest transportation cost solution. Based on this information, answer the following questions by creating a Linear Programming model, drawing the network diagram, and solving it using Solver in Excel (you can round all answers to a whole number): 1. The minimized value of the Total Costs of Transportation = $ 2. The number of truckloads going from Egg Supplier A to the First Farmer's Market = 3. The number of truckloads going from Egg Supplier A to the Second Farmer's Market = 4. The number of truckloads going from Egg Supplier B to the First Farmer's Market = 5. The number of truckloads going from Egg Supplier B to the Second Farmer's Market =
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:Notice that the original PERT/CPM model you created will work for this problem since the order of the activities has not changed. Create a Crashing Model and answer
the following questions:
1. Jeanie's total cost of crashing is $
2. The activities that Jeanie needs to crash are:
1.
by
hours
2.
by
hours
3.
by
hours
4.
hours
by
Transcribed Image Text:Chapter 9. Fresh Egg Delivery service brings fresh eggs from two different egg suppliers to two Farmer's Markets in the North San Antonio area. With the costs of fuel
rising to $5 per mile driven by the delivery trucks, whether they are empty or loaded, the owner of Fresh Egg wants to make sure that he is minimizing his costs of
transportation. The distance in miles from Egg Supplier A to the First Farmer's Market is 5 miles and to the Second Farmer's Market is 6 miles. The distance in miles from
Egg Supplier B to the First Farmer's Market is 4 miles and to the Second Farmer's Market is 7 miles. The maximum number of truckloads that Egg Supplier A can provide is
20 truckloads per month, whereas Egg Supplier B can provide 30 truckloads a month. Both the Farmer's Markets have a steady demand of 25 truckloads per month, each.
As we can see the total supply available is the same as the total demand available in this system, so applying a simple transportation model can help the Fresh Egg
Delivery owner determine the lowest transportation cost solution. Based on this information, answer the following questions by creating a Linear Programming model,
drawing the network diagram, and solving it using Solver in Excel (you can round all answers to a whole number):
1. The minimized value of the Total Costs of Transportation = $
2. The number of truckloads going from Egg Supplier A to the First Farmer's Market =
3. The number of truckloads going from Egg Supplier A to the Second Farmer's Market =
4. The number of truckloads going from Egg Supplier B to the First Farmer's Market =
5. The number of truckloads going from Egg Supplier B to the Second Farmer's Market =
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 8 images
Recommended 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.