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 1. The following markdowns were taken in department 100: Style Original Retail MD Retail Units OH $ Item 1 5.00 $ 3.49 12500 $ Item 2 7.00 $ 4.99 16588 $ Item 3 4.00 $ 1.99 9052 Item 4 $ 3.50 $ 1.99 2535 Item 5 $ 2.00 $ 0.99 15785 Planned sales for the department are $568,000 and the planned MD% is 15% Find the following: a. Total markdown dollars taken b. Actual MD% C. Planned MD $ d. $ amount over/under plan I Thushalt ortants 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