Number of Machine 1 Month Year Utility costs units produced Sales revenue hours Labor hours 2 2 January 2017 $ 3,450 1,958 $ 241,571 2,280 5,841 3 February 2017 $ 4,120 2,121 $ 262,847 2,112 6,128 4 March 2017 $ 4,339 2,421 $ 275,881 3,310 11,500 5 April 2017 $ 2,481 2,195 $ 220,667 1,995 3,851 6 May 2017 $ 2,775 2,495 $ 225,991 2,784 3,675 7 June 2017 $ 3,838 2,519 $ 275,101 1,825 8,875 8 July 2017 $ 3,814 2,003 $ 241,110 1,662 8,910 9 August 2017 $ 4,299 2,674 $ 281,475 2,121 9,110 10 September 2017 $ 4,337 2,763 $ 292,841 2,381 9,852 11 October 2017 $ 4,562 2,891 $ 310,452 2,248 9,937 12 November 2017 $ 4,010 2,628 $ 299,735 2,003 9,151 13 December 2017 $ 3,882 2,071 $ 272,841 2,384 8,857 14 January 2018 $ 3,541 2,037 $ 245,914 2,775 7,991 15 February 2018 $ 4,382 2,234 $ 281,361 2,456 11,800 16 March 2018 $ 4,496 2,338 $ 291,939 3,951 10,532 17 April 2018 $ 2,650 1,902 $ 259,470 1,900 3,571 18 May 2018 $ 2,929 2,116 $ 270,479 2,517 4,141 19 June 2018 $ 3,847 2,300 $ 288,176 3,363 9,372 20 July 2018 S 3,826 1,766 $ 263,185 3,037 9,498 21 August 2018 $ 4,345 2,447 $ 288,298 4,731 11,200 22 September 2018 $ 4,451 2,522 $ 312,635 4,856 7,599 23 October 2018 $ 4,635 2,586 $ 342,133 4,592 11,935 24 November 2018 $ 4,226 2,429 $ 315,019 3,973 7,761 25 December 2018 $ 3,842 1,616 $ 288,035 3,076 6,549 26 January 2019 $ 3,281 2,121 $ 235,181 3,516 8,119 27 February 2019 $ 4,122 2,318 $ 270,628 3,197 9,114 28 March 2019 $ 4,236 2,422 $ 281,206 4,692 10,532 29 April 2019 $ 2,390 1,986 $ 248,737 2,641 6,959 30 May 2019 $ 2,669 2,200 $ 259,746 3,258 7,541 31 June 2019 $ 3,587 2,384 $ 277,443 4,104 9,372 32 July 2019 $ 3,566 1,850 $ 252,452 3,778 9,498 33 August 2019 $ 4,085 2,531 $ 277,565 5,472 6,844 34 September 2019 $ 4,191 2,606 $ 301,902 5,597 7,599 35 October 2019 $ 4,375 2,670 $ 331,400 5,333 8,443 36 November 2019 $ 3,966 2,513 $ 304,286 4,714 7,761 37 December 2019 $ 3,582 1,700 $ 277,302 3,817 6,549 38 January 2020 $ 3,584 2,115 $ 230,171 2,854 7,219 39 February 2020 $ 4,425 2,312 $ 265,618 2,535 9,114 40 March 2020 $ 4,539 2,416 $ 276,196 4,030 10,532 41 April 2020 $ 2,693 1,980 $ 243,727 1,979 6,959 42 May 2020 $ 2,972 2,194 $ 254,736 2,596 7,541 43 June 2020 $ 3,890 2,378 $ 272,433 3,442 9,372 44 July 2020 $ 3,869 1,844 $ 247,442 3,116 9,498 45 August 2020 $ 4,388 2,525 $ 272,555 4,810 6,844 46 September 2020 $ 4,494 2,600 $ 296,892 4,935 7,599 47 October 2020 $ 4,678 2,664 $ 326,390 4,671 8,443 48 November 2020 $ 4,269 2,507 $ 299,276 4,052 7,761 40 Decemb 3030 3.005 1504 373 303 ----- 5.40 Goodtimes Ready Accessibility: Good to go H This project only has one attempt. Review the check figures with your data file results before answering the questions. If your che for assistance from your instructor. Using the Excel file you created for Goodtimes, which variable would be the best allocation base for the company's utility costs? OA. Number of units produced B. Labor hours C. Machine hours D. Sales revenue Using the Excel file you created for Goodtimes, which variable would be the least desirable base for the company's utility costs? OA. Number of units produced B. Sales revenue C. Labor hours OD. Machine hours Using the Excel file you created for Goodtimes, what is the variable for sales revenue? OA. 0.656226 B. 0.717753 C. 0.531420 D. 0.469916 Using the Excel file you created for Goodtimes, what is the variable for machine hours? A. 0.469916 B. 0.531420 OC. 0.656226 OD. 0.717753