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:

  1. What is the transportation company trying to optimize? Are they trying to maximize or minimize?
  2. Write the objective function to support this analysis.
  3. What inputs do you need to support your analysis?
  4. Is there any extraneous data you have been given that you will not need?
  5. What criteria has the transportation company given you to support the analysis?
  6. Create a spreadsheet model that supports your analysis.
  7. 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.

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Compute an eigenvector for each of the eigenvalues

Compute an eigenvector for each of the eigenvalues found in part (a). Be sure to scale the eigenvectors so that each is a unit vector (i.e., vT.v = 1 for each eigenvector v).

  Three-reservoir system

Consider the three-reservoir system of Fig with the following data: L1 = 95 m L2 = 125 m L3 = 160 m z1 = 25 m z2 = 115 m z3 = 85 m All pipes are 28-cm-diameter unfinished concrete (e = 1 mm).

  Calculation of the correlation coefficient

Use your regression line equation to predict the value of y for x = 13.Round your answer to two decimal places.

  Determining the voltage across

Problem: In the circuit of Figure P2 use KCL and KVL to find α such that the voltage across the 2 Ω resistors is 4 V.

  What is the resulting cipher

Fix a modulus m and use the affine cipher with key k1 = (a, b) to encrypt an element x; then encrypt the result with a key k2 = (c, d). What is the resulting cipher

  Formulate the optimal solution

Can someone teach me how to formulate the Optimal solution for this problem without using Excel?

  Minimize the total shipping cost

Government regulations require equal distribution of shipping among the three carriers. Formulate and solve a linear program to determine the shipping arrangements (mode, destination, and quantity) that will minimize the total shipping cost.

  Problem regarding the roots of the scalar equation

All the roots of the scalar equation x-4sin(2x)-3=0, are to be determined with at least 10 accurate digits, (n accurate digits is equivalent to a relative error smaller than 0.5 x 10^-n)

  Determining the new investment opportunities

National Insurance Associates carries an investment portfolio of a variety of stocks, bonds, and other investment alternatives.  Currently $200,000 of funds from a new client is available and must be used for new investment opportunities.  The fou..

  1 every convergent sequence contains either an increasing

1 every convergent sequence contains either an increasing or a decreasing subsequence.?proof suppose that limas n goes

  Problems based on normal distribution

If a person bought one share of Google stock within the last year, what is the probability that the stock on that day closed at more than $400?

  Unit sphere centered

Problem 1: If D is the unit sphere centered at (0, 0, 0), evaluate

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd