Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I add the excel file so that I can get help to this question??? Nash Auto has two plants, two warehouses, and three

How do I add the excel file so that I can get help to this question???

Nash Auto has two plants, two warehouses, and three customers. The plants are in Detroit and Atlanta, the warehouses are in Denver and New York, and the customers are in Los Angeles, Chicago, and Philadelphia. Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 800 cars per week, and Atlanta can produce 400 cars per week. Los Angeles requires 450 cars per week, Chicago requires 300, and Philadelphia requires 250. It costs $10,000 to produce a car at each plant. The costs of shipping a car between various cities are listed in the fileP05_56.xlsx. Assume that during a week, at most 250 cars can be shipped from a warehouse to any particular city. Determine how to meet Nash's weekly demands at minimum cost.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Law Principles For Today's Commercial Environment

Authors: David P Twomey, Marianne M Jennings

2nd Edition

0324303947, 9780324303940

More Books

Students also viewed these Economics questions