Exam 9: Markup and Markdown

Adrian's Salon tracks their retail merchandise in a spreadsheet. Cost is in Column B, Markup Rate is in Column C, Mark up Amount is in Column D, and Selling Price is in Column E. If the Cost and Markup Rate Based on Cost are known, what formulas would be needed in Row 7 to find the missing values?

Magnifying glasses sell for $12.50 and are marked up 32% of the selling price. What is the cost of a magnifying glass?

Which statement is true?

Alice owns a clothing store. She is going to markdown her summer items by 35%. If a dress sells for $57.50, what is the markdown price?

Marlene sells make-up kits in her store. Each kit costs her $26.34. The markup amount is $7.25. What is the selling price?

The cost of an item is $239, and the markup rate is 35%. What is the selling price?

Adrian's Salon tracks their retail merchandise in a spreadsheet. Cost is in Column B, Markup Rate is in Column C, Mark up Amount is in Column D, and Selling Price is in Column E. If the Markup Rate and Selling Price Based on Cost are known, what formulas would be needed in Row 9 to find the missing values?

The original price on a table is $250. The table is on sale for $137.50. What is the markdown rate?

Janice marked down the coffee mugs 38%. If the sale price is $4.00, what is the original price?

The cost of a hairbrush is $2.20, and the markup is 25%. What is the selling price?

Markdown is also called gross profit. It is the difference between cost and selling price.

The only way to copy a formula or data from one cell to other cells in Excel is with the copy and paste functions on the Ribbon.

A puppy at a pet store has his price reduced by 40%, and the markdown amount is $120. What is the sale price?

A company buys swing sets for $1,500 and sells them at a markup rate of 40%. What is the markup amount?

The markup rate of furniture at Al's Furniture Barn is 48%. If the markup amount on an armchair is $123, what is the cost of the armchair?

The retail price of a camping chair is $12. If the markup rate is 30% based on cost, what is the cost of the camping chair?

A hat from last season is reduced by 60% and the markdown amount is $15. The sale price of the hat is $25.

The retail price of a tennis racket is $89. If the markup rate is 25% based on cost, what is the cost of the tennis racket?

Florence sells appliances at a local appliance store. Several clothes dryers were received that cost $215.68 each. If the markup rate is 56%, what is the retail price of a dryer?

The cost of a package of paper is $13.85. The markup rate is 31%. What is the selling price?