Our Services

Get 15% Discount on your First Order

Financial modelling – Guangzhou Mars

May 17, 2023

You are a consultant working in the fast moving consumer goods (FMCG) sector. Your client competes in the confectionary sub-sector, in particular the chocolate market. You have been engaged to analyse various issues relating to your client’s brand performance. For this exercise, there are nine major brands in the retail chocolate market, as outlined below: Brand Category Description Mars Budget The chocolate does not contain milk. Kit Kat Budget The chocolate does not contain milk. Ferrero Rocher Budget This product does not contain milk. Cadbury Mainstream The chocolate contains a fair amount of milk. Patchi Mainstream Contains milk. Galaxy Mainstream Uses small amount of milk Guy Lian Premium Contains bull milk. Toblerone Premium Contains milk. Lindt & Sprungli Premium Contains milk.

These nine brands of chocolate are stocked in all major grocery stores in China. Your group will be assigned one of nine brands to analyse. Your client is interested in various aspects of brand performance. You must analyse the data and write a report explaining your findings. The objectives of this assignment are to test your understanding of the various data modelling (regression) techniques covered in the course, expose you to the kind of work you may encounter in your professional career and test your ability to write reports that have technical depth but can be understood by a non-technical audience.

Data The data can be found in the file: China_Chocolate.xls. The data file contains time series data in monthly frequency from January 1997 to December 2017. The first nine columns contain volume sales (in tonnes) for each of the various brands of chocolate. The next nine columns contain the price per 100g (in US dollars and cents). In addition to the existing data, you will need to create additional time series variables, as required by the questions below.

QUESTION 1

By using MS Excel, construct a line chart for your given brand of chocolate. Comment on any features of interest. [10 marks]

QUESTION 2

Estimate a model of volume sales using a trend component. In other words, estimate the following: Where yt = Volume sales in period t T = Trend Comment on your findings. How do your findings for the trend variable compare to your observations in Question1? [10 marks] Hint : To complete this step, you must create a trend variable.

QUESTION 3

Refine the model you created in Question 2 by adding a seasonal index. In other words, estimate the following: Where SI = Seasonal Index Are there any months that exhibit above average sales? What do you think is the reason? How do your findings compare to your observations in previous questions? Comment on your findings. [10 marks] Hint : To complete this step, you must create a seasonal index.

#Financial #modelling #Guangzhou #Mars

Financial, Guangzhou, Mars, Modelling

Share This Post

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

Related Questions

On the morning of September 11, 2001, two airplanes, American

On the morning of September 11, 2001, two airplanes, American Airlines Flight 11 and United Airlines Flight 175, collided into the north and south towers (the main “Twin Towers”) of the World Trade Center complex in New York City. Shortly thereafter, as a result of fires caused by burning jet

What is the distinction between healthcare as a private benefit

What is the distinction between healthcare as a private benefit and healthcare as a private choice? How does this distinction impact political decisions about healthcare by politicians and voters? What is the difference between distributive and commutative justice? How do desert and need factor in ethical decisions about health care?

NURS 450: Public/Community Health Experiential Nursing Learning Course Assignment: Experiential Health

NURS 450: Public/Community Health Experiential Nursing Learning Course Assignment: Experiential Health PowerPoint Presentation 60 points Assignment: Following the experiential learning hours, the student will create a PowerPoint presentation about their experience. In addition to the information below, the PowerPoint should include narration. The assignment will be evaluated for content and

Using the Wall Street Journal menu link, select an article

Using the Wall Street Journal menu link, select an article that relates to either (1) building high-performance teams; or (2) culture and diversity in teams. Briefly explain why you chose the article and describe two ideas from the article that you could use in your growth as a leader. Be

Please choose a landmark case from the list provided below. Then, provide a brief description of the case selected. Next, provide the historical

Please choose a landmark case from the list provided below. Then, provide a brief description of the case selected. Next, provide the historical context in which the case was argued (e.g., what events were taking place in society that led the US Supreme Court to hear this particular case).

Clinical Trials at National Institute of Mental Health find four

Clinical Trials at National Institute of Mental Health find four research studies in different topic areas in the National Institute of Mental Health (NIMH) website. (website is find below) For example, you might look at the studies being conducted on panic disorder and depression. Read about each study and create

Write a 1,350-word addressing the following issue: Discuss scientific communication

Write a 1,350-word addressing the following issue: Discuss scientific communication from an ethical perspective and how the scientific community attempts to monitor the information that is communicated. Reference at least three journal resources, Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in

As a future business leader where do you see the

As a future business leader where do you see the music industry expanding to in the 21st century? What platforms do you believe will be utilized to reach the largest audience? Can American Music continue to compete on the World market? How does the music industry continue to be profitable

Please follow the project Action Item and Provide Take a

Please follow the project Action Item and Provide Take a screenshot of the terminal window showing the content of the passwd file. Weekly Learning and Reflection In two to three paragraphs (i.e., sentences, not bullet lists) using APA style citations if needed, summarize, and interact with the content covered in

HHow were the policies and/or attitudes of the presidential

Read and analyze the documents on American policy in the Vietnam War from the Eisenhower through the Nixon administration and explain in your paper the reasons for American involvement in the war. Why did government officials feel it necessary to defend South Vietnam? What did they fear if the South

MSN 5300 MRU Correlational Analysis Discussion Nursing Assignment Help

I’m studying for my Health & Medical class and need an explanation. In this week’s please discuss the purpose of correlational analysis. Expert Solution Preview Introduction: Correlational analysis is a statistical method widely used in health and medical research to examine the relationship between two or more variables. It allows

After reviewing the Smartest Guys in the Room, identify a

After reviewing the Smartest Guys in the Room, identify a single, specific ethical issueand provide a 3-4 page paper (not including title and reference pages) formatted according to the APA 7th edition for a Student Paper, that examines the ethical issue based on both a compliance and value-based ethical approach.

Finished Financial Paper needs to be reworked DRAFTED to fit

Finished Financial Paper needs to be reworked DRAFTED to fit Professor Template provided. is written just need calculation ratios from two below only these ratios ARE REQUIRED BUT ALL MUST BE COMPLETED ACCORDING TO 2 PRPOVIDED This needs to be exact do not take if its not correct I

During this semester, you worked through a series of 15

During this semester, you worked through a series of 15 modules which addressed the following competencies: Identify orally and in writing educational goals of an early childhood program. Discuss orally and in writing how an early childhood center can contribute to a young child’s growth and development. Identify orally and

NUS201 LPN to RN Transition – Theory Nursing Assignment Help

must analyze a pre-selected article with respect to Roy’s Adaptation Model (RAM) and write a Paper discussing the impact of RAM on care. (Choose a peer-reviewed article that is appropriate and within 5 years) The following matters must be discussed in the paper and presented in class: The author(s) of

Women’s Health Week 2 Discussion- Biological Explanations of Women’s Health

Women’s Health Week 2 Discussion- Biological Explanations of Women’s Health Discussion Topic After reading about the economic and biological impact of providing healthcare to women, should women have the right to decline taking a drug based on their sociological beliefs (you can also discuss their religious/spiritual beliefs as well)? Why

COAL

Description Select ONE topic that we touched on in this lesson and do some of your own research for recent articles. There are a number of topics you could go into more depth on as examples: electric grid/smart grid coal and climate change coal vs natural gas plants base-load vs

Compare “The Star-Spangled Banner,” the current US National Anthem, to

Compare “The Star-Spangled Banner,” the current US National Anthem, to “Life Every Voice,” a song that has been discussed as a possible replacement for it. Do not choose one over the other, simply compare them in a balanced way. Present both the advantages and disadvantages: do not choose a side