From the textbook, Operations Management: Processes and Supply Chains $13$th Edition by Lee J Krajewski, Refer to the Active Model Exercise provided at the end of Chapter $13$ on page $566$ of text. $[$Students should make use of the Microft Excel file is provided in Module $0,$ which consists setups of all Active Model Exercises.$]$ Please answer the following four questions related to the Active Model Exercise and submit your answers in the submission window. $($Please ensure to click on "Reset Data" button before attempting each question.$)$

In your submission, you do not need to rewrite the questions; just itemize the answers as #$1,$ #$2,$ etc. You will be graded based on the accuracy and completeness your answers.

Questions

What is the total load$$distance score to the new Health$-$Watch medical facility if it is located at the center of gravity?

Fix the y$-$coordinate $($that is$,$ keep the y$-$coordinate constant$),$ and use the scroll bar to modify the x$-$coordinate. Can you reduce the total load$$distance score?

Fix the x$-$coordinate, and use the scroll bar to modify the y$-$coordinate. Can you reduce the total load$$distance score?

The center of gravity does not necessarily find the site with the minimum total load$$distance score. Use both scroll bars to move the trial location, and see whether you can improve $($lower$)$ the total load$$distance score.