Microsoft Office Tutorials and References
In Depth Information
Cases and Places
2: Create a Profi t Potential Worksheet
You work part-time for Doze-Now, a retailer of sleep-related products. Your manager wants to know
the profi t potential of their inventory based on the categories of inventory 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 project to create and format the worksheet. Submit a
printout of the values version and formulas version of the worksheet. The company just received a
shipment of 175 additional comforters and 273 items of sleepwear. Update the appropriate cells in the
Units on Hand column.
Table 2–12 Doze-Now Profi t Potential Data and Worksheet Layout
Item
Units on
Hand
Average
Unit Cost
Total
Cost
Average
Unit Price
Total
Value
Potential
Profi t
Comforters
216
46.52
Formula A
Formula B
Formula C
Formula D
Night lights
4,283
6.89
Pillows
691
47.64
Sleep sound machines
103
45.06
Sleepwear
489
16.77
Total
Average
Formula E
Lowest
Formula F
Highest
Formula G
Table 2–13 Doze-Now Profi t Potential Formulas
Formula A = Units on Hand * Average Unit Cost
Formula B = Average Unit Cost * (1 / (1 – .58))
Formula C = Units on Hand * Average Unit Price
Formula D = Total Value – Total Cost
Formula E = AVERAGE function
Formula F = MIN function
Formula G = MAX function
Continued >
 
Search JabSto ::




Custom Search