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: Identify the dependent variable and independent variable with justification?

A: Dependent variable: The variable that is changed because of the influence of the independent…

Q: Description of item analysis

A: Introduction Statistics is a field which involves collection, arrangement and analysis of the data…

Q: What do you mean by Standardized Variables?

A: Standardized variables: Standardized variables are the variables which are rescaled using the…

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: xplain the relationship of the lessons (Research Design, Quantitative Data Collection Technique, and…

A: Research design: Research design is the framework of study it contains research techniques and…

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: Describe two ways economists try to forecasts developments in the economy

A: * An economic forecast is a process of trying to predict a future economic situation using a…

Q: A continuous variable is a variable_ O that is identified as an effect variable O with a unit of…

A: Given problem Given that A continuous variable is a variable Ans) with a unit of measurement…

Q: Explain the term variable and its different types.

A: Variable: A variable is any characteristics, number, or quantity that can be measured or counted…

Q: Why is it a critical and challenging part of the model-building process to determine the appropriate…

A: Model-building process is a part of Machine Learning.

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: Why do you think it is important for a researcher to do a background research to the chosen…

A: It generally supports the question, what did we know about this topic before I did this study?…

Q: hat is the dependent variable, constant, independent variable, and control group? Do bigger dogs…

A: A scientific experiment consists of a set of steps designed to test a hypothesis. To correctly…

Q: What are the Irrelevant variables?

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

Q: How do you suggest to do the monitoring and optimization

A: Optimization: An act, process, or methodology of making something (such as a design, system, or…

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: briefly discuss a method of data analysis

A: The method of Data Analysis is as follows

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: Simplity -72

A: To simplify: -72

Q: Evaluate the importance of social interaction during the problem-solving process.

A: The complete solution is in given below

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: How do quantitative research's strengths can contribute to the weaknesses of qualitative research?

A: Introduction - quantitative research- It is the process if collecting and analyzing numerical data.…

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: Explain with the aid of an example the concept depicted in the Include all 3 different use cases in…

A: Let us take an example where thee stress and strength the two physical qualities of a material are…

Q: What is the total number and percent of people who take antipsychotics? A total number of study…

A: Step 1: First we have to calculate the total number of people who take antipsychotic medication.…

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: Explain if two variables consist of nominal data?

A: Nominal Data: This is used to label variables without providing values that are quantitative in…

Q: How can In-depth interview help a researcher obtain a data from you?

A: Interviews are used to collect data across all educational research fields. There are different…

Q: Q2: Discuss the three types of data in an enterprise system and how they are.

A: 1. Briefly explain the three types of data in an enterprise system and how they are related. All…

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
Advanced Math Question
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?