Product Pricing Calculator Guidelines

Calculating Cost per Unit
1. Divide Total Price by the Volume of Product to calculate Cost per Unit. To
calculate cost per unit:
a. Select cell E5
b. Type =
c. Select cell B5
d. Type /
e. Select cell C5
f. Click Enter.
g. The value in cell E5 should be $0.14.
2. To create a relative reference in cells E6 and E7, select cell E5, grab the fill
handle and drag down to cell E7.
3. Type an X in the cell in column F that represents the “Best Buy” (lowest cost per
unit).
4. Now go back to the online shopping site and choose another completely different
product, for another product price comparison between three brands.
Fill handle
(pointer becomes the fill
handle when placed over
the lower right corner of
the cell)
Page 5/5
Free Download

Product Pricing Calculator Guidelines DOC

Favor this template? Just fancy it by voting!
  •  
  •  
  •  
  •  
  •  
(0 Votes)
0.0
Related Forms
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 643 Views | 4 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 555 Views | 5 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 976 Views | 15 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 1163 Views | 22 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 1059 Views | 25 Downloads