For this assignment, use Excel to calculate the answers using figures provided. Keep two decimal places. Save your work as "Last Name Assignment 6 Part 3 so that I can tell whose assignment it is and which assignment it is. Submit your assignment on Canvas. A buyer has planned purchases for the month of March for the ten items listed below. At the end of the first week in March, the buyer wants to determine the open-to-buy (at both retail and cost) for each of these items. Initial markup percentages as well as purchases to date are provided for each item. Calculate open-to-buy (at both retail and cost). Item Purchases to date Initial MU% Open-to-buy (at Open-to-buy (at retail) cost) 1 2 3 4 5 6 7 8 9 10 Planned purchases at retail $ 14,900 $ 27,400 $ 11,800 $ 9,700 $ 15,300 $ 12,900 $ 19,100 $ 14,300 $ 9,200 $ 1,300 $ 10,500 $ 17,900 $ 10,500 $9,000 $ 10,700 $ 13,000 $ 19,000 $ 1,500 $ 9,000 $ 1,250 49.5% 49.0 % 47.5 % 49.5% 49.0% 49.0 % 49.5% 49.5 % 49.0 % 49.5%