Please help with this problem based off of information in the excel spreadsheet.

\fCust. CustName Address State 22 Brown Co, 123 Main SNY 22 Brown Co, 123 Main SNY 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 22 Brown Co, 123 Main SNY 22 Brown Co, 123 Main SNY 22 Brown Co, 123 Main SNY 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 26 Homebase234 Pacif NJ 26 Homebase234 Pacif NJ 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT 24 Easy Shop 456 Broad CT Zip Distance Ord_NumbOrd_Date QtyOrdere ShipperID 12345 317 101 7/5/2006 15 Fedex 12345 317 101 7/5/2006 18 Fedex 34567 224 102 7/5/2006 24 UPS 34567 224 102 7/5/2006 12 UPS 7/6/2006 12345 317 103 10 UPS 12345 317 103 7/6/2006 120 UPS 12345 317 103 7/6/2006 25 UPS ### 34567 224 104 15 UPS ### 34567 224 104 7 UPS ### 34567 224 104 8 UPS ### 34567 224 105 12 Fedex ### 34567 224 105 12 Fedex ### 23452 405 106 14 UPS ### 23452 405 106 15 UPS ### 34567 224 107 22 UPS ### 34567 224 107 10 UPS ### 34567 224 107 10 UPS Item_NumDescriptionPrice Weight-lb Cost ttlweight proftperli lineitem shippingcovalueandshipping 575.00 300.00 2010 LCD TV 30 450 4125 8625 85.5 8710.5 795.00 400.00 2011 LED TV 35 630 7110 14310 119.7 14429.7 499.00 217.00 2015 IPAD 5 120 6768 11976 27.6 12003.6 699.00 312.00 2016 LAPTOP 10 120 4644 8388 27.6 8415.6 715.00 315.00 2013 DRYER 50 500 4000 7150 115 7265 795.00 400.00 2011 LED TV 35 4200 47400 95400 966 96366 815.00 400.00 2012 WASHER 50 1250 10375 20375 287.5 20662.5 715.00 315.00 2013 DRYER 50 750 6000 10725 172.5 10897.5 699.00 312.00 2016 LAPTOP 10 70 2709 4893 16.1 4909.1 815.00 400.00 2012 WASHER 50 400 3320 6520 92 6612 499.00 217.00 2015 IPAD 5 60 3384 5988 11.4 5999.4 715.00 315.00 2013 DRYER 50 600 4800 8580 114 8694 815.00 400.00 2012 WASHER 50 700 5810 11410 161 11571 795.00 400.00 2011 LED TV 35 525 5925 11925 120.75 12045.75 575.00 300.00 2010 LCD TV 30 660 6050 12650 151.8 12801.8 699.00 312.00 2016 LAPTOP 10 100 3870 6990 23 7013 740.00 512.00 2014 IPHONE-6 2 20 2280 7400 4.6 7404.6 valueandshipping \fCustomer Invoices Customer Order 22 Brown Co, 101 Ord_Date: Item_Num Description 7/5/2006 Price QtyOrdered 103 $795.00 18 $14,310.00 $119.70 $14,429.70 2010 LCD TV $575.00 15 $8,625.00 $85.50 $8,710.50 $22,935.00 $205.20 $23,140.20 Ord_Date: Item_Num Description 101 7/6/2006 Price QtyOrdered shippingcost valueandshipping $715.00 10 $7,150.00 $115.00 $7,265.00 2011 LED TV $795.00 120 $95,400.00 $966.00 $96,366.00 2012 WASHER $815.00 25 $20,375.00 $287.50 $20,662.50 $122,925.00 $1,368.50 $124,293.50 $145,860.00 $1,573.70 $147,433.70 103 Total for Customer Brown Co, Customer 24 Easy Shop Order 7/5/2006 102 Ord_Date: Item_Num Description Price QtyOrdered lineitem shippingcost valueandshipping 2015 IPAD $499.00 24 $11,976.00 $27.60 $12,003.60 2016 LAPTOP $699.00 12 $8,388.00 $27.60 $8,415.60 $20,364.00 $55.20 $20,419.20 Order total for Order# 104 lineitem 2013 DRYER Order total for Order# Order shippingcost valueandshipping 2011 LED TV Order total for Order# Order lineitem Ord_Date: Item_Num Description 102 7/31/2006 Price QtyOrdered lineitem shippingcost valueandshipping 2012 WASHER $815.00 8 $6,520.00 $92.00 $6,612.00 2016 LAPTOP $699.00 7 $4,893.00 $16.10 $4,909.10 2013 DRYER $715.00 15 $10,725.00 $172.50 $10,897.50 $22,138.00 $280.60 $22,418.60 Order total for Order# 104 Order 105 Ord_Date: Item_Num Description 8/12/2006 Price QtyOrdered 107 shippingcost valueandshipping 2015 IPAD $499.00 12 $5,988.00 $11.40 $5,999.40 2013 DRYER $715.00 12 $8,580.00 $114.00 $8,694.00 $14,568.00 $125.40 $14,693.40 Order total for Order# Order lineitem Ord_Date: Item_Num Description 105 8/31/2006 Price QtyOrdered lineitem shippingcost valueandshipping 2014 IPHONE-6 $740.00 10 $7,400.00 $4.60 $7,404.60 2010 LCD TV $575.00 22 $12,650.00 $151.80 $12,801.80 2016 LAPTOP $699.00 10 $6,990.00 $23.00 $7,013.00 $27,040.00 $179.40 $27,219.40 $84,110.00 $640.60 $84,750.60 Order total for Order# 107 Total for Customer Easy Shop Customer 26 Homebase Order 8/13/2006 106 Ord_Date: Item_Num Description Price QtyOrdered lineitem shippingcost valueandshipping 2012 WASHER $815.00 14 $11,410.00 $161.00 $11,571.00 2011 LED TV $795.00 15 $11,925.00 $120.75 $12,045.75 $23,335.00 $281.75 $23,616.75 $23,335.00 $253,305.00 $281.75 $2,496.05 $23,616.75 255801.05 Order total for Order# Total for Customer Homebase Grand Total 106