{"id":11927,"date":"2024-02-16T19:53:39","date_gmt":"2024-02-16T19:53:39","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/write-up-an-executive-summary-on-what-city-you-chose-to-open-a-second-location-in-and-justify-the-results\/"},"modified":"2024-02-16T19:53:39","modified_gmt":"2024-02-16T19:53:39","slug":"write-up-an-executive-summary-on-what-city-you-chose-to-open-a-second-location-in-and-justify-the-results","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/write-up-an-executive-summary-on-what-city-you-chose-to-open-a-second-location-in-and-justify-the-results\/","title":{"rendered":"write up an Executive Summary on what city you chose to open a second location in and justify the results."},"content":{"rendered":"

Final
\nProject Assignment Instructions<\/span><\/b><\/span><\/b><\/p>\n

Scenario
\nBackground:<\/span><\/b><\/span><\/b><\/p>\n

A marketing company based out of New
\nYork City is doing well and is looking to expand internationally. The CEO and
\nVP of Operations decide to enlist the help of a consulting firm that you work
\nfor, to help collect data and analyze market trends.<\/span><\/span><\/p>\n

You work for Mercer Human Resources.
\nThe Mercer Human Resource Consulting website<\/span><\/a> lists
\nprices of certain items in selected cities around the world. They also report
\nan overall cost-of-living index for each city compared to the costs of hundreds
\nof items in New York City (NYC). For example, London at 88.33 is 11.67% less
\nexpensive than NYC.<\/span><\/span><\/p>\n

More specifically, if you choose to
\nexplore the website further you will find a lot of fun and interesting data.
\nYou can explore the website more on your own after the course concludes.<\/span><\/span><\/p>\n

https:\/\/mobilityexchange.mercer.com\/Insights\/
\ncost-of-living-rankings#rankings<\/span><\/a><\/span><\/span><\/p>\n

Assignment
\nGuidance:<\/span><\/b><\/span><\/b><\/p>\n

In the Excel document, you will find
\nthe 2018 data for 17 cities in the data set Cost of Living. Included are the
\n2018 cost of living index, cost of a 3-bedroom apartment (per month), price of
\nmonthly transportation pass, price of a mid-range bottle of wine, price of a
\nloaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup
\nof black coffee. All prices are in U.S. dollars.<\/span><\/span><\/p>\n

You use this information to run a
\nMultiple Linear Regression to predict Cost of living, along with calculating
\nvarious descriptive statistics. This is given in the Excel output (that is, the
\nMLR has already been calculated. Your task is to interpret the data).<\/span><\/span><\/p>\n

Based on this information, in which
\ncity should you open a second office in? You must justify your answer. If you
\nwant to recommend 2 or 3 different cities and rank them based on the data and
\nyour findings, this is fine as well.<\/span><\/b><\/span><\/p>\n

Deliverable
\nRequirements:<\/span><\/b><\/span><\/b><\/p>\n

This should be \u00be to 1 page, no more
\nthan 1 single-spaced page in length, using 12-point Times New Roman font. You
\ndo not need to do any calculations, but you do need to pick a city to open a
\nsecond location at and justify your answer based upon the provided results of
\nthe Multiple Linear Regression.<\/span><\/span><\/p>\n

The format of this assignment will be
\nan Executive Summary. Think of this assignment as the first page of a much
\nlonger report, known as an Executive Summary, that essentially summarizes your
\nfindings briefly and at a high level. This needs to be written up neatly and
\nprofessionally. This would be something you would present at a board meeting in
\na corporate environment. If you are unsure of an Executive Summary, this
\nresource can help with an overview. How to Write an Executive Summary That
\nGets the Job Done 2023.pdf<\/span><\/a><\/span><\/span><\/p>\n

Things to
\nConsider:<\/span><\/b><\/span><\/b><\/p>\n

To help you make this decision here
\nare some things to consider:<\/span><\/span><\/p>\n