Please do in Excel, Number 3-8 are all related questions for the table above, Thanks!

January Fall 2022 38 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 8 Purchases, Cost 49 50 3. 51 The total department plan sales for Fall 2022 is 5845,000. 52. Plan sales by month using the following sales curve 53 XFall 2022 Fall 2022 54 August 10% November 20% 55 September 12% December 30% 56 October 15% January 13% 57 58 59 Reductions are planned to be 20% of net sales 60 Plan reductions by month using the following curve 51 X Fall 2022 X Fall 2022 62 August 8% November 25% 63 September December 28% 54 October 11% January 16% 65 66 67 Use the following stock to sales ratios to plan monthly BOM and EOM stocks 58 Stock /Sales Stock /Sales 69 August 29 November 2.9 70 September 2.7 December 2.2 71 October January 3.4 72 Plan the January EOM stock to be $280,000 73 74 75 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2022. 76 775. 78 The plan IMU for Fall 2021 is $3.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2022 12 29 80 81 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2022: January Fall 2022 38 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 8 Purchases, Cost 49 50 3. 51 The total department plan sales for Fall 2022 is 5845,000. 52. Plan sales by month using the following sales curve 53 XFall 2022 Fall 2022 54 August 10% November 20% 55 September 12% December 30% 56 October 15% January 13% 57 58 59 Reductions are planned to be 20% of net sales 60 Plan reductions by month using the following curve 51 X Fall 2022 X Fall 2022 62 August 8% November 25% 63 September December 28% 54 October 11% January 16% 65 66 67 Use the following stock to sales ratios to plan monthly BOM and EOM stocks 58 Stock /Sales Stock /Sales 69 August 29 November 2.9 70 September 2.7 December 2.2 71 October January 3.4 72 Plan the January EOM stock to be $280,000 73 74 75 Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2022. 76 775. 78 The plan IMU for Fall 2021 is $3.00%. Plan the monthly purchases at cost and sum the total purchases at cost for Fall 2022 12 29 80 81 Calculate and post to the buying plan the average stock and inventory turnover for Fall 2022