Done in excel

2. Develop a merchandise plan based on information that follows. Sales for the six-month fall/winter season have been planned to total $650,000. Markdowns for the total season are to be 22% of the total planned sales, and season's turnover should be 1.9. BOM inventory values are to be planned by the basic stock method. In this problem, ending inventory will be the same as the average inventory. a. Calculate total markdown dollars for the season and allocate the markdowns for each month on the basis of the percentages given. b. Using the basic stock method, calculate BOM inventory values for each month. c. The season's EOM is the average inventory for the season. d. Calculate planned purchases at retail