Answered: Fairway Inc. makes custom golf clubs.…

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

Related questions

Concept explainers

Question

Fairway Inc. makes custom golf clubs. They are manufactured in 3 plants in Denver, Phoenix, and Dallas. They are then shipped to distribution centers in Sacramento, Salt Lake, Chicago, Albuquerque, and New York. Since shipping costs are a major expense, management requires an analysis to determine the optimal shipping routes and quantities shipped along those routes. Each plant has a maximum production capacity and each distribution center has a demand that must be satisfied. You must determine how many clubs to send along each route, staying within plant capacity, meeting demand, for the lowest total shipping cost.

Shipping Costs per route
Plants	Sacramento	Salt Lake	Chicago	Albeq	New York	Capacity
Denver	$10	$8	$6	$5	$4	310
Phoenix	$6	$5	$4	$3	$6	260
Dallas	$3	$4	$5	$5	$9	280
Demand	180	80	200	160	220

	Number to ship from plant to warehouse:
Plants	Sacramento	Salt Lake	Chicago	Albeq	New York	Total Shipped
Denver
Phoenix
Dallas
Total Received:

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions