SP2 Frances Drew ib_e02_merchandiseperformancereport.xlsx

SP2 Frances Drew ib_e02_merchandiseperformancereport.xlsx -...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Merchandise Performance Report Category Item Color Unit Sales Price Bottoms Shorts Tan 12,500 $19.00 $237,500 36,000 Bottoms Shorts White 9,500 $19.00 $180,500 40,000 Bottoms Shorts Brown 8,500 $19.00 $161,500 25,000 Bottoms Shorts Blue 5,500 $19.00 $104,500 45,000 Shoes Boots Black 1,600 $60.00 $96,000 5,000 Shoes Sandals Black 3,000 $22.00 $66,000 15,000 Shoes Boots Brown 750 $60.00 $45,000 3,500 Shoes Sandals Grey 1,200 $22.00 $26,400 3,400 Shoes Sandals Green 850 $22.00 $18,700 2,500 Tops Sweater Red 15,000 $34.00 $510,000 20,000 Tops Sweater Grey 8,500 $34.00 $289,000 18,000 Tops Sweater Brown 3,500 $34.00 $119,000 15,000 Tops T-Shirts Black 10,000 $11.50 $115,000 50,000 Tops T-Shirts Blue 8,500 $11.50 $97,750 25,000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Tops Tank Tops White 6,500 $8.50 $55,250 35,000 Tops T-Shirts Yellow 4,500 $11.50 $51,750 10,000 Tops Tank Tops Pink 2,500 $8.50 $21,250 10,000 Tops Tank Tops Red 1,500 $8.50 $12,750 5,500 Total Sales Dollars Inventory Units 11.5 16.8 11.8 32.7 12.5 20.0 18.7 11.3 11.8 5.3 8.5 17.1 20.0 11.8 21.5 8.9 16.0 14.7 Weeks of Supply Question An tan short black boots red sweaters 36000 Which Item generates the most dollars for each category ? ==> How many $19.00 price tickets will the pricing manager need to print? swer...
View Full Document

Page1 / 4

SP2 Frances Drew ib_e02_merchandiseperformancereport.xlsx -...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online