The PipeWell Company produces a particular electronic device for pipeline projects at two plants in Dublin and Casablanca. After production, the products are first shipped to warehouses located in Baku and Bologna then delivered to the customers in Dubai, Moscow, and Istanbul, hence, all arcs are one- directional, from the plants to the warehouses, and from the warehouses to the customers. The following figure is a network representation of the logistics structure. The numbers on arcs represent the unit cost of shipment of a product between the corresponding nodes. The monthly capacities of the plants (300,100) and the demands of the customers (150,100,150) are also shown next to the related nodes. Any number of products can be shipped between nodes. Build an appropriate LP model to find a shipment plan that minimizes total cost of shipment for this company. Do not forget to write the necessary definitions (i.e. variables) related to your model. Solve the model, and answer the following questions. 150 300 Duba Dublin Bologna 100 Moscow 100 2 Cautlanca 150 stanbu Answer the following questions based on the data represented in the sensitivity report:

The PipeWell Company produces a particular electronic device for pipeline projects at two plants in Dublin and Casablanca. After production, the products are first shipped to warehouses located in Baku and Bologna then delivered to the customers in Dubai, Moscow, and Istanbul, hence, all arcs are one- directional, from the plants to the warehouses, and from the warehouses to the customers. The following figure is a network representation of the logistics structure. The numbers on arcs represent the unit cost of shipment of a product between the corresponding nodes. The monthly capacities of the plants (300,100) and the demands of the customers (150,100,150) are also shown next to the related nodes. Any number of products can be shipped between nodes. Build an appropriate LP model to find a shipment plan that minimizes total cost of shipment for this company. Do not forget to write the necessary definitions (i.e. variables) related to your model. Solve the model, and answer the following questions. 150 300 Duba Dublin Bologna 100 Moscow 100 2 Cautlanca 150 stanbu Answer the following questions based on the data represented in the sensitivity report:

Name: I need the excel model and lp modelMy Lecture: Management Science The
Uploaded: 2024-03-20T06:38:44.000Z
Channel: Bartleby
Description: I need the excel model and lp modelMy Lecture: Management Science The PipeWell Company produces a particular electronic device for pipeline projects at two plants inDublin and Casablanca. After production, the products are first shipped to warehouses

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Related questions

Q: How does the number of attributes of a variable impact the number of cells in the cross-tabulation…

A: A cross-tabulation is a two- (or more) dimensional table that records the number (frequency) of…

Q: how to organize information pictorially using charts or graphs?

A: The three common charts representing statistical data are bar graphs, histograms and pie charts.…

Q: Give 2 characteristics that indicate a linear model may be appropriate to model a data set

A: In bare eyes, it is not so easy to identify or tell whether a linear model is appropriate to model a…

Q: What big problem does Power Query solve? Creating interactive visuals Cleaning messy data Making…

A: Power Query is a business intelligence application found in Excel software. The big problem options…

Q: What are the Irrelevant variables?

A: Irrelevant variables are complement to omitted variable and A variable is irrelevant if its true…

Q: How can data be compared?

A: Here, we have to describe the different ways by which data can be compared.

Q: Statistical information about the data can be helpful in making efficient query plan. True or False?

A: Given: The statement, Statistical information about the data can be helpful in making efficient…

Q: The variable personal desire for aggressive treatment is?

A: Aggression is a typical mental illness. This can be caused because of emotional instability due to…

Q: What is the difference between an individual and a variable?

A: Step 1: In a study, an individual is a subject that is included in the study. On the other hand, a…

Q: Hepl please What is your opinion on a national curriculum? How do you think it will affect the…

A: Approach to solving the question:I simply based my answers on my understanding of the given topic by…

Q: TRUE OR FALSE Suppose you wish to use number of views for a video to predict the number of comments…

A: The objective of the question is to understand the concept of response variable in the context of a…

Q: Explain the concept of Degrees of Freedom through an example:

Q: What is the difference between dependent and independent variable?

A: Our aim is to state the difference between dependent and independent variable

Q: How does a histogram work? How do I make one?

A: A histogram is a graphical representation of continuous numerical data using rectangular bars. It…

Q: What are levels/factors of a variable?

A: Factors: It is also called explanatory variable or independent variable. Consider the experiment…

Q: Describe the three primary charts and graphs used to organize and display data.

