Dear Oly Clothing store manager. Please complete your weekly report by filling out the requested information in each table. Record your information in the following manner:
- Add a Worksheet <Insert> <Worksheet>
- Rename it "Summaries"
- Copy/paste each table below and fill out the required information
You will find 2 parts to your report. The first is a statistical analysis of the store activity and the second part is your recommendations. Be sure to reference your statistics when you make your recommendations.
Part 1 Statistical analysis
Complete the tables below:
Employees:
| Employee | Total Items sold | Total gross | # days worked | # Items sold/day | Gross/day |
|---|---|---|---|---|---|
| Bill | |||||
| Jan | |||||
| Jim | |||||
| Sue |
Products:
| Product | Number sold | Total gross | % of Gross |
|---|---|---|---|
| Coat | |||
| Pants | |||
| Shirt | |||
| Tie |
Days:
| Day of the week | # of Items Sold | Total gross | % of Gross |
|---|---|---|---|
| Tuesday | |||
| Wednesday | |||
| Thursday | |||
| Friday | |||
| Saturday | |||
| Sunday |
Feel free to include any other tables or charts that you think are important to explain the activity in the store for the week.
Part 2 Recommendations
Please write a brief paragraph for each question below. Be sure to reference any statistics from the information above that will support your opinion. To do this, insert a Word document object under each table in your Summaries Worksheet
( <Insert> <Object> <Microsoft Word Document> )
In your response be certain to:
- Write a clear and convincing argument
- You must include one comparative argument for full credit
- Examples will be given in class to help you "hit the target"
Questions:
- If an employee is to be fired, who should it be and why?
- If an employee should be given a raise, who should it be and why?
- If one product must be eliminated from our stock, which item should it be and why?
- On which day(s) should we have the most workers on hand and why?
- On which day(s) should we have the the least number of workers on hand and why?
Part 3 Submitting your work
When you are finished, please submit your Excel Spreadsheet to the submissions in the Clothing Sales folder
