Ask Question, Ask an Expert

+61-413 786 465

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

Project exploring the value of project management linking

Project: Exploring the value of project management: Linking Project Management Performance and Project Success. A Case Study of Toyota Motor Corporation 1. Purpose of the proposed investigation: This section should inclu ...

Assignment interpersonal communication at your

Assignment : Interpersonal Communication at Your Workplace For this assignment, you have the opportunity to apply what you have learned from the assigned module readings and any additional research you may have done. You ...

Question ch 21a welcoming environment1in what way does your

Question: Ch. 21 A welcoming environment 1. In what way does your institution send the message "you are welcome here"? 2. Do you see any barriers that might send another message? 3. Is the mission statement visible? 4. W ...

Assignment bullresearch the access to essential health

Assignment: • Research the access to essential health commodities. Medical innovations are failing many patients globally. • Describe the issues, barriers, and challenges for the neglected populations. • Discuss how acce ...

Short answers questions1- what are the effects of race and

Short answers questions: 1- What are the effects of Race and class in shaping a child's personality? 2- Does Macionis claim that watching TV -(remember media is the 4th agent of socialization)- is harmful for children? e ...

Question submit a powerpoint presentation based on four

Question: Submit a PowerPoint Presentation based on four different conflicts you have encountered. These conflicts can be work related or personal conflicts. The presentation will consist of 5 slides and must have at lea ...

Question need two different postsresponses with 200 words

Question: Need two different posts(responses) with 200 words each on the below topic. Your company is experiencing decline in business because of competition. Your manager thinks they may be able to turn the company arou ...

Question please answer the following question in 2-3

Question: Please, answer the following question in 2-3 paragraphs, the answer requires two references: 1). from peer-reviewed Nursing Journal not older than 5 years, and 2). from the following text book: Title: Nursing H ...

Instructionsyou have been hired by a general contractor to

Instructions You have been hired by a general contractor to provide safety training for 20 construction workers. The first training module will be for fall protection during roofing projects. The workers may work on proj ...

Question for this assignment review the cortez multimedia

Question: For this Assignment, review the "Cortez Multimedia" case study, and identify a target behavior or issue that needs to be ameliorated, decreased, or increased. In a 2- to 4-page report, complete the following: • ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As