ib_e09_merchandiseplanningmeeting

ib_e09_merchandiseplanningmeeting - Item Number Item 556097...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Item Number Item 556097 Rayon Pants 777806 Rayon 2 Pc Set 798995 Rayon Knits 649738 Printed Rayon Skirts 650551 Knit Pants 744951 Knit 2 Pc Set 769809 Cardigan Knit 740910 Twill Jackets 692309 Twill Pants 768354 Denim Jeans 808362 Denim Jackets 595269 Leather Jackets 774926 Leather Vests 660445 Velvet Jeans 690970 Velvet Jackets 558977 Velvet Dress 565209 Velvet Skirts 589022 Wool Jackets 648291 Suede Jackets 711338 Suede Tops Department Grand Totals Cost Units Percent Sold Units Sold at Purchased at Full Price Full Price Retail Price Profit Rate 27 68.99 60.86% 6500 75.0% 36 98.99 63.63% 4000 75.0% 27 64.99 58.46% 3000 75.0% 22.5 58.99 61.86% 15000 75.0% 18 34.99 48.56% 2500 75.0% 27 54.99 50.90% 3500 75.0% 16.2 34.99 53.70% 1500 75.0% 23.4 44.99 47.99% 2500 75.0% 16.2 29.99 45.98% 5000 75.0% 14.4 24.99 42.38% 7500 75.0% 20.7 44.99 53.99% 3500 75.0% 135 289.99 53.45% 1500 75.0% 40.5 159.99 74.69% 2000 75.0% 18 44.99 59.99% 6500 75.0% 27 54.99 50.90% 3500 75.0% 45 144.99 68.96% 4000 75.0% 27 68.99 60.86% 5500 75.0% 36 89.99 60.00% 6000 75.0% 58.5 179.99 67.50% 2500 75.0% 40.5 89.99 54.99% 5000 75.0% Percent Sold at Units Sold at Markdown Markdown Price 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% Average Markdown Markdown Sales Dollars at Price Full Price Percent 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% 25.0% Scroll Bar Goal Seek How much does the total assortment have to sell at full price in order to achieve a 45% margin assuming all markdowns are 40% off. Scenario Manager Ask for various scenarios changing the full price Sell thru and the markdown. Table Builder Show the profit results of the entire department at 5 different markdown rates and 8 different Full Price Sales percent. Sales Dollars at Markdown Price Total Profit Total Sales Dollars Dollars Total Profit Rate ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online