Circuit City Employee Evaluation Table
In this assignment, you are the assistant manager at Circuit City and your boss has asked you for the weekly reports showing the sales for the week. You are responsible for evaluating each sale person’s performance as well as looking at the number of items that were sold for the week. You need to construct a table that will help your boss see both items sold and who sold what items. Based on your table your supervisor will be deciding who will move up the sales ladder and who needs to be let go. This table should have a title cell, as well as a cell for each employee and the items that they sell for the days of the week they are sold. This table should be easy to read and understand, so with that in mind here are the particulars for the table: Employees are; Juan, Carol, Mark, Melissa and Jesse. There are five items being sold they are; TVs, VCRs, Stereos, Satellites and DVD Players. The store is open 7 days a week and the table should reflect this. The employee’s sales are as follows: Juan’s days off are Mondays and Tuesdays. He sold the following for the week – Wednesday – 1 TV, 1 Stereo, 1 DVD player, Thursday - 1 stereo, 1 satellite, Friday – 1 VCR, 3 DVD players, Saturday – 3 TVs, 1 satellite, Sunday – 1 VCR, 2 Satellite. Carol’s days off are Saturday and Sunday. She sold the following for the week – Monday – 2 stereos, Tuesday – 1 TV, 1 DVD player, Wednesday – 2 Satellites, 1 DVD Player, Thursday – 2 TVs, Friday – 2 TVs, 2 satellites. Mark’s days off are Wednesday and Saturday. He sold the following for the week – Monday – 1 TV, 1 DVD player, Tuesday – 2 stereos, 1 satellite, Thursday – 1 satellite, Friday – 1 TV, and 1 DVD player, Sunday – 1 VCR, 2 satellites. Melissa’s days off are Thursday and Friday. She sold the following for the week – Monday – 1 DVD player, Tuesday – 1 VCR, 1 stereo, Wednesday – 1 stereo, 1 satellite, Saturday – 2 TVs, 2 stereos, 1 satellite, 1 DVD player, Sunday – 1 TV, 1 VCR, 1 satellite, 1 DVD player Jesse’s days off are Mondays and Sundays. He sold the following for the week – Tuesday – 1 stereo, 2 DVD players, Wednesday – 1 satellite, Thursday – 1 stereo, 1 satellite, Friday – 1 stereo, Saturday – 1 stereo, 1 DVD player. Answer the following questions based on the information in the table. Put your answers in the same document following your table. Make sure to save this table because you will be using it in excel as the next assignment. 1. What days are the best days for sales? 2. Who is the best sales associate?
3. What are the worst days for sales? 4. What items sell the best? 5. Which items should be discontinued? Name this assignment, yourlastname_css43_ circuitcityeval. Put it in the week three folder.