You work for HumiCorp, an online retailer of home humidifiers. Your manager wants to know the profi t potential of their inventory based on the items in the 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.

Table 1 HumiCorp Inventory Profit Potential Data and Worksheet Layout

 

Transcribed Image Text:

Tem Units on Unit Total Cost Unit Price Total Potential Hand Cost Value Profit Desk 187 27.58 Formula A:Formula Formula Formula D B 11 Filtered home-sized 42 324.14 Filtered room-sized 118 86.55 Home-sized 103 253.91 Room-sized 97 53.69 Total Average Formula E Lowest Formula F Highest Formula G Table 2 HumiCorp Inventory Profi t Potential Formulas Formula A = Units on Hand x Unit Cost Formula B = Unit Cost x (1/ (1- 66) Formula 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 Tem Units on Unit Total Cost Unit Price Total Potential Hand Cost Value Profit Desk 187 27.58 Formula A:Formula Formula Formula D B 11 Filtered home-sized 42 324.14 Filtered room-sized 118 86.55 Home-sized 103 253.91 Room-sized 97 53.69 Total Average Formula E Lowest Formula F Highest Formula G Table 2 HumiCorp Inventory Profi t Potential Formulas Formula A = Units on Hand x Unit Cost Formula B = Unit Cost x (1/ (1- 66) Formula 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

Answer rating: 100% (QA)

Analyzing Profit Potential You want to know the profit potential of inventories based on item in inv... View the full answer