A: Here we describe the three primary charts and graphs to display the data.

Q: The accompanying table shows the ages (in years) of 11 children and the numbers of words in their…

Q: Explain what secondary analysis is and its key advantages and disadvantages

Q: According to your textbook, the dependent variable is also called the measure. criterion.…

A: The dependent variable is the variable which is being measured or under the test of the model.…

Q: Draw a scatter diagram with square feet of living space as the independent variable and selling…

A: Draw a scatter diagram with square feet of living space as the independent variable and selling…

Concept explainers

Statements and Logic

Logic is the analysis of general patterns of thoughts without regard to any specific sense of context.

Topic Video

Question

I need the excel model and lp model

My Lecture: Management Science

The PipeWell Company produces a particular electronic device for pipeline projects at two plants in
Dublin and Casablanca. After production, the products are first shipped to warehouses located in Baku
and Bologna then delivered to the customers in Dubai, Moscow, and Istanbul, hence, all arcs are one-
directional, from the plants to the warehouses, and from the warehouses to the customers. The
following figure is a network representation of the logistics structure. The numbers on arcs represent
the unit cost of shipment of a product between the corresponding nodes. The monthly capacities of
the plants (300,100) and the demands of the customers (150,100,150) are also shown next to the
related nodes. Any number of products can be shipped between nodes. Build an appropriate LP model
to find a shipment plan that minimizes total cost of shipment for this company. Do not forget to write
the necessary definitions (i.e. variables) related to your model. Solve the model, and answer the
following questions.
150
300
Duhal
Dublin
3
in
Bologna
100
Moscow
10
100
2
Baku
150
Casablanca
Istanbul
Answer the following questions based on the data represented in the sensitivity report:
a) Explain the optimal solution (values of the decision variables and the total shipping cost).
b) What if the demand of the first customer (node 5) decreases to 100 units?
c) What if the second plant (node 2) increases its capacity to 120 units?
d) What if the units cost of shipping from the first plant (node 1) to the second warehouse
decreases (node 4) to $3?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step by step

Solved in 9 steps with 9 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Propositional Calculus$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.

Similar questions

How to find independent and defendant variables
Cellulon, a manufacturer of home insulation, wants to develop guidelines for builders and consumers on how the thickness of the insulation in the attic of a home and the outdoor temperature affect natural gas consumption. In the laboratory, it varied the insulation thickness and temperature. A few of the findings are: Monthly Natural Gas Consumption (cubic feet), Thickness of Insulation (inches), Outdoor Temperature (ºF), y x1 x2 30.3 4.0 42.0 24.8 12 40 31.7 8 49 On the basis of the sample results, the regression equation is: yˆy⁢^⁢ = 62.93 − 1.25x1 − 0.78x2 How much natural gas can homeowners expect to use per month if they install 4 inches of insulation and the outdoor temperature is 42 degrees F? (Round your answer to 2 decimal places.) What effect would installing 7 inches of insulation instead of 4 have on the monthly natural gas consumption (assuming the outdoor temperature remains at 42 degrees F)? (Round your answers to 2 decimal…
Define the terms dependent and independent variable and explain their relationship.
Explain the difference between Independent and Dependent Variables.
answer quickly
Cellulon, a manufacturer of home insulation, wants to develop guidelines for builders and consumers on how the thickness of the insulation in the attic of a home and the outdoor temperature affect natural gas consumption. In the laboratory, it varied the insulation thickness and temperature. A few of the findings are: Monthly Natural Gas Consumption (cubic feet), Thickness of Insulation (inches), Outdoor Temperature (ºF), y x1 x2 30.3 6.0 40.0 24.2 12 40 27.9 8 49 On the basis of the sample results, the regression equation is: yˆy⁢^⁢ = 56.26 − 0.66x1 − 0.59x2 How much natural gas can homeowners expect to use per month if they install 6 inches of insulation and the outdoor temperature is 40 degrees F? (Round your answer to 2 decimal places.) What effect would installing 7 inches of insulation instead of 6 have on the monthly natural gas consumption (assuming the outdoor temperature remains at 40 degrees F)? (Round your answers…
2. How do you identify which variable in a study is the factor? How do you identify the levels of a factor? How do you identify the dependent variable?
how does the number of attributes of a variable impact the number of cells in the cross-tabulation table and describe what each cell represents?