Find the optimal shipping strategy

Assignment Help Operation Management

Reference no: EM13106650

Company A has four plants locating in different cities across the region. There are three markets the company is selling its products to. Currently, each plant can only produce 500 units of products, and Market 1 needs 800 units of the product, Market 2 needs 500 units, while Market 3 needs 500 units. The shipping costs for Company A to ship one unit from each plant to different markets are listed in the following table. Unit Shipping Cost in $ Market 1 Market 2 Market 3 Plant 1 10 8 15 Plant 2 8 9 7 Plant 3 12 13 15 Plant 4 11 10 12 Please create and write down a standard/mathematical LP model and use Excel Solver to find the optimal shipping strategy for Company A, which minimize the total shipping costs.

Reference no: EM13106650

Questions Cloud

Explain why if a town needs jobs and increased tax revenue : explain why if a town needs jobs and increased tax revenue, is it not okay to seize property to create the same?

Question regarding z scores : Heights of Presidents. With a height of 67 in., William McKinley was the shortest president of the past century. The presidents of the past century have a mean height of 71.5 in. and a standard deviation of 2.1 in.

How personalities-identities formed in different cultures : Explain how personalities and identities are formed and shaped in the two different cultures? Write two specific examples from each of selected cultures.

Illustrate what are some of the challenges faced by marketer : Illustrate what are some of the challenges faced by marketers as they attempt to define their target markets? Explain how necessary is it to fine-tune your Marketing Plan so that your target market is clearly defined and measurable?

Find the optimal shipping strategy : Company A has four plants locating in different cities across the region. There are three markets the company is selling its products to. Currently, each plant can only produce 500 units of products, and Market 1 needs 800 units of the product.

Determining z test for proportion : A presidential candidate's aide estimates that, among all college students, the proportion p who intend to vote in the upcoming election is at least 60%.

Calculate excess reserves after the first round : Suppose that the currency drain ratio is 10 per cent of deposits and the desired reserve ratio is 1 per cent. If the Reserve Bank sells $100,000 of securities on the open market, calculate excess reserves after the first round. Calculate the money..

What is the index of refraction of the jelly : what is the index of refraction of the jelly? 2 glass plates are parallel and between is jelly 0.015mm thick. the glass has an index of refraction 1.53, the plates are each 8.00 cm long, 10 dark fringes are 6.33mm apart. wave length is 525nm .

Explain why you believe the individual is a visionary leader : Looking for papers similar to a biography that focuses on a balanced perspective of the characteristics, roles, traits and leadership style (behaviours) of any individual and justify explain why you believe the individual is a visionary leader.

User Account

All Pages