calculate using excel please and can you provide formulas?

used as the ending inventory figure and expects a turnover rate of 3.0. Chapter 8 Review Exercise A Complete the blank six-month plan form using the following data and rounding to Sales for the six-month period beginning in August are planned at $350,000 and total markdowns during the period are planned at 18%. The department utilizes the basic stock method for planning BOM stock levels and the average stock figure will be the nearest whole dollar: MONTY PLANS 223 MONTH % SALES BY MONTH % MARKDOWNS BY MONTH August September 14% 18% 20% October 20% 15% 12% November December January 17% 23% 15% 19% 11% 16% a. Calculate planned sales by month b. Calculate total planned markdown dollars c. Calculate planned markdowns by month d. Calculate planned BOM stock levels e Calculate average stock . Calculate planned purchases by month (at retail) g. Calculate the initial markup percentage and gross margin percentage given the following: Operating Expenses = 30% Planned Profit = 5% Cash Discounts = 2% h. Calculate planned GMROHI used as the ending inventory figure and expects a turnover rate of 3.0. Chapter 8 Review Exercise A Complete the blank six-month plan form using the following data and rounding to Sales for the six-month period beginning in August are planned at $350,000 and total markdowns during the period are planned at 18%. The department utilizes the basic stock method for planning BOM stock levels and the average stock figure will be the nearest whole dollar: MONTY PLANS 223 MONTH % SALES BY MONTH % MARKDOWNS BY MONTH August September 14% 18% 20% October 20% 15% 12% November December January 17% 23% 15% 19% 11% 16% a. Calculate planned sales by month b. Calculate total planned markdown dollars c. Calculate planned markdowns by month d. Calculate planned BOM stock levels e Calculate average stock . Calculate planned purchases by month (at retail) g. Calculate the initial markup percentage and gross margin percentage given the following: Operating Expenses = 30% Planned Profit = 5% Cash Discounts = 2% h. Calculate planned GMROHI