Solution-Problem regarding the transportation system

Problem regarding the transportation system

Assignment Help Engineering Mathematics

Reference no: EM13962625

Transportation System

A company which manufactures product in five plants ships locally using its own transportation system, but has orders which must be sent to locations too far to be serviced by the local fleet. It therefore contracts with a middle distance carrier to complete its shipping. The locations of the manufacturing plants and the amount of product available to be shipped per week are show in the chart below.

Manufacturing Locations	Units Available per Week
Columbia	450
Macon	370
Huntsville	550
Greensboro	290
Knoxville	360
Total Available	2020

The seven locations and their weekly demand are shown in the chart below.

Destination Cities	Weekly Demand
Norfolk	305
Charleston	253
Gainesville	328
Mobile	225
Memphis	420
Louisville	158
Roanoke	210
Total Available	1899

Shipping costs per unit (in dollars) between plants and the destination cities are as follows:

Shipping Costs	Norfolk	Charleston	Gainesville	Mobile	Memphis	Louisville	Roanoke
Columbia	27	13	31	42	48	51	44
Macon	42	27	19	23	18	36	43
Huntsville	42	31	23	16	20	39	36
Greensboro	28	25	36	48	37	32	17
Knoxville	47	31	43	39	16	14	34

The transportation company wants to identify its optimal shipping plan that will satisfy demand at the lowest aggregate shipping cost.

Questions:

What is the transportation company trying to optimize? Are they trying to maximize or minimize?
Write the objective function to support this analysis.
What inputs do you need to support your analysis?
Is there any extraneous data you have been given that you will not need?
What criteria has the transportation company given you to support the analysis?
Create a spreadsheet model that supports your analysis.
How would you change your model if one of the locations was temporarily unavailable due to severe weather conditions? On a separate sheet in your Excel file, show how you might do this.

Reference no: EM13962625

Questions Cloud

Constraint and the feasible region : Use a graph to show each constraint and the feasible region. Identify the optimal solution point on your graph.What are the values of X and Y at the optimal solution?

Responsible for generating reliable financial reporting : An organization’s internal environment is responsible for generating reliable financial reporting and complying with laws and regulations. Internal business process improvement methods establish best practices and strengthen corporate governance and ..

Data collection methodology and anticipated results : Creating business intelligence PDF regarding creating a company wide dashboard of results. Seeking information pertaining to the Solution functionality, Data collection methodology, Anticipated results, Limitations of the BI solution, Lessons learned

Explain the activity variances : Prepare a flexible budget performance report that shows both activity variances and revenue and spending variances for the pizzeria for October.

Problem regarding the transportation system : A company which manufactures product in five plants ships locally using its own transportation system, but has orders which must be sent to locations too far to be serviced by the local fleet.

Making surveys cross-culturally appropriate : How do the steps in instrument development apply to making surveys cross-culturally appropriate? What effects might you expect in the data, and subsequently in the interpretation of those data, if surveys are not culturally appropriate?

Most recent best and worst managers : Who are Business Week’s most recent “best and worst managers,” and why were they selected? From your research, do any of them demonstrate Christian values in their actions? Explain.

Provide a detailed fact file about vitamin c : Provide a detailed fact file about vitamin C. Give the sources, importance in the human body, the effects it has on ther human body and the Vitamin C supplements

Disadvantages of pursuing a globalization strategy : Discuss the advantages and disadvantages of pursuing a globalization strategy when given the depth of competition, profitability issues, and market share implications. Use recent news and company examples to illustrate your points.

User Account

All Pages

Problem regarding the transportation system

Reference no: EM13962625

Reference no: EM13962625

Questions Cloud

Reviews

Write a Review

Engineering Mathematics Questions & Answers

Prime number theorem

Proof of bolzano-weierstrass to prove the intermediate value

Antisymmetric relations

Distributed random variables

Prepare a system of equations

Managing ashland multicomm services

Skew-symmetric matrices

Type of taxes and rates in spokane wa

Stratified random sample

Find the probability density function

Develop a new linear programming for an aggregate production

Discrete-time model for an economy

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT