subject
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?

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 11:30
Amano s preguntes cationing to come fonds and consumer good 8. why did the u.s. government use rationing for some foods and consumer goods during world war ii?
Answers: 1
question
Business, 22.06.2019 12:30
Sales at a fast-food restaurant average $6,000 per day. the restaurant decided to introduce an advertising campaign to increase daily sales. to determine the effectiveness of the advertising campaign, a sample of 49 days of sales were taken. they found that the average daily sales were $6,300 per day. from past history, the restaurant knew that its population standard deviation is about $1,000. if the level of significance is 0.01, have sales increased as a result of the advertising campaign? multiple choicea)fail to reject the null hypothesis.b)reject the null hypothesis and conclude the mean is higher than $6,000 per day.c)reject the null hypothesis and conclude the mean is lower than $6,000 per day.d)reject the null hypothesis and conclude that the mean is equal to $6,000 per day.expert answer
Answers: 3
question
Business, 22.06.2019 13:20
In order to be thoughtful about the implementation of security policies and controls, leaders must balance the need to reduce with the impact to the business operations. doing so could mean phasing security controls in over time or be as simple as aligning security implementation with the business’s training events.
Answers: 3
question
Business, 22.06.2019 23:50
When a market is in equilibrium, the buyers are those with the willingness to pay and the sellers are those with the costs.
Answers: 2
You know the right answer?
A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sen...
Questions
question
Chemistry, 20.07.2019 17:10
question
Social Studies, 20.07.2019 17:10
Questions on the website: 13722361