This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created for Tollhouse, which variable would be the best allocation base for the company's material handling costs? O A. Weight of parts OB. Volume O C. Number of parts moved OD. Time Using the Excel file you created for Tollhouse, which variable would be the least desirable base for the company's material handling costs? O A. Volume of parts OB. Number of parts moved OC. Weight of parts OD. Time 2 3 4 5 F Time spent (hours) 423 189 283 142 136 304 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 B Materials Number of Week handling costs parts moved 1 $ 7,596 2,317 2 $ 3,449 876 3 $ 5,007 1,412 4 $ 2,202 482 5 $ 2,122 850 6 $ 5,482 935 7 $ 5,084 688 8 $ 3,921 722 9 $ 6,478 2,448 10 $ 3,363 1,535 11 $ 5,367 1,935 12 $ 2,262 824 13 $ 2,225 1,149 14 $ 6,234 1,316 15 $ 5,940 932 16 $ 6,004 2,558 17 $ 2,889 1,331 18 $ 4,893 1,443 19 $ 1,788 332 20 $ 1,751 657 21 $ 5,760 824 22 $ 5,466 440 23 $ 5,998 2,215 24 $ 2,883 988 25 $ 4,887 1,388 26 $ 1,782 277 27 $ 1,745 602 D Weight of parts (pounds) 1,760 711 873 885 372 1,989 1,897 886 1,684 873 1,019 1,054 552 3,174 3,007 2,416 1,884 881 1,027 1,062 3,176 2,554 3,721 530 2,599 996 850 E Volume of parts (pallets) 850 865 2,068 1,219 708 1,745 1,992 1,173 2,794 2,816 4,265 1,054 743 3,919 4,094 3,679 812 2,934 1,485 227 3,427 4,603 2,428 1,613 847 869 1,018 277 224 485 160 284 151 130 376 325 250 462 137 261 128 107 353 302 227 519 194 318 1 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 B Materials Week handling costs 28 $ 5,754 29 $ 5,460 30 $ 6,887 31 $ 3,772 32 $ 5,776 33 $ 2,671 34 $ 2,634 35 $ 6,643 36 $ 6,349 37 $ 5,378 38 $ 2,263 39 $ 4,267 40 $ 1,162 41 $ 1,125 42 $ 5,134 43 $ 4,840 44 $ 5,781 45 $ 2,666 46 $ 4,670 47 $ 1,565 48 $ 1,528 49 $ 5,537 50 $ 5,243 51 $ 6,608 52 $ 3,493 Number of parts moved 769 385 2,971 1,744 2,144 1,033 1,358 1,525 1,141 1,876 649 1,049 205 530 697 313 2,246 1,019 1,419 308 633 800 416 2,661 1,434 D E Weight of parts Volume of (pounds) parts (pallets) 2,885 3,276 2,383 2,965 4,005 4,141 2,838 1,844 1,647 1,529 1,703 895 700 917 1,846 3,366 1,881 2,108 1,379 1,797 757 1,621 590 1,796 399 981 1,637 932 634 954 780 2,403 815 245 313 234 1,935 1,410 1,768 1,035 577 220 1,725 2,512 722 2,534 868 3,983 903 2,725 F Time spent (hours) 185 164 410 359 284 421 96 220 87 66 312 261 186 399 74 198 65 44 290 239 164 403 78 202 69