2. Create three additional "Focused Products worksheets, one for the Placentia Store, one for the Harbor Store, and one to be used as a summary, by making copies of the Focused Products- Chapman" worksheet. 3. Correct the new worksheets subtitles by replacing the words "Chapman Store, to Placentia Store", "Harbor Store", and "Summary" respectively. Also, re-name the worksheet tabs to "Focused Products - Placentia", and "Focused Products - Harbor", and "Focused Products-Summary". 4. Re-order the four "Focused Products worksheets so that the Summary is first, followed by Chapman, then Harbor, and finally Placentia. 5. Replace the inventory quantities on the focused Products Harbor, and Focused Products Placentia sheets to the values below. Harbor Placentia Sweatshirts - Standard Sweatshirts - Premium Baseball Hats T-Shirts Standard T-shirts Premium Sweatpants Shorts Mugs 38 3 14 20 31 21 2 18 16 2 19 2 29 23 3 13 6. On the focused Products - Summary sheet, replace the quantity for Sweatshirts-Standard (cell C4), with a 3-D reference function which adds up the quantities of the three "Focused Products" sheets. On the Summary sheet, copy this formula down for the column (through C11). (Be sure not to include the three additional worksheets which are showing all the inventory that are also included in this workbook) 7. Apply conditional formatting to the Quantity column on the focused Products - Summary sheet so that if the inventory levels drop below 10, they will appear with a red background and a red font color. Titan Off-Campus Shops Focused Products Inventory - Chapman Store Total Retail Category Description Quantity Cost Retail Price 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-IP 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 Titan Off-Campus Shops Product Inventory: Chapman Store Quantity Cost 42 $ 18 21 13 41 19 3 1 32 54 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005 TP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total Total Retail Retail Price Value 12.00 $ 32.00 $ 1,344.00 18.00 54.00 972.00 4.00 16.00 336.00 7.00 18.00 234.00 12.00 28.00 1,148.00 14.00 32.00 608.00 9.00 22.00 66.00 2.00 12.00 12.00 2.00 12.00 384.00 0.25 1.99 107.46 7.00 25.00 325.00 0.10 1.00 75.00 3.00 15.00 105.00 9.00 25.00 100.00 0.25 2.00 86.00 1.00 4.00 164.00 1.50 6.00 144.00 1.50 10.00 140.00 1.50 15.00 195.00 3.00 20.00 180.00 0.75 1.95 85.80 $ 6,811.26 13 75 4 43 41 24 43 14 13 9 44 531 Titan Off-Campus Shops Product Inventory: Harbor Store Quantity Cost 38 $ 3 14 20 31 21 2 18 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005-IP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total 30 48 14 70 1 2 34 39 28 15 12 Total Retail Retail Price Value 12.00 $ 32.00 $ 1,216.00 18.00 54.00 162.00 4.00 16.00 224.00 7.00 18.00 360.00 12.00 28.00 868.00 14.00 32.00 672.00 9.00 22.00 44.00 2.00 12.00 216.00 2.00 12.00 360.00 0.25 1.99 95.52 7.00 25.00 350.00 0.10 1.00 70.00 3.00 15.00 15.00 9.00 25.00 50.00 0.25 2.00 68.00 1.00 4.00 156.00 1.50 6.00 168.00 1.50 10.00 150.00 1.50 15.00 180.00 3.00 20.00 180.00 0.75 1.95 85.80 $ 5,690.32 9 44 493 Titan Off-Campus Shops Product Inventory: Placentia Store Cost Quantity 16 $ 2 19 2 29 23 3 13 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005 IP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total 28 50 10 65 5 1 38 45 26 17 Total Retail Retail Price Value 12.00 $ 32.00 $ 512.00 18.00 54.00 108.00 4.00 16.00 304.00 7.00 18.00 36.00 12.00 28.00 812.00 14.00 32.00 736.00 9.00 22.00 66.00 2.00 12.00 156.00 2.00 12.00 336.00 0.25 1.99 99.50 7.00 25.00 250.00 0.10 1.00 65.00 3.00 15.00 75.00 9.00 25.00 25.00 0.25 2.00 76.00 1.00 4.00 180.00 1.50 6.00 156.00 1.50 10.00 170.00 1.50 15.00 315.00 3.00 20.00 340.00 0.75 1.95 79.95 $ 4,897.45 21 17 41 471 2. Create three additional "Focused Products worksheets, one for the Placentia Store, one for the Harbor Store, and one to be used as a summary, by making copies of the Focused Products- Chapman" worksheet. 3. Correct the new worksheets subtitles by replacing the words "Chapman Store, to Placentia Store", "Harbor Store", and "Summary" respectively. Also, re-name the worksheet tabs to "Focused Products - Placentia", and "Focused Products - Harbor", and "Focused Products-Summary". 4. Re-order the four "Focused Products worksheets so that the Summary is first, followed by Chapman, then Harbor, and finally Placentia. 5. Replace the inventory quantities on the focused Products Harbor, and Focused Products Placentia sheets to the values below. Harbor Placentia Sweatshirts - Standard Sweatshirts - Premium Baseball Hats T-Shirts Standard T-shirts Premium Sweatpants Shorts Mugs 38 3 14 20 31 21 2 18 16 2 19 2 29 23 3 13 6. On the focused Products - Summary sheet, replace the quantity for Sweatshirts-Standard (cell C4), with a 3-D reference function which adds up the quantities of the three "Focused Products" sheets. On the Summary sheet, copy this formula down for the column (through C11). (Be sure not to include the three additional worksheets which are showing all the inventory that are also included in this workbook) 7. Apply conditional formatting to the Quantity column on the focused Products - Summary sheet so that if the inventory levels drop below 10, they will appear with a red background and a red font color. Titan Off-Campus Shops Focused Products Inventory - Chapman Store Total Retail Category Description Quantity Cost Retail Price 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-IP 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 Titan Off-Campus Shops Product Inventory: Chapman Store Quantity Cost 42 $ 18 21 13 41 19 3 1 32 54 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005 TP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total Total Retail Retail Price Value 12.00 $ 32.00 $ 1,344.00 18.00 54.00 972.00 4.00 16.00 336.00 7.00 18.00 234.00 12.00 28.00 1,148.00 14.00 32.00 608.00 9.00 22.00 66.00 2.00 12.00 12.00 2.00 12.00 384.00 0.25 1.99 107.46 7.00 25.00 325.00 0.10 1.00 75.00 3.00 15.00 105.00 9.00 25.00 100.00 0.25 2.00 86.00 1.00 4.00 164.00 1.50 6.00 144.00 1.50 10.00 140.00 1.50 15.00 195.00 3.00 20.00 180.00 0.75 1.95 85.80 $ 6,811.26 13 75 4 43 41 24 43 14 13 9 44 531 Titan Off-Campus Shops Product Inventory: Harbor Store Quantity Cost 38 $ 3 14 20 31 21 2 18 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005-IP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total 30 48 14 70 1 2 34 39 28 15 12 Total Retail Retail Price Value 12.00 $ 32.00 $ 1,216.00 18.00 54.00 162.00 4.00 16.00 224.00 7.00 18.00 360.00 12.00 28.00 868.00 14.00 32.00 672.00 9.00 22.00 44.00 2.00 12.00 216.00 2.00 12.00 360.00 0.25 1.99 95.52 7.00 25.00 350.00 0.10 1.00 70.00 3.00 15.00 15.00 9.00 25.00 50.00 0.25 2.00 68.00 1.00 4.00 156.00 1.50 6.00 168.00 1.50 10.00 150.00 1.50 15.00 180.00 3.00 20.00 180.00 0.75 1.95 85.80 $ 5,690.32 9 44 493 Titan Off-Campus Shops Product Inventory: Placentia Store Cost Quantity 16 $ 2 19 2 29 23 3 13 Category Description 1001-SS Sweatshirts - Standard 1002-SP Sweatshirts - Premium 1003-HA Baseball Hats 1004-TS T-Shirts Standard 1005 IP T-shirts Premium 1006-SP Sweatpants 1007-SH Shorts 1008-MU Mugs 1009-GL Glasses 1010-PS Pens - Standard 1011-PD Pens - Delux 1012-PE Pencils 1013-SA Stuffed Animals 1014-BP Backpacks 1015-FO Folders 1016-BS Binders - Standard 1017-BD Binders - Delux 1018-PW Paperweight 1019-TC Tie clips 1020-TI Ties 1021-KC Keychains Total 28 50 10 65 5 1 38 45 26 17 Total Retail Retail Price Value 12.00 $ 32.00 $ 512.00 18.00 54.00 108.00 4.00 16.00 304.00 7.00 18.00 36.00 12.00 28.00 812.00 14.00 32.00 736.00 9.00 22.00 66.00 2.00 12.00 156.00 2.00 12.00 336.00 0.25 1.99 99.50 7.00 25.00 250.00 0.10 1.00 65.00 3.00 15.00 75.00 9.00 25.00 25.00 0.25 2.00 76.00 1.00 4.00 180.00 1.50 6.00 156.00 1.50 10.00 170.00 1.50 15.00 315.00 3.00 20.00 340.00 0.75 1.95 79.95 $ 4,897.45 21 17 41 471
