Executive Report of Corey's Coffee Shop Sales
Use the Activity homework starter, to complete the excel spreadsheet and answer the following questions below:
Description of Activity:
You have been asked by the Director of Sales to give a short summary report and presentation to the executive team during the kick-off business meeting for the new fiscal year's operations. You will need to produce both a one-page executive summary report for distribution and a short slide show for your discussion portion of that meeting. You only have 10 minutes on the agenda, so you report needs to be concise and the slide set brief and informative for the group. Specific points you've been asked to address include the following:
Total sales by quarter as follows:?
Total sales (all products)?
Sales subtotals by each of the eight (8) major categories (Beverages, Condiments, Confections, Dairy Products, Grains/Cereals, Meat/Poultry, Produce, Seafood)?
Which product generated the highest sales in each of the four quarters of this past year?
Which two categories produced the lowest sales volumes overall?
-----------------Your assignment is to answer all of those questions using the starter worksheet
Once you have answered all the questions you need to develop the identified reports (Executive Summary and Presentation Slide Set). The executive report should be nicely organized and clearly communicate the required information. The accompanying slide set should also be concise, clean, and informative. The executive should be organized as a Microsoft Word document (PDF is also acceptable) and the slide set either as a native Powerpoint slide set or exported PDF that was developed using a similar presentation tool.
-----------------In addition to these two artifacts, you should also update the workbook to be attached as supporting material to your work. The final version you submit should be organized as a Spreadsheet Table and include a summary row that can be used for generating the calculations that you derived. In addition, the format of your resulting table should include the application of one of the available Table Designs in whatever tool you used.
The updated workbook should also include calculations that clearly reflect how you computed the values to the challenge questions presented in the HR memo.
Executive Report of Corey's Coffee Shop Sales
Name
Institution
Course
Professor
Date
Executive Summary
Sales analysis helps businesses identify their most profitable and slow-moving products and establish sales patterns; this helps allocate resources efficiently and provides more significant opportunities for future growth (Sayed, n.d). This report gives a summary of the analysis of Corey's coffee shop sales in the last 12 months. The dataset being analyzed consists of categories, products, sales, and the period in quarters (Quarter 1 to Quarter 4). There are 77 different products sold in the coffee shop and are classified into eight major categories; Beverages, Condiments, Confections, Dairy Products, Grains/Cereals, Meat/Poultry, Produce, and Seafood.
The fol...
π Other Visitors are Viewing These Other Coursework Samples:
- Accounting System For Your Business4 pages/β1100 words | Other | Accounting, Finance, SPSS | Coursework |
- Analysis Basics: Organizational Financial Health1 page/β275 words | Other | Accounting, Finance, SPSS | Coursework |
- Ratio Analysis: Benefits and Limitations1 page/β275 words | Other | Accounting, Finance, SPSS | Coursework |
- Statements of cash flows. Cash Flow Statement of Apple Inc.1 page/β275 words | Other | Accounting, Finance, SPSS | Coursework |
- Financial Reporting: Profitability Ratios1 page/β275 words | No Sources | Other | Accounting, Finance, SPSS | Coursework |
- What is a Static Budget?1 page/β275 words | Other | Accounting, Finance, SPSS | Coursework |
- Tax Policy with Professor Fisher1 page/β275 words | Other | Accounting, Finance, SPSS | Coursework |