excel 3

olaz
_Assessment1_Order.xlsx

Q1

Quarter 1 Uniform Orders
Item Price Sales Front Desk Grounds Room Keeping Other Total
Women's long sleeve $ 19.95 5 3 0 7 0
Men's long sleeve $ 14.95 7 4 8 2 0
Short sleeve $ 10.95 3 10 6 6 0
Vest $ 13.95 11 12 7 4 2
Women's Jacket $ 23.95 5 4 2 0 0
Men's Jacket $ 26.95 6 2 11 2 0
Women's sweater $ 36.95 2 3 0 0 0
Men's sweater $ 42.95 4 6 6 0 0
Women's pants $ 45.95 7 3 0 7 1
Men's pants $ 50.95 10 6 2 0 0
Long skirt $ 36.95 2 2 0 2 0
Short skirt $ 24.95 1 4 0 0 0
Hat $ 12.95 4 0 6 5 1
Scarf $ 11.95 0 4 0 0 0
Tie $ 10.95 4 1 0 0 0
Total 71 64 48 35 4 0

&F

Q2

Quarter 2 Uniform Orders
Item Price Sales Front Desk Grounds Room Keeping Other Total
Women's long sleeve 19.95 2 3 0 6 0
Men's long sleeve 14.95 5 2 7 2 1
Short sleeve 10.95 1 8 5 7 0
Vest 13.95 3 6 2 3 0
Women's Jacket 23.95 3 2 5 1 0
Men's Jacket 26.95 5 1 2 3 2
Women's sweater 36.95 3 4 1 1 0
Men's sweater 42.95 2 5 5 1 0
Women's pants 45.95 8 2 1 3 0
Men's pants 50.95 2 4 3 2 0
Long skirt 36.95 1 1 1 1 0
Short skirt 24.95 0 2 1 1 1
Hat 12.95 0 0 5 0 0
Scarf 11.95 0 0 1 0 0
Tie 10.95 0 1 1 0 0

&F

Q3

Quarter 3 Uniform Orders
Item Price Sales Front Desk Grounds Room Keeping Other Total
Women's long sleeve 19.95 4 3 0 7 0
Men's long sleeve 14.95 6 3 3 2 0
Short sleeve 10.95 2 9 5 6 0
Vest 13.95 7 8 4 4 1
Women's Jacket 23.95 4 3 3 1 0
Men's Jacket 26.95 5 2 6 3 0
Women's sweater 36.95 3 4 1 1 0
Men's sweater 42.95 3 5 5 1 0
Women's pants 45.95 7 2 1 5 0
Men's pants 50.95 6 5 3 0 1
Long skirt 36.95 2 1 1 2 0
Short skirt 24.95 1 3 1 0 1
Hat 12.95 2 0 2 2 0
Scarf 11.95 0 1 1 0 0
Tie 10.95 2 0 0 0 1

&F

Q4

Quarter 4 Uniform Orders
Item Price Sales Front Desk Grounds Room Keeping Other Total
Women's long sleeve 19.95 4 3 0 7 1
Men's long sleeve 14.95 5 3 6 2 0
Short sleeve 10.95 1 8 5 6 1
Vest 13.95 7 7 4 3 0
Women's Jacket 23.95 4 2 3 1 0
Men's Jacket 26.95 5 1 6 3 0
Women's sweater 36.95 3 2 1 1 1
Men's sweater 42.95 3 5 5 1 1
Women's pants 45.95 7 1 1 5 0
Men's pants 50.95 6 2 3 1 1
Long skirt 36.95 2 1 0 2 0
Short skirt 24.95 1 2 0 0 0
Hat 12.95 1 0 1 0 1
Scarf 11.95 0 2 2 0 0
Tie 10.95 2 2 0 0 2

&F

Year

Yearly Uniform Orders
Item Price Sales Front Desk Grounds Room Keeping Other Total
Women's long sleeve $ 19.95 0
Men's long sleeve $ 14.95 0
Short sleeve $ 10.95 0
Vest $ 13.95 0
Women's Jacket $ 23.95 0
Men's Jacket $ 26.95 0
Women's sweater $ 36.95 0
Men's sweater $ 42.95 0
Women's pants $ 45.95 0
Men's pants $ 50.95 0
Long skirt $ 36.95 0
Short skirt $ 24.95 0
Hat $ 12.95 0
Scarf $ 11.95 0
Tie $ 10.95 0
Total 0 0 0 0 0 0

&F

YearLinked

&F

Prices

Tops Price
Hat $ 12.95
Long skirt $ 36.95
Mens Jacket $ 26.95
Mens long sleeve $ 14.95
Mens pants $ 50.95
Mens sweater $ 42.95
Scarf $ 11.95
Short skirt $ 24.95
Short sleeve $ 10.95
Tie $ 10.95
Vest $ 13.95
Womens Jacket $ 23.95
Womens long sleeve $ 19.95
Womens pants $ 45.95
Womens sweater $ 36.95

&F