Management Statistic

The goal of this homework assignment is to set up and solve a Transportation Model problem in MS Excel using the Solver Add-in. MS Excel provides users with the Solver Add-in, giving them super powers to solve linear, integer, and nonlinear optimization problems. Attached is the instructions for this as

MSIS 301 Homework #5 Dr. Rice

The goal of this homework assignment is to set up and solve a Transportation Model problem in MS
Excel using the Solver Add-in. MS Excel provides users with the Solver Add-in, giving them super powers
to solve linear, integer, and nonlinear optimization problems.
The Transportation model is a special case of Linear Programming (LP). The key to solving LP on a
spreadsheet is to:
? Set up a worksheet that tracks everything of interest (e.g., costs, distance, capacity, demand)
? Identify decision variables?that is, cells that will change in solving the LP
? Identify the objective function?the target cell that will be maximized, minimized, or set to
? Identify the constraints
? Use the MS Excel Solver Add-in to solve the problem
? The optimal solution to our problem?that is, optimal values for decision variables?will be
placed on the spreadsheet
The information of interest for this problem is in Figure 1 and the MS Excel spreadsheet set-up should
be similar to Figure 2. The spreadsheet has 4 parts; (1) data table on the top, (2) decision variables
(changing cells) highlighted yellow, (3) objective function (cost), and (4) capacity/demand constraints on
the bottom. Next, we?ll use solver to find the optimal (cost minimizing) changing cells that meet the
constraints. Set up the problem and find the optimal solution user Solver and fill in the highlighted cells.
Additional information about the Transportation Model and this problem is on the next couple of pages.
A B C Factory Capacity
DM 5 4 3 100
E 8 4 3 300
FL 9 7 5 300
300 200 200
A B C Factory Capacity
DM 100
E 300
FL 300
300 200 200
Cost 0
DM 0 <= 100
E 0 <= 300
FL 0 <= 300
A 0 >= 300
B 0 >= 200
C 0 >= 200
Figure 1 – Problem Information
Figure 2- Excel Spreadsheet Setup
Philadelphia, andcarsfromBostoncome-to
Miami.Thesceneisrepeatedinover100 .
citiesaroundtheU.S. As a result,thereare
toomanycarsinsomecitiesandtoofew in
howmanyoftheserentalsshouldbe truGked
excesscapacitytoeachcity thatneedsmore
themosteconomicalrouting,so rentalcar
companiestumto transportationmodeling.
Transportation modeling
the costofshippingproductsfrom
a seriesofsourcesto a seriesof
Develop an initial solution to a transportation model with the northwest-corner and intuitive
lowest-cost methods 732
Solve a problem with the stepping-stone method 734
BaJance a transportation problem 737
Deal with a problem that has degeneracy 737
Transportation Modeling
Because location of a new factory, warehouse, or distribution center is a strategic issue wirz
substantial cost implications, most companies consider and evaluate several locations. With
wide variety of objective and subjective factors to be considered, rational decisions are aida:
by a number of techniques. One of those techniques is transportation modeling.
The transportation models described in this module prove useful when considering alternative
facility locations within the framework of an existing distribution system. Each new potential
plant, warehouse, or distribution center will require a different allocation of shipments.
depending on its own production and shipping costs and the costs of each existing facility. The
choice of a new location depends on which will yield the minimum cost for the entire system.
Transportation modeling finds the least-cost means of shipping supplies from several origins (
several destinations. Origin points (or sources) can be factories, warehouses, car rental agencies
like Avis, or any other points from which goods are shipped. Destinations are any points thz;
receive goods. To use the transportation model, we need to know the following:
1. The origin points and the capacity or supply per period at each.
2. The destination points and the demand per period at each.
3. The cost of shipping one unit from each origin to each destination.
The transportation model is one form of the linear programming models discussed in Business
Analytics Module B. Software is available to solve both transportation problems and the more
general c1ass of linear programming problems. To fully use such programs, though, you neec
to understand the assumptions that underlie the modeL To illustrate the transportation problem,
we now look at a company called Arizona Plumbing, which makes, among other products,
TABLE (,1 Transportation Costs Per Bathtub for Arizona Plumbing
D~ MOII~~s _$5 =-?
Evansville $8 $4
Fort Lauderdale J ~ -$]-
_– — ~- — —-
a full line of bathtubs. In our example, the firm must decide which of its factories should supply
which of its warehouses. Relevant data for Arizona Plumbing are presented in Table C.l and
Figure C.l. Table C.I shows, for example, that it costs Arizona Plumbing $5 to ship one bathtub
from its Des Moines factory to its Albuquerque warehouse, $4 to Boston, and $3 to Cleveland.
Likewise, we see inFigure C.I that the 300 units required by Arizona Plumbing’s Albuquerque
warehouse may be shipped in various combinations from its Des Moines, Evansville, and
.Fort Lauderdale factories.
The first step in the modeling process is to set up a transportation matrix. Its purpose is to
summarize all relevant data and to keep track of algorithm computations. Using the information
displayed in Figure C.l and Table C.l, we can construct a transportation matrix as shown
in Figure C.2.
Des Moines
Des Moines constraint
a possible
to Cleveland)
Fort Lauderdale
Cost of shipping 1 unit from Fort
Lauderdale factory to Boston warehouse
warehouse demand
Total demand
and total supply
Transportation Problem
Transportation Matrix for
Arizona Plumbing

The Dutchman Essay Question

Disset Clay’s monologue and use other plays assigned to class to identify specific ideas and concepts that resonate with the African American community.

Other plays assignrd to class that could be used in the essay includes:
A Sunday Morning In The South
A Raisin In The Sun
Big White Fog
Mine Eyes Have Seen

I would like for you to use three of this plays to help identify specific ideas and concepts that resonate with the african american community along with The Dutchman. (Hint: It needs to support the play the dutchman) (The Dutchman is the main part and things that went on in the other plays should just support the ideas from Clay’s monologue.) But I do not think it is necessary to read those plays completely. Summaries are available and should be enough to write the essay. But you should read The Dutchman since the essay is mainly about that play. (It isn’t a very long play) The ideas and concepts that my professor is getting at includes basically the struggle that can come with being African American. You should get an idea once you begin to read the summaries of the other plays and the play The Dutchman.

**YOU HAVE TO TALK ABOUT CLAY’S MONOLOGUE IN THE PLAY. It is the main part of the question. As for the other plays, you do not have to so much as tell the story behind them but rather examples from the additional plays I listed to support the ideas and concepts that you decide to write about that resonate with the african american community. Example of an idea would be how african americans are judge and expected to be less than because of the traditions of slavery. You have to talk about how the unfortunate events such as slavery that leads to the african american being viewed differently and given the same opportunities. That is the direction that the paper should go in. AGAIN the point is to DISSECT CLAY’S MONOLOGUE in the play and alk about some of the ideas that he express that resonates with his community.




Second Vatican Council
October 28, 1965
Revised English Translation*
1. In our day, when people are drawing more closely together and the bonds of friendship
between different peoples are being strengthened, the church examines more carefully its
relations with non-Christian religions. Ever aware of its duty to foster unity and charity among
individuals, and even among nations, it reflects at the outset on what people have common
and what tends to bring them together.
Humanity forms but one community. This is so because all stem from the one stock which
God created to people the entire earth (see Acts 17:26), and also because all share a
common destiny, namely God. His providence, evident goodness, and saving designs extend
to all humankind (see Wis 8:1; Acts 14:17; Rom 2:6-7; 1 Tim 2:4) against the day when the
elect are gathered together in the holy city which is illumined by the glory of God, and in
whose splendor all peoples will walk (see Apoc 21:23 ff.).
People look to their different religions for an answer to the unsolved riddles of human
existence. The problems that weigh heavily on people’s hearts are the same today as in past
ages. What is humanity? What is the meaning and purpose of life? What is upright behavior,
and what is sinful? Where does suffering originate, and what end does it serve? How can
genuine happiness be found? What happens at death? What is judgment? What reward
follows death? And finally, what is the ultimate mystery, beyond human explanation, which
embraces our entire existence, from which we take our origin and towards which we tend?
2. Throughout history, to the present day, there is found among different peoples a certain
awareness of a hidden power, which lies behind the course of nature and the events of
human life. At times, there is present even a recognition of a supreme being, or still more of a
Father. This awareness and recognition results in a way of life that is imbued with a deep
religious sense. The religions which are found in more advanced civilizations endeavor by
way of well-defined concepts and exact language to answer these questions. Thus, in
Hinduism people explore the divine mystery and express it both in the limitless riches of myth
and the accurately defined insights of philosophy. They seek release from the trials of the
present life by ascetical practices, profound meditation and recourse to God in confidence
and love. Buddhism in its various forms testifies to the essential inadequacy of this changing
world. It proposes a way of life by which people can, with confidence and trust, attain a state
of perfect liberation and reach supreme illumination either through their own efforts or with
divine help. So, too, other religions which are found throughout the world attempt in different
ways to overcome the restlessness of people’s hearts by outlining a program of life covering
doctrine, moral precepts and sacred rites.
The Catholic Church rejects nothing of what is true and holy in these religions. It has a high
regard for the manner of life and conduct, the precepts and doctrines which, although
differing in many ways from its own teaching, nevertheless often reflect a ray of that truth
which enlightens all men and women. Yet it proclaims and is in duty bound to proclaim
without fail, Christ who is the way, the truth and the life (Jn 1:6). In him, in whom God
reconciled all things to himself (see 2 Cor 5:18-19), people find the fullness of their religious
The Church, therefore, urges its sons and daughters to enter with prudence and charity into
discussion and collaboration with members of other religions. Let Christians, while witnessing
to their own faith and way of life, acknowledge, preserve and encourage the spiritual and
moral truths found among non-Christians, together with their social life and culture.
3. The church has also a high regard for the Muslims. They worship God, who is one, living
and subsistent, merciful and almighty, the Creator of heaven and earth,1 who has also
spoken to humanity. They endeavor to submit themselves without reserve to the hidden
decrees of God, just as Abraham submitted himself to God’s plan, to whose faith Muslims
eagerly link their own. Although not acknowledging him as God, they venerate Jesus as a
prophet; his virgin Mother they also honor, and even at times devoutly invoke. Further, they
await the day of judgment and the reward of God following the resurrection of the dead. For
this reason they highly esteem an upright life and worship God, especially by way of prayer,
alms-deeds and fasting.
Over the centuries many quarrels and dissensions have arisen between Christians and
Muslims. The sacred council now pleads with all to forget the past, and urges that a sincere
effort be made to achieve mutual understanding; for the benefit of all, let them together
preserve and promote peace, liberty, social justice and moral values.
4. Sounding the depths of the mystery which is the church, this sacred council remembers the
spiritual ties which link the people of the new covenant to the stock of Abraham.
The church of Christ acknowledges that in God’s plan of salvation the beginnings of its faith
and election are to be found in the patriarchs, Moses and the prophets. It professes that all
Christ’s faithful, who as people of faith are daughters and sons of Abraham (see Gal 3:7), are
included in the same patriarch’s call and that the salvation of the church is mystically
prefigured in the exodus of God’s chosen people from the land of bondage. On this account
the church cannot forget that it received the revelation of the Old Testament by way of that
people with whom God in his inexpressible mercy established the ancient covenant. Nor can
it forget that it draws nourishment from that good olive tree onto which the wild olive branches
of the Gentiles have been grafted (see Rom 11:17-24). The church believes that Christ who
is our peace has through his cross reconciled Jews and Gentiles and made them one in
himself (see Eph 2:14,16).
Likewise, the church keeps ever before its mind the words of the apostle Paul about his kin:
“they are Israelites and it is for them to be sons and daughters, to them belong the glory, the
covenants, the giving of the law, the worship, and the promises; to them belong the
patriarchs, and of their race according to the flesh, is the Christ” (Rom 9:4,5), the Son of the
Virgin Mary. It is mindful, moreover, that the apostles, the pillars on which the church stands,
are of Jewish descent, as are many of those early disciples who proclaimed the Gospel of
Christ to the world.
As holy scripture testifies, Jerusalem did not recognize God’s moment when it came (see Lk
19:42). Jews for the most part did not accept the Gospel; on the contrary, many opposed its
spread (see Rom 11:28). Even so, the apostle Paul maintains that the Jews remain very dear
to God, for the sake of the patriarchs, since God does not take back the gifts he bestowed or
the choice he made.2 Together with the prophets and that same apostle, the church awaits
the day, known to God alone, when all peoples will call on God with one voice and serve him
shoulder to shoulder (Soph 3:9; see Is 66:23; Ps 65:4; Rom 11:11-32).
Since Christians and Jews have such a common spiritual heritage, this sacred council wishes
to encourage and further mutual understanding and appreciation. This can be achieved,
especially, by way of biblical and theological enquiry and through friendly discussions.
Even though the Jewish authorities and those who followed their lead pressed for the death
of Christ (see Jn 19:6), neither all Jews indiscriminately at that time, nor Jews today, can be
charged with the crimes committed during his passion. It is true that the church is the new
people of God, yet the Jews should not be spoken of as rejected or accursed as if this
followed from holy scripture. Consequently, all must take care, lest in catechizing or in
preaching the word of God, they teach anything which is not in accord with the truth of the
Gospel message or the spirit of Christ.
Indeed, the church reproves every form of persecution against whomsoever it may be
directed. Remembering, then, it?s common heritage with the Jews and moved not by any
political consideration, but solely by the religious motivation of Christian charity, it deplores all
hatreds, persecutions, displays of anti-semitism directed against the Jews at any time or from
any source. The church always held and continues to hold that Christ out of infinite love
freely underwent suffering and death because of the sins of all, so that all might attain
salvation. It is the duty of the church, therefore, in it?s preaching to proclaim the cross of
Christ as the sign of God’s universal love and the source of all grace.
5. We cannot truly pray to God the Father of all if we treat any people as other than sisters
and brothers, for all are created in God’s image. People’s relation to God the Father and their
relation to other women and men are so dependent on each other that the Scripture says
“they who do not love, do not know God” (1 Jn 4:8). There is no basis therefore, either in
theory or in practice for any discrimination between individual and individual, or between
people and people arising either from human dignity or from the rights which flow from it.
Therefore, the church reproves, as foreign to the mind of Christ, any discrimination against
people or any harassment of them on the basis of their race, color, condition in life or religion.
Accordingly, following the footsteps of the holy apostles Peter and Paul, the sacred council
earnestly begs the Christian faithful to “conduct themselves well among the Gentiles” (1 Pet
2:12} and if possible, as far as depends on them, to be at peace with all people (see Rom
12:18) and in that way to be true daughters and sons of the Father who is in heaven (see Mt
I. See St Gregory VII, Letter 21 to Anzir (Nacir), King of a. Mauretania: PL 148, col. 450 ff.
II. See Rom 11:28-29; see Vatican Council II, Dogmatic Constitution on the Church, Lumen Gentium.
* As found in Austin Flannery, O.P., ed., Vatican Council II: Constitutions Decrees,
Declarations. A Completely Revised Translation in Inclusive Language (Northport, NY:
Costello Publishing, 1996).

Business Ethics Rubric

I will be looking for the following items in your Case Study Analysis.

I. Developing a Practical Ethical Viewpoint (Have you clearly picked and stated an Ethical Viewpoint) (You need to choose one for each case study)
A. Utilitarianism
B. Universal Ethics
C. Ethical Relativism
D. Virtue Ethics

II. To help you choose the ethical theory do the following (By looking at the moral situations):
A. Interpret what is right and wrong according to each of the four theories
B. Give an argument that each theory might provide
C. State your own assessment of the strengths of each theory

III. Find the Ethical Conflict (Develop questions to identify the ethical issues)
A. Is any party being exploited solely for the advantage of another?
1. Is there any lying?
2. Is anyone or party injured
3. Is there a deliberate falsification of information
4. Has there been a creation of unequal competition?
5. The above mentioned items are prohibitions(these are actions that you must refrain from doing)
B. Is every effort being made to assist and affirm the human dignity of all parties involved?
1. Is there encouragement of fulfillment of legal and human rights
2. Take personal responsibility for results
3. The above mentioned items are obligations(these are actions that you are required to do)
C. Anything that is not an obligation or a prohibition is a permission.(Permissions are actions that you may do if you choose)
D. Summary of finding the Ethical Conflict
1. List the professional practice issues at stake
2. Identify your practical ethical viewpoint including any linking principles
3. Determine which character?s perspective you will adopt
4. Identify two or more detection questions that define obligation and prohibition within the ethical theory you have chosen.
5. Apply the detection questions to the cases to bring attention to the ethical issues.
6. Discuss the interrelationships between the dictates of the ethical issues and those of the professional practice. How might they work together? How might they be opposed?

IV. Applying Ethical Issues
A. Thoughts on the position and Argument for the position (Brainstorm list)
B. Thoughts on the position and Argument against the position (Brainstorm list)
C. Compare the pivotal premises in those arguments using ethical consideration as part of the decision making matrix
D. Make a judgment on which course to take

V. Resolution?What is the best way to resolve this conflict (Do any or all of the following apply?)
A. Truth vs. loyalty (Is the truth best or is it better to be loyal)
B. Short term vs. Long term (Is this consequence a short term or long term consequence)
C. Justice vs. Mercy (Is this a case of dispensing justice or is this a case of dispensing mercy)
D. Individual vs. Community (Does your decision affect an individual or a community)

VI. Structuring the Essay
A. Executive Summary (Brief synopsis of your worldview position and ethical theory) (Heading)
B. Introduction (Case Study) (Heading)
C. Body of the Essay(Heading)
D. Conclusion (Heading)
E. Spelling and Mechanics/Citations
F. Page Requirements (seven to nine pages can be more than seven but not less than seven)

Please do the required pages which are seven to nine pages. You are allowed to pick any Thinking Critically exercise or Ethical Dilemma case study in your textbook. You have to make sure that you pick a case study that you have not done before. Please make sure to include your headings.

Introduction?Explain the case study the facts.

Body of Paper?This is where you state the different ethical theories, strengths and weaknesses, which theory you choose, why you choose that theory, what would you do, do you agree with what was done.

Conclusion?Summary of what you told me in the paper.

Do not forget your citation as you are using the textbook and any other materials to help you write your paper.

Look at the case study. Find the conflict. Look at the case study from various perspectives. Choose a way to resolve it? Analyze it by how you personally see the world.

Do you think education would be better if it were privatized in the United States? What are the benefits of education being privatized? What are the drawbacks? What are the benefits of public education? What are the drawbacks? Would you, personally, prefer to send your kids to a public or a private school? What are your reasons for this choice?

In this discussion you will make an initial post. Initial posts should be 200-250 words. Points will be deducted for not meeting the minimum word count requirements.

Please respond to the following;

Do you think education would be better if it were privatized in the United States? What are the benefits of education being privatized? What are the drawbacks? What are the benefits of public education? What are the drawbacks? Would you, personally, prefer to send your kids to a public or a private school? What are your reasons for this choice?



07/12/2016 Register now with! 4/7

07/12/2016 Register now with! 5/7