the first 2 photos include the problem, the next 2 include the six month plan with the yellow places where i need to fill things out, and the last 2 are formulas incase you need them. please answer the problems and how to plug things in the six month plan (with their formulas, not just the answer) thanks so much!

When the buyer for the activewear department started to develop the merchandise plan for the Spring season, they reviewed the six-month on the next sheet. The numbers that were achieved represent the department's performance last year for a fast-selling and up-trending department. The buyer was given the following information to plan the upcoming Spring season: +4% Planned Sales: Planned Markdowns %: 45.1% Planned Turnover: 0.98 Cumulative Markup %: 68.7% For next Spring, the buyer has to take into account a shift in Easter selling. Last year, Easter occurred on the first Sunday in April, therefore, pre-Ester sales happened the last two weeks in March. This year, Easter falls in the third week of April, Based on the sales success this department has experienced over the last two years, the buyer is concerned about keeping that trend going Acting as the buyer for the acrivewear department, formulate the six-month plan: 3 4 5 a Calculate each month's percentage of sales for last year. 16 17 b. Calculate the total season sales planned. What will the planned sales by by taking into account the Easter shift. 18 so 12 Acting as the buyer for the acrivewear department, formulate the six-month plan: 13 a. Calculate each month's percentage of sales for last year. 17 b. Calculate the total season sales planned. What will the planned sales by by taking into account the Easter shift. 14 15 16 c. Calculate the planned markdown dollars and percentage by month. 18 19 20 21 22 23 d. Calculate the BOM stock needed by month. 24 e. Calculate the receipts dollars needed to achieve the BOM stock. 25 1 DEPARTMENT WOMEN'S ACTIVEWEAR 3 SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL $685.00 $790.00 $650.00 $800.00 $950.00 $625.00 $4,500,00 10 11 13 6.1 5.81 67 63 5. 69 1 SALES % TO TOTALLY LAST YEAR IPLAN SALESS XINCREASE/DECREASE REVISED ACTUAL STOCK-SALES LAST YEAR RATIO IPLAN LAST YEAR BOM STOCKS PLAN (RETAIL) REVISED ACTUAL LAST YEAR PLAN MARKDOWNSS XTO SALES BY MONTH REVISED SACTUAL Six month $4,200.00 $4,600.00 $4,350.00 $5,000,00 $5,400.00 $4,300.00 $4,800.00 54,800.00 $4,664.30 11 17 $229.00 $28.00 $254.00 58.00 $120.00 $375.00 $1,914.00 10 $1,478.00 $828.00 $1,554.00 $1,548.00 $270.00 $1,500.00 $7,178.00 20 % TO SALES MARKDOWNS $ % BY MONTH SEVSED 95 ACTUAL 24 LAST YEAR PURCHASES $ PLAN 26 (RETAIL) REVISED 21 ACTUAL SEASON TOTAL SALES CMUX MARKDOWN 31 GROSS MARGIN AVERAGE STOCK TURNOVER PLAN ACTUAL LAST YEAR $4,500 68 SOX 42 50% 55.10X 46643 0.96 21 A B c D E F % Monthly Sales to Total Month's Sales $ / Season Total Sales S S Monthly Sales LY % Monthly Sales x TY season Sales 3 Stock-to-Sales Ratio Current Retail Stock $ / Current Sales $ 4 MD % to Sales MD $ / Sales $ 5 MD $ MD % to Sales x Sales $ 6 Purchase $ (Next Month BOM + Current Month Sales + Current Month MD) - Current Month BOM 7 Average Retail Stock Sum of Monthly BOMs/# of months 3 Stock-to-Sales Ratio Current Retail Stock $ / Current Sales $ 4 MD % to Sales MD $ / Sales $ 5 MDS MD % to Sales x Sales 6 Purchase $ (Next Month BOM + Current Month Sales + Current Month MD) - Current Month BOM 7 Average Retail Stock Sum of Monthly BOMs/# of months 8 Turnover Net Sales / Average Retail stock To increase turn to the plan 0.98 for the season, the BOM stock will need to be adjusted down. Sales should not change as they are planned at a 4% increase. The factor that will affect the turnover would be to decrease the average Inventory. As fuly is the highest stock to sales ratio, some inventory can be taken out of July, April and May as well. August should remain flat. 9 10 Problem Six month plan formulas When the buyer for the activewear department started to develop the merchandise plan for the Spring season, they reviewed the six-month on the next sheet. The numbers that were achieved represent the department's performance last year for a fast-selling and up-trending department. The buyer was given the following information to plan the upcoming Spring season: +4% Planned Sales: Planned Markdowns %: 45.1% Planned Turnover: 0.98 Cumulative Markup %: 68.7% For next Spring, the buyer has to take into account a shift in Easter selling. Last year, Easter occurred on the first Sunday in April, therefore, pre-Ester sales happened the last two weeks in March. This year, Easter falls in the third week of April, Based on the sales success this department has experienced over the last two years, the buyer is concerned about keeping that trend going Acting as the buyer for the acrivewear department, formulate the six-month plan: 3 4 5 a Calculate each month's percentage of sales for last year. 16 17 b. Calculate the total season sales planned. What will the planned sales by by taking into account the Easter shift. 18 so 12 Acting as the buyer for the acrivewear department, formulate the six-month plan: 13 a. Calculate each month's percentage of sales for last year. 17 b. Calculate the total season sales planned. What will the planned sales by by taking into account the Easter shift. 14 15 16 c. Calculate the planned markdown dollars and percentage by month. 18 19 20 21 22 23 d. Calculate the BOM stock needed by month. 24 e. Calculate the receipts dollars needed to achieve the BOM stock. 25 1 DEPARTMENT WOMEN'S ACTIVEWEAR 3 SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL $685.00 $790.00 $650.00 $800.00 $950.00 $625.00 $4,500,00 10 11 13 6.1 5.81 67 63 5. 69 1 SALES % TO TOTALLY LAST YEAR IPLAN SALESS XINCREASE/DECREASE REVISED ACTUAL STOCK-SALES LAST YEAR RATIO IPLAN LAST YEAR BOM STOCKS PLAN (RETAIL) REVISED ACTUAL LAST YEAR PLAN MARKDOWNSS XTO SALES BY MONTH REVISED SACTUAL Six month $4,200.00 $4,600.00 $4,350.00 $5,000,00 $5,400.00 $4,300.00 $4,800.00 54,800.00 $4,664.30 11 17 $229.00 $28.00 $254.00 58.00 $120.00 $375.00 $1,914.00 10 $1,478.00 $828.00 $1,554.00 $1,548.00 $270.00 $1,500.00 $7,178.00 20 % TO SALES MARKDOWNS $ % BY MONTH SEVSED 95 ACTUAL 24 LAST YEAR PURCHASES $ PLAN 26 (RETAIL) REVISED 21 ACTUAL SEASON TOTAL SALES CMUX MARKDOWN 31 GROSS MARGIN AVERAGE STOCK TURNOVER PLAN ACTUAL LAST YEAR $4,500 68 SOX 42 50% 55.10X 46643 0.96 21 A B c D E F % Monthly Sales to Total Month's Sales $ / Season Total Sales S S Monthly Sales LY % Monthly Sales x TY season Sales 3 Stock-to-Sales Ratio Current Retail Stock $ / Current Sales $ 4 MD % to Sales MD $ / Sales $ 5 MD $ MD % to Sales x Sales $ 6 Purchase $ (Next Month BOM + Current Month Sales + Current Month MD) - Current Month BOM 7 Average Retail Stock Sum of Monthly BOMs/# of months 3 Stock-to-Sales Ratio Current Retail Stock $ / Current Sales $ 4 MD % to Sales MD $ / Sales $ 5 MDS MD % to Sales x Sales 6 Purchase $ (Next Month BOM + Current Month Sales + Current Month MD) - Current Month BOM 7 Average Retail Stock Sum of Monthly BOMs/# of months 8 Turnover Net Sales / Average Retail stock To increase turn to the plan 0.98 for the season, the BOM stock will need to be adjusted down. Sales should not change as they are planned at a 4% increase. The factor that will affect the turnover would be to decrease the average Inventory. As fuly is the highest stock to sales ratio, some inventory can be taken out of July, April and May as well. August should remain flat. 9 10 Problem Six month plan formulas