This assignment requires you to use a mixed integer program

 

This assignment requires you to use a mixed integer program to solve a network design problem.

  1. Refer to the “Hands on Excel” discussion on pages 53–56 of the textbook.
  2. Download the MIP 9 City Example Excel file from the assignment resources and open it in Excel.
  3. Ensure that Solver has been enabled on your PC. This may require  you to turn Solver on in the “Add-Ins” area of Excel. For instructions  on how to do this, you can go to the Office Support page and do a search  for “Excel Solver Add-in.”
  4. Develop an answer to question 6 on page 61. In addition, solve the model with four locations.
  5. Develop a 2- to 3-page document that includes:      
    • Quantitative answers to the questions raised in the text.
    • Explanations of what these solutions mean in business terms.
    • An explanation of the managerial implications to your solutions.
    • Answers to the following questions:        
      • Consider the change in total distance as you move from two,  to three, to four locations. How significant an improvement does the  firm achieve in each step?
      • What change to your results do you see in parts C and D of question 6?
      • What service level impacts do you foresee as you move from two, to three, to four locations?

As you complete your assignment, be sure your paper meets the following guidelines:

  • Written communication: Written communication is free of errors that detract from the overall message.
  • APA formatting: All resources and citations should be formatted according to current APA style and formatting guidelines.
  • Length: 2–3 typed, double-spaced pages.
  • Font size and type: 10-point Arial

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Media History: History of Cinema in the UAE or GCC

MPS 361 Media History Guidelines for the alternative research project for those students not doing the oral history assignment. The alternative research project should follow the following guidelines:   Topic: History of Cinema in the UAE or GCC.   1.       This paper should be double spaced, using a font size

Benchmark – Work-Based Assessment Assessment Description Work-based assessment is a

Benchmark – Work-Based Assessment Assessment Description Work-based assessment is a central topic in industrial and organizational psychology. Work-based assessments are often criticized for lack of quantitative rigor and lack of predictive nature for work performance. However, companies and organizations that have clear methods to describe the work, attributes needed to

Describe the role of the EEOC in the practice of

Describe the role of the EEOC in the practice of I/O psychology and three different laws that are enforced by the EEOC. Describe two different types of discrimination prohibited by the laws enforced by EEOC and at least three best practices you would suggest for ensuring equity in the workplace.

Literacy Pre-Assessment and Lesson Plan

Be sure to incorporate a chosen book identified with your mentor teacher to create ELA activities in your mini lesson plan. This mini-lesson plan will be administered to the selected group of students to support instruction to meet the selected standards. Your mini-lesson should include. Grade level, ELA standards, learning

RENT CONTROL ASSIGNMENT: an example of Shortage and Surplus Use

RENT CONTROL ASSIGNMENT: an example of Shortage and Surplus  Use an article that discusses “rent control” from the Internet or library sources as a reference for this exercise. 1.)  On a separate sheet of paper: A.)  draw a clear example of a surplus, show price, quantity, supply, demand, and equilibrium.

Download the following two documents: Part I and Part II

  Download the following two documents: Part I and Part II (these documents are taken from https://www.churchofjesuschrist.org/study/manual/teaching-in-the-saviors-way/teacher-council-meetings?lang=eng (Links to an external site.)).   2. You now need to combine these two documents into one document by importing Part II into Part I.      Here are the steps to do that. Put your cursor

please describe 3 lessons that can be learned about conflict

please describe 3 lessons that can be learned about conflict resolution with young children. You MUST cite where you exactly you found the information. You MUST also use a minimum of 6 sentences also explain 2 reasons how do you resolve conflict when working in groups with classmates or co-workers.

Scenario You are a business development manager reporting to the

Scenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. Their latest venture is producing a new cancer drug. The recent clinical trials of the organization’s flagship product have shown great success and

Recommendations o Objectives. What are realistic goals given 5C conditions?

Recommendations o Objectives. What are realistic goals given 5C conditions?  o Strategic considerations           – Target market(s)                    – Is firm pursuing right target market?’                    – Are there ways the firm needs to understand the target market better?            – Value proposition                    – Does the value proposition align with the job customers want

Unit III AssignmentAssignment Content For this two-part assignment, you will review and analyze a conversation as well as discuss your own communication

Unit III AssignmentAssignment Content For this two-part assignment, you will review and analyze a conversation as well as discuss your own communication noisemakers and barriers and how they can be overcome. Instructions: Part I: Read A Heated Conversation Scenario. A PDF version of A Heated Conversation Scenario is also provided. Identify one noisemaker

Overview Monitoring a marketing strategy from start to finish helps

Overview Monitoring a marketing strategy from start to finish helps you assess a marketing plan and its effectiveness. You are a regional marketing director of a theme park responsible for creating a customizable template for strategic marketing. This template can be used across all parks. Now, to identify continuous improvement

Death, be not proud (Holy Sonnet 10)

Analyze and interpret your chosen poem. Be sure to discuss its thematic content (the ideas, issues, problems, or questions that it explores) and well as its poetic form (rhythm, rhyme, stanza, prosody, diction, imagery, figurative language, and so forth). Quote frequently from the poem. About 20% of your overall word-count

In a Word® document answer the following questions. In Module

  In a Word® document answer the following questions. In Module 01 Written Assignment – Reflection you were asked to give yourself a rating from 1 to 5, with 5 representing the healthiest eater. What number would you give yourself now? Did your rating change? If so, in what direction and

Since 1985, women incarceration rates have nearly doubled. More and

Since 1985, women incarceration rates have nearly doubled. More and more women are receiving prison sentences due as a result of their involvement in criminal activity. A growing topic in corrections has been the supervision of women in correctional facilities. This video examines mass incarceration and women (TEDx Talks, 2018):

Column 1 = 15 15 14 14 13 12 11

  Column 1 = 15 15 14 14 13 12 11 10 10 10 10 10 10 9 9 8 8 7 7 6 5 5 5 5 4 4 4 4 3 3 Column 2 95 94 93 95 93 90 91 94 90 89 88 90 91 85

Design project for the Marine Research Facility

 Design project for the Marine Research Facility. For this task it is needed to draft a report for our managing director that can be used to inform a potential clients of the benefits of using project management consultants as project leaders. Identify the services your firm could offer the project’s