mosken_e04capstone_grader_a2_order.xlsx
Q1
| Quarter 1 Uniform Orders |
| Item |
Price |
Sales |
Front Desk |
Grounds |
Room Keeping |
Other |
Total |
| Womens long sleeve |
$ 12.95 |
5 |
3 |
0 |
7 |
0 |
| Mens long sleeve |
$ 14.95 |
7 |
4 |
8 |
2 |
0 |
| Vest |
$ 13.95 |
11 |
12 |
7 |
4 |
2 |
| Womens Jacket |
$ 23.95 |
5 |
4 |
2 |
0 |
0 |
| Mens Jacket |
$ 26.95 |
6 |
2 |
11 |
2 |
0 |
| Womens pants |
$ 35.95 |
7 |
3 |
0 |
7 |
1 |
| Mens pants |
$ 40.95 |
10 |
6 |
2 |
0 |
0 |
| Hat |
$ 9.95 |
4 |
0 |
6 |
5 |
1 |
| Tie |
$ 10.95 |
4 |
1 |
0 |
0 |
0 |
| Total |
| 59 |
35 |
36 |
27 |
4 |
0 |
Q2
| Quarter 2 Uniform Orders |
| Item |
Price |
Sales |
Front Desk |
Grounds |
Room Keeping |
Other |
Total |
| Womens long sleeve |
12.95 |
2 |
3 |
0 |
6 |
0 |
| Mens long sleeve |
14.95 |
5 |
2 |
7 |
2 |
1 |
| Vest |
13.95 |
3 |
6 |
2 |
3 |
0 |
| Womens Jacket |
23.95 |
3 |
2 |
5 |
1 |
0 |
| Mens Jacket |
26.95 |
5 |
1 |
2 |
3 |
2 |
| Womens pants |
35.95 |
8 |
2 |
1 |
3 |
0 |
| Mens pants |
40.95 |
2 |
4 |
3 |
2 |
0 |
| Hat |
9.95 |
0 |
0 |
5 |
0 |
0 |
| Tie |
10.95 |
0 |
1 |
1 |
0 |
0 |
Q3
| Quarter 3 Uniform Orders |
| Item |
Price |
Sales |
Front Desk |
Grounds |
Room Keeping |
Other |
Total |
| Womens long sleeve |
12.95 |
4 |
3 |
0 |
7 |
0 |
| Mens long sleeve |
14.95 |
6 |
3 |
3 |
2 |
0 |
| Vest |
13.95 |
7 |
8 |
4 |
4 |
1 |
| Womens Jacket |
23.95 |
4 |
3 |
3 |
1 |
0 |
| Mens Jacket |
26.95 |
5 |
2 |
6 |
3 |
0 |
| Womens pants |
35.95 |
7 |
2 |
1 |
5 |
0 |
| Mens pants |
40.95 |
6 |
5 |
3 |
0 |
1 |
| Hat |
9.95 |
2 |
0 |
2 |
2 |
0 |
| Tie |
10.95 |
2 |
0 |
0 |
0 |
1 |
Q4
| Quarter 4 Uniform Orders |
| Item |
Price |
Sales |
Front Desk |
Grounds |
Room Keeping |
Other |
Total |
| Womens long sleeve |
12.95 |
4 |
3 |
0 |
7 |
1 |
| Mens long sleeve |
14.95 |
5 |
3 |
6 |
2 |
0 |
| Vest |
13.95 |
7 |
7 |
4 |
3 |
0 |
| Womens Jacket |
23.95 |
4 |
2 |
3 |
1 |
0 |
| Mens Jacket |
26.95 |
5 |
1 |
6 |
3 |
0 |
| Womens pants |
35.95 |
7 |
1 |
1 |
5 |
0 |
| Mens pants |
40.95 |
6 |
2 |
3 |
1 |
1 |
| Hat |
9.95 |
1 |
0 |
1 |
0 |
1 |
| Tie |
10.95 |
2 |
0 |
0 |
0 |
2 |
Year
| Yearly Uniform Orders |
| Item |
Price |
Sales |
Front Desk |
Grounds |
Room Keeping |
Other |
Total |
| Womens long sleeve |
$ 12.95 |
|
|
|
|
| 0 |
| Mens long sleeve |
$ 14.95 |
|
|
|
|
| 0 |
| Vest |
$ 13.95 |
|
|
|
|
| 0 |
| Womens Jacket |
$ 23.95 |
|
|
|
|
| 0 |
| Mens Jacket |
$ 26.95 |
|
|
|
|
| 0 |
| Womens pants |
$ 35.95 |
|
|
|
|
| 0 |
| Mens pants |
$ 40.95 |
|
|
|
|
| 0 |
| Hat |
$ 9.95 |
|
|
|
|
| 0 |
| Tie |
$ 10.95 |
|
|
|
|
| 0 |
| Total |
| 0 |
0 |
0 |
0 |
0 |
0 |
Prices
| Tops |
Price |
| Hat |
$ 9.95 |
| Long skirt |
$ 36.95 |
| Mens Jacket |
$ 26.95 |
| Mens long sleeve |
$ 14.95 |
| Mens pants |
$ 40.95 |
| Mens sweater |
$ 42.95 |
| Scarf |
$ 11.95 |
| Short skirt |
$ 34.95 |
| Short sleeve |
$ 10.95 |
| Tie |
$ 10.95 |
| Vest |
$ 13.95 |
| Womens Jacket |
$ 23.95 |
| Womens long sleeve |
$ 12.95 |
| Womens pants |
$ 35.95 |
| Womens sweater |
$ 36.95 |
Brazil2013
