AutoSave OR pg 8 9781501395062 spreadsheet_027 (1) - Compatibility Mode - Excel Home Insert File Draw Formulas View Page Layout Data Review Help CS f -C3C4 K A B C D E F G H PERRY'S STOCK/SALES RATIO AND BOM STOCK 1 AUGUST SEPTEMBER Na OCTOBER DECEMBER NOVEMBER JANUARY FEBRUARY 3 PL Sales 4 S/S Ratio 5 BOM Stock 6 Plan Sales Stock/Sales Ratio - BOM Stock 7 Justification by Month 8 August 9 10 September 11 12 October 13 14 November 15 16 December 17 18 January Sheet1 Sheet2 Sheet3 + Type here to search O BE E E PERRY'S MONTHLY SALES BY PERCENTAGE AND INCREASE/DECREASE AUGUST 20.5 SEPTEMBER 19.9 OCTOBER 17.7 NOVEMBER 23.4 DECEMBER 38.0 15.4% 15.0% 13.3% 17.6% 28.6% JANUARY Total 13.3 132.8 10.0% 100% 14.5 145.1 10.0% 100% 1.2 12.3 21.3 20.7 21.5 26.7 PL Sales % by Month LY Sales % by Month $ Inc/Dec % Inc/Dec 40.4 14.7% 14.3% 14.8% 18.4% 27.8% 0.8 0.8 3.3 2.4 3.8 -17.7% -3.8% -3.9% -12.4% -5.9% -8.3% -8.5% AutoSave OR pg 8 9781501395062 spreadsheet_027 (1) - Compatibility Mode - Excel Home Insert File Draw Formulas View Page Layout Data Review Help CS f -C3C4 K A B C D E F G H PERRY'S STOCK/SALES RATIO AND BOM STOCK 1 AUGUST SEPTEMBER Na OCTOBER DECEMBER NOVEMBER JANUARY FEBRUARY 3 PL Sales 4 S/S Ratio 5 BOM Stock 6 Plan Sales Stock/Sales Ratio - BOM Stock 7 Justification by Month 8 August 9 10 September 11 12 October 13 14 November 15 16 December 17 18 January Sheet1 Sheet2 Sheet3 + Type here to search O BE E E PERRY'S MONTHLY SALES BY PERCENTAGE AND INCREASE/DECREASE AUGUST 20.5 SEPTEMBER 19.9 OCTOBER 17.7 NOVEMBER 23.4 DECEMBER 38.0 15.4% 15.0% 13.3% 17.6% 28.6% JANUARY Total 13.3 132.8 10.0% 100% 14.5 145.1 10.0% 100% 1.2 12.3 21.3 20.7 21.5 26.7 PL Sales % by Month LY Sales % by Month $ Inc/Dec % Inc/Dec 40.4 14.7% 14.3% 14.8% 18.4% 27.8% 0.8 0.8 3.3 2.4 3.8 -17.7% -3.8% -3.9% -12.4% -5.9% -8.3% -8.5%