Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Table 2 – 11 Appliance Electricity Usage Costs
Total Cost per
Month (30 Days)
Appliance
Cost per Hour
Hours Used Daily
Total Cost Per Day
Clothes dryer
$0.325
1
Computer
$0.02
6
DVD player
$0.035
1
Light bulbs
$0.043
8
Refrigerator
$0.035
24
Stereo
$0.02
5
Television
$0.04
4
Washing machine
$0.03
2
3: Analyzing Proi t Potential
Professional
You work for HumiCorp, an online retailer of home humidii ers. Your manager wants to know the
proi t 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 humidii ers and shipped out 48 room-sized humidii ers. Update
the appropriate cells to rel ect the change in inventory.
Table 2 – 12 HumiCorp Inventory Proi t Potential Data and Worksheet Layout
Item
Units on Hand
Unit Cost
Total Cost
Unit Price
Total Value
Potential Proi t
Desk
187
27.58
Formula A
Formula B
Formula C
Formula D
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 – 13 HumiCorp Inventory Proi t Potential Formulas
Formula A = Units on Hand × Unit Cost
Formula B = Unit Cost × (1 / (1 – .66))
Formula C = Units on Hand × Unit Price
Formula D = Total Value – Total Cost
Formula E = AVERAGE function
Formula F = MIN function
Formula G = MAX function
 
Search JabSto ::




Custom Search