Chapter 5 Excel Assignments Ex5.1, E eBook Show Me How Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period: Merchandise Freight Customer Returns Invoice Amount Paid by Seller and Allowances a. $31,000 FOB destination, n/30 $1,600 b. 12,900 $325 FOB shipping point, 2/10, n/30 2,500 c. 21,200 FOB shipping point, 1/10, n/30 4,000 d. 9,100 175 FOB shipping point, 2/10, n/30 1,000 e. 77,000 FOB destination, 1/10, n/30 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. ' Open spreadsheet Round your answers to the nearest dollar