Question
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
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
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
Step by Step Solution
3.32 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
608fe68231699_21355.pdf
180 KBs PDF File
608fe68231699_21355.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started