Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Homework Help/Study Tips Expert

You need to use Microsoft Excel for the tasks in the following Project.

Aims:

To analyse a set of data, and prepare a memo, identifying and describeing your insights into the operation of Todd Restaurants.

Learning Objectives:

In the process of this assessment task you will:

• learn to plan, schedule and execute project tasks with a view to improve your personal productivity;
• gain an understanding of some typical issues related to the operation of a medium size business;
• use the functionality of Microsoft Excel 2007/2010 to manipulate the sales and marketing data, analyse it and visualise it in tabular and chart form; and prepare a brief memo of your business observations and recommendations.

Case Background:

Todd Restaurants offer national chain of full-service, casual-themed restaurants in Australia. You have been offered the job of vice president of operations for Todd Restaurants. During your first week on the job, Joshua Todd, your boss and CEO of the company, has asked you to provide an analysis of how well the company’s restaurants are performing. Specifically, he would like to know which units and regions are performing extremely well, which are performing moderately well, and which are underperforming.

Assignment Instructions:

The CEO asks you to identify where to spend time and focus efforts to improve the overall health of the company.

1) Review the data that Joshua has provided you from the data warehouse in Data.Xlsx file. Rename the spreadsheet as: Lastname_Firstname.xlsx.
 
2) Use the Informationworksheet for your calculations and analysis to provide results for each of the following tasks:

• Use ‘Restaurant Size by Sales’ column in ‘Information’ worksheet to categorize each restaurant size as ‘Small’, ‘Medium’, ‘Large’ or ‘Really Big’ according to their ‘Annual Store Sales’by using the following table. (You need to use VLOOKUP function for this; and the table needs to be stored in a new worksheet: ‘Size Table’)

705_annual sales level.jpg

• find out the number of years each restaurant is operating in the ‘Store Age (years)’ column. (you need to use a formula that find outs (‘Data Collection Date’ – ‘Store Opening Date’)/365))

• find out Total, Mean, Median, Maximum, Minimum, Range and Standard Deviation for all relevant columns, at the end of the data in the ‘Information’ worksheet.

3) Using the Information worksheet, Joshua needs to have a summary reportfor each region. The report should include the following:

a) Total Annual Sales
b) Total number of Seats
c) Average Annual Sales   
d) Average Store Age (years)
e) Total number of Restaurants   
f) Total number of advertising Restaurants

• Use the table in the ‘Summary Report’ worksheet for your calculations. For this report you should not use any Pivot Table analyses.  Instead you need to use functions such as SUMIF, AVERAGEIF, COUNTIFS, etc…

• The report table needs to be sorted by ' Total Annual Sales’ column in descending order.

• All the cells in the report table need to be formatted appropriately.

4) Using the Information worksheet, Joshua also needs to have some analyses report for  the following problems:

a) Which region has the highest ‘Annual Store Sales’ for ‘Really Big’ size restaurants
b) Which region has the lowest ‘Annual Store Sales’ for ‘Really Big’ size restaurants
c) What is the total number of seats for ‘Medium’ size restaurants in the highest ‘Annual Store Sales’ region?
d) What is the total number of seats for ‘Large’ size restaurants in the lowest ‘Annual Store Sales’ region?
e) What is the best annual sale restaurant at the worst region?
f) What is the worst annual sale restaurant at the best region?
g) What is the lowest age of the restaurant in the highest ‘Annual Store Sales’ region?
h) What is the highest age of the restaurant in the lowest ‘Annual Store Sales’ region?

• You should use Pivot Tables for these analyses. Provide your answers in the Solution Report worksheet using cell referencing to the results from your pivot tables.

• Create as many pivot tables as needed to show your results.

• You can include best and worst in the same pivot tables.

• Be sure to use filtering and/or sorting where needed to get exact results. For all worsts selling products be sure the amount is greater than 0.

• Make sure to show the results of your pivot table analysis by cells reference in the Solution Reportworksheet.

• For each problem provide a chart with clear indication of the best/worst results. (You can show both best and worst in a same chart). 

5) Prepare a Report in Microsoft Word that includes:

• An introduction

• The results from the Excel work sheet. You need to follow the exact problems sequence and copy and paste the necessary analyses (summary tables and graphs) from the excel file into the report.

• Discussion of your observations and recommendations. In your discussion include also which units and regions are performing extremely well, which are performing moderately well, and which are underperforming.

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M9409

Have any Question? 


Related Questions in Homework Help/Study Tips

Assignment disorders of the veins and arteriesadvanced

Assignment: Disorders of the Veins and Arteries Advanced practice nurses often treat patients with vein and artery disorders such as chronic venous insufficiency (CVI) and deep venous thrombosis (DVT). While the symptoms ...

Critical thinking reasoning abilities and content specific

Critical thinking, reasoning abilities, and content specific competencies are essential skillsets for business leaders. The ethical application of these skillsets to business principles in a 21st century globalized econo ...

Assignment - research and argumentative essaywhat is

Assignment - Research and Argumentative Essay What is burnout and what factors contribute to an employee's perception of burnout in the workplace (e.g., personal characteristics, characteristics of their job, and the wor ...

Part 11 explain the difference between a genotype and a

Part 1: 1. Explain the difference between a genotype and a phenotype. 2. What are the 3 different ways that trisomy 21 can be expressed? 3. What are the differences and similarities between Klinefelter syndrome and Turne ...

Potential essay exam question one of the following

Potential Essay Exam Question One of the following questions will be on your essay exam on September 29. Prepare to write two to three pages in answer to the question. You will NOT need a Blue Book. In your essay be sure ...

Apply critical-thinking skills to answer the following

Apply critical-thinking skills to answer the following questions in a 1,050- to 1,400-word paper, based on this week's readings. What are the dimensions of cultural diversity? Identify and briefly explain the dimensions ...

Response to dqaccording to kapucu 2016 several scholarly

Response to DQ According to (Kapucu, 2016), several scholarly works have been documented, heightening military involvement in response too natural and or man-made disasters, due in part to both historical factors about t ...

1youd like to ask a question that can be expected to bring

1. You'd like to ask a question that can be expected to bring out client feelings or emotions. Your best bet is a question that begins with a. could. b. what. c. how. d. why. 2. Which of the following is NOT an open-ende ...

Assignment1 discuss what is contained in a sexual battery

Assignment 1. Discuss what is contained in a sexual battery kit, the significance of each item, and what evidential value it may hold to prove a rape occurred. 2. Describe at least three of the methods that can be used b ...

The angelino familythe angelino family has five children

The Angelino Family The Angelino family has five children and a sixth is on the way. The children are ages 14 (girl), 12 (boy), 10 (girl), 7 (boy), and 6 (girl). They all attend a nearby parochial school. Mr. Angelino ow ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate