You have been given the second quarter sales reports and unit sales by separate colleagues. Use VLOOKUP formulas to pull in the monthly sales revenue and unit sales shown on separate tabs for April, May and June into the Q2 YTD Sales for further analysis. With the populated information complete the three questions included in the workbook. Please use correct formatting and include formulas with your final submission. Item Mar Unit Sales April $ Sales April Unit Sales May $ Sales May Unit Sales Jun $ Sales 69 Q2 YTD Unit Sales 750 734 478 890 196 312 468 340 412 492 96 STD-001 STD-002 STD-003 STD-004 STD-005 STD-006 STD-007 STD-008 STD-009 PER-001 PER-002 PER-003 PER-004 PER-005 PER-006 PER-007 Total Sales Jan $ Sales $ 64,184 $ 17,675 $ 41,670 $ 31,860 $ 336 $ 39,984 $ 624 $ 90,860 $ 76,830 $ 342 $ 10,688 $ 3,040 $ 42,500 $ 48,884 $ 25,164 $ 10,549 $ 505,190 Jan Unit Sales Feb $ Sales 284 $ 89,722 101 $ 27,125 463 $ 20,790 135 $ 4,956 2 $ 69,384 196 $ 80,172 16 $ 17,628 413 $ 6,820 394 $ 26,715 9 $ 14,668 167 $ 27,008 95 $ 13,888 250 $ 83,980 404 $ 32,186 466 $ 8,424 137 $ 11,704 3,532 $ 535,170 Feb Unit Sales Mar $ Sales 397 $ 15,594 155 $ 83,650 231 $ 17,640 21 $ 73,632 413 $ 57,120 393 $ 84,048 452 $ 19,188 31 $ 21,120 137 $ 13,650 386 $ 3,344 422 $ 31,808 434 $ 128 494 $ 77,690 266 $ 46,827 156 $ 19,764 152 $ 36,036 4,540 $ 601,239 June Unit Sales Q2 YTD $ Sales $ 169,500 $ 128,450 $ 80,100 $ 110,448 $ 126,840 $ 204,204 $ 37,440 $ 118,800 $ 117,195 $ 18,354 $ 69,504 $ 17,056 $ 204,170 $ 127,897 $ 53,352 $ 58,289 0 $ 1,641,599 70 88 755 1,001 960 540 601 483 1,086 533 1,201 1,057 988 497 4 457 387 366 468 757 4,732 0 0 0 12,804 What was the per unit sales price increase or decrease of Item STD-003 from March to April? What was the average sales price per unit of Item STD-004 through Q2 YTD? What was the average sales price per unit of Item PER-005 through Q2 YTD? PER-001 STD-001 PER-002 STD-002 PER-003 STD-003 PER-004 STD-004 PER-005 STD-005 PER-006 STD-006 PER-007 STD-007 STD-008 Sales Revenue ($) April Sales May Sales 8,820 13,919 10,938 35,301 1,971 986 92,593 42,735 6,230 13,482 19,206 31,878 6,732 63,393 97,350 97,869 54,039 20,764 83,160 46,015 25,186 14,612 52,734 72,930 33,711 21,006 5,019 17,074 29,766 73,084 74,646 27,671 June Sales 9,154 30,329 10,208 16,170 11,616 41,481 54,978 127,464 62,424 26,057 119 14,586 39,301 15,573 116,886 12,441 STD-009 PER-001 PER-002 PER-003 PER-004 PER-005 PER-006 PER-007 STD-001 STD-002 STD-003 STD-004 STD-005 STD-006 STD-007 STD-008 STD-009 #of Units Sold April Sales May Sales 211 333 28 14 177 383 36 339 406 156 424 246 398 248 44 142 481 222 194 322 375 377 450 249 235 325 117 398 123 302 348 129 June Sales 219 145 330 294 469 2 464 122 84 419 491 141 65 363 483 58
