Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Aim: 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:

A) Learn to plan, schedule and execute project tasks with a view to improve your personal productivity;
B) Gain an understanding of some typical issues related to the operation of a medium size business;
C) 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:

ToddRestaurantsoffer 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 CEOasksyou to identify where to spend time and focus efforts to improve the overall health of the company.

A) Review the data that Joshua has provided you from the data warehouse in Data.Xlsx file. Rename the spreadsheet as: Lastname_Firstname.xlsx.
 
B) 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’)

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

C) Using the Information worksheet, Joshuaneeds to have a summary reportfor each region. The report should includethe following:

i) Total Annual Sales

ii) Total number of Seats

iii) Average Annual Sales

iv) Average Store Age (years)

v) Total number of Restaurants

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

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

  • Which region has the highest ‘Annual Store Sales’ for ‘Really Big’ size restaurants
  • Which region has the lowest ‘Annual Store Sales’ for ‘Really Big’ size restaurants
  • What is the total number of seats for ‘Medium’ size restaurants in the highest ‘Annual Store Sales’ region?
  • What is the total number of seats for ‘Large’ size restaurants in the lowest ‘Annual Store Sales’ region?
  • What is the best annual sale restaurant at the worst region?
  • What is the worst annual sale restaurant at the best region?
  • What is the lowest age of the restaurant in the highest ‘Annual Store Sales’ region?
  • What is the highest age of the restaurant in the lowest ‘Annual Store Sales’ region?

E) Prepare a Report in Microsoft Word that includes:

i) An introduction

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

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

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9647

Have any Question? 


Related Questions in DBMS

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

Data analysis assignment- apriori analysis and cluster

Data Analysis assignment- ApriorI analysis and Cluster analysis CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" s ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

Salaries for database administrators database

SALARIES FOR DATABASE ADMINISTRATORS Database administrators (DBAs) are among the highest paid professionals in the information technology field. Many people work for 10 to 20 years to get a promotion to DBA. Connect to ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen