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 =
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
4
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 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education