ALL SIX MONTH PLAN WORK MUST BE INSERTED INTO THE PLAN (TABLE) WITH FORMULAS. SEASON TOT....

Transcribed Image Text:

ALL SIX MONTH PLAN WORK MUST BE INSERTED INTO THE PLAN (TABLE) WITH FORMULAS. SEASON TOT. SALES PLAN TY $ 1,044,100 SALES ACTUALLY $ 1,015,000 Markup % 56% Reductions $ $ 156,615 Reductions% 15% Average Stock $ Turnover 160,675 6.50 SIX-MONTH DOLLAR PLAN SEASON TOTAL 1,015,000 $ 1,044,100 Spring SALES $ FEBRUARY MARCH Sales Plan % to total Last Year Sales TY Plan $ $ % Inc/Dec vs LY 8.0% 80,000 $ 84,000 $ 5.0% APRIL 12.4% 18.4% 120,000 $ 175,000 $315,000 $ 129,600 $ 192,500 $ 299,250 $ 8.0% 10.0% -5.0% MAY JUNE 28.7% 22.2% 10.2% 225,000 $100,000 D 231,750 $ 107,000 3.0% JULY AUGUST $ STOCK/SALES RATIO Plan 2.6 2.4 2.3 2.0 1.8 7.0% 1.7 BOM STOCK $ Plan EOM STOCK $ Plan MARKDOWNS $ Plan % by Month PURCHASES $ RETAIL PURCHASES $ COST Plan Plan 6. Plan the Sales for This Year (TY) by applying the % Increase or % Decrease by month. What are the Total Planned Sales for TY? February March April May June July 5% 8% 10% -5% 3% 7% TOTAL PLANNED SALES 1,044,100 7. Calculate the % of sales each month contributes to the new TY Plan. What Is the % Contribution of April to the total? % to Total Plan April 18.4% 8. Total Markdowns or Reductions are planned at 15% of Planned Sales. Calculate the Total Planned Markdowns. Total Planned Reductions $ n 156,615 9. Plan the Markdowns or Reductions Value by month with the following % distribution. What are the Planned Reductions value for April? February March April May June July APRIL PLANNED MARKDOWNS 8% 10% 10% 15% 27% 30% $156,615 ALL SIX MONTH PLAN WORK MUST BE INSERTED INTO THE PLAN (TABLE) WITH FORMULAS. SEASON TOT. SALES PLAN TY $ 1,044,100 SALES ACTUALLY $ 1,015,000 Markup % 56% Reductions $ $ 156,615 Reductions% 15% Average Stock $ Turnover 160,675 6.50 SIX-MONTH DOLLAR PLAN SEASON TOTAL 1,015,000 $ 1,044,100 Spring SALES $ FEBRUARY MARCH Sales Plan % to total Last Year Sales TY Plan $ $ % Inc/Dec vs LY 8.0% 80,000 $ 84,000 $ 5.0% APRIL 12.4% 18.4% 120,000 $ 175,000 $315,000 $ 129,600 $ 192,500 $ 299,250 $ 8.0% 10.0% -5.0% MAY JUNE 28.7% 22.2% 10.2% 225,000 $100,000 D 231,750 $ 107,000 3.0% JULY AUGUST $ STOCK/SALES RATIO Plan 2.6 2.4 2.3 2.0 1.8 7.0% 1.7 BOM STOCK $ Plan EOM STOCK $ Plan MARKDOWNS $ Plan % by Month PURCHASES $ RETAIL PURCHASES $ COST Plan Plan 6. Plan the Sales for This Year (TY) by applying the % Increase or % Decrease by month. What are the Total Planned Sales for TY? February March April May June July 5% 8% 10% -5% 3% 7% TOTAL PLANNED SALES 1,044,100 7. Calculate the % of sales each month contributes to the new TY Plan. What Is the % Contribution of April to the total? % to Total Plan April 18.4% 8. Total Markdowns or Reductions are planned at 15% of Planned Sales. Calculate the Total Planned Markdowns. Total Planned Reductions $ n 156,615 9. Plan the Markdowns or Reductions Value by month with the following % distribution. What are the Planned Reductions value for April? February March April May June July APRIL PLANNED MARKDOWNS 8% 10% 10% 15% 27% 30% $156,615