Answer the question below and need Excel

 my coursework information is down there and write around 2000words

 

 

 

Faculty of Business, Environment and Society

 

 

 

 

Module learning outcomes being assessed

1. Analyse realistic management problems based on analysis of data sets and case materials.

 

2. Apply the techniques studied to interpret and communicate findings on data analysis.

 

 

Assignment Information

 

Your coursework consists of the following four tasks based on Cocoa-Delight case study and data supplied in moodle. Some similar tasks will be performed in seminars with the tutors’ guidance. However, some parts of these tasks will require independent study. Your work will have to be submitted on the designated section of the module’s Moodle page AS A SINGLE EXCEL FILE containing all four tasks.

 

The Case Study & Tasks

Cocoa-Delight is a chocolate and bakery company based in the UK. They have been operating very successfully in the snacks industry for many years. Catering for consumers’ needs and demand is the key to their success and sustainability.  They collect consumer data on a regular basis and analyse it to identify the growing trend in snacks consumption. 

 

Recently they have identified that the British population is increasingly choosing healthier snacks with low sugar content. They have also established that this is strongly correlated with an Olympic spirit. To exploit this new trend Cocoa-Delight is planning to launch a new product after the Brazil Summer Olympic event. Cocoa-Delight’s innovation and product design team plan to market a chocolate bar for keeping weight under control, with average calories of 189per unit.

 

Cocoa-Delight has hired you for your analytical insights. Your job is to collate and analyse a range of data to recommend a competitive product for the healthy snack food market. See Excel file “CW2 Raw Data.xls” for raw data.

 

Task 1: [30 Marks]

Using the food table in the dataset provided, prepare a list of alternative snacks i.e. direct competitors to the new product. You are required to:

 

1. Sort, list & format the dataset into appropriate categories related to food groups e.g. chocolate-based snacks, baked food, processed food, fast food, healthier snacks etc. 

[10 marks]

2. Prepare appropriate graphs displaying & comparing calories, of the categories.

[5 marks]

3. Calculate summary statistics such as the mean, median and standard deviations of the categories. 

[5 marks]

4. Give a brief critical discussion of the summary statistics from part 3.

[5 marks]

5. What advice would you give for weight-loss purposes – which snacks have to be chosen? Is the chocolate bar going to be competitive in the market? 

[5 marks]

 

 

Task 2 [25 Marks]

 

Cocoa-Delight is now interested in trying to estimate how sales are influenced by the price of their products. To do this, the company randomly chooses 8 UK cities and offers the candy bar at different prices and run a regression analysis on price and sales data. 

 

CityPrice (£)Sales

London1.5693

Coventry2.5576

Manchester2.7360

Derby1.9881

Cardiff3.6445

Preston3.8935

Cardiff3.5762

          Swansea  4.50         20

 

[Continued on next page]

 

1. Using sales as the dependent variable, conduct linear regression analysis*. 

[5 marks]

2. Generate the scatterplot. 

[4 marks]

3. Write the regression equation using the results of the excel table. 

[5 marks]

4. Determine & interpret the slope and the intercept. 

[6 marks]

5. Determine what percentage of the total variation in candy bar sales is explained by prices? 

[5 marks]

 

*[Perform, using Excel, Data Analysis Pack, Regression function, the regression analysi

 

Task 3: [30 Marks]

 

Cocoa-Delight wants to prepare a company event to launchits new candy bar. The following table gives the key activities required for the project.

 

 

Activity

 

 

Description

 

Proceeding Activity

 

Duration (Days)

 

A

Agree event outline

-

4

B

Identify suitable marketing companies

A

2

C

Agree detailed brief for event

B

6

D

Circulate brief to marketing companies

A

6

E

Agree contract with marketing companies

B

2

F

Select marketing company

C, E

1

G

Send confirmation of event to employees of Cocoa-Delight 

D

2

H

Agree content of marketing event

F, G

2

I

Prepare content for marketing event

H

5

J

Prepare venue for event

G

1

K

Launch marketing campaign

I, J

-

 

 

Using the above table determine:

 

[Continued on next page]

 

1. Using the above table construct a network diagram for the project.

[5 marks]

2. Now construct a precedence diagram for the project.

[10 marks]

3. Determine and state the critical path

[10 marks]

4. List and state the float associated with each activity

[3 marks]

5. What is the complete duration of the project?

[2 marks]

 

Task 4 [15 Marks]

 

Write a summary report based on the results of the three tasks above.

 

 

Guidelines for completing task:

 

You are to follow the procedures, techniques and Excel based & long hand formula taught in seminars to answer questions related to categorising, tabling, central tendency, variance and regression analysis calculations. Theories delivered in lectures will help you to answer descriptive questions. 

 

 

Answers

Related Questions

Answer this Question ma man A-plus...

Hey Guys , I want someone help me to answer all this 18 qusition than who can do it ?  Mr. A-plus , you can do it ma man !! - This is all my Questi...

Who is here .....

Hey Guys , I want someone help me to answer all this 18 qusition than who can do it ?  - This is all my Question for Anthropology class.  The inst...

Who is here :)...

Hey Guys , I want someone help me to answer all this 18 qusition than who can do it ?  - This is all my Question for Anthropology class.  The inst...

As a business owner making a final decision regard...

As a business owner making a final decision regarding the international aspects of a business decision, you may decide to set up a table with the risk...

American Welfare...

This week we are looking at a variety of social policy issues, but will specifically address poverty in our discussion. (1) What factors do you belie...

sources note...

Hi, i would like to make for me 2 soures note.my topic is about causes of Abourtion in U.S.I narrowed my topic to causes of teenagers abortion in u.s...

Philosophy Question (250-300 words)...

What does the philosopher Rousseau mean when he says: Man is ‘everywhere he is in chains’ and must “be forced to be free”? Does he make a good...

Marketing paper!...

   Advertising Select four different ads from a particular product category (say, cars) from at least 3 different paid media environments (i.e., n...

general...

Q1a) KNG issued a 90-day, 7% note for $200,000, dated February 3rd to Amy Co. on account. (Assume a 360-day year when calculating interest.)Determine...

Who is here to help me .....

Hey Guys , I want someone help me to answer all this 18 qusition than who can do it ?  - This is all my Question for Anthropology class.  The inst...

computer...

Hey,I was looking for you but you didn't show up...  Anyway I edited the last homework and I uploaded the new one so u can work on it.what you n...

Begginner's C++, modify this magic number prog...

  Modify the magic number program so that the user can guess at more than one magic number where the magic number is an integer between 1 and 20.  W...

ETH 376 Week 5 Need Original non Plagiarized Essay...

Resource: The ABC Corporation Case located on your student website Write a 750- to 1,050-word paper accomplishing the following: ·        ...

I need someone to complete my online course: Ameri...

I need someone to complete my online course: American Literature after the Civil WarThe class contains:- 8 weekly forum post; Each initial forum post...

Journalize...

question 1:cash received during the week ended September 23 for cash sales was $15,543.00 and the amount indicated by the cash register total was $15,...

Final Info231...

Final ProjectThe Final Project consists of building an executable monetary conversion program to be submitted by the final day of the course.Focus of...

Arrays and Character Arrays wk4...

Arrays Define an Array and why you would use one. Provide an example that is not from the text. Respond to at least two of your classmates’ posting...

Course Project Part I: Interview and Background R...

Course Project Part I:  Interview and Background ResearchRefer to the Course Project Overview in Module 1. Early in the course, you have selected a...

Eng Summary and response...

its only three pages, the first pragraghe is a summary about the essay that you need to read and the other pragraghes should be your response about th...

environmental...

Project 3               Project format: Each page must be typed in 12-point Times New Roman or similar typeface, 1” margins on all sides, d...

hca250 wk 5...

Write a 700- to 1,050-word paper on managing change in the workplace based on the following scenario: A major health care organization has decided to...

Course Project Part I: Interview and Background R...

 Course Project Part I:  Interview and Background ResearchRefer to the Course Project Overview in Module 1. Early in the course, you have selected...

Few MCQ...

5. The owner of BobCats R Us paid his personal MasterCard bill using a company check. The correct entry to record the transaction is: 6.  The busine...

QNT/351 University of Phoenix week 4 DQs...

Discussion Questions  QUESTION 1: What is the importance of a 5% significance level? Why would you choose 5% as opposed to 10% or 1%? What effect doe...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it