Outtel manufactures tablet computers. These tablet computers are manufactured in Seattle, Columbus, and New York and...

Outtel manufactures tablet computers. These tablet computers are manufactured in Seattle, Columbus, and New York and shipped to retail stores in Pittsburgh, Austin, Denver, Los Angeles and Washington D.C. These retail stores require 420, 290, 320, 510, and 370 tablet computers, respectively. Seattle plant can manufacture up to 720 tablet computers. Columbus plant can manufacture up to 670 tablet computers, and New York plant can manufacture up to 590 tablet computers. Shipping costs per tablet computer between plants and retail stores are given in the following table: Retail Store Plant Pittsburgh Austin Denver Los Angeles Washington Seattle $10.5 $12.6 $7.2 $6.4 $9.8 Columbus $3.6 $18.1 $9.6 $10.6 $5.7 New York $2.9 $17.5 $10.1 $12.4 $3.2 a) Develop a network representation of this problem. b) Formulate a linear programming model that can be used to determine the amount that should be shipped from each plant to each retail store to minimize the total cost. (Write the complete model for the problem. Make sure to give clear definitions of your decision variables). c) Solve the problem by using Excel Solver (Hand-in the one-page value and one-page formulas printouts for the problem).

Solutions

Expert Solution

b) Decision variables

XSP = units shipped from Seattle to Pittsburgh

XSA = units shipped from Seattle to Austin

XSD = units shipped from Seattle to Denver

XSL = units shipped from Seattle to LosAngeles

XSW = units shipped from Seattle to Washington DC

XCP = units shipped from Columbus to Pittsburgh

XCA = units shipped from Columbus to Austin

XCD = units shipped from Columbus to Denver

XCL = units shipped from Columbus to LosAngeles

XCW = units shipped from Columbus to Washington DC

XNP = units shipped from NewYork to Pittsburgh

XNA = units shipped from NewYork to Austin

XND = units shipped from NewYork to Denver

XNL = units shipped from NewYork to LosAngeles

XNW = units shipped from NewYork to Washington DC

Objective function: Minimize the total cost of shipping

Suject to supply constrains of plants, demand constraints of retail stores and non-negativity contraints

keosha answered 1 week ago

Next > < Previous

Related Solutions

It is believed that the mean flight time from Seattle to New York City is 310...

It is believed that the mean flight time from Seattle to New York City is 310 minutes. You want to test to determine if it is different from this. The population standard deviation is 10 minutes. You randomly sample 50 flights and the sample average is 313 minutes. State your hypotheses, calculate and state the test statistic, calculate and state the p-value, state whether you reject the Ho or fail to reject the Ho, and state your final conclusion (i.e....

Tablet computers are rapidly becoming more mainstream and replacing traditional desktop and laptop computers with the...

Tablet computers are rapidly becoming more mainstream and replacing traditional desktop and laptop computers with the first IPAD becoming available in 2010 and an assortment of Linux and Windows-based tablets following. How do you believe that tablet computers have changed or contributed to the ways Forensic Scientists have to think or function on a daily basis? Do you believe that tablet computers have made a Forensic Scientist's job easier or harder? Can you think of any other technologies that have...

Tablet PC Comparison provides a wide variety of information about tablet computers. The company’s website enables...

Tablet PC Comparison provides a wide variety of information about tablet computers. The company’s website enables consumers to easily compare different tablets using factors such as cost, type of operating system, display size, battery life, and CPU manufacturer. A sample of 8 tablet computers is shown in the table below. Tablet Cost ($) Operating System Display Size (inches) Battery Life (hours) CPU Manufacturer Acer Iconia W510 599 Windows 10.1 8.5 Intel Amazon Kindle Fire HD 299 Android 8.9 9 TI...

In your view, are smartphones a closer substitute for tablet computers, such as the iPad, or...

In your view, are smartphones a closer substitute for tablet computers, such as the iPad, or for e-readers, such as the Kindle? Explain your position and share with the group if you think there is even better technology on the horizon that incorporates the best of both features.

First, identify a manufactured product such as a car, a desktop computer, a tablet… and describe...

First, identify a manufactured product such as a car, a desktop computer, a tablet… and describe the different stages of the value chain for this product. Second, identify a company that sells the product you chose To what extent is the company vertically integrated? What are the advantages and disadvantages of vertical integration for this company?

First, identify a manufactured product such as a car, a desktop computer, a tablet… and describe...

First, identify a manufactured product such as a car, a desktop computer, a tablet… and describe the different stages of the value chain for this product. Second, identify a company that sells the product you chose. To what extent is the company vertically integrated? What are the advantages and disadvantages of vertical integration for this company? I chose: Desktop Computer

In the market for tablet computers, more suppliers enter the market and the price of laptops,...

In the market for tablet computers, more suppliers enter the market and the price of laptops, a substitute good, increases, while all other factors remain constant. Explain the change(s) in the equilibrium price and quantity.

Small, energy-efficient, Internet-centric, new computers are increasingly gaining popularity (The New York Times, July 20, 2008)....

Small, energy-efficient, Internet-centric, new computers are increasingly gaining popularity (The New York Times, July 20, 2008). Some of the biggest companies are wary of the new breed of computers because their low price could threaten PC makers’ already thin profit margins. An analyst comments that the larger companies have a cause for concern since the mean price of these small computers has fallen below $350. She examines six popular brands of these small computers and records their retail prices as:...

Auto Inc. (Auto) is a company based in New York that manufactures automobiles and exports the...

Auto Inc. (Auto) is a company based in New York that manufactures automobiles and exports the finished vehicles to Europe. Auto manufactures two models; the most popular model is a four-door sedan (Sedan), and the other is a less common, highly customizable luxury sports car (Luxury Car). Auto contracts Trans-Atlantic Inc. (Atlantic) to ship its products to Europe. Atlantic has a fleet of 10 multi-use shipping vessels, each with capacity for 2,000 vehicles. The terms of the shipping contracts are...

Auto Inc. (Auto) is a company based in New York that manufactures automobiles and exports the...

Subjects