Question

In: Statistics and Probability

Drew Rosen Corp owns factories in three towns, which distribute to three retail locations. The following...

Drew Rosen Corp owns factories in three towns, which distribute to three retail locations. The following table summarizes factory availabilities, projected store demands, and unit shipping costs. What is the resultant lowest dollar cost.

Decatur Minneapolis Carbondale Dummy Supply
Blue Earth 20 17 21 250
Ciro 25 27 20 200
Des Moines 22 25 22 350
Demand 300 200 150 150 800 \ 800
Shipments
Decatur Minneapolis Carbondale Dummy Row Total
Blue Earth
Ciro
Des Moines
Totals 0 \ 0

a. 17500

b. 14687

c. 15262

d. 12900

Solutions

Expert Solution

Answer: 12900

Using Excel<data<solver


Related Solutions

A company has three factories in different locations. The disposal values of the factories are zero....
A company has three factories in different locations. The disposal values of the factories are zero. The following information has been provided for each factory: Factory                                                   A                  B                     C                                                               £m                £m                £m Initial investment                                    40                 70                     100 Operating profit of factories before depreciation per annum: Year 1                                                    20                 20                     60 Year 2                                                    20                 20                     20 Year 3                                                    2                   20                     10 Year 4                                                    0                   37                   15 Depreciation is based on the straight-line method. The cost...
Molly’s Home Cooking, a regional restaurant with locations in three small Southern towns, one of which...
Molly’s Home Cooking, a regional restaurant with locations in three small Southern towns, one of which is a college town, specializes in comfort foods and regional specialties. Two of the restaurants have been open for over five years. The Molly’s located in the college town opened in May 2018. The restaurants are either freestanding near other businesses or in a strip shopping/eating area. With a menu consisting of all fresh, cooked-to-order foods, Molly’s features different items daily and serves traditional...
1) Baltimore Furniture Inc. owns two factories, each of which produces three types of tables –...
1) Baltimore Furniture Inc. owns two factories, each of which produces three types of tables – the deluxe, medium and the standard. The company has a contract to supply tables to a newly built hotel in downtown Washington DC comprising of at least 12 deluxe tables, 8 medium tables and 24 standard tables. Each factory produces a certain number of tables during each hour it operates. Factory 1 produces 6 deluxe tables and 2 medium tables. Factory 2 produces 2...
A small businessman is planning on opening a new retail location. Three locations are available, and...
A small businessman is planning on opening a new retail location. Three locations are available, and he is interested in the annual income of families near each location. A random sample of 4 families is selected near each location, and the results are shown below (in thousands of dollars). Use this data to test the hypothesis that mean income is the same in all three areas. Location 1 Location 2 Location 3 66 65 71 65 69 72 66 63...
Suppose there are three factories in Macroland and the following occurred in 2019: Metal, plastic and...
Suppose there are three factories in Macroland and the following occurred in 2019: Metal, plastic and a car factory. Metal factory produces $200, plastic factory produces $500, and car factory produces $700, of its respective products. The metal factory sells all of its output to the car factory. The plastic factory sells $80 worth of plastic to the car factory, $20 to the government, and the rest to consumers. The Car factory exports $50 of its cars and sells the...
A particular mattress company has three factories (1,2,3), each of which produces three types of mattresses:...
A particular mattress company has three factories (1,2,3), each of which produces three types of mattresses: (1) spring, (2) foam, and (3) hybrid. In the matrix ? = [ 80 50 25 45 110 60] ??? represents the number of mattresses of type ? produced at factory ? in one day. Find the production levels if production increases by 15%.
The following is an Excel Question: We have three factories (A, B, C) and five distributors...
The following is an Excel Question: We have three factories (A, B, C) and five distributors (P, Q, R, S, T) of our products. The products are shipped by truck from factory to distributor. At most 180 units of our products fit a truck. The shipping cost is $1 per unit to load the truck and $1 per unit to unload the truck plus the mileage cost. The mileage cost is based on the mileage the truck must travel between...
The following is an Excel question: We have three factories (A, B, C) and five distributors...
The following is an Excel question: We have three factories (A, B, C) and five distributors (P, Q, R, S, T) of our products. The products are shipped by truck from factory to distributor. At most 180 units of our products fit a truck. The shipping cost is $1 per unit to load the truck and $1 per unit to unload the truck plus the mileage cost. The mileage cost is based on the mileage the truck must travel between...
In which of the following locations are you UNLIKELY to find a serous membrane?
In which of the following locations are you UNLIKELY to find a serous membrane?lining the heartlining the lungslining the nasal passageslining the abdominal cavity
Austin owns 100% of the stock of MoJo Corp., which is a calendar year S corporation....
Austin owns 100% of the stock of MoJo Corp., which is a calendar year S corporation. MoJo has been an S corp for 12 years, but was a C corp prior to that. At the beginning of 20x1, MoJo has an Accumulated Adjustments Account of $200,000 and Accumulated Earnings and Profits from C-Corp years of $500,000. Austin has a stock basis of $300,000 on January 1, 20x1. MoJo has income of $0 in 20x1 ignoring any effect of distributions. MoJo...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT