You, as the owner of the boutique, My Lady, want to figure out the net markdown % and maintained markup% from your September sales.In order to facilitate the calculation, you are creating an EXCEL spreadsheet containing September Performance Record as follows.

You, as the owner of the boutique, My Lady, want to figure out the net markdown % and maintained markup% from your September sales. In order to facilitate the calculation, you are creating an EXCEL spreadsheet containing September Performance Record as follows. The actual retail MD$ & MD% price for which Maintained for each unit. each unit was sold MU% # Item Units Unit Original Retail Sale Price Total Net Cost per unit Cost$ Sales$ $Net MD sold per unit MMU% $MD MD% Pants 1 35 $8.50 $17.00 $17.00 Pants 2 7 $8.50 $17.00 $14.00 Skirt 1 20 $9.00 $20.00 $20.00 Skirt 2 5 $7.00 $20.00 $13.00 T-shirt 1 50 $7.50 $15.00 $15.00 T-shirt 2 40 $7.00 $15.00 $13.00 T-shirt 3 20 $6.00 $15.00 $10.00 Total 177 Net MD% = Net MD% in September