application to find the total income per destination and per bed type (take into consideration the full price computed in column G). If management wishes to discontinue sales to one destination based solely on the income data, which destination would you recommend? Give your reasoning in the range G3:15 of the PivotTable sheet. Name this sheet Calculated_Income. (0.5 Points) 6. Now assume that there are some duplicate values when recording the data. Delete the unnecessary records on the Customer sheet. Check how this change impacts the PivotTable from the previous question. Starting in Cell A20 in Calculated_Income sheet, explain the impact of this change on the PivotTable. (0.5 Points) 7. Karake, Inc. is interested in finding out what percent of all orders to different destinations are regular shipping orders (not expedited). Use the PivotTable application to answer this question. Name the new sheet Shipping_Regular. (0.5