The A&B Supermarkets have 3 warehouses A, B, and C, that ships supplies to their 23...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The A&B Supermarkets have 3 warehouses A, B, and C, that ships supplies to their 23 stores. Their costs of shipping per unit are given below: 1 2 3 A 14 12 в 11 8 12 13 10 12 The capacities of A, B, and C are 240, 360, and 200 units, respectively, while the demands of stores 1, 2, and 3 are 400, 250, and 150, respectively. [Notice that the supplies = demands!] a) Formulate the transportation problem to minimize total cost for shipping. Please provide the actual shipping schedule derived from Solver. b) If the shipping routes can be changed so that the supplies can be transshipped from warehouse to warehouse, market to market, and even market to warehouse, would you recommend a new set of shipping routes given the following per unit cost shipping data: A 1 2 3 A 51 14 12 9 B 1 2 11 8 12 2 13 10 12 1 14 11 13 4 3 12 8 10 4 2 3 9. 12 12 3 2 What would be the new shipping routes and quantities? How are these different from those of The A&B Supermarkets have 3 warehouses A, B, and C, that ships supplies to their 23 stores. Their costs of shipping per unit are given below: 1 2 3 A 14 12 в 11 8 12 13 10 12 The capacities of A, B, and C are 240, 360, and 200 units, respectively, while the demands of stores 1, 2, and 3 are 400, 250, and 150, respectively. [Notice that the supplies = demands!] a) Formulate the transportation problem to minimize total cost for shipping. Please provide the actual shipping schedule derived from Solver. b) If the shipping routes can be changed so that the supplies can be transshipped from warehouse to warehouse, market to market, and even market to warehouse, would you recommend a new set of shipping routes given the following per unit cost shipping data: A 1 2 3 A 51 14 12 9 B 1 2 11 8 12 2 13 10 12 1 14 11 13 4 3 12 8 10 4 2 3 9. 12 12 3 2 What would be the new shipping routes and quantities? How are these different from those of
Expert Answer:
Answer rating: 100% (QA)
EXCEL FORMULAS Optimal shipping plan From To 1 2 3 Sent A 90 0 150 SUMB10D10 B 110 250 0 SUMB11D11 C ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The two vectors A and B are drawn from a common point, and C = 1 + B. (a) Show that if C2 = A2 + B2, the angle between the vectors A and B is 90. (b) Show that if C2 < A2 + B2, the angle between the...
-
If two m n matrices A and B are close in the sense that ||A - B||2 < for some small positive number6, then their pseudoinverses will also be close; that is, ||A+ - B+||2 < , for some small positive...
-
A and B are partners in an equal general partnership. A has a basis of $30,000 in his partnership interest. B has a basis of $10,000 in her partnership interest. What is the effect of each of the...
-
Mr. D. Duck, a sole trader has not maintained proper accounting records during the year. He provides you with bank statements that show payments to suppliers of 86,167. You determine that the opening...
-
(a) Use trigonometric substitution to show that dx/(x2+a2) = ln(x+(x2+a2) + C (b) Use the hyperbolic substitution to show that dx/(x2 + a2) = sinh-1(x/a) + C These formulas are connected by formula...
-
The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are...
-
Sometimes people who act inappropriately are just trying to save their jobs and the company. How do you feel about those types of persons?
-
Optix Camera Shop uses the lower-of-cost-or-market basis for its inventory. The following data are available at December 31. Instructions Determine the amount of the ending inventory by applying the...
-
On a private flight with capacity for 150 people, $800,000 per person is charged, plus $25,000 for each unsold seat on the plane. How many people must travel on the plane and what will be the price...
-
A bale of cotton tipped the scales at around 500 pounds was about the size of a large suitcase was the amount of picked cotton each slave was expected to produce weekly was equivalent to about six...
-
Using the RFP Analysis Template, you will write an analysis on the selected IT RFP's. You will create a document with the following information: Title Page Table of Contents Sections as listed below...
-
Explain how an effective performance management system along with compensation and benefits can attract, develop and retain talented employees. Discuss labor and employment laws and regulations that...
-
You have been asked to send an email to Stacey Mintern. The email contained some background notes attached about an important meeting she has scheduled for tomorrow with the other departments. You...
-
A firm that is currently locating facilities in a large number of other countries in order to capitalize on lower production and distribution costs is at what level of global participation?...
-
Describe the legal, social, and psychological employment contracts in organisations. Citing examples, explain why it is important for HRM to manage each of these three contracts at the workplace....
-
What special compensation and benefits issues arise in international HRM ?
-
Actual investment equals planned investment: O times unplanned investment minus inventory investment. plus unplanned investment. Ominus unplanned investment. plus unplanned investment plus inventory...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
Based on the data for the years 1962 to 1977 for the United States, Dale Bails and Larry Peppers obtained the following demand function for automobiles: t = 5807 + 3.24Xt r2 = 0.22 se = (1.634) where...
-
Show that E(X - k)2 = var (X) + [E(X) - k]2. For what value of k will E(X - k)2 be minimum? And what is that value of k?
-
What is meant by the moments of a PDF? What are the most frequently used moments?
-
You are studying survival times for mice given a drug at one of three doses (Low, Medium, or High). You define two dummy variables: (a) With these definitions, write the expressions for the mean...
-
The data in Table 8.25 were collected in order to study factors affecting the supply and demand for commercial air travel. Data on various aspects of commercial air travel for an arbitrarily chosen...
-
It is beneficial to be able to estimate the yield of useful product of a tree based on measurements of the tree taken before it is harvested. Measurements on four such variables were taken on a...
Study smarter with the SolutionInn App