Please give formulas for: monthly reductions, purchases at retail, and purchases at coat

ROBLEMS 1. 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 initial markup is planned 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 Reductipas Month Distribution Stock-to-Sales Ratio Distribution Feb 10% 2.4 5% Mar 10% 2.4 5% Apr 35% 2.1 10% May 20% 2.0 20% June 15% 2.0 30% July 10% 2.0 30% 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. G17 x F D G B E A 1 5 MONTH BUYING PLAN 2 3 Sales (LY) 4 % Planned Increase 5 Planned Sales for Period 6 Planned EOM for Period 7 Initial Markup % 8 Planned Reductions % $589,345.00 5% $618,812.25 $190,000.00 53.90% 8% 9 FEB MAR APR MAY JUNE JULY 10% 10% 35% 20% 10% 15% 2 2. 2.4 2 2.4 2.1 5% 5% 10% 20% 30% 30% 10 Sales Distribution 11 Stock-Sales Ratio 12 Reductions Distribution 13 14 PLANNED MONTHLY SALES 15 PLANNED MONTHLY BOM 16 PLANNED MONTHLY EOM 17 PLANNED MONTHLY REDUCTIONS 18 PLANNED PURCHASES AT RETAIL 19 PLANNED PURCHASES AT COST 20 21 22 23 $61,881.23 $148,514.94 $148,514.94 $61,881.23 $216,584.29 $123,762.45 $92,821.84 $61,881.23 $148,514.94 $454,827.00 $247,524.90 $185,643.68 $123,76245 $454,827.00 $247,52490 $185,643.68 $123,762.45 $190.000.00