Module3BasicMarkupEquationsBuyingDecisions.xlsx

Formulas

RETAIL PRICING AND REPRICING OF MERCHANDISE (MARKUP)
Basic Markup Equations Used in Buying Decisions
A. Basic Markup Percentage Equations
1. Calculating Markup % on Retail
Using the Retail Method of Inventory
Markup %
$markup
retail
markup % ERROR:#DIV/0!
2. Calculating Markup % on Cost
Markup %
$ markup
cost
markup % ERROR:#DIV/0!
3. Calculating Markup % when cost and retail are known
a. when individual cost and individual retail are known
individual retail
- individual cost
$ markup 0
markup % ERROR:#DIV/0!
b. when total purchase cost and total purchase retail are known
total retail
- total cost
$ markup on entire purchase 0
markup % ERROR:#DIV/0!
4. Calculating Markup % on a group of items with varying costs or retail prices (i.e., order writing)
$ cost $ retail $markup
Item A
Item B
Item C
Item D
Total $0.00 $0.00 $0.00
markup % ERROR:#DIV/0!
5. Calculating markup % with varying retail prices that have the same cost
Merchandise no. pieces unit cost total cost unit retail total retail markup
portion A same ERROR:#VALUE! $0.00
portion B same ERROR:#VALUE! $0.00
portion C same ERROR:#VALUE! $0.00
total 0 same ERROR:#VALUE! $0.00 ERROR:#VALUE!
markup% on entire purchase ERROR:#VALUE!
6. Calculating markup % on merchandise with varying costs at the same retail price
no.pieces unit cost total cost unit retail total retail markup
Merchandise A $0.00 same ERROR:#VALUE!
Merchandise B $0.00 same ERROR:#VALUE!
Merchandise C $0.00 same ERROR:#VALUE!
total $0.00 same ERROR:#VALUE! ERROR:#VALUE!
markup % on enitre purchase ERROR:#VALUE!
B. Basic $ Markup Calculations Used in Buying Decisions
1. Finding Retail when Cost and Markup % are Known
retail
cost
markup %
0
2. Finding Cost when Retail and Markup % are known
cost
retail
markup %
cost 0

Problems

RETAIL PRICING AND REPRICING OF MERCHANDISE (MARKUP)
Correct formula and answer
One or more formula errors
1. If the men’s buyer purchases pants at a cost of $34.00 and has a markup of $33.00, what will be the retail price for each pair of pants? Cost Markup Retail Wrong formula or no formula
$34.00 $33.00
2. If the electronics buyer purchases televisions at a cost price of $325.00 and the markup is $249.99, what is the retail price for the televisions? Cost Markup Retail
$325.00 $249.99
3. The misses sweater buyer retails cotton sweaters for $45.99, and the markup is $24.24. What is the cost price of each sweater? Retail Markup Cost
$45.99 $24.24
4. A man’s belt retails for $74.00, and the markup is $43.00. What is the cost price? Retail Markup Cost
$74.00 $43.00
5. Calculate the markup dollars for a tie if the cost is $23.60 and the manufacturer’s suggested retail price is $59.00. Retail Cost MU $
$59.00 $23.60
6. If a necklace retails for $49.00 and the cost is $14.70, what is the markup in dollars and percentage at retail for the necklace? Retail Cost MU $ MU %
$49.00 $14.70
7. If a pair of brand-name leather boots has a retail price of $249.00 and the cost is $125.00, what is the markup for the boots in both dollars and percentage at retail? Retail Cost MU $ MU %
$249.00 $125.00
Markup Practice Problems
Calculate the cost price given the retail and the planned MU %
8. A pair of sneakers will be ticketed with a retail price of $118.00 and the markup % is 54.0%. What is the cost price for the sneakers? Retail $ Cost % Cost $
$118.00
9. What is the maximum cost a buyer can pay for a coat that will sell for $550 with a markup of 56.0%? Retail $ Cost % Cost $
$550.00
10. You are the jewelry buyer for a large mass-market chain. For the holiday season, you are planning a boxed jewelry “Gifts to Go” promotion for $19.99. The markup for the promotion is planned at 43.0%. What is the maximum cost price that you will pay for the boxed jewelry? Retail $ Cost % Cost $
$19.99
11. Given the following departmental markups and average retails per department, what is the maximum cost that the buyer can pay? Retail $ Cost % Cost $
a. Sneakers, 54.4% markup; Retail price $89.00. $89.00
b. Men’s ties, 65.7% markup; Retail price $38.00. Retail $ Cost % Cost $
$38.00
c. Boy's apparel, 47.9% markup; Retail price $14.00 Retail $ Cost % Cost $
$14.00
Calculate the retail price given the cost and the planned MU%
12. An eye shadow compact costs $25.20, and the markup is 40.0%. What is the retail price of the compact? Cost $ Mark Up Cost Retail $
$25.20
13. A buyer will purchase sweaters at a cost of $37.85, and the planned MU % for the department is 62.0%. What is the minimum retail price for each sweater? What possible retail price for each sweater might be used if you were the buyer of a department store? What about an off-price retailer? Cost $ Cost % Retail $ Pricing Strategies
$37.85 0.38 Dept store: $
Off price retailer: $
14. If a graphic T-shirt costs $8.95 and the MU % is 53.4%, what is the retail price for the T-shirt? What would the pricing strategy be? Cost $ Cost % Retail $ Pricing Strategies
$8.95 0.47 $
Cumulative Markup Practice Problems
Description Quantity Unit Cost Total Cost Unit Retail Total Retail
15. A buyer purchased 50 assorted leather briefcases that cost $79.50 each and establishes retail prices based on the style as follows: • 15 zip-top briefcases to retail for $175 each. • 20 messengers to retail for $150 each. • 15 backpacks to retail for $125 each. Find the cumulative markup percentage on this purchase. Zip Top 15 $79.50 $175.00
Messenger 20 $79.50 $150.00
Backpack 15 $79.50 $125.00
TOTAL
MU $ = Total Retail -Total Cost
MU $ =
MU % = MU $/total retail $
MU % =
16. The sweater buyer is buying 12,000 cashmere crew neck and 8,000 V-neck sweaters at a cost of $32.50. The buyer plans to retail the sweaters as follows: Crew neck to retail at $74.00; V-neck to retail at $79.00
a.   Calculate the IMU $ and IMU % for the crew neck. Quantity Unit Cost Total Cost Unit Retail Total Retail
12,000 $32.50 $74.00
MU $= Retail -Cost
MU $= or
MU %= MU $/ Retail $
b.   Calculate the IMU $ and IMU % for the V- neck.
8,000 $32.50 $79.00
MU $= Retail -Cost
MU $= or
MU %= MU $/ Retail $
c. Calculate the CMU % for the total buy. Total Cost Total Retail CMU $ CMU %
CMU $ =Total Retail -Total Cost
CMU %=CMU $/Total Retail $
Cumulative Markup Application Practice Problems
17. The jewelry buyer wants to spend $25,000 at retail. The department maintains a 76.7% markup. The buyer needs a minimum of 600 pairs of earrings to cover each branch with an adequate assortment.
a. What should be the retail price per pair? Retail Budget Units Retail Price
$25,000 600
b. What should be the cost per pair? Retail Cost % Cost Price
$25.00
18. For a monthly T-shirt buy, you will be spending $22,560 at retail. Orders for $9,980 at cost have been placed. The planned MU % is 51.5%. What is left in retail dollars for you to place? Cost Cost %
$9,980.00 Retail Budget
Plan/Budget Spent Over/Under
$22,560.00