Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Answer the question below and need Excel  Business management homework help
Â 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 CocoaDelight 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
CocoaDelight 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 CocoaDelight is planning to launch a newÂ product after the Brazil Summer Olympic event. CocoaDelightâs innovation and product design team plan to market a chocolate bar for keeping weight under control, with average calories of 189per unit.
Â
CocoaDelight 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. chocolatebased 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 weightloss purposes â which snacks have to be chosen? Is the chocolate bar going to be competitive in the market?Â
[5 marks]
Â
Â
Task 2Â [25 Marks]
Â
CocoaDelight 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]
Â
CocoaDelight 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 CocoaDelightÂ
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.Â
Â
Â
Attachments: