it must have all formulas.

Last year's sales for the 6-month period of February to July were $589,345. A 5 percent increase in sales is anticipated this year. Total reductions for the period are planned at 8 percent. The at 53.9 percent. The buyer desires an ending inventory of $190,000 for the period. Based on an analysis of past sales records and current market trends, the buyer has also made plans for the period in relation to (1) monthly distribution of sales, (2) monthly stock- to-sales ratios, and (3) monthly distribution of planned reductions. These three planning estimates for each month are as follows: Sales Reductions Month Distribution Stock-to-Sales Ratio Distribution Feb 10% Mar 10% Apr 35% 10% May 20% 20% June 15% 30% July 10% 30% 5% 5% 20 Calculate (1) planned monthly sales, (2) planned monthly BOM, (3) planned monthly EOM (4) planned monthly reductions, (5) planned purchases at retail, and (6) planned purchases at cost. 6 MONTH BUYING PLAN Sales (LY) % Planned Increase $0.00 Planned Sales for Period Planned EOM for Period Initial Markup % Planned Reductions % MAR APR JUNE JULY Sales Distribution Stock-Sales Ratio Reductions Distribtution PLANNED MONTHLY SALES PLANNED MONTHLY BOM PLANNED MONTHLY EOM PLANNED MONTHLY REDUCTIONS PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST