= Homework: Chapter 4 - HW #3 The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step-by-step. 3) Perform the requirements on the data file. 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the four multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365. B) If you do not have Office 365, click here to learn how to get it for free. C) Troubleshooting FAQ. Question 1, E4-33A (similar to) 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 Sunshine, which variable would be the best allocation base for the company's utility costs? A. Machine hours B. Number of units produced OC. Sales revenue OD. Labor hours Using the Excel file you created for Sunshine, which variable would be the least desirable base for the company's utility costs? A. Number of units produced OB. Machine hours OC. Sales revenue OD. Labor hours Using the Excel file you created for Sunshine, what is the variable for labor hours? A. 0.648845 B. 0.727530 OC. 0.605625 D. 0.319060 Check figures - X R3 - sales revenue R4-number of units produced 0.648845 0.605625 Print Done Using the Excel file you created for Sunshine, what is the variable for machine hours? OA. 0.727530 B. 0.648845 OC. 0.319060 OD. 0.605625 Number of Machine 1 17 April Month Year Utility costs units produced Sales revenue hours Labor hours 2018 $ 2,224 1,868 $ 242,332 2,365 6,959 18 May 2018 $ 2,503 2,082 $ 253,341 2,982 7,541 19 June 2018 $ 3,421 2,266 $ 271,038 3,828 9,372 20 July 2018 $ 3,400 1,732 $ 246,047 3,502 9,498 21 August 2018 $ 3,919 2,413 $ 271,160 5,196 6,844 22 September 2018 $ 4,025 2,488 $ 295,497 5,321 7,599 23 October 2018 $ 4,209 2,552 $ 324,995 5,057 8,443 24 November 2018 $ 3,800 2,395 $ 297,881 4,438 7,761 25 December 2018 $ 3,416 1,582 $ 270,897 3,541 6,549 26 January 2019 $ 3,318 2,209 $ 248,615 3,516 8,119 27 February 2019 $ 4,159 2,406 $ 284,062 3,197 9,114 28 March 2019 $ 4,273 2,510 $ 294,640 4,692 10,532 29 April 2019 $ 2,427 2,074 $ 262,171 2,641 6,959 30 May 2019 $ 2,706 2,288 $ 273,180 3,258 7,541 31 June 2019 $ 3,624 2,472 $ 290,877 4,104 9,372 32 July 2019 $ 3,603 1,938 $ 265,886 3,778 9,498 33 August 2019 $ 4,122 2,619 $ 290,999 5,472 6,844 34 September 2019 $ 4,228 2,694 $ 315,336 5,597 7,599 35 October 2019 $ 4,412 2,758 $ 344,834 5,333 8,443 36 November 2019 $ 4,003 2,601 $ 317,720 4,714 7,761 37 December 2019 $ 3,619 1,788 $ 290,736 3,817 6,549 38 January 2020 $ 3,475 2,357 $ 231,116 3,291 7,219 39 February 2020 $ 4,316 2,554 $ 266,563 2,972 9,114 40 March 2020 $ 4,430 2,658 $ 277,141 4,467 10,532 41 April 2020 $ 2,584 2,222 $ 244,672 2,416 6,959 42 May 2020 $ 2,863 2,436 $ 255,681 3,033 7,541 43 June 2020 $ 3,781 2,620 $ 273,378 3,879 9,372 44 July 2020 $ 3,760 2,086 $ 248,387 3,553 9,498 45 August 2020 $ 4,279 2,767 $ 273,500 5,247 6,844 46 September 2020 $ 4,385 2,842 $ 297,837 5,372 7,599 47 October 2020 $ 4,569 2,906 $ 327,335 5,108 8,443 48 November 2020 $ 4,160 2,749 $ 300,221 4,489 7,761 49 December 2020 $ 3.776 1.936 273.237 3.592 6.549