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

Other questions on the subject: Business

Business, 22.06.2019 07:30, cecem58

Net income and owner's equity for four businesses four different proprietorships, jupiter, mars, saturn, and venus, show the same balance sheet data at the beginning and end of a year. these data, exclusive of the amount of owner's equity, are summarized as follows: total assets total liabilities beginning of the year $550,000 $215,000 end of the year 844,000 320,000 on the basis of the preceding data and the following additional information for the year, determine the net income (or loss) of each company for the year. (hint: first determine the amount of increase or decrease in owner's equity during the year.) jupiter: the owner had made no additional investments in the business and had made no withdrawals from the business. mars: the owner had made no additional investments in the business but had withdrawn $36,000. saturn: the owner had made an additional investment of $60,000 but had made no withdrawals. venus: the owner had made an additional investment of $60,000 and had withdrawn $36,000. jupiter net income $ mars net income $ saturn net income $ venus net income $

Answers: 3

continue

Business, 22.06.2019 07:30, SophomoreSareke

Which of the following is an example of an unsought good? a. cameron purchases a new bike. b. jordan buys paper towels. c. taylor buys cupcakes from her favorite bakery. d. riley buys new windshield wipers for her car.

Answers: 3

continue

Business, 22.06.2019 12:50, trintrin227

Afirm’s production function is represented by q(m, r) = 4m 3/4r1/3, where q denotes output, m raw materials, and r robots. the firm is currently using 6 units of raw materials and 12 robots. according to the mrts, in order to maintain its output level the firm would need to give up 2 robots if it adds 9 units of raw materials. (a) true (b) false

Answers: 3

continue

Business, 22.06.2019 21:00, kebo63

After hearing a knock at your front door, you are surprised to see the prize patrol from a large, well-known magazine subscription company. it has arrived with the good news that you are the big winner, having won $21 million. you have three options.(a) receive $1.05 million per year for the next 20 years.(b) have $8.25 million today.(c) have $2.25 million today and receive $750,000 for each of the next 20 years. your financial adviser tells you that it is reasonable to expect to earn 13 percent on investments.

Answers: 3

continue

Do you know the correct answer?

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