Product Pricing Calculator Guidelines

Step-by-Step Microsoft Excel XP:
Product Pricing
Step-by-Step Microsoft Excel XP: Product Pricing provides guided instructions for
completing Exercise 2.4: Determining and Comparing the Unit Price of Similar Items –
Getting the Best Buy. In this exercise you will access the online grocery shopping site
and choose three different brands of the same product. You will then record on the
ProductPricing Excel worksheet the cost information provided from the online site.
Below is an illustration of the ProductPricing Excel worksheet you will be working on with
a sample of one product (three different brands of raisin bran cereal) completed for you:
1. Open the Excel template ProductPricing (the file can be found in the Step-by-
Step folder for Project 4 – Consumers\Student Lessons\).
2. Save the file as “YourNameProductPricing
3. Six columns (A-F) will be used for this exercise. Each column is labeled in the
Row 1 cell for that column:
Column A = Product Brand
Column B = Total Price
Column C = Volume of Product
Column D = Unit of Measurement
Column E = Cost per Unit
Column F = Best Buy (mark with X)
Page 1/5

Product Pricing Calculator Guidelines DOC

Favor this template? Just fancy it by voting!
•
•
•
•
•
0.0
Related Forms
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•