Laptops R Us manufactures laptops France, Spain, and Denmark. They only partial build the laptops in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Laptops R Us manufactures laptops France, Spain, and Denmark. They only partial build the laptops in Europe and then ship the partially completed laptops to Brazil, Costa Rica, and Peru and have them completed before final shipment to the U.S. distributors in Alabama, Maryland, and Illinois. The available supply from the European plants and the demand of the U.S, distributors States as follows: Demand (units) European Plant France Spain Denmark Supply (units) 550 680 490 European Plant France Spain Denmark The unit costs of shipping partially completed laptops to the plants in South and Central America for finishing before sending them to the United States are as follows: Factory Brazil Costa Rica Peru Brazil $280 180 200 U.S. Distributor Alabama Maryland Illinois Alabama $160 The unit costs of shipping completed laptops from the plants in South and Central America to the United States are as follows: 120 180 Factory Costa Rica $240 220 180 450 500 580 U.S. Distributor Maryland $140 160 140 Peru $220 200 170 Illinois $180 140 160 Formulate this problem in Excel and solve to determine the optimal shipment of laptops that will meet the demand at the U.S. Distributors at the minimum total cost. SOLUTION: The optimal solution, the value of the cost, should be $509,400. This is a transshipment problem. (Hint: count the supply available at the European countries and compare them to the demand needed at the distribution centers to determine which location (European country or U.S. Distributor) will have the inequality). Questions a) Which European country did not ship out all its supply? b) Did any U.S. distributor receive shipment from more than one plant in South and Central America? Explain. c) Did any plant in South and Central America receive shipments from more than European country? Explain. Laptops R Us manufactures laptops France, Spain, and Denmark. They only partial build the laptops in Europe and then ship the partially completed laptops to Brazil, Costa Rica, and Peru and have them completed before final shipment to the U.S. distributors in Alabama, Maryland, and Illinois. The available supply from the European plants and the demand of the U.S, distributors States as follows: Demand (units) European Plant France Spain Denmark Supply (units) 550 680 490 European Plant France Spain Denmark The unit costs of shipping partially completed laptops to the plants in South and Central America for finishing before sending them to the United States are as follows: Factory Brazil Costa Rica Peru Brazil $280 180 200 U.S. Distributor Alabama Maryland Illinois Alabama $160 The unit costs of shipping completed laptops from the plants in South and Central America to the United States are as follows: 120 180 Factory Costa Rica $240 220 180 450 500 580 U.S. Distributor Maryland $140 160 140 Peru $220 200 170 Illinois $180 140 160 Formulate this problem in Excel and solve to determine the optimal shipment of laptops that will meet the demand at the U.S. Distributors at the minimum total cost. SOLUTION: The optimal solution, the value of the cost, should be $509,400. This is a transshipment problem. (Hint: count the supply available at the European countries and compare them to the demand needed at the distribution centers to determine which location (European country or U.S. Distributor) will have the inequality). Questions a) Which European country did not ship out all its supply? b) Did any U.S. distributor receive shipment from more than one plant in South and Central America? Explain. c) Did any plant in South and Central America receive shipments from more than European country? Explain.
Expert Answer:
Answer rating: 100% (QA)
ANSWER a Spain did not ship out all of its supply b Yes Illinois received shipments from ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
The Republic of Costa Rica began proceedings against the Republic of Nicaragua for its alleged military invasion and occupation of Costa Rican territory, during which it dug a channel in and dredged...
-
The United States and Brazil each produce only cheese and wine. Domestic prices are given in the following table: On April 1, the London exchange listed an exchange rate of $1 = 1BRL. a. Which...
-
Alabama was one of only sixteen states that permitted commercial hazardous waste landfills. From 1985 through 1989, the tonnage of hazardous waste received per year more than doubled. Of this, up to...
-
Please refer to the instructions and the table in this question. Enter the correct journal entry for part [A] in the following Balance Sheet and Income Statement for 20X1 and 20X2. Note that for the...
-
What strategic role does operations management play?
-
Wofford Company had net sales of $150,000 in its first year and $187,500 in its second year. Calculate the amount of change in terms of both dollars and percentage.
-
Suppose that you need to travel by air from Miami (MIA) to Orlando (MCO) and you were restricted to flights represented on the graph. For the trip to Orlando, you decide to purchase tickets with a...
-
Bryce Power Tool Company Kevin Ertle is the director of information technology (IT) for the Bryce Power Tool Company. A decision was made recently to upgrade Bryces legacy systems to a comprehensive...
-
The wholesale price p of e-tablet writing styluses in dollars is related to the supply x in thousands of units by 300p^2- x^2= 14675. If 5,000 styluses are available at the beginning of a week, and...
-
Golden Wedding Dress Company designs custom wedding dresses for brides to be. The person preparing the adjusting entries at year-end was unable to complete the adjustments due to illness. You have...
-
1. uzdevums (3 punkti Dots konuss Ieraksttrksto nosaukumuai apzmjumu Konusa elementa nosaukums Veidule Konusa elementa apzmjumattl AO AABM 2. uzdevums(5 punkti Cilindraksillumar taisnstrikuramalasir...
-
You can express any logic function f as f(x,y,z,...)=x f(x=1, y, z, ...) + x' f(x=0, y, z, ...). This is called Shannon's Expansion. = For example, f(w1, W2, W3, W) = W (W) + Wf (w), where (w ) =...
-
= The Generic 501(c)(3) Fund had revenue from contributions = $500,000, administrative expense = $125,000 program service expenses = $360,000 paid interest of $10,000 and had an increase in net...
-
A wire coil of 35 turns has a cross-sectional area of 10 cm 2 . The coil is placed in a uniform field of a large magnet with B = 0.42 T. The coil is suddenly rotated 90 o from an orientation parallel...
-
A subject weighing 162 lbs wants to lose of her weight. If shewere to exercise for a total of 4 hours every week at an intensityof 31.4 mLkg -1 min -1 , how many weeks wouldit take her to lose this...
-
what ways can ecosystem services be quantitatively valued, and what are the implications of this valuation for environmental policy ?
-
Graph the following quadratic function.f(x)=x-9Find the vertex of the function.The vertex is(Simplify your answer. Type an ordered pair.)
-
Consider the following cash flows in Table P5.5. (a) Calculate the payback period for each project. (b) Determine whether it is meaningful to calculate a payback period for project D. (c) Assuming...
-
Ben Cheery, the Sox general manager, wants to sign at least one free agent player for the coming baseball season. He is considering four players-Joe Aaron, Mike Bass, Carlos Cabrera, and Josh Donald....
-
Katnis Evergreen, a junior at Tech, is moving out of the dorms where she has lived for 2 years into an apartment in town. She is considering three apartment complexes-the Terraces, the Vistas, and...
-
If the maximum operating capacity of the Rolling Creek Textile Mill described in Problem 3 is 25,000 yards of denim per month, determine the break-even volume as a percentage of capacity.
-
In making short-term special decisions, you should a. focus on total costs b. separate variable from fixed costs c. use a traditional absorption costing approach d. focus only on quantitative factors
-
Assume the value of an unlevered firm is $10,000,000. The tax rate is .35. What is the maximum amount of debt that can be issued in substitution for equity if the $10,000,000 is an accurate measure?...
-
Change the cost of debt of problem 3b. to .10. Recompute the investor's return if the firm earns $2,000 EBIT.
Study smarter with the SolutionInn App