Quickstove ships worldwide and this is but a sample of shipments to the Western United States....

Transcribed Image Text:

Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states. Task # Points 1 2 3 4 5 сл 6 7 6 1 2 1 2 3 1 2 6 Task Description Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate. Reuse your formula in cell G15 and paste it down to complete the "Net Price" column of the table. Multiply the ÒQuantityó by the ÒNet Priceó to get the ÒSale Amtó in Cell H15 Reuse your formula in cell H15 and paste it down to complete the ÖSale Amtó column Use an IF function in Cell I15 to calculate the Tax. There is a tax of 5% applied on shipments to Utah, 6% applied on shipments to Oregon, but no tax on shipments to other states. Refer to the appropriate tax rates in cells B10, B11 and B12 for your IF function arguments. Use absolute and relative references when appropriate. Reuse your formula in cell 115 and paste it down to complete the ÒTaxó column Calculate the Invoice ÒTotaló in cell J15 Reuse your formula in cell J15 and paste it down to complete the ÒTotaló column Use the SUM function to calculate the worksheet totals in cells 19, 110 and 111 1 2 3 4 5 6 7 8 9 10 UT 11 OR 12 All Others 13 14 15 16 17 18 19 20 A 21 22 23 24 25 26 27 28 29 30 OrderID Sales Tax Rate 1003 1004 1007 1011 1027 1041 B 1042 1050 1058 1059 1060 1062 1073 1074 1088 1094 5% 6% 0% Ship To AZ WA NV UT C CA MT CA OR UT AZ WA UT CO CO WA NV Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states. D ProductID Quantity Break Point Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 1 2 10 Discount $ $ Unit Price 17.55 17.55 17.55 17.55 17.55 4.00 34.99 34.99 34.99 4.00 $ 34.99 4.00 $ 34.99 $ $ 4.00 $ 4.00 $ 4.00 $ $ E $ $ $ $ $ $ 0% 2% 5% F Quantity Net Price 4 5 7 7 1 11 2 8 8 4 G 2 16 1 5 1 2 H Total Sales Total Tax Grand Total Sale Amt I Tax J Total K L Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states. Task # Points 1 2 3 4 5 сл 6 7 6 1 2 1 2 3 1 2 6 Task Description Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate. Reuse your formula in cell G15 and paste it down to complete the "Net Price" column of the table. Multiply the ÒQuantityó by the ÒNet Priceó to get the ÒSale Amtó in Cell H15 Reuse your formula in cell H15 and paste it down to complete the ÖSale Amtó column Use an IF function in Cell I15 to calculate the Tax. There is a tax of 5% applied on shipments to Utah, 6% applied on shipments to Oregon, but no tax on shipments to other states. Refer to the appropriate tax rates in cells B10, B11 and B12 for your IF function arguments. Use absolute and relative references when appropriate. Reuse your formula in cell 115 and paste it down to complete the ÒTaxó column Calculate the Invoice ÒTotaló in cell J15 Reuse your formula in cell J15 and paste it down to complete the ÒTotaló column Use the SUM function to calculate the worksheet totals in cells 19, 110 and 111 1 2 3 4 5 6 7 8 9 10 UT 11 OR 12 All Others 13 14 15 16 17 18 19 20 A 21 22 23 24 25 26 27 28 29 30 OrderID Sales Tax Rate 1003 1004 1007 1011 1027 1041 B 1042 1050 1058 1059 1060 1062 1073 1074 1088 1094 5% 6% 0% Ship To AZ WA NV UT C CA MT CA OR UT AZ WA UT CO CO WA NV Quickstove ships worldwide and this is but a sample of shipments to the Western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states. D ProductID Quantity Break Point Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 1 2 10 Discount $ $ Unit Price 17.55 17.55 17.55 17.55 17.55 4.00 34.99 34.99 34.99 4.00 $ 34.99 4.00 $ 34.99 $ $ 4.00 $ 4.00 $ 4.00 $ $ E $ $ $ $ $ $ 0% 2% 5% F Quantity Net Price 4 5 7 7 1 11 2 8 8 4 G 2 16 1 5 1 2 H Total Sales Total Tax Grand Total Sale Amt I Tax J Total K L

Answer rating: 100% (QA)

We apply the formulae to th... View the full answer