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

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of th

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of the file. Worksheet Problem 1 Gulf Coast Paddle produces paddleboards for retailers in the United States. The cost of

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting help aid associations make tough choices in Haiti?Links to an external site. Issues in Accounting Education, 33(1), 17–28. Answer the following questions:

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asba

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asbat has a calendar year-end and is audited annually. Asbat only operates in the United States and is not subject to state or local income taxation. Its

I need help with my Ethics project. My work should be formatted and cited in current APA style with appropriate references. No plagiarism. No flags on turnitin.com. The Institute of Management Acco

I need help with my Ethics project. My work should be formatted and cited in current APA style with appropriate references. No plagiarism. No flags on turnitin.com. The Institute of Management Accountants, like other professional organizations, has produced a statement of ethics that their members are expected to follow. Find the

Module 2 – CaseCost AnalysisAssignment OverviewPricing Considerations Analyzing accounting data is essential for informed financial decisions and long-term sustainability. Large quantity price reducti

Module 2 – CaseCost AnalysisAssignment OverviewPricing Considerations Analyzing accounting data is essential for informed financial decisions and long-term sustainability. Large quantity price reductions boost sales but impact profit margins. Discontinuing a product affects supply chain, finance, and customer relations, while make-or-buy decisions influence cost control and operational efficiency, shaping overall

Module 2 – SLPCost AnalysisAssignment OverviewCost Analysis Understanding the interaction between costs, breakeven points, economic changes, and the broader economy is important for business planning.

Module 2 – SLPCost AnalysisAssignment OverviewCost Analysis Understanding the interaction between costs, breakeven points, economic changes, and the broader economy is important for business planning. It helps organizations adjust pricing, manage expenses, and forecast profits. ***SLP 2 Must be Completed Before Case 2*** Module 2 SLP Resources Variable Cost vs.

Locate a U.S.-based, publicly listed company of interest to you. This should be a company that has made a substantive amount of sustainability-related reporting or disclosures in its latest annual rep

Locate a U.S.-based, publicly listed company of interest to you. This should be a company that has made a substantive amount of sustainability-related reporting or disclosures in its latest annual report on Form 10K. (Use only information published within the last two years.) Note: You will find this type of

Analytics Mindset – TechWear You will need Microsoft Excel to prepare this assignment. We suggest you start on this assignment early in the week, as it will, most likely, take you some time to complet

Analytics Mindset – TechWear You will need Microsoft Excel to prepare this assignment. We suggest you start on this assignment early in the week, as it will, most likely, take you some time to complete. Read below (and/or download the attached Word file TechWear (Links to an external site.) Download TechWear (Links to an

You have been provided with a significant amount of material from Ernst & Young’s Academic Resource Center on two converged accounting standards that cover revenue recognition and lease accounting

You have been provided with a significant amount of material from Ernst & Young’s Academic Resource Center on two converged accounting standards that cover revenue recognition and lease accounting. These are major converged accounting standards, which were subject to intense scrutiny not only by boards but also by publicly listed

You have been provided with a significant amount of material from Ernst & Young’s Academic Resource Center on two converged accounting standards that cover revenue recognition and lease accounting

It is very important as a professional in the accounting field to stay up to date on the key topics being addressed by the PCAOB (Public Company Accounting Oversight Board), including findings of its

It is very important as a professional in the accounting field to stay up to date on the key topics being addressed by the PCAOB (Public Company Accounting Oversight Board), including findings of its most recent inspections of public company audits. The major emphasis in this module is on auditing

Option #2: Audit Procedures to Address Audit Risks This assignment is constructed to examine your understanding of the importance of proper auditing, done in accordance with generally accepted auditin

Option #2: Audit Procedures to Address Audit Risks This assignment is constructed to examine your understanding of the importance of proper auditing, done in accordance with generally accepted auditing standards, of the information provided by the entity (the audit client). Assignment Requirements: Download the Word document and fill in the

Locate a publicly owned corporation’s financial statements and interpret the financial results using what you have learned from this week and this course. After reviewing the company’s financials, exp

Locate a publicly owned corporation’s financial statements and interpret the financial results using what you have learned from this week and this course. After reviewing the company’s financials, explain whether the organization is sound, and if not, suggest ways to improve its financials. Be sure to include the link to your

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

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

Read the following article: Lawson, R. (2019, March 1). New competencies for management accountants.Links to an external site.. Strategic Finance. Focus on one of the major subjects of this article th

Read the following article: Lawson, R. (2019, March 1). New competencies for management accountants.Links to an external site.. Strategic Finance. Focus on one of the major subjects of this article that is of interest to you. These subjects include (but are not limited to): Include the subject you have decided to

Select one of the following (either Fringe Benefits or Example Disability/Economic Damages Claim) and address the associated items or questions as your initial post for this discussion board. Copy and

Select one of the following (either Fringe Benefits or Example Disability/Economic Damages Claim) and address the associated items or questions as your initial post for this discussion board. Copy and paste your selected item into your initial response in bold type, so that you are sure to answer each aspect of your