Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

image text in transcribed Boolean Functions Enable Macros to Begin Assignment If Function Lookup Functions This assignment file relies on a set of macros to handle submission and scoring. Before Conditional you may begin theFunctions assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below. If you have already dismissed the prompt, you may need to close this workbook and open it again. An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to t "tag up" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire Scenario Runner on 1st Runner on 2nd 1 Yes No 2 Yes No 3 Yes No 4 No Yes 5 Yes Yes 6 No No 7 Yes Yes 8 Yes Yes 9 Yes Yes 10 Yes Yes 11 No No 12 Yes Yes 13 No Yes 14 No Yes 15 Yes Yes 16 No No 17 No Yes 18 No No 19 No No 20 Yes Yes 21 Yes Yes 22 No No 23 No Yes 24 No Yes 25 No No 26 Yes No 27 Yes Yes 28 No No 29 No No 30 No No Catchable Fly Ball Hit to... Infield Shallow Outfield No Yes Yes No No Yes No No No No No Yes No No No Yes No No No Yes No No Yes No No Yes No No Yes No Yes No Yes No Yes No No No No Yes Yes No Yes No Yes No No Yes No Yes Yes No No Yes No Yes No Yes No Yes Outs 0 0 0 2 0 1 1 2 1 1 0 2 0 2 1 0 0 0 0 0 0 1 1 0 0 1 0 1 2 2 Force @ Third 0 0 0 0 1 0 1 1 1 1 0 1 0 0 1 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 play. When an infield fly occurs, the batter is nners must go back to their bases (though they may ere is a force out at third base (this means that there r hits a catchable fly ball to the infield or the shallow determine if the umpire should declare an infield fly. Fly Ball Not 2 Outs 1 1 1 0 0 1 0 1 0 1 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 Infield Fly 1 1 1 0 1 1 1 0 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 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. Sales Tax Rate UT OR All Others Quantity Break Point 5% 6% 0% OrderID Ship To ProductID Product Name 1003 AZ 100 QuickStove 1004 WA 100 QuickStove 1007 NV 100 QuickStove 1011 UT 100 QuickStove 1027 CA 100 QuickStove 1041 MT 102 Replacement Fuel Cells 1042 CA 104 Quick Stove Can 1050 OR 104 Quick Stove Can 1058 UT 104 Quick Stove Can 1059 AZ 102 Replacement Fuel Cells 1060 WA 104 Quick Stove Can 1062 UT 102 Replacement Fuel Cells 1073 CO 104 Quick Stove Can 1074 CO 102 Replacement Fuel Cells 1088 WA 102 Replacement Fuel Cells 1094 NV 102 Replacement Fuel Cells 1109 HI 102 Replacement Fuel Cells 1120 OR 102 Replacement Fuel Cells 1255 OR 106 Stove In A Can 1262 UT 106 Stove In A Can 1265 WA 106 Stove In A Can 1267 CA 106 Stove In A Can 1268 MT 106 Stove In A Can 1364 AZ 106 Stove In A Can 1417 UT 108 QuickStove Fuel Disk 1629 CA 107 SIAC Fuel Cell 1635 CO 106 Stove In A Can 1661 AZ 107 SIAC Fuel Cell 1666 OR 107 SIAC Fuel Cell 1677 WA 108 QuickStove Fuel Disk 1686 CA 101 QuickStove Can 1701 CO 101 QuickStove Can 1708 AZ 101 QuickStove Can 1712 AZ 108 QuickStove Fuel Disk 1718 OR 101 QuickStove Can 1720 UT 101 QuickStove Can 1725 WA 101 QuickStove Can 1733 CA 110 Firebox Bundle Discount 1 2 10 0% 2% 5% Unit Price Quantity Net Price $ 17.55 4 $ 17.20 $ 17.55 5 $ 17.20 $ 17.55 7 $ 17.20 $ 17.55 7 $ 17.20 $ 17.55 1 $ 17.55 $ 4.00 1 $ 4.00 $ 34.99 2 $ 34.29 $ 34.99 8 $ 34.29 $ 34.99 8 $ 34.29 $ 4.00 4 $ 3.92 $ 34.99 2 $ 34.29 $ 4.00 16 $ 3.80 $ 34.99 1 $ 34.99 $ 4.00 5 $ 3.92 $ 4.00 1 $ 4.00 $ 4.00 2 $ 3.92 $ 4.00 2 $ 3.92 $ 4.00 10 $ 3.80 $ 34.99 1 $ 34.99 $ 34.99 3 $ 34.29 $ 34.99 1 $ 34.99 $ 34.99 3 $ 34.29 $ 34.99 1 $ 34.99 $ 34.99 12 $ 33.24 $ 1.66 24 $ 1.58 $ 5.00 2 $ 4.90 $ 34.99 2 $ 34.29 $ 5.00 10 $ 4.75 $ 5.00 4 $ 4.90 $ 1.66 20 $ 1.58 $ 19.95 1 $ 19.95 $ 19.95 1 $ 19.95 $ 19.95 1 $ 19.95 $ 1.66 30 $ 1.58 $ 19.95 2 $ 19.55 $ 19.95 4 $ 19.55 $ 19.95 4 $ 19.55 $ 87.75 2 $ 86.00 1746 1748 1776 1797 1814 1834 1835 1839 1842 1873 1877 1897 1913 1923 1946 1964 1979 1982 1990 2000 2031 2078 2093 2136 2146 2168 2198 2202 2217 2218 2249 2258 2283 2319 2324 2328 2331 2353 2358 2386 2393 2417 2419 2423 2439 2513 2521 2527 2605 2644 2653 2714 CO NV MT WA AZ CO CA CA MT CA CA NV AZ WA WA AZ HI CA CO WA CA AZ AZ NV CO NV UT AZ WA OR OR CA UT WA UT MT UT CA HI CO CO OR HI AZ UT AZ CA CO CO WA OR NV 110 Firebox Bundle 101 QuickStove Can 101 QuickStove Can 114 Cube Stove + 2 Fuel Disks 114 Cube Stove + 2 Fuel Disks 113 Firebox Stove w/ Fuel 113 Firebox Stove w/ Fuel 114 Cube Stove + 2 Fuel Disks 108 QuickStove Fuel Disk 109 Folding Campfire Stove 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 121 Firebox Master Combo Kit 117 Firebox Upgrade Kit 117 Firebox Upgrade Kit 121 Firebox Master Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 108 QuickStove Fuel Disk 114 Cube Stove + 2 Fuel Disks 123 Cordura D-Ring Bag 117 Firebox Upgrade Kit 118 Firebox Deluxe Combo Kit 117 Firebox Upgrade Kit 123 Cordura D-Ring Bag 118 Firebox Deluxe Combo Kit 124 The Ugly Bag - HD VCP Bag 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 124 The Ugly Bag - HD VCP Bag 109 Folding Campfire Stove 123 Cordura D-Ring Bag 114 Cube Stove + 2 Fuel Disks 109 Folding Campfire Stove 123 Cordura D-Ring Bag 124 The Ugly Bag - HD VCP Bag 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 125 3 Months Fuel with Stove 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 128 Heavy Duty Cordura D-Ring Bag 129 Stainless Steel Cup Charger 117 Firebox Upgrade Kit $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 87.75 19.95 19.95 24.95 24.95 49.95 49.95 24.95 1.66 59.99 144.98 89.99 89.99 59.99 89.99 59.99 89.99 89.99 59.99 144.98 34.98 34.98 144.98 59.99 89.99 1.66 24.95 15.99 34.98 89.99 34.98 15.99 89.99 9.99 144.98 89.99 59.99 9.99 59.99 15.99 24.95 59.99 15.99 9.99 34.98 189.99 189.99 34.98 189.99 15.99 149.99 34.98 1 4 4 2 1 1 1 2 12 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 20 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 3 1 1 1 1 1 1 1 1 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 87.75 19.55 19.55 24.45 24.95 49.95 49.95 24.45 1.58 59.99 144.98 89.99 89.99 59.99 89.99 59.99 89.99 89.99 59.99 144.98 34.28 34.98 144.98 59.99 89.99 1.58 24.95 15.99 34.98 89.99 34.98 15.99 89.99 9.99 144.98 89.99 59.99 9.79 59.99 15.99 24.95 59.99 15.99 9.79 34.98 189.99 189.99 34.98 189.99 15.99 149.99 34.98 2726 2779 2829 2833 2837 2855 2859 2865 2868 2887 2889 2896 2903 2905 2921 2928 2932 2938 2939 2979 2999 3005 3034 3043 3049 3069 3079 3095 3111 3233 3246 3265 3324 3330 3345 3352 3357 3360 3374 3377 3381 3394 3403 3404 3429 3430 3441 3446 3464 3485 3539 3546 CA MT HI OR AZ AZ CA CA NV WA OR WA WA WA AZ MT MT CA CO OR MT MT MT UT UT CA CA OR AZ CA WA AZ UT WA CA CO CA CO CA AZ OR UT CO CA OR HI HI HI OR AZ CA UT 127 Stainless Steel Cooking Pot 109 Folding Campfire Stove 132 Adjustable Fire Grate 132 Adjustable Fire Grate 127 Stainless Steel Cooking Pot 137 QuickStove Fire Starter 132 Adjustable Fire Grate 137 QuickStove Fire Starter 132 Adjustable Fire Grate 123 Cordura D-Ring Bag 133 Extended Grill Plate 132 Adjustable Fire Grate 134 Set of 2 Fire Sticks 139 Aluminum Matchbox 110 Firebox Bundle 132 Adjustable Fire Grate 150 Trangia Fuel Bottle - 0.3L 138 Grill Plate 132 Adjustable Fire Grate 124 The Ugly Bag - HD VCP Bag 133 Extended Grill Plate 146 Olicamp Space Saver Cup 121 Firebox Master Combo Kit 123 Cordura D-Ring Bag 132 Adjustable Fire Grate 157 Nalgene Cantene 32 oz 145 Cube Stove + 9 Fuel Disks 134 Set of 2 Fire Sticks 136 Boil Plate 144 Trangia Spirit Burner 146 Olicamp Space Saver Cup 144 Trangia Spirit Burner 124 The Ugly Bag - HD VCP Bag 163 Klean Kanteen Wide 40 oz 163 Klean Kanteen Wide 40 oz 161 Olicamp Pot Lifter 136 Boil Plate 134 Set of 2 Fire Sticks 168 Blue Bag 150 Trangia Fuel Bottle - 0.3L 150 Trangia Fuel Bottle - 0.3L 129 Stainless Steel Cup Charger 128 Heavy Duty Cordura D-Ring Bag 146 Olicamp Space Saver Cup 171 Power Bank with Flashlight 128 Heavy Duty Cordura D-Ring Bag 121 Firebox Master Combo Kit 133 Extended Grill Plate 127 Stainless Steel Cooking Pot 130 Emergency Cook Kit 139 Aluminum Matchbox 128 Heavy Duty Cordura D-Ring Bag $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19.99 59.99 7.99 7.99 19.99 1.95 7.99 1.95 7.99 15.99 9.99 7.99 5.99 3.99 87.75 7.99 16.49 7.99 7.99 9.99 9.99 8.96 144.98 15.99 7.99 11.49 35.99 5.99 7.99 14.99 8.96 14.99 9.99 25.16 25.16 4.95 7.99 5.99 4.99 16.49 16.49 149.99 15.99 8.96 14.99 15.99 144.98 9.99 19.99 25.00 3.99 15.99 1 1 1 1 1 2 5 35 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 2 1 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19.99 59.99 7.99 7.99 19.99 1.91 7.83 1.85 7.99 15.99 9.99 7.99 5.99 3.99 87.75 7.99 16.49 7.99 7.99 9.99 9.99 8.96 144.98 15.99 7.99 11.49 35.99 5.87 7.99 14.99 8.96 14.99 9.99 25.16 25.16 4.95 7.99 5.99 4.99 16.49 16.49 149.99 15.67 8.96 14.99 15.67 144.98 9.99 19.99 25.00 3.91 15.99 3554 3585 3616 3618 3653 3663 3702 3718 3800 HI NV CA OR CA CA CA CA MT 134 Set of 2 Fire Sticks 127 Stainless Steel Cooking Pot 175 Folding Firebox Nano 143 Trangia Fuel Bottle - 0.5L 120 Master Combo Kit 154 Deluxe Combo Kit 171 Power Bank with Flashlight 176 Firebox Accessory Kit 168 Blue Bag $ $ $ $ $ $ $ $ $ 5.99 19.99 29.99 15.29 144.98 89.99 14.99 31.48 4.99 1 1 1 1 1 1 1 1 1 $ $ $ $ $ $ $ $ $ 5.99 19.99 29.99 15.29 144.98 89.99 14.99 31.48 4.99 United States. that item are offered. s located as well as on shipments to other states. Total Sales Total Tax Grand Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Sale Amt 68.80 86.00 120.39 120.39 17.55 4.00 68.58 274.32 274.32 15.68 68.58 60.80 34.99 19.60 4.00 7.84 7.84 38.00 34.99 102.87 34.99 102.87 34.99 398.89 37.85 9.80 68.58 47.50 19.60 31.54 19.95 19.95 19.95 47.31 39.10 78.20 78.20 171.99 Tax Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 87.75 78.20 78.20 48.90 24.95 49.95 49.95 48.90 18.92 59.99 144.98 89.99 89.99 59.99 89.99 59.99 89.99 89.99 59.99 144.98 68.56 34.98 144.98 59.99 89.99 31.54 24.95 15.99 34.98 89.99 34.98 15.99 89.99 9.99 144.98 89.99 59.99 19.58 59.99 15.99 24.95 59.99 15.99 29.37 34.98 189.99 189.99 34.98 189.99 15.99 149.99 34.98 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19.99 59.99 7.99 7.99 19.99 3.82 39.15 64.84 7.99 15.99 9.99 7.99 5.99 3.99 87.75 7.99 16.49 7.99 7.99 9.99 9.99 8.96 144.98 15.99 7.99 11.49 35.99 11.74 7.99 14.99 8.96 14.99 9.99 25.16 25.16 4.95 7.99 5.99 4.99 16.49 16.49 149.99 31.34 8.96 14.99 31.34 144.98 9.99 19.99 25.00 7.82 15.99 $ $ $ $ $ $ $ $ $ 5.99 19.99 29.99 15.29 144.98 89.99 14.99 31.48 4.99 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment Quickstove has an agreement with shippers for a fixed rate that is determined by destination state and service level (regular , express or Regular overnite). Express Overnite OrderID 1003 1004 1007 1011 1027 1041 1042 1050 1058 1059 1060 1062 1073 1074 1088 1094 1109 1120 1255 1262 1265 1267 1268 1364 1417 1629 1635 1661 1666 1677 1686 1701 1708 1712 1718 1720 1725 1733 1746 1748 Ship To AZ WA NV UT CA MT CA OR UT AZ WA UT CO CO WA NV HI OR OR UT WA CA MT AZ UT CA CO AZ OR WA CA CO AZ AZ OR UT WA CA CO NV ProductID 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 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 110 Firebox Bundle 110 Firebox Bundle 101 QuickStove Can Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 68.80 86.00 120.39 120.39 17.55 4.00 69.98 274.32 274.32 15.68 69.98 60.80 34.99 19.60 4.00 8.00 8.00 38.00 34.99 102.87 34.99 102.87 34.99 398.89 37.85 10.00 69.98 47.50 19.60 31.54 19.95 19.95 19.95 47.31 39.90 78.20 78.20 175.50 87.75 78.20 $ $ $ AZ WA 5.00 $ 6.00 7.60 $ 8.40 11.60 $ 13.70 Shipping Class Express Express Regular Express Overnite Overnite Overnite Overnite Express Regular Overnite Regular Overnite Overnite Overnite Express Express Express Overnite Regular Express Overnite Regular Regular Overnite Express Express Regular Express Express Overnite Overnite Overnite Express Overnite Overnite Express Regular Express Overnite Insurance Cost $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2.50 2.50 3.00 3.00 1.00 0.50 2.50 4.00 4.00 1.00 2.50 2.50 2.00 1.00 0.50 0.50 0.50 2.00 2.00 3.00 2.00 3.00 2.00 4.00 2.00 1.00 2.50 2.00 1.00 2.00 1.00 1.00 1.00 2.00 2.00 2.50 2.50 3.00 2.50 2.50 1776 1797 1814 1834 1835 1839 1842 1873 1877 1897 1913 1923 1946 1964 1979 1982 1990 2000 2031 2078 2093 2136 2146 2168 2198 2202 2217 2218 2249 2258 2283 2319 2324 2328 2331 2353 2358 2386 2393 2417 2419 2423 2439 2513 2521 2527 2605 2644 2653 2714 2726 2779 MT WA AZ CO CA CA MT CA CA NV AZ WA WA AZ HI CA CO WA CA AZ AZ NV CO NV UT AZ WA OR OR CA UT WA UT MT UT CA HI CO CO OR HI AZ UT AZ CA CO CO WA OR NV CA MT 101 QuickStove Can 114 Cube Stove + 2 Fuel Disks 114 Cube Stove + 2 Fuel Disks 113 Firebox Stove w/ Fuel 113 Firebox Stove w/ Fuel 114 Cube Stove + 2 Fuel Disks 108 QuickStove Fuel Disk 109 Folding Campfire Stove 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 121 Firebox Master Combo Kit 117 Firebox Upgrade Kit 117 Firebox Upgrade Kit 121 Firebox Master Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 108 QuickStove Fuel Disk 114 Cube Stove + 2 Fuel Disks 123 Cordura D-Ring Bag 117 Firebox Upgrade Kit 118 Firebox Deluxe Combo Kit 117 Firebox Upgrade Kit 123 Cordura D-Ring Bag 118 Firebox Deluxe Combo Kit 124 The Ugly Bag - HD VCP Bag 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 124 The Ugly Bag - HD VCP Bag 109 Folding Campfire Stove 123 Cordura D-Ring Bag 114 Cube Stove + 2 Fuel Disks 109 Folding Campfire Stove 123 Cordura D-Ring Bag 124 The Ugly Bag - HD VCP Bag 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 125 3 Months Fuel with Stove 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 128 Heavy Duty Cordura D-Ring Bag 129 Stainless Steel Cup Charger 117 Firebox Upgrade Kit 127 Stainless Steel Cooking Pot 109 Folding Campfire Stove $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 78.20 49.90 24.95 49.95 49.95 49.90 18.92 59.99 144.98 89.99 89.99 59.99 89.99 59.99 89.99 89.99 59.99 144.98 69.96 34.98 144.98 59.99 89.99 31.54 24.95 15.99 34.98 89.99 34.98 15.99 89.99 9.99 144.98 89.99 59.99 19.98 59.99 15.99 24.95 59.99 15.99 29.37 34.98 189.99 189.99 34.98 189.99 15.99 149.99 34.98 19.99 59.99 Overnite Express Regular Overnite Overnite Express Overnite Regular Overnite Regular Regular Regular Overnite Express Overnite Overnite Regular Express Overnite Overnite Overnite Overnite Regular Regular Regular Regular Regular Overnite Regular Regular Overnite Express Regular Express Regular Express Express Regular Express Overnite Regular Overnite Overnite Overnite Express Overnite Express Overnite Overnite Overnite Overnite Express $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2.50 2.00 1.00 2.00 2.00 2.00 1.00 2.50 3.00 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 3.00 2.50 2.00 3.00 2.50 2.50 2.00 1.00 1.00 2.00 2.50 2.00 1.00 2.50 0.50 3.00 2.50 2.50 1.00 2.50 1.00 1.00 2.50 1.00 1.00 2.00 3.00 3.00 2.00 3.00 1.00 3.00 2.00 1.00 2.50 2829 2833 2837 2855 2859 2865 2868 2887 2889 2896 2903 2905 2921 2928 2932 2938 2939 2979 2999 3005 3034 3043 3049 3069 3079 3095 3111 3233 3246 3265 3324 3330 3345 3352 3357 3360 3374 3377 3381 3394 3403 3404 3429 3430 3441 3446 3464 3485 3539 3546 3554 3585 HI OR AZ AZ CA CA NV WA OR WA WA WA AZ MT MT CA CO OR MT MT MT UT UT CA CA OR AZ CA WA AZ UT WA CA CO CA CO CA AZ OR UT CO CA OR HI HI HI OR AZ CA UT HI NV 132 Adjustable Fire Grate 132 Adjustable Fire Grate 127 Stainless Steel Cooking Pot 137 QuickStove Fire Starter 132 Adjustable Fire Grate 137 QuickStove Fire Starter 132 Adjustable Fire Grate 123 Cordura D-Ring Bag 133 Extended Grill Plate 132 Adjustable Fire Grate 134 Set of 2 Fire Sticks 139 Aluminum Matchbox 110 Firebox Bundle 132 Adjustable Fire Grate 150 Trangia Fuel Bottle - 0.3L 138 Grill Plate 132 Adjustable Fire Grate 124 The Ugly Bag - HD VCP Bag 133 Extended Grill Plate 146 Olicamp Space Saver Cup 121 Firebox Master Combo Kit 123 Cordura D-Ring Bag 132 Adjustable Fire Grate 157 Nalgene Cantene 32 oz 145 Cube Stove + 9 Fuel Disks 134 Set of 2 Fire Sticks 136 Boil Plate 144 Trangia Spirit Burner 146 Olicamp Space Saver Cup 144 Trangia Spirit Burner 124 The Ugly Bag - HD VCP Bag 163 Klean Kanteen Wide 40 oz 163 Klean Kanteen Wide 40 oz 161 Olicamp Pot Lifter 136 Boil Plate 134 Set of 2 Fire Sticks 168 Blue Bag 150 Trangia Fuel Bottle - 0.3L 150 Trangia Fuel Bottle - 0.3L 129 Stainless Steel Cup Charger 128 Heavy Duty Cordura D-Ring Bag 146 Olicamp Space Saver Cup 171 Power Bank with Flashlight 128 Heavy Duty Cordura D-Ring Bag 121 Firebox Master Combo Kit 133 Extended Grill Plate 127 Stainless Steel Cooking Pot 130 Emergency Cook Kit 139 Aluminum Matchbox 128 Heavy Duty Cordura D-Ring Bag 134 Set of 2 Fire Sticks 127 Stainless Steel Cooking Pot $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7.99 7.99 19.99 3.90 39.15 64.84 7.99 15.99 9.99 7.99 5.99 3.99 87.75 7.99 16.49 7.99 7.99 9.99 9.99 8.96 144.98 15.99 7.99 11.49 35.99 11.98 7.99 14.99 8.96 14.99 9.99 25.16 25.16 4.95 7.99 5.99 4.99 16.49 16.49 149.99 31.98 8.96 14.99 31.98 144.98 9.99 19.99 25.00 7.98 15.99 5.99 19.99 Regular Regular Regular Express Overnite Regular Regular Overnite Express Regular Overnite Overnite Overnite Express Express Overnite Overnite Overnite Express Regular Express Regular Express Overnite Express Express Express Regular Express Overnite Regular Express Overnite Overnite Express Regular Overnite Regular Overnite Regular Overnite Regular Regular Overnite Express Overnite Regular Express Overnite Overnite Regular Overnite $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 0.50 0.50 1.00 0.50 2.00 2.50 0.50 1.00 0.50 0.50 0.50 0.50 2.50 0.50 1.00 0.50 0.50 0.50 0.50 0.50 3.00 1.00 0.50 1.00 2.00 1.00 0.50 1.00 0.50 1.00 0.50 1.00 1.00 0.50 0.50 0.50 0.50 1.00 1.00 3.00 2.00 0.50 1.00 2.00 3.00 0.50 1.00 1.00 0.50 1.00 0.50 1.00 3616 3618 3653 3663 3702 3718 3800 CA OR CA CA CA CA MT 175 Folding Firebox Nano 143 Trangia Fuel Bottle - 0.5L 120 Master Combo Kit 154 Deluxe Combo Kit 171 Power Bank with Flashlight 176 Firebox Accessory Kit 168 Blue Bag $ $ $ $ $ $ $ 29.99 15.29 144.98 89.99 14.99 31.48 4.99 Express Overnite Express Express Overnite Express Express $ $ $ $ $ $ $ 1.00 1.00 3.00 2.50 1.00 2.00 0.50 $ $ $ Freight Cost NV UT CA MT OR CO HI 5.00 $ 3.00 $ 5.00 $ 6.00 $ 6.00 $ 5.00 $ 8.00 7.60 $ 4.70 $ 7.60 $ 8.40 $ 8.40 $ 7.60 $ 13.50 11.60 $ 7.80 $ 11.60 $ 13.70 $ 13.70 $ 11.60 $ 17.10 Freight Cost Shipping Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 71.30 88.50 123.39 123.39 18.55 4.50 72.48 278.32 278.32 16.68 72.48 63.30 36.99 20.60 4.50 8.50 8.50 40.00 36.99 105.87 36.99 105.87 36.99 402.89 39.85 11.00 72.48 49.50 20.60 33.54 20.95 20.95 20.95 49.31 41.90 80.70 80.70 178.50 90.25 80.70 Insurance Cost Shipment Insurance Value Cost $ - $ 0.50 $ $ $ $ $ $ 10 30 50 100 200 400 $ $ $ $ $ $ 1.00 2.00 2.50 3.00 4.00 5.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 80.70 51.90 25.95 51.95 51.95 51.90 19.92 62.49 147.98 92.49 92.49 62.49 92.49 62.49 92.49 92.49 62.49 147.98 72.46 36.98 147.98 62.49 92.49 33.54 25.95 16.99 36.98 92.49 36.98 16.99 92.49 10.49 147.98 92.49 62.49 20.98 62.49 16.99 25.95 62.49 16.99 30.37 36.98 192.99 192.99 36.98 192.99 16.99 152.99 36.98 20.99 62.49 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8.49 8.49 20.99 4.40 41.15 67.34 8.49 16.99 10.49 8.49 6.49 4.49 90.25 8.49 17.49 8.49 8.49 10.49 10.49 9.46 147.98 16.99 8.49 12.49 37.99 12.98 8.49 15.99 9.46 15.99 10.49 26.16 26.16 5.45 8.49 6.49 5.49 17.49 17.49 152.99 33.98 9.46 15.99 33.98 147.98 10.49 20.99 26.00 8.48 16.99 6.49 20.99 $ $ $ $ $ $ $ 30.99 16.29 147.98 92.49 15.99 33.48 5.49 Looking at shipments, at employee performance, and at services required by customers; Quickstove managment performs several analyses. OrderID Ship To 1003 AZ 1004 WA 1007 NV 1011 UT 1027 CA 1041 MT 1042 CA 1050 OR 1058 UT 1059 AZ 1060 WA 1062 UT 1073 CO 1074 CO 1088 WA 1094 NV 1109 HI 1120 OR 1255 OR 1262 UT 1265 WA 1267 CA 1268 MT 1364 AZ 1417 UT 1629 CA 1635 CO 1661 AZ 1666 OR 1677 WA 1686 CA 1701 CO 1708 AZ 1712 AZ 1718 OR 1720 UT 1725 WA 1733 CA 1746 CO 1748 NV 1776 MT 1797 WA ProductID 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 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 110 Firebox Bundle 110 Firebox Bundle 101 QuickStove Can 101 QuickStove Can 114 Cube Stove + 2 Fuel Disks Ship Class Express Express Regular Express Overnite Overnite Overnite Overnite Express Regular Overnite Regular Overnite Overnite Overnite Express Express Express Overnite Regular Express Overnite Regular Regular Overnite Express Express Regular Express Express Overnite Overnite Overnite Express Overnite Overnite Express Regular Express Overnite Overnite Express $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Value 68.80 86.00 120.39 120.39 17.55 4.00 69.98 274.32 274.32 15.68 69.98 60.80 34.99 19.60 4.00 8.00 8.00 38.00 34.99 102.87 34.99 102.87 34.99 398.89 37.85 10.00 69.98 47.50 19.60 31.54 19.95 19.95 19.95 47.31 39.90 78.20 78.20 175.50 87.75 78.20 78.20 49.90 Employee Merrill George George Merrill Frank Frank George Frank Frank Frank George George Merrill George Frank George Howard George George Merrill Merrill Merrill Merrill Frank George George Merrill Merrill Merrill Frank Frank Merrill Merrill Frank Merrill George Frank Merrill George Howard Merrill George 1814 1834 1835 1839 1842 1873 1877 1897 1913 1923 1946 1964 1979 1982 1990 2000 2031 2078 2093 2136 2146 2168 2198 2202 2217 2218 2249 2258 2283 2319 2324 2328 2331 2353 2358 2386 2393 2417 2419 2423 2439 2513 2521 2527 2605 2644 2653 2714 AZ CO CA CA MT CA CA NV AZ WA WA AZ HI CA CO WA CA AZ AZ NV CO NV UT AZ WA OR OR CA UT WA UT MT UT CA HI CO CO OR HI AZ UT AZ CA CO CO WA OR NV 114 Cube Stove + 2 Fuel Disks 113 Firebox Stove w/ Fuel 113 Firebox Stove w/ Fuel 114 Cube Stove + 2 Fuel Disks 108 QuickStove Fuel Disk 109 Folding Campfire Stove 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 121 Firebox Master Combo Kit 117 Firebox Upgrade Kit 117 Firebox Upgrade Kit 121 Firebox Master Combo Kit 109 Folding Campfire Stove 118 Firebox Deluxe Combo Kit 108 QuickStove Fuel Disk 114 Cube Stove + 2 Fuel Disks 123 Cordura D-Ring Bag 117 Firebox Upgrade Kit 118 Firebox Deluxe Combo Kit 117 Firebox Upgrade Kit 123 Cordura D-Ring Bag 118 Firebox Deluxe Combo Kit 124 The Ugly Bag - HD VCP Bag 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 109 Folding Campfire Stove 124 The Ugly Bag - HD VCP Bag 109 Folding Campfire Stove 123 Cordura D-Ring Bag 114 Cube Stove + 2 Fuel Disks 109 Folding Campfire Stove 123 Cordura D-Ring Bag 124 The Ugly Bag - HD VCP Bag 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 125 3 Months Fuel with Stove 117 Firebox Upgrade Kit 125 3 Months Fuel with Stove 128 Heavy Duty Cordura D-Ring Bag 129 Stainless Steel Cup Charger 117 Firebox Upgrade Kit Regular Overnite Overnite Express Overnite Regular Overnite Regular Regular Regular Overnite Express Overnite Overnite Regular Express Overnite Overnite Overnite Overnite Regular Regular Regular Regular Regular Overnite Regular Regular Overnite Express Regular Express Regular Express Express Regular Express Overnite Regular Overnite Overnite Overnite Express Overnite Express Overnite Overnite Overnite $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 24.95 49.95 49.95 49.90 18.92 59.99 144.98 89.99 89.99 59.99 89.99 59.99 89.99 89.99 59.99 144.98 69.96 34.98 144.98 59.99 89.99 31.54 24.95 15.99 34.98 89.99 34.98 15.99 89.99 9.99 144.98 89.99 59.99 19.98 59.99 15.99 24.95 59.99 15.99 29.37 34.98 189.99 189.99 34.98 189.99 15.99 149.99 34.98 Frank Merrill George Merrill Howard Merrill George George George Frank Merrill George Frank Merrill Frank George Merrill Howard Frank Frank Merrill Merrill Merrill George Frank Merrill Howard George Howard Merrill George Frank George Merrill George George Frank Merrill George George Merrill Merrill Merrill Merrill Merrill George Howard Frank 2726 2779 2829 2833 2837 2855 2859 2865 2868 2887 2889 2896 2903 2905 2921 2928 2932 2938 2939 2979 2999 3005 3034 3043 3049 3069 3079 3095 3111 3233 3246 3265 3324 3330 3345 3352 3357 3360 3374 3377 3381 3394 3403 3404 3429 3430 3441 3446 CA MT HI OR AZ AZ CA CA NV WA OR WA WA WA AZ MT MT CA CO OR MT MT MT UT UT CA CA OR AZ CA WA AZ UT WA CA CO CA CO CA AZ OR UT CO CA OR HI HI HI 127 Stainless Steel Cooking Pot 109 Folding Campfire Stove 132 Adjustable Fire Grate 132 Adjustable Fire Grate 127 Stainless Steel Cooking Pot 137 QuickStove Fire Starter 132 Adjustable Fire Grate 137 QuickStove Fire Starter 132 Adjustable Fire Grate 123 Cordura D-Ring Bag 133 Extended Grill Plate 132 Adjustable Fire Grate 134 Set of 2 Fire Sticks 139 Aluminum Matchbox 110 Firebox Bundle 132 Adjustable Fire Grate 150 Trangia Fuel Bottle - 0.3L 138 Grill Plate 132 Adjustable Fire Grate 124 The Ugly Bag - HD VCP Bag 133 Extended Grill Plate 146 Olicamp Space Saver Cup 121 Firebox Master Combo Kit 123 Cordura D-Ring Bag 132 Adjustable Fire Grate 157 Nalgene Cantene 32 oz 145 Cube Stove + 9 Fuel Disks 134 Set of 2 Fire Sticks 136 Boil Plate 144 Trangia Spirit Burner 146 Olicamp Space Saver Cup 144 Trangia Spirit Burner 124 The Ugly Bag - HD VCP Bag 163 Klean Kanteen Wide 40 oz 163 Klean Kanteen Wide 40 oz 161 Olicamp Pot Lifter 136 Boil Plate 134 Set of 2 Fire Sticks 168 Blue Bag 150 Trangia Fuel Bottle - 0.3L 150 Trangia Fuel Bottle - 0.3L 129 Stainless Steel Cup Charger 128 Heavy Duty Cordura D-Ring Bag 146 Olicamp Space Saver Cup 171 Power Bank with Flashlight 128 Heavy Duty Cordura D-Ring Bag 121 Firebox Master Combo Kit 133 Extended Grill Plate Overnite Express Regular Regular Regular Express Overnite Regular Regular Overnite Express Regular Overnite Overnite Overnite Express Express Overnite Overnite Overnite Express Regular Express Regular Express Overnite Express Express Express Regular Express Overnite Regular Express Overnite Overnite Express Regular Overnite Regular Overnite Regular Overnite Regular Regular Overnite Express Overnite $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19.99 59.99 7.99 7.99 19.99 3.90 39.15 64.84 7.99 15.99 9.99 7.99 5.99 3.99 87.75 7.99 16.49 7.99 7.99 9.99 9.99 8.96 144.98 15.99 7.99 11.49 35.99 11.98 7.99 14.99 8.96 14.99 9.99 25.16 25.16 4.95 7.99 5.99 4.99 16.49 16.49 149.99 31.98 8.96 14.99 31.98 144.98 9.99 George Merrill Merrill Howard Howard Merrill George George George Merrill Frank Merrill George Frank Howard Frank George Frank George Merrill Merrill Howard Merrill Merrill George Merrill Howard Merrill Merrill George Merrill Frank Merrill Howard Merrill Merrill Howard Merrill Merrill Frank Merrill Merrill Frank Merrill Howard George Howard George 3464 3485 3539 3546 3554 3585 3616 3618 3653 3663 3702 3718 3800 OR AZ CA UT HI NV CA OR CA CA CA CA MT 127 Stainless Steel Cooking Pot 130 Emergency Cook Kit 139 Aluminum Matchbox 128 Heavy Duty Cordura D-Ring Bag 134 Set of 2 Fire Sticks 127 Stainless Steel Cooking Pot 175 Folding Firebox Nano 143 Trangia Fuel Bottle - 0.5L 120 Master Combo Kit 154 Deluxe Combo Kit 171 Power Bank with Flashlight 176 Firebox Accessory Kit 168 Blue Bag Regular Express Overnite Overnite Regular Overnite Express Overnite Express Express Overnite Express Express $ $ $ $ $ $ $ $ $ $ $ $ $ 19.99 25.00 7.98 15.99 5.99 19.99 29.99 15.29 144.98 89.99 14.99 31.48 4.99 George Merrill Frank Merrill Merrill Howard Frank George Frank Merrill George Frank Howard Count Merrill Frank George Howard All Shipments by Employee Total Value Average Value 58 $ 2,781.55 $ 52.20 32 $ 2,098.40 $ 55.37 43 $ 2,519.79 $ 54.82 18 $ 818.54 $ 47.48 151 $ 8,218.29 $ 52.47 Shipments by Shipping Class Count Total Value Average Value Regular 42 $ 2,216.01 $ 52.76 Express 47 $ 2,703.33 $ 57.52 Overnite 62 $ 3,003.52 $ 48.44

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cambridge IGCSE And O Level Accounting Coursebook

Authors: Catherine Coucom

2nd Edition

1316502775, 978-1316502778

More Books

Students also viewed these Accounting questions

Question

preparing for and completing job interviews and considering offers.

Answered: 1 week ago

Question

What does this look like?

Answered: 1 week ago