Excel Question
Apayton4
FirstName_GLIB3195-HW71.docxGLIB 3195
HW 7
Due Date: March 8, 8:00 PM (EST)
Please provide your answer in red in front of each question.
A. LEARNING QUESTIONS (15 points)
Instruction A. You need to read chapter 7 for this question.
A1. A company is managing 4 warehouse and 5 retailers. The supply of these warehouses is 2300, 2700, 2200, and 2800. The demand of retailers is 1500, 1000, 500, 4500, and 1800. The cost of transportation between warehouses and retailers is shown in the following figure.
|
|
retailers |
|||||
|
|
1 |
2 |
3 |
4 |
5 |
|
|
Warehouses |
1 |
109 |
163 |
184 |
162 |
102 |
|
|
2 |
111 |
196 |
189 |
121 |
137 |
|
|
3 |
194 |
131 |
172 |
169 |
104 |
|
|
4 |
173 |
133 |
125 |
197 |
147 |
The company wants to decide how much to transport from warehouses to retailers.
· Formulate the problem by identifying variables, constraints, and objective function. Write the formal formulation of the problem.
· Solve the problem using Excel. Copy and paste screenshots of importing problem to Excel and solver feeding and final solution.
B. APPLICATION QUESTIONS (5 point)
Instruction B. This part helps you to understand the application of the course material.
B1. Summarize what you have learned in Chapter 7 in one paragraph!
C. ASSESSMENT QUESTIONS (0 point, Mandatory)
Instruction C. Please be aware your homework will not be graded if you leave this part out.
C1. Complete the “Teaching Effectiveness Survey” and upload an image (or PDF) that shows you have completed the survey for this course. Note that without part C, your homework will NOT be graded.
Instruction: You can go to the following website. You will be asked to enter your student ID and your “PAWS Pin”:
https://simba.savannahstate.edu/exit-survey
