Based on the item in the Excel spreadsheet below, the inventory manager wishes to use a two-bin inventory system for C items. Show all of your work in Excel to include any formulas used.

Part A: Which ones of the following items are C items? Use the ABC approach to find out.

Part B: Determine the respective proportions of A, B, and C items in terms of demand volume.

Part C: Determine the respective proportions of A, B, and C items in terms of annual dollar volume.

\begin{tabular}{|c|c|c|c|} \hline & A & B & C \\ \hline 1 & Item Code & Annual Demand & Unit Price \\ \hline 2 & 4556 & 1,000 & $1.20 \\ \hline 3 & 2564 & 32 & $5,000.00 \\ \hline 4 & 1289 & 128 & $100.00 \\ \hline 5 & 3265 & 300 & $4.00 \\ \hline 6 & 7896 & 90 & $50.00 \\ \hline 7 & 6842 & 60 & $2,200.00 \\ \hline 8 & 2589 & 30 & $650.00 \\ \hline 9 & 8496 & 420 & $7.00 \\ \hline 10 & 3564 & 560 & $3.00 \\ \hline 11 & 8547 & 136 & $28.00 \\ \hline 12 & 7826 & 30 & $5,000.00 \\ \hline 13 & 6514 & 400 & $123.00 \\ \hline 14 & 8951 & 450 & $5.00 \\ \hline 15 & 7265 & 176 & $142.00 \\ \hline 16 & 4235 & 100 & $20.00 \\ \hline 17 & 9898 & 200 & $120.00 \\ \hline 18 & 9542 & 400 & $13.00 \\ \hline 19 & 8474 & 300 & $56.00 \\ \hline 20 & 5454 & 600 & $10.00 \\ \hline 21 & 1236 & 700 & $9.00 \\ \hline \end{tabular}