Answer the last 2 questions using excel

The total department plan sales for Fall 2023 is $635,000. Plan sales by month using the following sales curve: \begin{tabular}{l|c|l|c|} \hline August & 11% & November & 20% \\ \hline September & 18% & December & 27% \\ \hline October & 15% & January & 9% \\ \hline & & & \\ \hline & & & \\ \hline Reductions are planned to be 17% of net sales. & & \\ \hline Plan reductions by month using the following curve: & & & \\ \hline & 8% & November & 23% \\ \hline August & 10% & December & 31% \\ \hline September & 12% & January & 16% \\ \hline October & & & \\ \hline \end{tabular} Use the following stock to sales ratios to plan monthly BOM and EOM stocks: Plan the January EOM stock to be $265,000. \begin{tabular}{|l|l|l|l|} \hline & & & \\ \hline August & 2.9 & November & 3.0 \\ \hline September & 2.6 & December & 2.4 \\ \hline October & 2.9 & January & 2.7 \\ \hline & & & \\ \hline \end{tabular} Plan the monthly purchases at retail and sum the total purchases at retail for Fall 2023