First picture is the table to be filled out using all the information gathered from numbers 3-8

please do in excel if you can and show formulas, thanks!

28 Use the following 6 Month Buying Plan to post your answers for Problems 3 - 8. 29 Make certain to complete both the header and the body of the buying plan: 30 Fall 2022 31 Plan Net Sales, Fall 2022 32 Average Stock, Retail: 33 Inventory Turnover: 34 Planned Reductions, $: 35 Reductions % Sales: 36 Plan IMU%: 37 Discover more about your data Fall 2021 6 Month Buying Plan 39 August September October November December 40 Net Sales 41 % Fall SALES Full Price 42 Plan BOM Stock 43 Stock /Sales Ratio 44 Plan EOM Stock 45 Plan Reductions 46 % Fall REDUCTIONS 47 Purchases, Retail 48 Purchases, Cost 38 January Fall 2022 16% 50 3. 51 The total department plan sales for Fall 2022 is $845,000. 52 Plan sales by month using the following sales curve: 53 % Fall 2022 % Fall 2022 54 August 10% November 20% 55 September 12% December 30% 56 October 15% January 13% 57 58 4. 59 Reductions are planned to be 20% of net sales. 60 Plan reductions by month using the following curve: 61 % Fall 2022 % Fall 2022 62 August 8% November 25% 63 September 12% December 28% 64 October 11% January 65 66 5. 67 Use the following stock to sales ratios to plan monthly BOM and EOM stocks: 68 Stock / Sales Stock/Sales 69 August November 70 September December 2.2 71 October 2.9 January 3.4 72 Plan the January EOM stock to be $280,000. 73 74 6. 75 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2022. 76 77 5. 78 The plan IMU for Fall 2021 is 53.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2022. 79 80 %. 81 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2022: 82 2.9 2.9 2.7 28 Use the following 6 Month Buying Plan to post your answers for Problems 3 - 8. 29 Make certain to complete both the header and the body of the buying plan: 30 Fall 2022 31 Plan Net Sales, Fall 2022 32 Average Stock, Retail: 33 Inventory Turnover: 34 Planned Reductions, $: 35 Reductions % Sales: 36 Plan IMU%: 37 Discover more about your data Fall 2021 6 Month Buying Plan 39 August September October November December 40 Net Sales 41 % Fall SALES Full Price 42 Plan BOM Stock 43 Stock /Sales Ratio 44 Plan EOM Stock 45 Plan Reductions 46 % Fall REDUCTIONS 47 Purchases, Retail 48 Purchases, Cost 38 January Fall 2022 16% 50 3. 51 The total department plan sales for Fall 2022 is $845,000. 52 Plan sales by month using the following sales curve: 53 % Fall 2022 % Fall 2022 54 August 10% November 20% 55 September 12% December 30% 56 October 15% January 13% 57 58 4. 59 Reductions are planned to be 20% of net sales. 60 Plan reductions by month using the following curve: 61 % Fall 2022 % Fall 2022 62 August 8% November 25% 63 September 12% December 28% 64 October 11% January 65 66 5. 67 Use the following stock to sales ratios to plan monthly BOM and EOM stocks: 68 Stock / Sales Stock/Sales 69 August November 70 September December 2.2 71 October 2.9 January 3.4 72 Plan the January EOM stock to be $280,000. 73 74 6. 75 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2022. 76 77 5. 78 The plan IMU for Fall 2021 is 53.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2022. 79 80 %. 81 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2022: 82 2.9 2.9 2.7