This project only has one attempt. Review the check figures with your data Se results belire ansering the questions your check Sgures do not match, do not proceed with answering the questions until you have asked for assistance from your insc Using the Excel file you created for Grand River, what was the total sales revenue for the recreational produ OA $482.510 OB $1,271,161 OC $740,524 D. $2,500,195 Using the Excel file you created for Grand River, what was the s evenue for Drive in Finsc OA $272.292 O 5010,704 OC $219,729 OD. $110,683 Using the Excel te you created for Grand River, what was the aver cane model in Fra OA 10.3750 On 2000807 OC. 1000000 OD 156 0407 Using the Excel se you created for Grand River, how many model were produced in Des M OA 400 OB 72 OC 2.549 OD 10 Using the Excel the you created for Grand River, whats the average gre pro ser ut hr the 350 de OA. $5.0067 OB 77.9537 OC. 790333 OD 55000 Ueng the Excel e you crested or Gander, how many jobe se pod OA OB D OC M C D E F G H Date Plant Job # Product group Model Units DM DL MOH Job cost Cost per unit Sales Rev GP per unit M N 2 1/2/2019 Peoria 2486 Recreational 5101 40 1,680 640 1,360 3,680 92 6,640 74 31/14/2019 Frisco 2410 Multi X230 30 1,595 410 680 2,685 90 4,325 55 4 1/17/2019 Peoria 1813 River F340 45 4,125 1,100 1,895 7,120 158 9,488 53 5 1/19/2019 Worcester 2061 Recreational $101 45 2,320 590 1,100 4,010 89 6,250 50 6 1/20/2019 7 1/21/2019 8 1/23/2019 9 1/25/2019 Frisco Peoria 1975 Recreational $101 10 400 180 360 940 94 1,650 71 1980 Recreational 1201 15 735 300 600 1,635 109 3,000 91 Des Moines 2013 River F340 60 5,300 1,260 2,520 9,080 151 13,500 74 Worcester 2035 Multi X230 20 1,240 300 600 2,140 107 3,500 68 10 1/26/2019 Worcester 2040 Recreational 5101 50 2,100 650 1,300 4,050 81 8,250 84 11 5/24/2019 Worcester 2192 Recreational 5101 80 3,280 1,280 2,720 7,280 91 14,240 87 12 10/24/2019 Frisco 2410 Multi X230 19 1,216. 304 627 2,147 13 5/30/2019 14 2/6/2019 15 12/14/2019 16 12/1/2015 17 11/8/2019 18 10/28/2019 Worcester 2212 Multi X230 34 2,142 510 1,054 3,706 Worcester 2049 Multi x220 86 4,730 1,204 2,494 8,428 Worcester 2483 Multi X230 57 3,762 855 1,767 6,384 Peoria 2486 Recreational 5101 40 1,680 640 1,360 3,680 Peoria 2269 Multi X230 81 5,110 1,450 2,590 9,150 Des Moines 2439 River F340 52 4,940 1,144 2,288 8,372 19 1/18/2020 Peoria 2545 River F340 46 4,324 966 2,070 7,360 20 5/8/2019 Peoria 2174 Multi X220 43 2,279 645 1,204 4,128 21 5/2/2019 22 10/2/2015 Worcester 2172 River F340 85 7,990 1,870 3,655 13,515 Worcester 2387 Multi X230 45 2,880 675 1,395 4,950 23 10/20/2019 24 5/7/2019 25 6/6/2019 26 1/31/2019 27 5/19/2019 28 5/22/2019 29 3/26/2019 30 10/5/2019 31 12/6/2019 32 3/9/2019 Frisco 2419 Recreational 1201 11 550 231 506 1,287 Frisco 2166 Recreational 5101 63 2,520 1,008 2,142 5,670 Frisco 2232 Recreational 5101 $7 3,480 1,479 2,871 7,830 Frisco 2041 Recreational 1201 921 4,508 1,840 4,232 10,580 115 Worcester 2188 Recreational 5101 10 420 160 340 920 Worcester Worcester 2208 Recreational 5101 44 1,848 704 1,452 4,004 2133 Recreational 5101 30 3,360 1,280 2,560 7,200 90 Worcester 2403 Multi X230 44 2,772 660 1,452 4,884 111 Des Moines Peoria 2500 Recreational 5101 98 4,018 1,568 3,332 8918 91 2105 Recreational 1201 35 2,695 1,155 2,365 6,215 113 EEEEEE 113 3,572 75 109 6,120 71 98 13,072 54 112 10,944 80 92 6,640 74 113 15,970 84 161 12,220 74 160 10,442 67 96 6,579 57 159 20,315 80 110 8,595 81 117 2,233 86 90 10,710 80 90 14,442 76 19,596 92 1,810 89 91 7,700 84 14,000 85 1,448 81 16,366 76 11,000 87 33 4/15/2019 34 2/9/2019 35 1/29/2019 369/12/2019 379/9/2019 38 6/28/2019 39 3/4/2019 40 2/15/2019 41/13/2019 429/7/2019 43 2/6/2019 Worcester 2146 Recreational 5101 20 800 320 640 1,760 88 3,360 80 Worcester 2061 Recreational 5101 22 924 352 748 2,024 92 3,784 30 Peoria 2048 River F340 87 8,265 1,827 3,828 13,920 100 20,793 79 Frisco Worcester Frisco Des Moines Frisco Worcester Frisco 2376 Multi X220 59 3,127 826 1,652 5,605 95 9,263 62 2365 Multi x230 65 4,556 1,020 2,108 7,684 113 12,512 71 2250 Multi X220 20 3,780 500 1,960 6,720 96 10,850 59 2095 Recreational 5101 85 3,570 1,360 2,805 7,735 91 14,620 1 2072 River F340 50 4,000 1,100 2,200 8,100 162 11,300 64 2311 Recreational 5101 22 946 374 726 2,046 93 3,674 2371 Multi x230 95 74 5,890 1,520 2,945 10.355 109 18,145 02 Worcester 2014 Recreational 5101 12 504 204 408 1,116 93 2,100 44 5/5/2019 Des Moines 2182 Recreational 1201 18 87 936 378 792 2,106 117 3,726 45 7/12/2019 Worcester 22 Multi x220 " 4,998 90 1,372 2,940 9,310 9 46 12/10/2019 Peoria 47 4/18/2019 45 2/23/2015 49 12/26/2019 50 11/8/2019 51 2/9/2019 52/12/2019 53 7/10/2019 54 11/29/2019 55 10/7/2019 56 6/14/2019 57 6/16/2019. 58 10/19/2019 59A/21/2019 Frisco Peoria Worcester Worcester frisco Des Moines Worcester Worcester Frisco Des Moines Worcester Des Moines 245 Recreational 14,700 55 1201 32 2,600 3,092 2,392 6,064 117 10,972 2155 Multi X230 22 34 1,430 330 2,447 111 3,194 2066 Multi x230 42 2,004 630 66 1,386 4,620 110 7AM 2507 Rover F340 54 4,355 67 1,250 2,000 7,625 141 11,900 2451 Multi X230 24 4,736 1,110 2,442 79 8,200 112 2058 Multi x230 5 4,445 14,060 2 3,104 2,277 114 12,075 2320 River FM40 47 4,465 61 1,014 2,064 7,567 2275 Recreational 161 10.763 5101 68 2,924 1,00 2,244 60 6,236 92 2347 Multi X220 11 541 11,492 105 17 330 1,056 96 2390 Recreational 1201 53 2.650 1,738 1.113 2,438 62 6,201 117 2244 Multi X220 40 2,000 560 11.44 1,200 99 3,040 9 2236 Recreational 6,320 5101 45 1.800 720 1,455 02 4,000 2414 Recreational 1201 61 8,100 3,050 1,281 2,867 7,196 91 318 Grand River 2147 Recreational 3840 12,993 1610 95 16.312 Grand River Canoe Company has several plants located around the United States. The company's controller has imported its job cost and sales data from the past three years into Excel. Complete the following requirements based upon the Excel data sheet. Requirements for the Excel analysis 1. What was the total sales revenue for each product group? 2. What was the total sales revenue for each product group by plant? 3. What was the average cost per unit for each canoe model? 4. What was the average cost for each canoe model in each plant? 5. How many units of each model were produced in each plant? 6. What is the average gross profit per unit for each canoe model? 7. What is the average gross profit per unit for each canoe model in each plant? 8. How many jobs were produced in each plant? (Hint: Use Job # in the Values box to get the count.) have Office 365, click here to leam how to get it for free Land Office 365 C) Troubleshooting FAQ 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 Using the Excel file you created for Grand River, what was the total sales revenue for the recreational product group? OA. $482,510 OB. $1,271,161 OC. $746,524 D. $2,500,195 Using the Excel file you created for Grand River, what was the total sales revenue for the mult product group in Frisco? OA $272,292 OB. $610,704 OC. $219,729 OD. $118,683 Using the Excel file you created for Grand River, what was the average cost for the F340 canoe model in Frisco? OA. 166.3750 OB. 206.0807 OC. 160 8889 OD. 156.8407 Using the Excel file you created for Grand River, how many units of the S101 model were produced in Des Moines? OA. 469 B. 732 OC. 2.649 OD. 188 Using the Excel file you created for Grand River, what is the average gross profit per unit for the F350 model in Worcester? OA. 85 6667 OB. 77.9537 OC. 79 6333 OD. 06.5000 Using the Excel file you created for Grand Rover, how many jobs were produced in Peona? CA 40 8. 00 C. 54