Need Paper written in 2 days or less( 100%Plagiarism Free) (MAT 540 Assignment 4 (Stateline Shipping and Transport Company)

you are using the Blackboard Mobile Learn IOS App, please click “View in Browser.”

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center. 
Instructors, training on how to grade is within the Instructor Center.
Click the link above to submit your assignment.
Assignment #4: Case Problem “Stateline Shipping and Transport Company”
Read the ‘Stateline Shipping and Transport Company” Case Problem on pages 273-274 of the text. Analyze this case, as follows:

1. In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites.

2. Solve the model you developed in #1 (above) and clearly describe the results.
In Excel, or other suitable program, Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points.

3. Solve the model you developed in #3 (above) and clearly describe the results.

4. Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph.

There are two deliverables for this Case Problem, the Excel spreadsheets and an accompanying written description/explanation. Please submit both of them electronically via the dropbox. 
The assignment will be graded using the associated rubric.

Outcome Assessed:	· Develop solutions for transshipment problems. · Communicate issues in Management Science
Grading Rubric for Stateline Shipping & Transport Case Problem There are 12 points in each of the five criteria for a total of 60 points possible

Did not submit or the objective function and/or constraints are specified with less than 70% accuracy.

The objective function and most or all constraints are specified correctly and adequately described.

The objective function and all constraints are specified correctly in the model and clearly described

Did not solve the model or adequately describe the results.

The model is solved, but its validity is questionable or it is incorrectly described.

The model is solved and the results are mostly valid and mostly correctly described.

The model is solved and the results are valid and correctly described.

Criteria	0 Unacceptable (0 points)	1 Developing (6 points)	2 Competent (9 points)	3 Exemplary (12 points)
1. Develop a transportation model for shipping from the 6 plants directly to the 3 disposal sites. Describe and implement the model.		Did not submit or the objective function and/or constraints are specified with less than 70% accuracy.	The objective function and constraints are specified and described with 70 – 79% accuracy.		The objective function and most or all constraints are specified correctly and adequately described.		The objective function and all constraints are specified correctly in the model and clearly described
2. Solve the model given in 1 and describe the results.		Did not solve the model or adequately describe the results.		The model is solved, but its validity is questionable or it is incorrectly described.		The model is solved and the results are mostly valid and mostly correctly described.		The model is solved and the results are valid and correctly described.
3. Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points.	The objective function and constraints are specified and described with 70 -79% accuracy.
4. Solve the model given in 3 and describe the results.
5. Interpret the models and draw conclusions	Did not complete the assignment or interpretation and/or conclusions drawn are invalid and/or not intelligibly communicated.	There are errors in interpreting the results; or inappropriate conclusions are drawn; or this is not clearly communicated.	Results are interpreted in a mostly correct manner; conclusions drawn are mostly appropriate; and communicated in a mostly clear manner.	Results are correctly interpreted; appropriate conclusions are drawn and communicated clearly.

you

are

using

the

Blackboard

Mobile

Learn

IOS

App,

please

click

“View

in

Browser.”

Students
, please view the “Submit a Clickable Rubric Assignment” in the Student
Center.

Instructors
, training on how to grade is within the Instructor Center.

Click the link above to submit your assignment.

Assignment #4: Case Problem “Stateline Shipping and Transport Company”

Read the ‘Stateline Shipping and Transport Company” Case Problem on pages 273
–
274
of the text. Analyze this case, as follows:

1.

In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste
disposal sites.

2.

Solve the model you developed in #1 (above) and clearly describe the results.

In Excel, or othe
r suitable program, Develop a transshipment model in which each of the plants and disposal sites
can be used as intermediate points.

3.

Solve the model you developed in #3 (above) and clearly describe the results.

4.

Interpret the results and draw conclusions th
at address the question posed in the case problem. What are the limits of
the study? Write at least one paragraph.

There are two deliverables for this Case Problem, the Excel spreadsheets and an
accompanying written description/explanation. Please submit b
oth of them electronically
via the dropbox.

The assignment will be graded using the associated rubric.

Outcome Assessed:

·

Develop solutions for transshipment problems.

·

Communicate issues in Management Science

Grading Rubric for Stateline Shipping & Transport Case Problem

There are 12 points in each of the five criteria for a total of 60 points possible

Criteria

0 Unacceptable (0
points)

1 Developing (6
points)

2 Competent (9
points)

3 Exemplary (12
points)

1. Develop a
transportation model
for shipping from
the 6 plants directly
to the 3 disposal
sites. Describe and
implement the
model.

Did not submit or
the objective
function and/or
constraints are
specified with less
than 70% accuracy.

The objective
function and
constraints are
specified and
described with 70
–

79% accuracy.

The objective
function and most
or all constraints
are speci
fied
correctly and
adequately
described.

The objective
function and all
constraints are
specified correctly
in the model and
clearly described

2. Solve the model
given in 1 and
describe the results.

Did not solve the
model or
adequately describe
t
he results.

The model is
solved, but its
validity is
questionable or it is
incorrectly
described.

The model is
solved and the
results are mostly
valid and mostly
correctly described.

The model is solved
and the results are
valid and correctly
described.

3. Develop a
transshipment
model in which each
of the plants and
disposal sites can be
used as intermediate
points.

Did not submit or
the objective
function and/or
constraints are
specified with less
than 70% accuracy.

The objective
function and
constraints are
specified and
described with 70
–
79% accuracy.

The objective
function and most
or all constraints
are specified
correctly and
adequately
described.

The objective
function and all
constraints are
specified correctly
in the model and
clearl
y described

you are using the Blackboard Mobile Learn IOS App, please click “View in Browser.”
Students, please view the “Submit a Clickable Rubric Assignment” in the Student
Center.
Instructors, training on how to grade is within the Instructor Center.

Click the link above to submit your assignment.

Assignment #4: Case Problem “Stateline Shipping and Transport Company”

Read the ‘Stateline Shipping and Transport Company” Case Problem on pages 273-274
of the text. Analyze this case, as follows:
1. In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste
disposal sites.
2. Solve the model you developed in #1 (above) and clearly describe the results.
In Excel, or other suitable program, Develop a transshipment model in which each of the plants and disposal sites
can be used as intermediate points.
3. Solve the model you developed in #3 (above) and clearly describe the results.
4. Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of
the study? Write at least one paragraph.
There are two deliverables for this Case Problem, the Excel spreadsheets and an
accompanying written description/explanation. Please submit both of them electronically
via the dropbox.

The assignment will be graded using the associated rubric.

Outcome Assessed:
 Develop solutions for transshipment problems.
 Communicate issues in Management Science
Grading Rubric for Stateline Shipping & Transport Case Problem
There are 12 points in each of the five criteria for a total of 60 points possible
Criteria 0 Unacceptable (0
points)
1 Developing (6
points)
2 Competent (9
points)
3 Exemplary (12
points)
1. Develop a
transportation model
for shipping from
the 6 plants directly
to the 3 disposal
sites. Describe and
implement the
model.
Did not submit or
the objective
function and/or
constraints are
specified with less
than 70% accuracy.
The objective
function and
constraints are
specified and
described with 70 –
79% accuracy.
The objective
function and most
or all constraints
are specified
correctly and
adequately
described.
The objective
function and all
constraints are
specified correctly
in the model and
clearly described
2. Solve the model
given in 1 and
describe the results.
Did not solve the
model or
adequately describe
the results.
The model is
solved, but its
validity is
questionable or it is
incorrectly
described.
The model is
solved and the
results are mostly
valid and mostly
correctly described.
The model is solved
and the results are
valid and correctly
described.
3. Develop a
transshipment
model in which each
of the plants and
disposal sites can be
used as intermediate
points.
Did not submit or
the objective
function and/or
constraints are
specified with less
than 70% accuracy.
The objective
function and
constraints are
specified and
described with 70 –
79% accuracy.
The objective
function and most
or all constraints
are specified
correctly and
adequately
described.
The objective
function and all
constraints are
specified correctly
in the model and
clearly described