Use the Polarbear-GBI Answer sheet to submit your answers. The two Excel file provide are called for as you go through the exercise.
moiz
Polarbear-GBIcasestudyANSWERSHEET.docxPolarbear-GBI answer sheet: Please put your answers in red
a. Place a screen shot of you GFA clearly showing the name of your scenario (must have your name or initials in it, and the map of Germany here. No screen shot-No credit for any of the following!
1. What are the optimal coordinates of the DC?
2. What is the maximum distance from the optimal DC location to a customer?
3. What is the minimum distance from the optimal DC location to a customer?
4. What are the total costs of the SC?
(Note: to compute the sum of costs or flows in GFA Results, just slightly drag the heading of the column “Period” in table “Product flows” in the space over the table)
5. Compare the data in statistics “Flows”and Table“Demand”. Do we satisfy all customer demands from the optimal DC location? If Yes, why? If no, why?
6. What are the total costs of the SC?
7. Compare the results with one and two DCs in terms of costs and responsiveness.
8. What other costs were not considered in selecting the optimal facility location in the GFA?
9. What is the most profitable SC design?
10. Is demand for all customers satisfied? Why or Why not?
11. What is the total revenue of the most profitable SC?
12. What is total profit of the most profitable SC?
13. Compare the data in statistics “Production Flows” and Table “Demand”. Does the production quantity correspond to the total demand? Explain.
14. Compare the optimal SC design as computed in the NO and the initial SC design (factory and DC in Germany) in terms of profit.
15. What other costs should be considered when redesigning the SC according to NO results?
16. What other factors, apart from costs, should be considered when re-designing the SC according to the results of the NO?
