Please solve NUMBER 6. PLEASE PLEASE PLEASE SOLVE IN EXCEL AND KEEP IN THE FORMATTING. Im so stuck on 6 and cannot figure it out

6. For this question you are to make the following assumptions: First, estimated demand for the coming year is 30,000 . Second, you have adopted an inventory policy that includes an EOQ of 3,000 and a ROP of 6,000. Third, following your analysis of supplier information (as you did in Q4), you made a decision to use Alternative Supplier B. I (A). What are the expected annual costs for inventory management. The types of costs to be included are annual holding costs, annual ordering costs, and annual purchasing costs. Also, you will need to have access to data from the supplier information table that was used in your analysis for 4. I (B) . Based on your analysis in part a, what are a few suggestions you feel are worthy of consideration to try to reduce the expected annual costs for inventory management? \begin{tabular}{|c|r|r|r|} \hline Measure (mm) & \multicolumn{1}{|c|}{ Current } & \multicolumn{1}{|c|}{ Alternative A } & \multicolumn{1}{|c|}{ Alternative B } \\ \hline Mean Sock Thickness & 7 & 6.7 & 7.1 \\ \hline Standard Deviation & 0.14 & 0.13 & 0.11 \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline Supplier Scorecard & Weighted Score \\ \hline Current & 1.8 \\ \hline Alternative A & 1.8 \\ \hline Alternative B & 2.4 \\ \hline \end{tabular} CPK for Current CPK For Alternative A CPK for Alternative Bf