Exercise 2: Analyzing Profit Potential You work for Humi-Corporation, an online retailer of home humidifiers. Your manager wants to know the profit potential of their inventory based on the items in inventory listed in Table 2-12. Table 2-12 contains the format of the desired report. The required formulas are shown in Table 2-13. Use the concepts and techniques developed in this chapter to create and format the worksheet. The company just received 67 additional desk-sized humidifiers and shipped out 48 room-sized humidifiers. Update the appropriate cells to reflect the change in inventory. Use conditional formatting to change the formatting to white font on a green background in any cell in of the Total Value that contains a value greater than 20,000.00. Create a 3-D Clustered Bar chart with the Total Cost and Total Value of each Item. Insert a 3D pie chart of the Potential Profit Table 2-12 HumiCorp Inventory Profit Potential Data and Worksheet Layout Item Units on Hand Unit Cost Total Cost Unit Price Total Value Potential Profit Desk 187 2 758 Foma Formula Formule 1 Formula D Filtered home-sized Filtered roomszed Home-sized Room-sized Total Average Formal Lowest Formula F- Formula G to 986 Table 2-13 HumiCorp Inventory Profit Potential Formulas Formula A Units on Hand Unli Cost Formula 3 - Unit Costx (1/(1-651) Formula C Units cn Hard x Unit Price Formula D=TotalValue - Total Cost formula E - AVERAGE INC Formula FEMINunction Change the name of the sheet tab to 12-Bier Use conditional formatting to change the formatting to white font on a green bac in any cell in of the Total Value that contains a value greater than 20,000.00 Create a 3-D Clustered Bar chart with the Total Cost and Total Value of each Item Insert a 3D pie chart of the Potential Profit Table 2-12 HumiCorp Inventory Profit Potential Data and Worksheet Layout Potential Profit Units on Hand 187 Unit Cost 1 2758 324,34 Total Cost Formula Unit Price Formula Total Value Formu Item Desk Filtered home-sized Filtered room-sized Home-sized Room-sized Total Average 103 97 2 53.91 53.59 Formula Lowest Form Forme Table 2-13 HumiCorp Inventory Profit Potential Formulas Tomus A ntson Hand Unit Cost Formula Be Unit Costx (11(1.65)) Formula Unilson Hand xeit Price Formula D=Total Value - Total Cost Formu AVERAGE funcion Formula F MN function Forma G = MAX funcion Change the name of the sheet tab to M2-Exercise 2
