dolution

dolution.

Open the Trust SPSS data-set and perform the following operations:

a. The variable q64 (country) is a nominal variable with five response categories, each corresponding to a country. Transform it into five dummy variables, one for each country, by using the COMPUTE command (you may find it easier by exploiting SPSS syntax

b. Create a MULTIPLE RESPONSE SET (see SPSS Help and the DATA menu) for the dummy variables recording the point of purchase (q8a to q8d) and name it as POP

c. Using the CUSTOM TABLE command under the ANALYZE/TABLE menu, create a frequency table to show the proportion of points of purchase across countries (POP by q64)

d. Create a pie chart showing the proportion of points of purchase for the whole data-set.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

The purpose of this exercise is to get you familiar with strategy terms introduced and defined in this chapter. Let’s apply these terms to the Cohesion Case on Nestlé S.A. (traded as NSRGY). Instructions Step 1 Go to the Nestlé Global corporate website. Scroll to the bottom of the site and find Investors; click on Publications and download the most recent Annual Review report. The Annual Review contains excellent information for developing a list of internal strengths and weaknesses for Nestlé. Step 2 From your college library website, download a copy of Standard & Poor’s Industry Surveys for the food industry. This document will contain excellent information for developing a list of external opportunities and threats facing Nestlé. You could also refer to Citi group’s credit cards page, IBIS World, ValueLine, and Mergent Online, if these sources are available in your college library. Step 3 Using the Internet, find out and print information about Nestlé’s two major competitors: Danone (DANOY) and Mondelēz International (MDLZ). Step 4 Using the Nestlé Cohesion Case and with the help of the information gathered above, identify what you consider to be Nestlé’s three major strengths, three major weaknesses, three major opportunities, and three major threats. Each factor listed for this exercise must include a percentage (%), number (#), dollar ($), or ratio (employees per share) to reveal some quantified fact or trend. These factors provide the underlying basis for a strategic plan because a firm strives to take advantage of strengths, improve weaknesses, avoid threats, and capitalize on opportunities. Estimate the numbers as needed. Step 5 Through class discussion, compare your lists of external and internal factors to those developed by other students and add to your lists of factors. Keep this information for use in later exercises at the end of other chapters. Step 6 Be mindful that whatever case company is assigned to you or your team this semester, you can start to update the information on your company by following the steps listed for any publicly held firm.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

For each question, provide me with a screenshot of the query and its result in MySQL.

  1. Find a query that shows attributes ChooseName1, ChooseName3, and ChooseNameNum (only when there is a match on ChooseName2 between Tables A and B).
  2. Find a query that shows the same list as the question above but also ChooseName3 and its value when there is no match with Table A. (normally in individual Assignment 3, you entered instances in Table B that are not matched in Table A. If not, please do it now).
  3. Find a query that returns the same as question a. but only for ChooseNameNum values that are greater than the average of ChooseNameNum.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

Developing a Global Advertising Campaign Plan

You must prepare a global advertising campaign for a global brand you choose for a specific market you choose. You must include the following topics in your campaign plan.

A. Research/Introduction: Background information (history) about the global brand in the market you choose. If possible then please identify the current market share. Brief competition analysis. Who are the biggest competitors of your global brand in this market. Very brief information about them.

B. Target Audience: Who will be the primary consumers that your brand in this campaign will talk to? Don’t forget to pay attention to Hofstede’s culture scores for the market you choose. You can write about some of these topics: What are their demographic characterstics (such as gender, education, marital status, age…), psychographic characteristics (such as main concerns, desires, motivations, life-styles, worries…) and behavioral characteristics (such as when do they use your brand?, where?, with whom?, why? and how frequently?)

C. Current Communication Problem: What is missing in the current marketing communication of the brand in the specific market? What is the thing that needs to be focused on the advertising campaign? Identification of the brand’s communicational problem or advertising need in the context of the target audience selected.

D. Marketing Communication strategy/message/positioning: How do you want your target audience know your brand? What should come to the their minds when they think or hear about or see your brand? The answer which is the place your brand occupies in the target audiences’ minds is called positioning. For example: the positioning of Volvo cars is “safetyâ€Â. Positioning should be related your brands’ core values, competencies, perspective, philosophy, culture etc. The positioning should be the magnet that will appeal/attract the target audience to wish to gather around or come closer to the brand.

E. The slogan: Please identify a good slogan that will fit with your positioning and will lead the positioning for the goals of the campaign.

F. Ad Application: TV or Internet Display Commercial: Write a film scenario/script/synopsis according to the message/positioning/slogan you have already developed. Please remember to pay attention to Hofstede’s six cultural dimensions’scores and tailor your film scenario/script/synopsis to these cultural dimensions. After writing it, please very clearly explain how you matched up (tailored) your scenario/script/synopsis based on these scores. You must provide examples (words, sentences, seen things…) from your scenario/script/synopsis for all of the six cultural dimensions.

G. Planned Integrated Marketing Communication Tools: What kind of events or corporate social responsibility projects would you also make to help your tv advertising? Or would you also get help from social media? How? Please provide some information about the events, corporate social responsibility projects or social media support you plan to use in your campaign.

I know this is a big assignment, but its a common one.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"