[Retail/ Merchandising Math]

... Even just explaining how to get each box on the first row would help this make more sense

1.Set up the following chart, assuming 500 units were bought of the item or product category you have been monitoring and calculate the missing information.You can choose to enter it in excel or on this sheet by hand.

Item or product category

Fila Disruptor Sneaker

Ticketed Price

$64.99

Cost (60% IMU)

(chart attached)

Fila Disruptor Item or product category Sneaker Ticketed Price $64.99 Cost (60% IMU) Units Sales Selling Total Sales OH Sell thru Units Price at Retail MMU% Week 1 - 9/24 500 2.0% Week 2 - 10/1 3.0% Week 3 - 10/8 3.5% Week 4 - 10/15 4.0% Week 5 - 10/22 4.5% Week 6 - 11/5 5.0% Week 7 - 11/12 5.0% Week 8 - 11/19 5.0% Week 9 - Black Friday 35.0% Total Season Selling price is less any markdowns or promotions To Calculate MMU% you will need to calculate total cost the same way you calculate total retail