Note: Please use a 6-Month Blank Template from Canvas to work this problem and upload the file here. Please show your work and round to the nearest dollar and ratios to two decimal points. Month % of Sales BOM Stock-Sales Ratio % of Markdowns February 14.0 3.8 16.8 March 16.0 4.2 14.26 April 20.0 3.5 15.64 May 17.5 3.6 15.28 June 16.5 3.7 16.20 July 16.0 3.9 21.82 Distribute total season's sales of $250,000 over each month. Calculate monthly dollar markdowns and total season dollar markdowns of the season markdown percent is 9.5%. Plan BOM stock values. Enter EOM values. Use $150,000 for the July EOM. Calculate monthly planned purchases at retail. Calculate monthly planned purchases at cost if the initial markup percent is 50.5%. Calculate turn over for the season. Six Month Merchandising Plan Department Dept. No. From Spring Feb Aug Mar Sept Apr Oct May Nov June Dec July Jan Total Total To LY TY Departmental Data % Initial Markup % Reductions % Maintained Markup % Alteration Expense % Cash Discount % Gross Margin % Operating Expense % Net Profit Season Turnover Average Sales Average Inventory Basic Stock Fall Sales Last Year Plan Plan % Revised Plan Actual % of LY Sales EOM Last Year Plan Revised Plan Actual Markdowns Last Year Plan Revised Plan Actual Plan % BOM Last Year Plan Revised Plan Actual Plan S/S Ratio Planned Last Year Purchases Plan at Retail Revised Plan Actual Planned Last Year Purchases Plan at Cost Revised Plan Note: Please use a 6-Month Blank Template from Canvas to work this problem and upload the file here. Please show your work and round to the nearest dollar and ratios to two decimal points. Month % of Sales BOM Stock-Sales Ratio % of Markdowns February 14.0 3.8 16.8 March 16.0 4.2 14.26 April 20.0 3.5 15.64 May 17.5 3.6 15.28 June 16.5 3.7 16.20 July 16.0 3.9 21.82 Distribute total season's sales of $250,000 over each month. Calculate monthly dollar markdowns and total season dollar markdowns of the season markdown percent is 9.5%. Plan BOM stock values. Enter EOM values. Use $150,000 for the July EOM. Calculate monthly planned purchases at retail. Calculate monthly planned purchases at cost if the initial markup percent is 50.5%. Calculate turn over for the season. Six Month Merchandising Plan Department Dept. No. From Spring Feb Aug Mar Sept Apr Oct May Nov June Dec July Jan Total Total To LY TY Departmental Data % Initial Markup % Reductions % Maintained Markup % Alteration Expense % Cash Discount % Gross Margin % Operating Expense % Net Profit Season Turnover Average Sales Average Inventory Basic Stock Fall Sales Last Year Plan Plan % Revised Plan Actual % of LY Sales EOM Last Year Plan Revised Plan Actual Markdowns Last Year Plan Revised Plan Actual Plan % BOM Last Year Plan Revised Plan Actual Plan S/S Ratio Planned Last Year Purchases Plan at Retail Revised Plan Actual Planned Last Year Purchases Plan at Cost Revised Plan