This project only has one attempt. Review the check figures with your data file results before...

 

Transcribed Image Text:

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 OC. Number of parts moved O D. 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 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 222278 24 25 26 A Week handling costs 7,596 3,449 5,007 2,202 2,122 5,482 5,084 3,921 6,478 3,363 5,367 2,262 2,225 6,234 5,940 6,004 2,889 4,893 1,788 1,751 5,760 1 $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8 $ 9 $ 10 $ 11 $ 12 $ 13 $ 14 $ 15 $ 16 $ 17 $ 18 $ 19 $ 20 $ B Materials 21 $ 22 $ 23 $ 24 $ 25 $ 26 $ 27 $ 5,466 5,998 2,883 4,887 1,782 1,745 с Number of parts moved 2,317 876 1,412 482 850 935 688 722 2,448 1,535 1,935 824 1,149 1,316 932 2,558 1,331 1,443 332 657 824 440 2,215 988 1,388 277 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 F Time spent (hours) 423 189 283 142 136 304 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 A Week B Materials handling costs 5,754 5,460 6,887 3,772 5,776 2,671 2,634 6,643 6,349 28 $ 29 $ 30 $ 31 $ 32 $ 33 $ 34 $ 35 $ 36 $ 37 $ 38 $ 39 $ 40 $ 41 $ 42 $ 43 $ 44 $ 45 $ 46 $ 47 $ 48 $ 49 $ 50 $ 51 $ 52 $ 5,378 2,263 4,267 1,162 1,125 5,134 4,840 5,781 2,666 4,670 1,565 1,528 5,537 5,243 6,608 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 Weight of parts (pounds) 2,885 2,383 4,005 2,838 1,647 1,703 700 1,846 1,881 1,379 757 590 399 1,637 634 780 815 313 1,935 1,768 577 1,725 722 868 903 E Volume of parts (pallets) 3,276 2,965 4,141 1,844 1,529 895 917 3,366 2,108 1,797 1,621 1,796 981 932 954 2,403 245 234 1,410 1,035 220 2,512 2,534 3,983 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 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 OC. Number of parts moved O D. 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 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 222278 24 25 26 A Week handling costs 7,596 3,449 5,007 2,202 2,122 5,482 5,084 3,921 6,478 3,363 5,367 2,262 2,225 6,234 5,940 6,004 2,889 4,893 1,788 1,751 5,760 1 $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8 $ 9 $ 10 $ 11 $ 12 $ 13 $ 14 $ 15 $ 16 $ 17 $ 18 $ 19 $ 20 $ B Materials 21 $ 22 $ 23 $ 24 $ 25 $ 26 $ 27 $ 5,466 5,998 2,883 4,887 1,782 1,745 с Number of parts moved 2,317 876 1,412 482 850 935 688 722 2,448 1,535 1,935 824 1,149 1,316 932 2,558 1,331 1,443 332 657 824 440 2,215 988 1,388 277 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 F Time spent (hours) 423 189 283 142 136 304 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 A Week B Materials handling costs 5,754 5,460 6,887 3,772 5,776 2,671 2,634 6,643 6,349 28 $ 29 $ 30 $ 31 $ 32 $ 33 $ 34 $ 35 $ 36 $ 37 $ 38 $ 39 $ 40 $ 41 $ 42 $ 43 $ 44 $ 45 $ 46 $ 47 $ 48 $ 49 $ 50 $ 51 $ 52 $ 5,378 2,263 4,267 1,162 1,125 5,134 4,840 5,781 2,666 4,670 1,565 1,528 5,537 5,243 6,608 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 Weight of parts (pounds) 2,885 2,383 4,005 2,838 1,647 1,703 700 1,846 1,881 1,379 757 590 399 1,637 634 780 815 313 1,935 1,768 577 1,725 722 868 903 E Volume of parts (pallets) 3,276 2,965 4,141 1,844 1,529 895 917 3,366 2,108 1,797 1,621 1,796 981 932 954 2,403 245 234 1,410 1,035 220 2,512 2,534 3,983 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

Answer rating: 100% (QA)

Answer A weight of the parts The best allocation base for the company material handling costs will b... View the full answer