Question

Offered Price $ 10.00

You have been asked to design a network whereby 3 plants in Madrid

Question # 00008763
Subject: General Questions
Topic: General General Questions
Due on: 02/28/2014
Posted On: 02/20/2014 07:40 AM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
75
Tutorials:
189
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question
1) You have been asked to design a network whereby 3 plants in Madrid, Milan, and Warsaw serve 5 customer cities-London, Stockholm, Paris, Rome, and Istanbul. The demands of each city are shown in the Question 1 tab, as are the production and distribution costs as well as the fixed cost associated with each installation. You must do the following

a) Insert the correct cost formulas for fixed, variable, and total cost (30 points)
b) Put in the necessary constraints (30 points)
c) Determine the lowest cost network that will fulfill customer demand and lowest total cost. (20 points)

Your answer should be on the Question 1 tab of the spreadsheet with the Solver model that allowed you to compute the lowest cost network after you have executed Solver so that the spreadsheet displays your answer to part c.
Tutorials for this Question
Available for
$ 8.00

design a network whereby 3 plants in Madrid

Tutorial # 00008384
Posted On: 02/20/2014 07:42 AM
Posted By:
Best Tutors for school students, college students koolmind
Expert tutors with experiences and qualities
Questions:
75
Tutorials:
189
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview … n…
Attachments
design_a_network_.xlsx (11.72 KB)
Preview: cities-London, Stockholm, Paris, Rome, and I.....
Purchase this Tutorial @ $8.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
List of Main Subjects
Accounting
Anthropology
Architecture
Art
Asian Studies
Astronomy
Biology
Business
Chemistry
Communications
Computer Science
Economics
Education
Engineering
English
Finance
Foreign Languages
Gender Studies
General Questions
Geography
Geology
Health Care
History
Kindergarten
Law
Linguistics
Literary Studies
Marketing
Mathematics
Music
Nursing
Performing Arts
Philosophy
Physics
Political Science
Psychology
Religious Studies
Sociology
Statistics
Urban Planning and Policy
View all subjects...
Loading...