Business, 25.02.2020 19:54 autumnsumrall

A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sent to regional distributors in Jacksonville, Boise, and Charlotte. The shipping costs vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers Jacksonville needs to receive 800 printers per month, Boise needs 600, and Charlotte needs 200 New Orleans has 750 printers available each month, Albuquerque has 550, and Nashville has 300 The shipping cost per unit from New Orleans to Jacksonville is $8, to Boise is $12, and to Charlotte is $10. Due to truck capacity limits, no more than 50 printers can be shipped between New Orleans and Charlotte each month. The cost per unit from Albuquerque to Jacksonville is $10, and to Charlotte is $9. Printers from Albuquerque are never ship The cost per unit from Nashville to Jacksonville is $11, to Boise is $8, and to Charlotte is $12. ped to Boise

(a) Formulate a linear optimization model to determine how many units should be shipped from each plant to each regional distribution center
(b) Is the capacity of the plants equal to the demand at the distribution centers?
(c) Enter your model in Excel and use Solver to find the optimal distribution plan. Include your spreadsheet in vour homework submission.
(d) What is the optimal distribution plan?
(e) What is the cost of the optimal distribution plan?

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 16:10

Braverman company has two manufacturing departments—finishing and fabrication. the predetermined overhead rates in finishing and fabrication are $18.00 per direct labor-hour and 110% of direct materials cost, respectively. the company’s direct labor wage rate is $16.00 per hour. the following information pertains to job 700: finishing fabrication direct materials $ 410 $ 60 direct labor $ 128 $ 48 required: 1. what is the total manufacturing cost assigned to job 700? 2. if job 700 consists of 15 units, what is the unit product cost for this job?

Answers: 1

Answer

Business, 22.06.2019 11:40

In each of the following, what happens to the unemployment rate? does the unemployment rate give an accurate impression of what’s happening in the labor market? a.esther lost her job and begins looking for a new one.b.sam, a steelworker who has been out of work since his mill closed last year, becomes discouraged and gives up looking for work.c.dan, the sole earner in his family of 5, just lost his $90,000 job as a research scientist. immediately, he takes a part-time job at starbucks until he can find another job in his field.

Answers: 2

Answer

Business, 22.06.2019 20:00

How many organs are supplied at a zero price? (b) how many people die in the government-regulated economy where the government-set price ceiling is p = 0? the quantity qd – qa. the quantity qe – qa. the quantity qd – qe. (c) how many people die in the market-driven economy?

Answers: 1

Answer

Business, 22.06.2019 22:50

Suppose that the u.s. dollars-mexican pesos exchange rate is fixed by the u.s. and mexican governments. assume also that labor is mobile between the united states and mexico due to low transportation costs.which of the following situations is likely to happen as a result of a simultaneous increase in the demand for u.s. goods and decrease in the demand for mexican goods? (pick mexican unemployment rate increases, and the country undergoes bad economic times for a sustained u.s. unemployment rate increases, and the country undergoes bad economic times for a sustained mexican unemployment rate rises at first, but it soon drops as unemployed mexicans move to the united states for mexican unemployment rate rises at first, but then it drops as mexican pesos depreciate against u.s. dollars.

Answers: 1

Answer

You know the right answer?

A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sen...

Questions