Create a new excel workbook and save it

Assignment Help Database Management System

Reference no: EM13762442

Analyzing Manager Performance at Home Station

You are a regional manager for Home Station, a national chain of home renovation stores. You are analyzing the weekly sales data for one of the retail stores located in Austin, Texas. The sales data is reported by department and manager. The Austin store manager wants to rotate the department managers in each of the store's departments so each manger becomes more familiar with the entire store's operations. You have been assigned the task of determining the impact of rotating the managers on store sales. You will import the sales data from a database into Excel and then create a PivotTable report to summarize the quarterly sales by department and by manager.

Complete the following:

1. Create a new Excel workbook and save it as Home Station-Austin.xlsx.

2. Import the information from the Sales table in the Sales.accdb database into a worksheet named Sales.

3. Create a PivotTable report using the data in the Sales worksheet and place the Pivot-Table report in a new worksheet named Austin.

4. Use the PivotTable report to analyze the sales by department. Change the number format of the sales data to currency and sort the sales so that the department with the highest sales appears first. Print the worksheet.

5. Rearrange the fields in the Pivot fable report to analyze department sales by quarter. Which department had the highest quarterly sales, and in which quarter did it occur? (Hint; Use the Date field to summarize the dates by quarter.)

6. Add the N tanager field to the Pivot table report to analyze each department's quarterly sales performance by manager. Which manager had the highest sales for each department? In which quarter did the manager's highest sales occur?

7. Rearrange the fields in the PivotTable report to analyze each manager's quarterly sales performance by department. Which department resulted in the highest sales for each manager? In which quarter did the highest sales occur?

8. Based on the data collected, which manager would you choose to manage each department on a long-term basis? Support your recommendations with data from the PivotTable report.

9. Save and close the Home Station-Austin.xlsx workbook.

Attachment:- sales.accdb

Reference no: EM13762442

Questions Cloud

Fundamental drivers of the fraud : Research one (1) publicly traded company that committed fraud within the last five (5) years and the fundamental drivers of the fraud.

Develop a closing process powerpoint presentation : Develop a Closing Process PowerPoint Presentation. Your PowerPoint must have speaker notes and these speaker notes must be written as if you were presenting this project to your stakeholders.

The historical evolution of health care : Significant Health Care Event Paper Grading Criteria

Calculate the net benefit : Calculate the net benefit (cost) to HP of outsourcing the component from Samina-SCI. Use a negative sign with your answer, if appropriate.

Create a new excel workbook and save it : You are a regional manager for Home Station, a national chain of home renovation stores. Create a new Excel workbook and save it as Home Station-Austin.xlsx

Record sale and settlement of account receivable : Make the journal entries to record the sale and settlement of the account receivable.

The principles of database design and management : Complete the 8- to 10-slide Microsoft® PowerPoint® presentation in which you explain the principles of database design and management. Include the following

What is emotional intelligence and what are soft skills : What is emotional intelligence and what are soft skills? Illustrate your points with the help of examples.

Smartphones and the great digital divide : Smartphones and the Great Digital Divide on page 282 in the text and answer the questions below. APA formatting guidelines require a title page, abstract page, and reference page in addition to the body of the paper.

User Account

All Pages