Solved by verified expert:Module 3 – SLPOPTIMIZING INVENTORY/TRANSPORTATIONSLP 3 – Transportation in the Supply ChainIn this SLP you will identify where the major transportation modes are used in the EESC from SLP3: rail, inland water, ocean steamer, and/or OTR.There are five basic transportation modes: rail, inland water ways, ocean, over-the-road, and air. We will not be concerned about air transport in this SLP as it is the least used and most expensive in general supply chain transportation.Review and read these resources on these three transportation modes: rail, inland water, and OTR. Ocean is not included in these readings since it is mainly used for importing and exporting. This will be covered in more detail in LOG502. But you are asked to identify where ocean transport is used, but not in detail.RESOURCES – SEE SLP 3 RESOURCES IN BACKGROUND PAGESession Long ProjectReview the EESC from SLP2. Identify in the EESC where each of the four modes of transportation are used: rail, inland water, ocean, and OTR. You can use topic headings for each mode. Identify the materials being transported from which industry to which industry. Discuss why this mode is being used and what the costs are on a per ton-mile basis.SLP Assignment ExpectationsThe paper should include:Background: Briefly review and discuss the targeted product, company, and industryDiagram: Include the diagram of the EESCTransportation Discussion: Discuss each of the four transportation modes (rail, inland water, ocean, OTR) in the EESC and where each one is used. Discuss why this mode is used and the costs of using.Clarity and Organization: The paper should be well organized and clearly discuss the various topics and issues in depth and breadth.Use of references and citations: at least six (6) proper references should be used correctly, cited in the text, and listed in the references using proper APA format.Length: The paper should be three to four pages – the body of the paper excluding title page and references page.NOTE: You can use the transportation resources. You should also do independent research and find at least two additional appropriate references, for a total of at least six.
module_3_background.docx
slp_assignment_rubric.docx
Unformatted Attachment Preview
Module 3 – Background
OPTIMIZING INVENTORY/TRANSPORTATION
Virtual World
EBBD EMAIL – for Internal Use Only
To: You
From: Danny Wilco
Subject: Re: Quarterly Product Ordering Decisions
Jones was reading an article in a back issue of Logistics
Manager about optimizing inventory and supply chains. And
I have some knowledge of an optimization technique called
linear programming or LP. We think that there is a way we
can use this technique with our new forecasting information
to develop a quarterly product ordering and inventory plan to
optimize our profits.
Here’s the article that Jones was reading:
Anonymous. (2010, Sept.). Supply chain standard: Tooled
up to optimize [sic]. Logistics Manager. Retrieved from
ProQuest.
Check out this article. It does not pertain precisely to our
situation, but the concept of optimization is what we are
interested in. We want to be able to plan for quarterly order
quantities based on the forecast of sales, the forecast of
cost inflation, and our inventory storage capacity. Knowing
what to purchase and hold given the future costs, should
help us to maximize our profits.
I will send more details shortly.
~DW, VP LogOps.
Learning Wizard
Case 3 Resources
Here is some (a lot of) background information to help you
learn how to do LP. Follow these guidelines and you will be
a wiz yourself in no time.
What is LP? Read these resources to gain an
understanding. Then do the learning exercises.
Linear programming. (n.d.). Absolute Astronomy. Retrieved
from http://www.absoluteastronomy.com/topics/Linear_programmin
g
Linear programming: Introduction (n.d.). Purplemath.
Retrieved from http://www.purplemath.com/modules/linprog.htm
Learning Exercises
1. Learn the Basics from this PowerPoint.
Download this PowerPoint with info on the basics of Linear Programming:
problem formulation and graphic solution in 2 dimensions – the Flair
Furniture example. [Linear Programming Models: Graphical & Computer
Methods]
NOTE: 2-D problems are the easiest to setup and solve, and you can see
the solutions graphically. Higher dimension problems, with three or more
decision variables, sometimes up into the thousands, are possible. The
method is basically the same – find the corner points and evaluate the
objective function – but it is more complex and takes more time and
computing power.
****WATCH THIS VIDEO THAT REVIEWS THE POWERPOINT – IN
YOUTUBE*** http://youtu.be/0HBHjHVE1XY
2. You will need to setup Solver Add-in in your Excel. This comes as part
of the Excel Package. You just need to make sure you have it setup and
ready to use.
Download this PowerPoint to show you how to setup Solver [Setting up
Solver Add-in]. Follow the directions. Then you will be ready to see the
examples in try your own.
***NOTE: Spreadsheet in OpenOffice has Solver included. Go to the
Tools menu and click on Solver.
3. View some examples and then try the Greenberg Motors problem
Download this Excel Spreadsheet file with examples of different LP
problems: [Product Mix Problem Example: DJJ Enterprise]
The first Tab in this spreadsheet file is DJJ Enterprise. Watch these
three YouTube videos to see how this problem is formulated, setup and
solved in Excel with Solver.
o YouTube LP example: DJJ Enterprise [3 parts]
Linear Programming Formulation in
Excel (n.d.). YouTube. Retrieved
from http://youtu.be/TNLqtmkK4EA
LP Formulas in Excel (n.d.). YouTube.
Retrieved
from http://youtu.be/wQhNEMvh3MM
Using Solver to Optimize LP (n.d.).
YouTube. Retrieved
from http://youtu.be/9tHqa8EV3rc
o Now download this PowerPoint file that provides more
examples including the Flair Furniture Example. [LPSolver&Examples].
o Review each example in the PowerPoint and explore the
setup and solution in Excel.
o Try the Greenberg Motors problem on your own. Once
you think you have it solved, download this Excel File to
see a solution. [GreenburgMotors-Solution]
4. Now focus on the problem for EBBD.
o Once you know what your task is from the case
assignment, you can experiment with these
spreadsheets with a similar, simpler situation.
o Download this Excel file: [EBBD Exercises: Flair
Furniture]
o Try the following:
Heuristics 1 Tab: First try to find the
optimal combination of products to
order using your best guess and any
heuristics that you can develop. This
is an adaptation of the Flair Furniture
problem.
Heuristics 2 Tab: Now try heuristics to
solve this problem, similar to the
EBBD situation with Quarterly
ordering quantities.
Solver Tab: Try to develop the solver
solution for this problem. It is very
similar to the EBBD problem in the
assignment.
o WATCH THIS VIDEO ON SOLVING THE EEBD
EXERCISE – IN
YOUTUBE:http://youtu.be/LwGXaM6WVq8
5. You should be able to solve the EBBD problem if you have completed
all of these exercises. Make sure you download the Excel file from Danny
Wilco with the Data for Case 3 – on the Case page in his email.
***NOTE: THIS MODULE IS NOT ABOUT ECONOMIC ORDER
QUANTITY (EOQ). THE CASE SOLUTION MUST USE LINEAR
PROGRAMMING AND EXCEL/SOLVER.***
The article that Danny Wilco was talking about, that Jones
discussed with him:
Anonymous. (2010, Sept.). Supply chain standard: Tooled up to optimise
[sic]. Logistics Manager. Retrieved from ProQuest.
SLP 3 Resources – Modes of Transportation
Waterways
U.S. Army Corps of Engineers. (2012). The U.S. Waterway
System, Transportation Facts & Information; Navigation
Center, retrieved
from http://www.navigationdatacenter.us/factcard/factcard12.pdf
American Society of Civil Engineers. Report Card for
America’s Infrastructure, retrieved
from http://www.infrastructurereportcard.org/fact-sheet/inlandwaterways
Ask.com ; Inland Waterways Transportation, retrieved
from http://www.answers.com/topic/inland-waterways-transportation
Texas Transportation Institute. (2009). A Modal Comparison
Of Domestic Freight Transportation Effects On The General
Public, retrieved
from http://www.nationalwaterwaysfoundation.org/study/FinalReport
TTI.pdf
Railroads
Nationalatlas.gov. 2002 Data: Overview of U.S. Freight
Railroads, retrieved
from http://www.nationalatlas.gov/articles/transportation/a_freightrr.
html
USDOT (2012). Freight rail: data & resources. Retrieved on
20 Sep 2016 from https://www.fra.dot.gov/Page/P0365
American Association of Railroads. (https://www.aar.org/)
American Association of Railroads. Railroad statistics,
retrieved
from https://www.aar.org/StatisticsAndPublications/Documents/AA
R-Stats-2013-04-17.pdf
American Association of Railroads. (2015). Today’s
railroads. Retrieved from https://www.aar.org/todays-railroads
Over the Road Trucking (OTR)
American Trucking Association (2015). Retrieved
from http://www.trucking.org/
ATA (2016). Reports, trends & statistics. Retrieved on 20
Sep 2016
from http://www.trucking.org/News_and_Information_Reports.aspx
eHow.com. About Trucking Companies, retrieved
from http://www.ehow.com/about_4586182_truckingcompanies.html
All Modes – Provides Cost Comparisons by Mode and
Other Comparisons
Center for Climate & Energy Solutions. Freight
Transportation Comparison, retrieved
from http://www.c2es.org/technology/factsheet/FreightTransportatio
n
Rubric Name: MBA/MSHRM/MSL SLP Grading Rubric for Quantitative Business Courses Timeliness v1
Criteria
Level 4 – Excellent Level 3 – Proficient Level 2 – Developing Level 1 – Emerging
9 points
Assignment-Driven Demonstrates
Criteria
mastery covering
all key elements of
the assignment in a
substantive way.
7 points
Presentation,
Computation, and
Relevance of
Quantitative
Information
Critical Thinking
8 points
6 points
7 points
Demonstrates
considerable
proficiency
covering all key
elements of the
assignment.
6 points
Demonstrates
Demonstrates partial limited or poor
proficiency covering proficiency
all key elements of
covering all key
the assignment.
elements of the
assignment.
4 points
5 points
Demonstrates
Demonstrates
considerable
mastery in
proficiency in
presenting
presenting
quantitative
quantitative
information in a
information in a
format appropriate
format appropriate
for the discipline.
for the discipline.
Supporting
Supporting
computations are
computations are
relevant and
mostly relevant and
accurate.
accurate.
Demonstrate partial
proficiency in
presenting
quantitative
information in a
format appropriate
for the discipline.
Supporting
computations are not
necessarily relevant
and somewhat
misleading.
6 points
4 points
5 points
Demonstrates
limited or poor
proficiency in
presenting
quantitative
information in a
format appropriate
for the discipline.
Supporting
computations are
not relevant,
misleading or
absent.
3 points
Analyzes
quantitative and
qualitative
information as the
basis for deep and
thoughtful
discussion, drawing
insightful, carefully
qualified
conclusions from
this work.
5 points
Analyzes
quantitative and
qualitative
information as the
basis for competent
and thoughtful
discussion, drawing
reasonable and
appropriately
qualified
conclusions from
this work.
4 points
Analyzes quantitative
and qualitative
information as the
basis for
workmanlike
(without inspiration
or nuance, ordinary)
discussion, drawing
plausible conclusions
from this work.
Analyzes
quantitative and
qualitative
information as the
basis for tentative or
limited discussion;
and is hesitant or
uncertain about
drawing conclusions
from this work.
0 points
2 points
Business Writing
Timeliness
Demonstrates
mastery and
proficiency in
written
communication to
an appropriately
specialized
audience.
3 points
Assignment
submitted on time
or collaborated
with professor for
an approved
Demonstrates
considerable
proficiency in
written
communication to
an appropriately
specialized
audience.
Demonstrates
limited or poor
Demonstrate partial
proficiency in
proficiency in written
written
communication to an
communication to
appropriately
an appropriately
specialized audience.
specialized
audience.
2 points
1 point
0 points
Assignment
submitted 1-2 days
after module due
date.
Assignment
submitted 3-4 days
after module due
date.
Assignment
submitted 5 or more
days after module
due date.
extension on due
date.
Overall Score
Close
Level 4
27 or more
Level 3
24 or more
Level 2
21 or more
Level 1
0 or more
…
Purchase answer to see full
attachment
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more