The buyer for the boys' department had received 4 dozen all-weather jackets that retailed for $68 each. After several weeks, 8 of the jackets were sold and the remaining 40 jackets were marked down to $50 for a one-day sale. Twelve jackets were sold during the one-day sale. All remaining jackets were re-marked to $61 and eventually sold at that price. Determine the net markdown percent.

Spreadsheet: Markdown Cancellation and Net Markdowns
Example 6-7
	Units	Orginal Price	Reduced Price
Total Markdown
	Units	Reduced Price	Repriced at
Total Markdown Cancellation
	Total	Markdown
	Markdown	Cancellation
Net $ Markdown
	Units	Selling Price	Total
Total Sales
	Net Markdown	Total Sales
Net Markdown %

Show formula to calculate problems in the excel table

#2

During March, the Camera Shop had a net markdown of $529. If the total markdowns amounted to $830, determine the markdown cancellation.

                                                                                                             

Spreadsheet: Markdown Cancellation and Net Markdowns
Example 6-7
	Units	Orginal Price	Reduced Price
Total Markdown
	Units	Reduced Price	Repriced at
Total Markdown Cancellation
	Total	Markdown
	Markdown	Cancellation
Net $ Markdown
	Units	Selling Price	Total
Total Sales
	Net Markdown	Total Sales
Net Markdown %

Show formula to calculate problems in the excel table