Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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...
See similar textbooks
icon
Related questions
Question
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 =
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
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.
SEE MORE TEXTBOOKS