Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders of ABC Auto Parts (“ABC” or the “Company”) to evaluate an unsolicited takeover bid for $175 million from the Company’s largest

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ ord

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ orders. There are many other manufacturers who produce similar motors. Ridgecrest believes that continuously improving its manufacturing processes and having satisfied

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this as

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this assignment does not have a standard template. Complete the balanced score card in presentation format to present to management your

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: Gross domestic product (GDP) is a measurement of how much people produce of goods and services. What

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: You have recently been promoted to the position of controller for M&K Industries. You have partnered

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: You have completed several assignments in the online learning platform. Everyone is challenged by different parts. Learning how to successfully

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: You have learned about supply and demand. You know that when prices go up, people buy

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Researc

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic and present your findings. Include a summary of the topic, why you found the topic

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freez

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freezes the biscuit dough, which it then sells to the franchise stores where it is thawed and baked in

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullse

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullseye, a general merchandise retailer with hundreds of stores throughout the United States. Bullseye is

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence.

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence. So yeah, we got fed up and threw this dumb little script. It just keeps posting this same question after approximately

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: Tax code changes in the United States occur for several reasons, reflecting both economic and social

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles. Review one journal article written in the l

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles.  Review one journal article written in the last 5 years concerning individualizing instruction in early childhood classrooms. Please use Google Scholars from Miami Dade College for the article. Directions: Read

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, audit evidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedu

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, auditevidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedures. In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic

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: Tax planning involves strategic decision making to minimize tax liability within the bounds of the law.

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. Understanding tax concepts, po

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.  Understanding tax concepts, policies, and effective tax planning strategies is essential for individuals. Explore the rationale behind two of the tax concepts, policies, or

Corporation: Walmart In this discussion, please reflect on changes in accounting principles and error corrections. How can you determine the difference between error correction and fraud? Add an exa

Corporation: Walmart  In this discussion, please reflect on changes in accounting principles and error corrections.  How can you determine the difference between error correction and fraud? Add an example from a public corporation. Include a copy of the corporation’s disclosure note and explain the effect the change or error correction