Supply and demand decision


Supply and Demand Decision:

Several companies use warehouse inventory to stock company stores to serve the buyers. Shipping fees are a significant cost to the company. Ample Computers has warehouses in Chicago, New York, and San Diego. The firm owns company-owned, retail stores in Houston, Indianapolis, and Miami. Each warehouse has 3,000 computers in inventory. The demand for computers at the store in Miami is 2,500 or more. Indianapolis needs at least 2,500 computers, and a minimum of 4,000 computers has been requested at the Houston store.

Below are the shipping costs for each computer shipped from each warehouse to each company-owned, retail store.

Warehouse    Houston Store    Indianapolis Store    Miami Store
Chicago              $1.20                  $0.60                  $0.50
New York            $2.00                  $1.10                  $0.90
San Diego           $3.00                  $2.60                  $2.80

To minimize the shipping costs, how many computers should be shipped from each warehouse to each company-owned, retail store?

What is the correct method to set up this problem in excel solver?

Solution Preview :

Prepared by a verified Expert
Microeconomics: Supply and demand decision
Reference No:- TGS01739901

Now Priced at $25 (50% Discount)

Recommended (99%)

Rated (4.3/5)