I need the formulas to calculate planned monthly sales, planned monthly BOM, planned monthly EOM, planned monthly reductions, planned purchase at retail and planned purchase at cost

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 Reductions Month Distribution Stock-to-Sales Ratio Distribution Feb 10% 5% Mar 10% 5% Apr 35% 2.1 10% May 20% 2.0 20% 15% 30% July 10% 30% 2.4 June 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. Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 6 MONTH BUYING PLAN Sales (LY) $589,345 % Planned Increase Planned Sales for Period Planned EOM for Period $35,360.70 $190,000 53.9% Initial Markup % Planned Reductions % 8% FEB MAR APR MAY JUNE JULY Sales Distribution 10% 10% 35% 20% 10% Stock-Sales Ratio 2.4 2.1 15% 2 30% Reductions Distribtution 5% 5% 10% 20% 30% PLANNED MONTHLY SALES PLANNED MONTHLY BOM PLANNED MONTHLY EOM PLANNED MONTHLY REDUCTIONS PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST