Requiene Create an automated process that can be used over and over again 1 Stream 1 Extract the data from the "Sales Report" sheet Transform the data to the correct values as found on the Region table 2 Stream 2 Extract the data from the "Products" sheet Review the data, join to Stream 1 and verify the number of rows 3 Stream 3 Extract the data from the "Salesperson" sheet Review the data, join to combined Stream 1 and Stream 2 and verify the number of rows 4 Stream 4 Extract the data from the "Shipping Costs" sheet Review the data, create required fields and join to the previously combined streams Verify that the number of rows has not changed 5 Create the number of units sold (unts sold sales/selling price per unit) and the shipping cost (shipping cost-units sold x shipping cost per unit) for each invoice For your project total sales are $11,440,836.00, units sold are 498,060 and total shipping costs are $1,022,715.12. 6 As lustrated below create a report that show the number of units sold and sales in dollars by product 7 As lustrated below, create a report that show the number of units sold, sales in dollars and shipping costs by salesperson 8 As utrated below, create a cross-tab report that show the shipping costs by product and region 9 These three reports are to be saved in this Excel fie Sange report 25 ty Product 27 Product Stuffed Bear Stuffed Elephant 30 Muffed Fr 22 Stuffed Panda Stuffed Unicorn Sales 696 $177,400.00 12506 $1,625,336.00 2934 $1,343,456.00 3240 $97,700.00 40296 5 526.806.00 42 332 564764000 28.308 $6.40% 400 00 Salesperson Ulysses Grant George Washington James Monroe John Tyler James Madison emes Polk Total By Salesperson Sales 36.636 5818052.00 58,284 $1,299.192.00 37.352 $2,162,436.00 78.524 $1,351.352.00 30.3 585441200 77484 $1,723,956.00 38068 58.609,400.00 Shipping Cost 577,366.44 512334328 $205622 64 $166.596.00 Stuffed $41,024 $163,717.08 Shipping Costs by Product and Region South Midwest Northeast 52600400 54304844 522.066 20 Stuffed Elephant 55481000 $72,06084 5 48,486 505 Stuffed Free Stuffed Koala Stuffed Panda Stuffed Unicom Grand Total West Grand To 41647.00 13344 6971.80 $262329.24 $ 36,405 60 5 52861.20 3075360 $50.00 $174,10 D $ 14,094.00 $ 2060028 5 14572.80 253044053470048 $1687560 53666400 5 15,720.00 $230440 2,4800 1364820 30604.325 18.144.00 $2.95.4020304.12 $162,73740 $24593808349743 20 3299131001754868 47 1 What were the sales of the Stuffed Bear product in dollars? 2 What were the sheping costs in dollars for the product with the fourth lowest shipping costs? 3 What were the units sold for the product with the second lowest number of units sold? 4 What were the sales in dolars for the product with the second lowest sales? 5 What was the shipping costs in dollars for the salesperson with the second highest shipping costs? What were the units sold for the salesperson with the fifth lowest number of units sold? What were the sales in dollars for the salesperson with the third lowest sales? What were the shipping costs of the Stuffed Tiger product in the region with the Stuffed Tiger's third lowest shipping cost? 9 What were the shipping costs of the Stuffed Panda product in the region with the Stuffed Panda's third highest shipping cost? 10 What were the shipping costs of the Stuffed Bear product the region with the Stuffed Bear's second lowest shipping cost? ound other anywhe nearest whole unit or dollar 01 141 (5) 121 10 (10) Product ID Product 101 Stuffed Elephant 102 Stuffed Panda Cuddly Stuffed Animals Product Information Unit Selling Price Unit Manufacturing Cost Profit Margin by Product 20.00 8.75 11.25 22.00 9.50 12.50 103 Stuffed Koala 24.00 9.50 14.50 104 Stuffed Bear 21.00 10.75 10.25 105 Stuffed Tiger 23.00 11.75 11.25 106 Stuffed Horse 25.00 10.75 14.25 MO 11 12 13 Code Cuddly Stuffed Animals Salesperson Information Salesperson Title 14 1301 James Polk 15 1302 Ulysses Grant 16 1303 Thomas Jefferson 17 1304 James Madison 181305 James Monroe 19 1306 Grover Cleveland 20 21 Sales Associate Senior Sales Associate Senior Sales Associate Sales Associate | Sales Associate | Senior Sales Associate 72 23 Code Region 1 2 3 1 Midwest IN IA 2 Northeast CT ME MA 3 South AL AR DE 4 West AK AZ CA NH 1228 N Cuddly Stuffed Animals Region Information 6 7 9 5231 NY GA ID 8233 MN MO NE NO PA RO VT LA MO MS MT NV NM 288 953 10 12 13 50 NC OR 9 85 WI OK SC IN TX UT WA WY " Cuddly Stuffed Animals Shipping Cost Per Unit Product ID Region Midwest Northeast South West 101 2.15 2.11 2.08 2.01 102 2.11 2.07 2.04. 1.97 103 2.16 2.12 2.09 2.02 104 2.12 2.08 2.05 1.98 105 2.09 2.05 2.02 1.95 106 2.07 2.03 2.00 1.93 1 What were the sales of the Stuffed Bear product in dollars? M 2 What were the shipping costs in dolars for the product with the fourth lowest shipping costs? e 3 What were the units sold for the product with the second lowest number of units sold? 4 4 What were the sales in dollars for the product with the second lowest sales? U 02 CL 14 5 What was the shipping costs in dollars the second highest shipping costs? 4 6 What were the units sold for the salesperson with i lowest number of unes sold 46 7 What were the sales in dollars for the salesperson s 47 AD thed lowest sales? 8 What were the shipping costs of the Shed Tiger product in the region with the Stuffed Tiger's the lowest song co What were the shipping costs of the Stuffed Panda product in the region with the Styled Panda's third highest shigong cos 10 What were the shop costs of the Stuffed Bear product in the regon with the Stuffed Bears second lowest shipping cost? 10 2 NO. QUESTION What were the sales of the Stuffed Bear product in dollars? What were the shipping costs in dollars for the product with the fourth lowest shipping costs? What were the units sold for the product with the second lowest number of units sold? What were the sales in dollars for the product with the second lowest sales? ANSWER (Round amounts to the Dearest dollar enter percentages as nearest rounded whole number without the % symbol, g.12 for 12.25A) 6 What were the sales in dollars for the product with the second lowest sales? What was the shipping costs in dollars for the salesperson with the second highest shipping costs? What were the units sold for the salesperson with the fifth lowest number of units sold? 7 What were the sales in dollars for the salesperson with the third lowest sales? 00 What were the shipping costs of the Stuffed Tiger product in the region with the Stuffed Tiger's third lowest shipping cost? What were the shipping costs of the Stuffed Panda product in the region with the Stuffed Panda's third highest shipping cout What were the shipping costs of the Stuffed Bear product in the region with the Stuffed Bear's second lowest shipping