2. The following markdowns were taken last month in department 200: Units Style Original Retail % off OH Item 1 $ 16.00 30% 680 Item 2 $ 28.00 30% 295 Item 3 $ 48.00 40% 98 Item 4 $ 62.00 50% 282 Item 5 $ 9.50 30% 490 Planned sales for the department are $385,000 and the planned MD% is 5%. Find the following: e. Total markdown dollars taken f. Actual MD% g. Planned MD $ h. $ amount over/under plan Markdown Problems Complete the problems using Excel. Create your tables using gridlines and appropriate number format. All problems should list $ answer with .00 and % answers with .O