Reference no: EM131165607
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 the department and manager. The Austin store manager wants to rotate the department managers in each of the store's department so each manager 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 managers.
1. Create a new Excel workbook and save as Home Station-Austin.xlsx in the Chapter 7 folder
2. Import the information from the sales table in the Sales.accdb database in the Chapter 7 folder into a worksheet name Sales
3. Create a PivotTable report using the data in Sales worksheet and place the PivotTable 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 PivotTable report to analyze department sales by quarter. Which department had the highest quarterly sales in which quarter did it occur. (Hint: Use the Data field to summarize the dates by quarter)
6. Add the manager field to the PivotTable 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 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.xlsx workbook.
|
What is the journal entry to record the event
: Assume the following account balances immediately after an interest payment date: If the bonds are retired immediately at a total cost of $104,000, what is the journal entry to record this event?
|
|
What is the cash inflow from the sale
: what growth rate is its P/E ratio consistent with?- If the capital gains tax rate is 40% what is the cash inflow from the sale?
|
|
Describe how the items connect to your unwrapped standard
: After completing the reading and viewing the presentation, create a Constructed-Response item for your Priority Standards. Insert your Construct-Response items in the correct section of your Class Template.
|
|
Calculate the price elasticity of demand for gasoline
: Is the demand for gasoline elastic, inelastic, perfectly elastic or inelastic, or unit elastic? Why?
|
|
Create a pivottable report
: Create a PivotTable report using the data in Sales worksheet and place the PivotTable report in a new worksheet named Austin.
|
|
What ways could have incorporated critical thinking skills
: In a 300 word reflective essay, students will describe how they have incorporated critical thinking strategies into their daily routines. Students should consider including responses to any or all of the following prompts. Which of the nine strate..
|
|
Libertarianism-liberalism or communitarianism
: Pick one of the political approaches (Libertarianism, Liberalism, or Communitarianism) and demonstrate why you believe it would be the most unjust of the three approaches for a centralized government,
|
|
What happens to the profits of boat makers in the short run
: What happens to the profits of boat makers in the short run? What happens to the number of boat makers in the long run?
|
|
Spend time more on openpro-not sap
: Give an adequate-and relevant-background of (link below) OpenPro (no financial analysis), target market for the comparable product, limitations of the product, and strengths of the product. In general, compare and contrast the functionality of Op..
|