Final Project Assignment InstructionsScenario Background: A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to

Final Project Assignment InstructionsScenario Background:

A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.

You work for Mercer Human Resources. The Mercer Human Resource Consulting website lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.

More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.

Assignment Guidance:

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

You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).

Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.

This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.

The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview.

Things to Consider:

To help you make this decision here are some things to consider:

Based on the MLR output, what variable(s) is/are significant?
From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?
- It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.
Based on the descriptive statistics, for the significant predictors, what city has the best potential?
- What city or cities fall are below the median?
- What city or cities are in the upper 3rd quartile?

Share This Post

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

Related Questions

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” o

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” of Fundamentals of Managerial Accounting Concepts. Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2.

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Researc

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret the notes disclosing the plans, reviewing the notes and explaining the post-retirement benefits that the corporations offer. This discussion supports CO-3 by

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies t

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies to borrow money. They can sign a note to borrow money from a bank or they can issue

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following: An entrepreneur is someone who has a passion and desire to organize and operate their own business. Using a business plan, an

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copil

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic, and what you learned after

KEONIA- UP TO 12/5/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS ASSIGNMENT HAS 4

KEONIA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 4 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** FISCAL ACCOUNTABILITY **** PART

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: A virtual business is any kind of business that is run via the Internet. With no physical location

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts. Not only is the employee paying taxes, but the employer is also paying additional payroll taxes. Watch the following

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the fin

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the financial statements. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Minimum 250 words At

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: When multiple employee personalities come into one business unit, there is a possibility of conflict happening.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important part of business operations. Internal controls are used to protect assets. Both companies and individuals use internal controls. Companies

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important fo

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important for making informed decisions that balance financial performance with social and environmental responsibility. It helps managers align strategies with sustainability goals, drive innovation, and support

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) reporting evaluates financial, social, and environmental impacts, providing a broader view of a company’s sustainability and long-term value creation. In analyzing trends over five years of financial

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make sure that all revenue and expenses are recorded in the correct period. Last week you learned about four

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and present a recommendation to help leadership make a loan decision. Collapse AllIntroduction This portfolio work project will

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recog

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recognition 2. Periodicity 3. Historical cost principle 4. Materiality 5. Revenue recognition 6. Going concern assumption 7.

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor