Sajdak_e01ch02_grader_a1_TCBInventory.xlsx - Open Daily fom 10 AM to 8 PM Thunder City Bookstore Manager Roger Harding Inventory Item Clothing Gym

Sajdak_e01ch02_grader_a1_TCBInventory.xlsx - Open Daily fom...

This preview shows page 1 - 3 out of 3 pages.

Open Daily fom 10 AM to 8 PM 9204036f971c35b60b85969b4f83f7e42059c8c0.xlsx Thunder City Bookstore Manager: Roger Harding Inventory Item Price per Unit Quantity in Stock Inventory Cost Subtotal Clothing Gym shorts (s) $15.99 5 $ 79.95 Gym shorts (m) $15.99 20 $ 319.80 Gym shorts (l) $15.99 25 $ 399.75 Gym shorts (xl) $15.99 12 $ 191.88 $ 991.38 Sweatpants (s) $24.99 20 $ 499.80 Sweatpants (m) $24.99 25 $ 624.75 Sweatpants (l) $24.99 10 $ 249.90 Sweatpants (xl) $24.99 15 $ 374.85 $ 1,749.30 T-shirts (s) $12.99 30 $ 389.70 T-shirts (m) $12.99 45 $ 584.55 T-shirts (l) $12.99 30 $ 389.70 T-shirts (xl) $12.99 28 $ 363.72 $ 1,727.67 Sweatshirts (s) $39.99 20 $ 799.80 Sweatshirts (m) $39.99 15 $ 599.85 Sweatshirts (l) $39.99 25 $ 999.75 Sweatshirts (xl) $39.99 3 $ 119.97 $ 2,519.37 Class Supplies Pen (pack of 10) $2.50 100 $ 250.00 Pencil (pack of 10) $5.49 75 $ 411.75 Notebook $0.79 250 $ 197.50 $2.00 200 $ 400.00 Calendars $4.99 50 $ 249.50 Mouse pads $3.99 5 $ 19.95 $ 669.45 Miscellaneous Coffee mug $4.50 100 $ 450.00 Digital frame (3x5) $24.99 25 $ 624.75 Digital frame (5x7) $34.99 35 $ 1,224.65 Key chains $2.50 150 $ 375.00 Water bottles $3.00 200 $ 600.00 $ 3,274.40 Total Err:508 Inventory Overview Number of tems in inventory 27 Average price of an item in i $17.24 Highest price of an item in i $39.99 Lowest price of an item in in $0.79 Review cards (individually laminated 5x7
Image of page 1
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '14
  • JohnC.Meyers
  • Ch2, Harry Connick, Jr., Roger Harding, Gym shorts, Thunder City Bookstore

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture