math 540

profilecad_00

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.

    • 10 years ago
    • 20
    Answer(3)

    Purchase the answer to view it

    blurred-text
    • attachment
      stateline_shipping_and_transport.doc
    • attachment
      stateline_shipping_and_transport.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mat_540_assignment_4_case_problem_stateline_shipping_and_transport_company_excel_sheet.xls
    • attachment
      mat_540_assignment_4_case_problem_stateline_shipping_and_transport_company.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mat_540_assignment_4_case_problem_stateline_shipping_and_transport_company.docx
    Bids(1)