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 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. 

 

 

Attachments: 

Duepapers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.