You work for HumiCorp, an online retailer of home humidifi ers. 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 humidifi ers and shipped out 48 room-sized

humidifi ers. update the appropriate cells to reflect the change in inventory.

Table HumICorp Inventory Profit Potential Data and Worksheet Layout.

Table 2 HumiCorp Inventory Profit Potential Formulas:

Formula A = Units on Hana x unit Cost

Formula B = unit Cost x (1 / 1-0.66))

Formal C = Units on Hand x unit Price

Formula D = Total Value -Total Cost

Formula E = AVERAGE function

Formula F = MIN function

Formula G = MAX function

Transcribed Image Text:

Tem Desk Filtered home-sized 42 Filtered room-sized 118 103 Home-sized Room-sized 97 53.69 Units on Hand Unit Cost Total Cost 187 27.58 Total Average Lowest Highest Formula E Formula F Formula G 324.14 86.55 253.91 Formula A;Formula B Unit Price Formula C Formula D Total Value Potential Profit Tem Desk Filtered home-sized 42 Filtered room-sized 118 103 Home-sized Room-sized 97 53.69 Units on Hand Unit Cost Total Cost 187 27.58 Total Average Lowest Highest Formula E Formula F Formula G 324.14 86.55 253.91 Formula A;Formula B Unit Price Formula C Formula D Total Value Potential Profit

Answer rating: 100% (QA)

Analyzing Profit Potential You want to know the profit potential of inventories based on item in inventory Steps needed for preparing worksheet of item are as follow 1 Open Microsoft Excel 2010 Micros... View the full answer