Calculate the Retail Price
The numbers we
entered into the B column represent the wholesale cost. That is what
Charlotte’s Web Site paid to purchase the items that go into a fruit
basket. In order to make a profit, we need to figure out how much we
need to markup the cost to get our retail price.
4. Format the Percentage
The Retail
Price equals the wholesale cost multiplied by the
percentage.
To start, select all of
Column C, Markup.
Go to the Home Ribbon. Look for the Number Group and click
on the Percentage (%) formatting.
5. Enter the Percentage
A standard keystone markup is 150%. Type 150 in cells C2 through
C5. Excel will automatically add the % sign.
So far so good.