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 Harper, which variable would be the best allocation base for the company's utility costs? O A. Machine hours O B. Labor hours O C. Sales revenue OD. Number of units produced Using the Excel file you created for Harper, which variable would be the least desirable base for the company's utility costs? O A. Sales revenue OB. Machine hours O C. Number of units produced OD. Labor hours Using the Excel file you created for Harper, what is the variable for sales revenue? Using the Excel file you created for Harper, what is the variable for sales revenue? O A. 0.664768 OB. 0.392909 OC. 0.587834 OD. 0.784749 Using the Excel file you created for Harper, what is the variable for machine hours? O A. 0.784749 OB. 0.392909 OC. 0.664768 OD. 0.587834 4 A B G H 1 Month 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 Septembe 11 October 12 November 13 December 14 January 15 February 16 March 17 April 18 May 19 June 20 July 21 August 22 Septembe 23 October 24 November 25 December 26 January 27 February 28 March 29 April 30 May 31 June 32 July 33 August 34 Septembe 35 October 36 November 37 December 38 January 39 February 40 March 41 April 42 May 43 June 44 July 45 August 46 Septembe 47 October 48 November 49 December 50 51 52 Utility Year costs 2017 $ 3,130 2017 $ 4,050 2017 $ 4,116 2017 $ 2,386 2017 $ 2,621 2017 $ 3,623 2017 $ 3,609 2017 $ 4,091 2017 $ 4,192 2017 $ 4,337 2017 $ 3,994 2017 $ 3,627 2018 $ 3,224 2018 $ 4,065 2018 $ 4,179 2018 $ 2,333 2018 $ 2,612 2018 $ 3,530 2018 $ 3,509 2018 $ 4,028 2018 $ 4,134 2018 $ 4,318 2018 $ 3,909 2018 $ 3,525 2019 $ 3,318 2019 $ 4,159 2019 $ 4,273 2019 $ 2,427 2019 $ 2,706 2019 $ 3,624 2019 $ 3,603 2019 $ 4,122 2019 $ 4,228 2019 $ 4,412 2019 $ 4,003 2019 $ 3,619 2020 $ 3,475 2020 $ 4,316 2020 $ 4,430 2020 $ 2,584 2020 $ 2,863 2020 $ 3,781 2020 $ 3,760 2020 $ 4,279 2020 $ 4,385 2020 $ 4,569 2020 $ 4,160 2020 $ 3,776 D E Number of units Sales produced revenue 2.175 $ 237,817 2,382 $ 258,013 2,521 $ 261,443 2,342 $ 241,243 2,508 $ 250,123 2,643 $ 277,707 2,192 $ 243,170 2,796 $ 278,415 2,884 $ 285,974 2.954 $ 299,841 2,728 $ 276,884 2,215 $ 268,022 2,113 $ 225,798 2,310 $ 261,245 2,414 $ 271,823 1,978 $ 239,354 2,192 $ 250,363 2,376 $ 268,060 1,842 $ 243,069 2,523 $ 268,182 2,598 $ 292,519 2,662 $ 322,017 2,505 $ 294,903 1,692 $ 267,919 2,209 $ 248,615 2,406 $ 284,062 2,510 $ 294,640 2,074 $ 262,171 2,288 $ 273,180 2,472 $ 290,877 1,938 $ 265,886 2,619 $ 290,999 2,694 $ 315,336 2,758 $ 344,834 2,601 $ 317,720 1,788 $ 290,736 2,357 $ 231,116 2,554 $ 266,563 2,658 $ 277,141 2,222 $ 244,672 2,436 $ 255,681 2,620 $ 273,378 2,086 $ 248,387 2,767 $ 273,500 2,842 $ 297,837 2,906 $ 327,335 2,749 $ 300,221 1,936 $ 273,237 F Machi ne hours 3,170 3,699 4,102 2,424 2,876 3,671 3,801 4,103 4,251 4,398 4,012 2.994 2,960 2,641 4,136 2,085 2,702 3,548 3,222 4,916 5,041 4,777 4,158 3,261 3,516 3,197 4,692 2,641 3,258 4,104 3,778 5,472 5,597 5,333 4,714 3,817 3,291 2,972 4,467 2,416 3,033 3,879 3,553 5,247 5,372 5,108 4,489 3,592 Labor hours 7,811 9,114 10,532 5,969 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 7,651 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 8,119 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 7,219 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 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 Harper, which variable would be the best allocation base for the company's utility costs? O A. Machine hours O B. Labor hours O C. Sales revenue OD. Number of units produced Using the Excel file you created for Harper, which variable would be the least desirable base for the company's utility costs? O A. Sales revenue OB. Machine hours O C. Number of units produced OD. Labor hours Using the Excel file you created for Harper, what is the variable for sales revenue? Using the Excel file you created for Harper, what is the variable for sales revenue? O A. 0.664768 OB. 0.392909 OC. 0.587834 OD. 0.784749 Using the Excel file you created for Harper, what is the variable for machine hours? O A. 0.784749 OB. 0.392909 OC. 0.664768 OD. 0.587834 4 A B G H 1 Month 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 Septembe 11 October 12 November 13 December 14 January 15 February 16 March 17 April 18 May 19 June 20 July 21 August 22 Septembe 23 October 24 November 25 December 26 January 27 February 28 March 29 April 30 May 31 June 32 July 33 August 34 Septembe 35 October 36 November 37 December 38 January 39 February 40 March 41 April 42 May 43 June 44 July 45 August 46 Septembe 47 October 48 November 49 December 50 51 52 Utility Year costs 2017 $ 3,130 2017 $ 4,050 2017 $ 4,116 2017 $ 2,386 2017 $ 2,621 2017 $ 3,623 2017 $ 3,609 2017 $ 4,091 2017 $ 4,192 2017 $ 4,337 2017 $ 3,994 2017 $ 3,627 2018 $ 3,224 2018 $ 4,065 2018 $ 4,179 2018 $ 2,333 2018 $ 2,612 2018 $ 3,530 2018 $ 3,509 2018 $ 4,028 2018 $ 4,134 2018 $ 4,318 2018 $ 3,909 2018 $ 3,525 2019 $ 3,318 2019 $ 4,159 2019 $ 4,273 2019 $ 2,427 2019 $ 2,706 2019 $ 3,624 2019 $ 3,603 2019 $ 4,122 2019 $ 4,228 2019 $ 4,412 2019 $ 4,003 2019 $ 3,619 2020 $ 3,475 2020 $ 4,316 2020 $ 4,430 2020 $ 2,584 2020 $ 2,863 2020 $ 3,781 2020 $ 3,760 2020 $ 4,279 2020 $ 4,385 2020 $ 4,569 2020 $ 4,160 2020 $ 3,776 D E Number of units Sales produced revenue 2.175 $ 237,817 2,382 $ 258,013 2,521 $ 261,443 2,342 $ 241,243 2,508 $ 250,123 2,643 $ 277,707 2,192 $ 243,170 2,796 $ 278,415 2,884 $ 285,974 2.954 $ 299,841 2,728 $ 276,884 2,215 $ 268,022 2,113 $ 225,798 2,310 $ 261,245 2,414 $ 271,823 1,978 $ 239,354 2,192 $ 250,363 2,376 $ 268,060 1,842 $ 243,069 2,523 $ 268,182 2,598 $ 292,519 2,662 $ 322,017 2,505 $ 294,903 1,692 $ 267,919 2,209 $ 248,615 2,406 $ 284,062 2,510 $ 294,640 2,074 $ 262,171 2,288 $ 273,180 2,472 $ 290,877 1,938 $ 265,886 2,619 $ 290,999 2,694 $ 315,336 2,758 $ 344,834 2,601 $ 317,720 1,788 $ 290,736 2,357 $ 231,116 2,554 $ 266,563 2,658 $ 277,141 2,222 $ 244,672 2,436 $ 255,681 2,620 $ 273,378 2,086 $ 248,387 2,767 $ 273,500 2,842 $ 297,837 2,906 $ 327,335 2,749 $ 300,221 1,936 $ 273,237 F Machi ne hours 3,170 3,699 4,102 2,424 2,876 3,671 3,801 4,103 4,251 4,398 4,012 2.994 2,960 2,641 4,136 2,085 2,702 3,548 3,222 4,916 5,041 4,777 4,158 3,261 3,516 3,197 4,692 2,641 3,258 4,104 3,778 5,472 5,597 5,333 4,714 3,817 3,291 2,972 4,467 2,416 3,033 3,879 3,553 5,247 5,372 5,108 4,489 3,592 Labor hours 7,811 9,114 10,532 5,969 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 7,651 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 8,119 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549 7,219 9,114 10,532 6,959 7,541 9,372 9,498 6,844 7,599 8,443 7,761 6,549