please show formulas

pls show work ****

Feb $100,000 March $110,000 April $60,000 May $120,000 TOTAL June $140,000 July $60,000 5.00% 5.00% 5.00% -3.00% 3.00% 3.00% 8.00% 12.00% 12.00% 18.00% 22.00% 28.00% 16.00% 12 Problem #1 COE 1 1. plan sales brag 1. Sales LY (5) TY planned U Increase/decrease from LY is (%) 16 Sales TY Plan ($) 17 2. plan reductions sala 1 Reduction TY Plan (%) nitorje 1. Reduction TY Plan (S) 20 3. plan stock |2| BOM LY 22 SSR 2 BOM TY Plan 22 EOM TY Plan 25 4. plan purchases * Purchases TY Plan year > Merchandise on Order 2 Open-to-buy (at retail) 20 Open-to-buy (at cost) verdig AMU = 58% liter 30 $360,000 $396,000 $312,000 $432,000 $434,000 $312,000 $380,000 $40,000 $10,000 $12,000 $6,000 $8,000 $4,000 31 Det TOTAL August $80,000 September $70,000 October $85,000 November $100,000 December $110,000 January $80,000 2.00% 3.00% -2.00% -2.00% 4.00% 4.00% 32 Problem #2 33 34 1. plan sales 3 Sales LY ($) TY planned increaseldecrease from LY 36 (%) 3 Sales TY Plan (S) ale 32. plan reductions erle Reduction TY Plan (%) 10 Reduction TY Plan (S) 41 3. plan stock 15.00% 13.00% 12.00% 18.00% 22.00% 20.00% 12.00% 2.8 3.4 32 44 SSR 3.2 3.6 $280,000 $20,000 $12,000 $8,000 $10,000 $8,000 45 BOM TY Plan EOM TY Plan 45 4. plan purchases 4 Purchases TY Plan 4Merchandise on Order ear 4 Open-to-buy (at retall) 4 Open-to-buy at cost) erag 30 tor $5,000 AMU = 55% Feb $100,000 March $110,000 April $60,000 May $120,000 TOTAL June $140,000 July $60,000 5.00% 5.00% 5.00% -3.00% 3.00% 3.00% 8.00% 12.00% 12.00% 18.00% 22.00% 28.00% 16.00% 12 Problem #1 COE 1 1. plan sales brag 1. Sales LY (5) TY planned U Increase/decrease from LY is (%) 16 Sales TY Plan ($) 17 2. plan reductions sala 1 Reduction TY Plan (%) nitorje 1. Reduction TY Plan (S) 20 3. plan stock |2| BOM LY 22 SSR 2 BOM TY Plan 22 EOM TY Plan 25 4. plan purchases * Purchases TY Plan year > Merchandise on Order 2 Open-to-buy (at retail) 20 Open-to-buy (at cost) verdig AMU = 58% liter 30 $360,000 $396,000 $312,000 $432,000 $434,000 $312,000 $380,000 $40,000 $10,000 $12,000 $6,000 $8,000 $4,000 31 Det TOTAL August $80,000 September $70,000 October $85,000 November $100,000 December $110,000 January $80,000 2.00% 3.00% -2.00% -2.00% 4.00% 4.00% 32 Problem #2 33 34 1. plan sales 3 Sales LY ($) TY planned increaseldecrease from LY 36 (%) 3 Sales TY Plan (S) ale 32. plan reductions erle Reduction TY Plan (%) 10 Reduction TY Plan (S) 41 3. plan stock 15.00% 13.00% 12.00% 18.00% 22.00% 20.00% 12.00% 2.8 3.4 32 44 SSR 3.2 3.6 $280,000 $20,000 $12,000 $8,000 $10,000 $8,000 45 BOM TY Plan EOM TY Plan 45 4. plan purchases 4 Purchases TY Plan 4Merchandise on Order ear 4 Open-to-buy (at retall) 4 Open-to-buy at cost) erag 30 tor $5,000 AMU = 55%