GRAFA ONLY EXCEL
phaoun
l5_inventory_summary.xlsxFocused Products-Chapman
| Titan Off-Campus Shops | |||||
| Focused Products Inventory - Chapman Store | |||||
| Category | Description | Quantity | Cost | Retail Price | Total Retail Value |
| 1001-SS | Sweatshirts - Standard | 42 | $ 12.00 | $ 32.00 | $ 1,344.00 |
| 1002-SP | Sweatshirts - Premium | 18 | 18.00 | 54.00 | 972.00 |
| 1003-HA | Baseball Hats | 21 | 4.00 | 16.00 | 336.00 |
| 1004-TS | T-Shirts Standard | 13 | 7.00 | 18.00 | 234.00 |
| 1005-TP | T-shirts Premium | 41 | 12.00 | 28.00 | 1,148.00 |
| 1006-SP | Sweatpants | 19 | 14.00 | 32.00 | 608.00 |
| 1007-SH | Shorts | 3 | 9.00 | 22.00 | 66.00 |
| 1008-MU | Mugs | 1 | 2.00 | 12.00 | 12.00 |
| Total | 158 | $ 4,720.00 | |||
Inventory - Chapman
| Titan Off-Campus Shops | |||||
| Product Inventory: Chapman Store | |||||
| Category | Description | Quantity | Cost | Retail Price | Total Retail Value |
| 1001-SS | Sweatshirts - Standard | 42 | $ 12.00 | $ 32.00 | $ 1,344.00 |
| 1002-SP | Sweatshirts - Premium | 18 | 18.00 | 54.00 | 972.00 |
| 1003-HA | Baseball Hats | 21 | 4.00 | 16.00 | 336.00 |
| 1004-TS | T-Shirts Standard | 13 | 7.00 | 18.00 | 234.00 |
| 1005-TP | T-shirts Premium | 41 | 12.00 | 28.00 | 1,148.00 |
| 1006-SP | Sweatpants | 19 | 14.00 | 32.00 | 608.00 |
| 1007-SH | Shorts | 3 | 9.00 | 22.00 | 66.00 |
| 1008-MU | Mugs | 1 | 2.00 | 12.00 | 12.00 |
| 1009-GL | Glasses | 32 | 2.00 | 12.00 | 384.00 |
| 1010-PS | Pens - Standard | 54 | 0.25 | 1.99 | 107.46 |
| 1011-PD | Pens - Delux | 13 | 7.00 | 25.00 | 325.00 |
| 1012-PE | Pencils | 75 | 0.10 | 1.00 | 75.00 |
| 1013-SA | Stuffed Animals | 7 | 3.00 | 15.00 | 105.00 |
| 1014-BP | Backpacks | 4 | 9.00 | 25.00 | 100.00 |
| 1015-FO | Folders | 43 | 0.25 | 2.00 | 86.00 |
| 1016-BS | Binders - Standard | 41 | 1.00 | 4.00 | 164.00 |
| 1017-BD | Binders - Delux | 24 | 1.50 | 6.00 | 144.00 |
| 1018-PW | Paperweight | 14 | 1.50 | 10.00 | 140.00 |
| 1019-TC | Tie clips | 13 | 1.50 | 15.00 | 195.00 |
| 1020-TI | Ties | 9 | 3.00 | 20.00 | 180.00 |
| 1021-KC | Keychains | 44 | 0.75 | 1.95 | 85.80 |
| Total | 531 | $ 6,811.26 | |||
Inventory - Harbor
| Titan Off-Campus Shops | |||||
| Product Inventory: Harbor Store | |||||
| Category | Description | Quantity | Cost | Retail Price | Total Retail Value |
| 1001-SS | Sweatshirts - Standard | 38 | $ 12.00 | $ 32.00 | $ 1,216.00 |
| 1002-SP | Sweatshirts - Premium | 3 | 18.00 | 54.00 | 162.00 |
| 1003-HA | Baseball Hats | 14 | 4.00 | 16.00 | 224.00 |
| 1004-TS | T-Shirts Standard | 20 | 7.00 | 18.00 | 360.00 |
| 1005-TP | T-shirts Premium | 31 | 12.00 | 28.00 | 868.00 |
| 1006-SP | Sweatpants | 21 | 14.00 | 32.00 | 672.00 |
| 1007-SH | Shorts | 2 | 9.00 | 22.00 | 44.00 |
| 1008-MU | Mugs | 18 | 2.00 | 12.00 | 216.00 |
| 1009-GL | Glasses | 30 | 2.00 | 12.00 | 360.00 |
| 1010-PS | Pens - Standard | 48 | 0.25 | 1.99 | 95.52 |
| 1011-PD | Pens - Delux | 14 | 7.00 | 25.00 | 350.00 |
| 1012-PE | Pencils | 70 | 0.10 | 1.00 | 70.00 |
| 1013-SA | Stuffed Animals | 1 | 3.00 | 15.00 | 15.00 |
| 1014-BP | Backpacks | 2 | 9.00 | 25.00 | 50.00 |
| 1015-FO | Folders | 34 | 0.25 | 2.00 | 68.00 |
| 1016-BS | Binders - Standard | 39 | 1.00 | 4.00 | 156.00 |
| 1017-BD | Binders - Delux | 28 | 1.50 | 6.00 | 168.00 |
| 1018-PW | Paperweight | 15 | 1.50 | 10.00 | 150.00 |
| 1019-TC | Tie clips | 12 | 1.50 | 15.00 | 180.00 |
| 1020-TI | Ties | 9 | 3.00 | 20.00 | 180.00 |
| 1021-KC | Keychains | 44 | 0.75 | 1.95 | 85.80 |
| Total | 493 | $ 5,690.32 | |||
Inventory - Placentia
| Titan Off-Campus Shops | |||||
| Product Inventory: Placentia Store | |||||
| Category | Description | Quantity | Cost | Retail Price | Total Retail Value |
| 1001-SS | Sweatshirts - Standard | 16 | $ 12.00 | $ 32.00 | $ 512.00 |
| 1002-SP | Sweatshirts - Premium | 2 | 18.00 | 54.00 | 108.00 |
| 1003-HA | Baseball Hats | 19 | 4.00 | 16.00 | 304.00 |
| 1004-TS | T-Shirts Standard | 2 | 7.00 | 18.00 | 36.00 |
| 1005-TP | T-shirts Premium | 29 | 12.00 | 28.00 | 812.00 |
| 1006-SP | Sweatpants | 23 | 14.00 | 32.00 | 736.00 |
| 1007-SH | Shorts | 3 | 9.00 | 22.00 | 66.00 |
| 1008-MU | Mugs | 13 | 2.00 | 12.00 | 156.00 |
| 1009-GL | Glasses | 28 | 2.00 | 12.00 | 336.00 |
| 1010-PS | Pens - Standard | 50 | 0.25 | 1.99 | 99.50 |
| 1011-PD | Pens - Delux | 10 | 7.00 | 25.00 | 250.00 |
| 1012-PE | Pencils | 65 | 0.10 | 1.00 | 65.00 |
| 1013-SA | Stuffed Animals | 5 | 3.00 | 15.00 | 75.00 |
| 1014-BP | Backpacks | 1 | 9.00 | 25.00 | 25.00 |
| 1015-FO | Folders | 38 | 0.25 | 2.00 | 76.00 |
| 1016-BS | Binders - Standard | 45 | 1.00 | 4.00 | 180.00 |
| 1017-BD | Binders - Delux | 26 | 1.50 | 6.00 | 156.00 |
| 1018-PW | Paperweight | 17 | 1.50 | 10.00 | 170.00 |
| 1019-TC | Tie clips | 21 | 1.50 | 15.00 | 315.00 |
| 1020-TI | Ties | 17 | 3.00 | 20.00 | 340.00 |
| 1021-KC | Keychains | 41 | 0.75 | 1.95 | 79.95 |
| Total | 471 | $ 4,897.45 | |||
