Determining amounts to be paid on invoices 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 Invoice Amount Freight Paid by Seller Customer Returns and Allowances a. $31,000 FOB destination, n/30 $1,600 b. 12,600 $305 2,500 c. 21,900 4,200 FOB shipping point, 1/10, n/30 FOB shipping point, 1/10, n/30 FOB shipping point, 2/10, n/30 FOB destination, 1/10, n/30 d. 9,500 195 1,100 e. 77,300 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. b. $ C. $ d. $ e. $ B D E A G H M Determining amounts to be paid on invoices The data of each of the invoices are provided in the table below. Assume that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Calculate the corresponding amount for each of the cases below. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (L7:L11) into the appropriate fields in CNOWv2 for grading. Freight Paid by Seller Amount Formulas a. b. Merchandise Invoice Amount $31,000 12,600 21,900 9,500 77,300 $305 Customer Returns and Allowances FOB destination, n/30 $1,600 FOB shipping point, 1 /10, n/30 00 FOB shipping point, 1/10, n/30 4,200 FOB shipping point, 2 /10, n/30 1,100 FOB destination, 1 /10, n/30 C. d. 195 e