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