Business, 03.03.2020 01:32 mathman783

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 750 printers per month, Boise needs 650, and Charlotte needs 250. New Orleans has 800 printers available each month, Albuquerque has 500, and Nashville has 350.
The shipping cost per unit from New Orleans to Jacksonville is $8, to Boise is $12, and to Charlotte is $7. Due to truck capacity limits, no more than 100 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 shipped to Boise. The cost per unit from Nashville to Jacksonville is $11, to Boise is $9, and to Charlotte is $12.
(a) Formulate a linear optimization model to determine how many units should be shipped from each plant to each regional distribution center.
Decision Variables:
Objective Function:
Constraints:
Capacity Constraints:
Demand Constraints:
Non-Negativity Constraints:
(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 with your homework submission.
(d) What is the optimal distribution plan?
(e) What is the cost of the optimal distribution plan?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 07:00

For the past six years, the price of slippery rock stock has been increasing at a rate of 8.21 percent a year. currently, the stock is priced at $43.40 a share and has a required return of 11.65 percent. what is the dividend yield? 3.20 percent 2.75 percent 3.69 percent

Answers: 3

Answer

Business, 22.06.2019 18:20

Principals are an administration career

Answers: 2

Answer

Business, 22.06.2019 21:00

Sue peters is the controller at vroom, a car dealership. dale miller recently has been hired as the bookkeeper. dale wanted to attend a class in excel spreadsheets, so sue temporarily took over dale's duties, including overseeing a fund used for gas purchases before test drives. sue found a shortage in the fund and confronted dale when he returned to work. dale admitted that he occasionally uses the fund to pay for his own gas. sue estimated the shortage at $450. what should sue do?

Answers: 3

Answer

Business, 22.06.2019 21:00

Which of the following statements is correct? stockholders should generally be happier than bondholders to have managers invest in risky projects with high potential returns as opposed to safe projects with lower expected returns. potential conflicts between stockholders and bondholders are increased if a firm's bonds are convertible into its common stock. takeovers are most likely to be attempted if the target firm’s stock price is above its intrinsic value. one advantage of operating a business as a corporation is that stockholders can deduct their pro rata share of the taxes the firm pays, thereby eliminating the double taxation investors would face in a partnership.

Answers: 1

Answer

You know the right answer?

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

Questions