formulas for the x values

June Planned BOM Stock Planned Sales Planned Retail Reductions Planned EOM Stock Planned Purchases at Retail Planned SOM Stock-to-Sales Ratio Planned Sales Planned Retail Reduction February March April May July Total $225,000 $300,000 5375,000 $300,000 75,000 100.000 50,000 125,000 75,000 7,500 X 5,000 7,500 16,250 50,000 300,000 250,000 375.000 300.000 X 157,500 82.500 55,000 182,500 56,250 41,250 575,000 3 4 3 5 3 X 15% 15% 20% 10 25% 155 100% 10 10% 5% 15% 56 21.67% 10% Planned Total Sales for the Period $500,000 Planned BOM Stock for August $250,000 5 6 7 B 9 0 1