. 4. A buyer is negotiating a markdown goal with a supplier. The supplier will agree to pay for a portion of the markdowns for the season for items stocked at the retailer's stores. The buyer needs to forecast the markdowns in order to begin negotiations. Forecast the season's markdown based on the following information: The buyer plans to purchase 10,000 units priced at $25 per unit A sell through of 40% is expected at regular price A first markdown of 25% will happen after 6 weeks of regular price sales In the past, goods have sold at a rate of about 5% per week at the first markdown After 4 weeks of sales at the first markdown, goods to be reduced to 50% off the original retail In the past, goods have sold at a rate of about 10% per week at the second markdown After 4 weeks of sales at the second markdown, goods will be reduced to 75% off for the final markdown . I . 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