Instructions

1. Reformat and provide appropriate calculations in the Income Statement Formatting tab to format the provided information in the following format (Areas for formulas [e.g., Gross Margin, Net Income, percentages, etc.] must be calculations.):

Unknown Company
Income Statement For the period ended December 31, XXXX
Revenues Cost of Goods Sold Gross Margin Expenses	Amount $ 50,000 20,000 30,000	100.0% 40.0% 60.0%
Research and Development Selling, General, & Administrative Interest Total Expenses	10,000 10,000 3,000 23,000	20.0% 20.0% 6.0% 46.0%
Net Income	$ 7,000	14.0%

2. Sort the data in the Basic Data Manipulation tab by Date of Sale from Oldest to Newest.
3. Use Column J to calculate the gross margin amount, and title the column, Margin."
4. Use Column K to calculate the gross margin percentage for each item, and title the column, Margin %.
5. Make a copy of the revised Basic Data Manipulation tab and name the new tab Data 2."
6. Filter the data in the Basic Data Manipulation tab by Margin % for items with less than 35% margin (hint: there should be 36 items visible after filtering).
7. In the tab VLookup, title Column G, Sales Tax."
8. Use the following formula in the Sales Tax column to determine the sales tax amount for the first line item:

=VLOOKUP(F:F,J:K,2,FALSE)*E2

Then copy the formula to calculate the remaining line items.

9. Use the Data 2 tab created earlier to create a Pivot Table as a new worksheet.
10. Structure the Pivot Table as follows:

Row: Description

Values:

Sum of Sales

Sum of Cost

Sum of Margin

Basic Data Manipulation Below:

Income Statement Formatting below:

V-LOOK Up below:

$8.01 77.52 0.01 Invoice # Customer # Zip Code Date of Sale 3069 2047 67838 3026 2088 67004 3043 2087 67731 3028 2086 67416 3046 2064 67732 3039 2060 67518 3067 2072 66736 3069 2047 67838 3068 2046 67035 3048 2031 67626 3045 2100 66226 3035 2051 66713 3043 2087 67731 3053 2032 66414 3043 2087 67731 3067 2072 66736 3022 2091 67621 3070 2018 67342 3055 2081 66014 3067 2072 66736 3069 2047 67838 3031 2041 66404 3030 2063 67010 3034 2077 66749 3046 2064 67732 3026 2088 67004 3053 2032 66414 3072 2100 67344 3030 2063 67010 3070 2018 67342 3055 2081 66014 3054 2088 66842 3028 2086 67416 3028 2086 67416 3056 2063 67335 3061 2024 66037 3023 2021 67511 3052 2036 67333 23 202 6751 3040 2074 67422 3039 2060 67518 3069 2047 67838 3025 2099 66710 3041 2066 66408 3068 2046 67035 3055 2081 66014 3069 2047 67838 3037 2073 66406 3055 2081 66014 3024 2079 66401 3021 2001 67510 2048 67018 3044 2048 67018 3054 2088 66842 3060 2046 67026 3032 2068 67418 3046 2064 67732 3061 2024 66937 3061 2024 66937 3072 2100 67344 3068 2046 67035 3071 2044 67042 3071 2044 67042 3069 2047 67838 3067 2072 66736 3048 2031 67626 3069 2047 67838 3069 2047 67838 3065 2067 67837 3036 2044 67516 3055 208I 60014 3067 2072 66736 3026 2088 67004 3032 2068 67418 3048 2031 67626 3033 2051 67332 3064 2006 67031 SKU 3/4/2021 FRT-APO 3/1/2021 FRT-FIL 3/2/2021 FRT-TAN 3/1/2021 FRT-COU 3/2/2021 FRT-SOO 3/2/2021 FRT-PLT 3/4/2021 FRT-LYE 3/4/2021 FRT-BIT 3/4/2021 FRT-LED 3/2/2021 FRT-SOO 3/2/2021 FRT-PEA 3/1/2021 FRT-CUE 3/2/2021 FRT-CUE 3/2/2021 FRT-JAU 3/2/2021 FRT-APL 3/4/2021 FRT-APL 3/1/2021 FRT-FIL 3/4/2021 FRT-COU 3/3/2021 FRT-POL 3/4/2021 FRT-PLI 3/4/2021 FRT-MAG 3/1/2021 FRT-LYE 3/1/2021 FRT-BIT 3/1/2022 FRT-BLR 3/2/2021 FRT-FEO 3/1/2021 FRT-CHY 3/2/2021 FRT-CLR 3/4/2021 FRT-JAL 3/1/2021 FRT-APL 3/4/2021 FRT-STI 3/3/2021 FRT-NEN 3/2/2021 FRT-PHI 3/1/2021 FRT-MII 3/1/2021 FRT-APO 3/3/2021 FRT-CLR 3/3/2021 FRT-CHY 3/1/2021 FRT-PEO 3/2/2021 FRT-FEO 3/1/2021 FRT-JUR 3/2/2021 FRT-JUR 3/2/2021 FRT-CHR 3/4/2021 FRT-GRI 3/1/2021 FRT-ELR 3/2/2021 FRT-BLN 3/4/2021 FRT-BLR 3/2/2021 FRT-JUB 3/4/2021 FRT-MEO 3/1/2021 FRT-GRI 3/3/2021 FRT-PEA 3/1/2021 FRT-DUA 3/1/2021 FRT-OLV 3/2/2021 FRT-GOR 3/2/2021 FRT-CUN 3/2/2021 FRT-DAO 3/3/2021 FRT-UGI 3/1/2021 FRT-GRI 3/2/2021 FRT-BLR 3/3/2021 FRT-AVD 3/3/2021 FRT-GRI 3/4/2021 FRT-BOR 3/4/2021 FRT-GOR 3/4/2021 FRT-NAC 3/4/2021 FRT-KIL 3/4/2021 FRT-QUC 3/4/2021 FRT-MAG 3/2/2021 FRT-RAA 3/4/2021 FRT-RAA 3/4/2021 FRT-RAR 3/3/2021 FRT- PHI 3/1/2021 FRT-CRR 3/3/2021 FRT-CRR 3/4/2021 FRT-JUB 3/1/2021 FRT-JAB 3/1/2021 FRT-TAN 3/2/2021 FRT-CUN 3/1/2021 FRT-PLT 3/3/2021 FRT-SAA Description Quantity (Pounds) Apricot Fig Tamarind Coconut Soursop Plumcot (or Lychee Biberty Lemon Soursop Cucumber Cucumber Jambul Apple Apple Fig Coconut Pomelo Plantain Mango Lychee Biberty Blackberry Feijoa Cherimoya Cloudberry Jambul Apple Star fruit Nectarine Physalis Miracle fruit Apricot Cloudberry Cherimoya Persimmon Feijoa Juniper berr Juniper berr Cherry Grapekaisin Elderberry Blackcurren Blackberry Jujube Melon GrapeRaisin Pear Durian Olive Goji berry Currant Damson Ugli fruit GrapeRaisin Blackberry Avocado GrapeRaisin Boysenbem Goji berry Nance Kiwifruit Quince Mango Rambutan Rambutan Raspberry Physalis Cranberry Cranberry Jujube Jabuticaba Tamarind Currant Plumcot (or Salak Sales Cost 50 140.02 50 120.52 50 109.52 45 10R.47 45 108.02 50 105.02 50 100.52 50 100.02 98.42 40 96.02 50 91.52 50 91.02 50 91.02 45 87.77 50 85.02 50 85.02 35 84.37 35 84.37 35 82.97 40 82.42 35 80.87 80.42 40 50.02 40 2002 40 79.22 45 78.77 45 78.77 40 78.02 45 76.52 30 75.02 50 73.52 40 72.R2 35 71.77 25 70.02 70.02 40 70.02 35 69.67 35 50 65.02 50 65.02 25 62.52 50 62.52 25 60.27 30 60.02 30 60.02 59.62 30 58.22 45 56.27 30 54.92 25 54.27 35 53.92 45 53.12 30 52.52 25 51.02 45 50.42 50.02 25 50.02 50 50.02 50.02 50 50.02 40 47.22 40 47.22 20 45 46.37 20 46.22 20 46.02 20 46.02 40 45.62 25 45.52 45 45.47 45 45.47 30 44.72 50 44.52 20 43.82 25 43.77 20 42.02 50 40.52 65.71 62.01 62.51 58.51 50.21 58.41 53.51 54.51 54.51 50.86 54.51 54.51 54.26 53.91 53.91 49.61 51.46 50.01 46.81 51.61 52.01 49.96 49.06 45.21 49.06 47.21 4.01 44.81 42.01 44.01 43.61 44.41 43.06 45.51 43.01 43.01 37.01 38.01 35.41 39.71 38.01 36.01 33.31 32.11 33.01 33.20 33.31 31.21 33.51 31.06 29.61 32.26 29.51 29.61 31.01 29.61 28.81 27.41 28.36 29.41 30.41 30.41 28.01 28.01 27.46 27.46 28.51 26.01 27.61 26.01 24.8 25.01 50000 Revenues Expenses Cost of Goods Sold Research and Development Expenses Selling, General, and Administrative Expenses Interest Expense 2000 1000 1000 3000 20013 20451 20103 20532 Sales Order Sales Orde product descr Product Sa Store Locat State Sales Tax Sales Order D/1/2019 Date Quanti Iption - le Pricelon state - Rate 20001 10 Product 1 95 KS AL 0.04 20005 11/1/2019 8 Product 1 95 TN AK 20017 11/7/2019 1 Product 1 95 TX AZ 0.056 2008 11/29/2019 11 Product 1 95 OK AR 0.065 20140 12/20/2015 5 Product 1 95 TX CA 0.0725 20183 1/1/2020 7 Product 1 95 NE CO 0.029 20223 1/13/2020 1 Product 1 95 MO CT 0.0635 20224 1/13/2020 1 Product 1 95 TX DE O 20227 1/14/ 2020 2 Product i 95 OK FL 0.06 20229 1/14/2020 9 Product 1 95 TX GA 0.04 202 80 1/30/2020 7 Product 1 95 AR HI 0.04 20305 2/10/2020 4 Product i 95 OK ID 0.06 20378 3/3/2020 7 Product 1 95 AR IL 0.0625 20379 3/3/2020 12 Product 1 95 MO IN 0.07 20440 3/19/2020 3 Product 1 95 TX IA 0.06 20457 3/26/ 2020 10 Product 1 95 TX KS 0.065 205 13 4/13/2020 10 Product 1 95 OK KY 0.06 205 18 4/14/2020 8 Product i 95 IA LA 0.05 11/4/2019 4 Product 2 120 OK ME 0.055 20031 11/12/2019 4 Product 2 120 MO MD 0.06 20090 12/1/2019 10 Product 2 120 TN MA 0.0625 20093 12/2/2019 1 Product 2 120 KS MI 0.06 20183 1/1/2020 10 Product 2 120 NE MN 0.06875 20230 1/15/2020 6 Product 2 120 MO MS 0.07 20282 1/31/2020 7 Product 2 120 OK 0.04225 3/24/2020 2 Product 2 120 NE MT O 205 16 4/13/2020 11 Product 2 120 TX NE 0.055 20564 4/28/2020 6 Product 2 120 IA NV 0.0685 20013 11/4/2019 2 Product 3 100 OK NH O 20020 11/7/2019 6 Product 3 100 TX NJ 0.06625 20033 11/12/2019 1 Product 3 100 MO NM 0.05125 20040 11/14/2019 2 Product 100 NE NY 0.04 20056 11/21/2019 8 Product 3 100 OK NC 0.0475 20063 11/22/2019 4 Product 3 100 NE ND 0.05 20097 12/4/2019 9 Product 3 100 LA OH 0.05 75 20098 12/4/2019 4 Product 3 100 NE OK 0.045 12/5/2019 7 Product 3 100 AR OR 20137 12/18/2019 10 Product 3 100 KS PA 0.06 20155 12/23/2019 8 Product 3 100 KS RI 0.07 20103 12/25/2019 3 Product 3 100 TX SC 0.06 20200 1/7/2020 12 Product 3 100 TX SD 0.045 20217 1/12/2020 11 Product 3 100 TX TN 0.07 20233 1/16/2020 7 Product 3 100 KS TX 0.0625 20261 1/25/2020 6 Product 3 100 TN UT 0.0595 20285 2/1/2020 2 Product 3 100 OK 0.06 20308 2/11/2020 11 Product 3 100 AR VA 0.053 203 12 2/12/2020 4 Product 3 100 OK WA 0.065 203 25 2/15/2020 7 Product 3 100 KS wy 0.06 20368 2/29/2020 il Product 3 100 LA WI 0.05 20384 3/4/ 2020 10 Product 3 100 NE WY 0.04 20393 3/7/2020 9 Product 3 100 MO DC 0.057 20404 3/9/2020 1 Product 3 100 TX 20416 3/13/2020 2 Product 3 100 AR 20439 3/19/2020 1 Product 3 100 KS 20441 3/19/2020 10 Product 3 100 AR 20450 3/24/ 2020 9 Product 3 100 TX 20454 3/25/2020 1 Product 3 100 MO 20458 3/26/2020 11 Product 3 100 MO 20460 3/27/2020 6 Product 3 100 OK 20471 3/29/2020 6 Product 3 100 OK 20491 4/7/2020 3 Product 100 AR 20492 4/8/2020 10 Product 3 100 TN 4/17/2020 11 Product 3 100 AR 205 35 4/19/2020 6 6 Product 3 100 AR 20543 4/20/2020 3 Product 3 100 LA 20545 4/21/2020 1 Product 3 100 TX 20009 11/2/2019 3 Product 4 105 IA 20024 11/8/2019 1 Product 4 105 AR 20037 11/13/2019 3 Product 4 105 TX 20053 11/20/2019 2 Product 4 105 KS 20055 11/20/2019 11 Product 4 105 TX 20062 11/22/2019 12 Product 4 105 IA 20068 11/24/2019 9 Product 4 105 OK 20106 12/7/2019 1 Product 4 105 TX 20124 12/15/2019 11 Product 4 105 KS 20126 12/16/2019 6 Product 4 105 TX 20142 12/20/2019 9 Product 4 105 AR 20151 12/22/2019 8 Product 4 105 IA 20179 12/30/2019 6 Product 4 105 NE 20192 1/6/ 2020 12 Product 4 105 MO 20200 1/7/2020 10 Product 4 105 TX 20218 1/12/2020 4 4 Product 4 105 TX 20241 1/19/2020 2 Product 4 4 105 MO 20242 1/19/2020 3 Product 4 105 MO 20249 1/22/2020 8 Product 4 105 OK 20251 1/22/2020 11 Product 4 105 MO 20256 1/24/ 2020 5 Product 4 105 NE 20265 1/27/2020 1 Product 4 105 OK 20266 1/27/2020 5 Product 4 105 MO 20305 2/10/2020 6 Product 4 105 OK 20307 2/11/2020 9 Product 4 105 IA 20308 2/11/2020 8 Product 4 105 AR 203 10 2/11/2020 2 Product 4 105 TX 20314 2/13/2020 2 Product 4 105 TX 20383 3/4/ 2020 5 Product 4 105 IA 20403 3/9/2020 4 Product 4 105 AR 20407 3/10/2020 9 Product 4 105 TX 20424 3/16/2020 10 Product 4 105 OK 20452 3/25/2020 4 Product 4 105 MO 20461 3/27/2020 2 Product 4 105 TX 20465 3/28/2020 8 Product 4 105 KS 20494 4/8/2020 2 Product 4 105 TX 20496 4/8/2020 5 Product 4 105 IA 20503 4/10/2020 2 Product 4 105 AR 20537 4/19/2020 6 Product 4 105 TX 20539 4/19/2020 10 Product 4 105 OK 20559 4/25/2020 11 Product 4 105 AR 20012 11/4/2019 1 Product 85 TX 20023 11/8/2019 2 Product 5 85 OK 20037 11/13/2019 3 Product 5 85 TX 20043 11/16/2019 12 Product 5 85 TX 2009 11/22/2019 6 Product 5 85 AR 20086 11/30/2019 11 Product 5 85 KS 20089 12/1/2019 10 Products 85 OK 20120 12/12/2019 10 Product 5 85 IA 20126 12/16/2019 9 Product 5 85 TX 20168 12/27/2019 8 Product 5 85 IA 20199 1/7/2020 8 Products 85 NE 20202 1/8/2020 7 Product 5 85 KS 20211 1/10/2020 12 Product 5 85 MO 20250 1/22/2020 5 Products 85 MO 20253 1/22/2020 10 Product 5 85 MO 1/26/2020 12 Product 5 85 TX 20271 1/28/2020 11 Products 85 AR 20291 7 2/4/2020 7 Product 5 85 NE 20305 2/10/2020 3 Product 5 85 OK 20307 2/11/2020 9 Product 5 85 IA 203 38 2/22/2020 6 Product 5 85 MO 20357 2/27/2020 8 Product 5 85 AR 20406 3/10/2020 4 Product 5 85 OK 20494 4/8/2020 6 Product 5 85 TX 20495 4/8/2020 4 Product 5 85 NE 20503 4/10/2020 6 Product 5 85 AR 20003 11/1/2019 8 Product 6 90 MO 20005 11/1/2019 9 Producto 90 TN 2013 12/19/2019 4 Product 6 90 KS 20161 12/25/2019 12 Product 6 90 TX 20211 1/10/2020 12 Product 6 90 MO 20277 1/29/2020 1 Product 6 90 OK 202 20 1/30/2020 4 Product 6 90 AR 20283 1/31/2020 4 Product 6 90 NE 203 28 2/17/2020 11 Product 6 90 NE 20375 3/2/2020 11 Product 6 90 KS 20404 3/9/2020 3 Product 6 90 TX 20407 3/10/2020 12 Product 6 90 TX 20418 3/14/2020 12 Product 3 90 LA 20438 3/18/2020 4 Product 6 90 OK 20451 3/24/2020 9 Product 6 90 NE 20453 3/25/2020 3 Product 6 90 NE 20262 $8.01 77.52 0.01 Invoice # Customer # Zip Code Date of Sale 3069 2047 67838 3026 2088 67004 3043 2087 67731 3028 2086 67416 3046 2064 67732 3039 2060 67518 3067 2072 66736 3069 2047 67838 3068 2046 67035 3048 2031 67626 3045 2100 66226 3035 2051 66713 3043 2087 67731 3053 2032 66414 3043 2087 67731 3067 2072 66736 3022 2091 67621 3070 2018 67342 3055 2081 66014 3067 2072 66736 3069 2047 67838 3031 2041 66404 3030 2063 67010 3034 2077 66749 3046 2064 67732 3026 2088 67004 3053 2032 66414 3072 2100 67344 3030 2063 67010 3070 2018 67342 3055 2081 66014 3054 2088 66842 3028 2086 67416 3028 2086 67416 3056 2063 67335 3061 2024 66037 3023 2021 67511 3052 2036 67333 23 202 6751 3040 2074 67422 3039 2060 67518 3069 2047 67838 3025 2099 66710 3041 2066 66408 3068 2046 67035 3055 2081 66014 3069 2047 67838 3037 2073 66406 3055 2081 66014 3024 2079 66401 3021 2001 67510 2048 67018 3044 2048 67018 3054 2088 66842 3060 2046 67026 3032 2068 67418 3046 2064 67732 3061 2024 66937 3061 2024 66937 3072 2100 67344 3068 2046 67035 3071 2044 67042 3071 2044 67042 3069 2047 67838 3067 2072 66736 3048 2031 67626 3069 2047 67838 3069 2047 67838 3065 2067 67837 3036 2044 67516 3055 208I 60014 3067 2072 66736 3026 2088 67004 3032 2068 67418 3048 2031 67626 3033 2051 67332 3064 2006 67031 SKU 3/4/2021 FRT-APO 3/1/2021 FRT-FIL 3/2/2021 FRT-TAN 3/1/2021 FRT-COU 3/2/2021 FRT-SOO 3/2/2021 FRT-PLT 3/4/2021 FRT-LYE 3/4/2021 FRT-BIT 3/4/2021 FRT-LED 3/2/2021 FRT-SOO 3/2/2021 FRT-PEA 3/1/2021 FRT-CUE 3/2/2021 FRT-CUE 3/2/2021 FRT-JAU 3/2/2021 FRT-APL 3/4/2021 FRT-APL 3/1/2021 FRT-FIL 3/4/2021 FRT-COU 3/3/2021 FRT-POL 3/4/2021 FRT-PLI 3/4/2021 FRT-MAG 3/1/2021 FRT-LYE 3/1/2021 FRT-BIT 3/1/2022 FRT-BLR 3/2/2021 FRT-FEO 3/1/2021 FRT-CHY 3/2/2021 FRT-CLR 3/4/2021 FRT-JAL 3/1/2021 FRT-APL 3/4/2021 FRT-STI 3/3/2021 FRT-NEN 3/2/2021 FRT-PHI 3/1/2021 FRT-MII 3/1/2021 FRT-APO 3/3/2021 FRT-CLR 3/3/2021 FRT-CHY 3/1/2021 FRT-PEO 3/2/2021 FRT-FEO 3/1/2021 FRT-JUR 3/2/2021 FRT-JUR 3/2/2021 FRT-CHR 3/4/2021 FRT-GRI 3/1/2021 FRT-ELR 3/2/2021 FRT-BLN 3/4/2021 FRT-BLR 3/2/2021 FRT-JUB 3/4/2021 FRT-MEO 3/1/2021 FRT-GRI 3/3/2021 FRT-PEA 3/1/2021 FRT-DUA 3/1/2021 FRT-OLV 3/2/2021 FRT-GOR 3/2/2021 FRT-CUN 3/2/2021 FRT-DAO 3/3/2021 FRT-UGI 3/1/2021 FRT-GRI 3/2/2021 FRT-BLR 3/3/2021 FRT-AVD 3/3/2021 FRT-GRI 3/4/2021 FRT-BOR 3/4/2021 FRT-GOR 3/4/2021 FRT-NAC 3/4/2021 FRT-KIL 3/4/2021 FRT-QUC 3/4/2021 FRT-MAG 3/2/2021 FRT-RAA 3/4/2021 FRT-RAA 3/4/2021 FRT-RAR 3/3/2021 FRT- PHI 3/1/2021 FRT-CRR 3/3/2021 FRT-CRR 3/4/2021 FRT-JUB 3/1/2021 FRT-JAB 3/1/2021 FRT-TAN 3/2/2021 FRT-CUN 3/1/2021 FRT-PLT 3/3/2021 FRT-SAA Description Quantity (Pounds) Apricot Fig Tamarind Coconut Soursop Plumcot (or Lychee Biberty Lemon Soursop Cucumber Cucumber Jambul Apple Apple Fig Coconut Pomelo Plantain Mango Lychee Biberty Blackberry Feijoa Cherimoya Cloudberry Jambul Apple Star fruit Nectarine Physalis Miracle fruit Apricot Cloudberry Cherimoya Persimmon Feijoa Juniper berr Juniper berr Cherry Grapekaisin Elderberry Blackcurren Blackberry Jujube Melon GrapeRaisin Pear Durian Olive Goji berry Currant Damson Ugli fruit GrapeRaisin Blackberry Avocado GrapeRaisin Boysenbem Goji berry Nance Kiwifruit Quince Mango Rambutan Rambutan Raspberry Physalis Cranberry Cranberry Jujube Jabuticaba Tamarind Currant Plumcot (or Salak Sales Cost 50 140.02 50 120.52 50 109.52 45 10R.47 45 108.02 50 105.02 50 100.52 50 100.02 98.42 40 96.02 50 91.52 50 91.02 50 91.02 45 87.77 50 85.02 50 85.02 35 84.37 35 84.37 35 82.97 40 82.42 35 80.87 80.42 40 50.02 40 2002 40 79.22 45 78.77 45 78.77 40 78.02 45 76.52 30 75.02 50 73.52 40 72.R2 35 71.77 25 70.02 70.02 40 70.02 35 69.67 35 50 65.02 50 65.02 25 62.52 50 62.52 25 60.27 30 60.02 30 60.02 59.62 30 58.22 45 56.27 30 54.92 25 54.27 35 53.92 45 53.12 30 52.52 25 51.02 45 50.42 50.02 25 50.02 50 50.02 50.02 50 50.02 40 47.22 40 47.22 20 45 46.37 20 46.22 20 46.02 20 46.02 40 45.62 25 45.52 45 45.47 45 45.47 30 44.72 50 44.52 20 43.82 25 43.77 20 42.02 50 40.52 65.71 62.01 62.51 58.51 50.21 58.41 53.51 54.51 54.51 50.86 54.51 54.51 54.26 53.91 53.91 49.61 51.46 50.01 46.81 51.61 52.01 49.96 49.06 45.21 49.06 47.21 4.01 44.81 42.01 44.01 43.61 44.41 43.06 45.51 43.01 43.01 37.01 38.01 35.41 39.71 38.01 36.01 33.31 32.11 33.01 33.20 33.31 31.21 33.51 31.06 29.61 32.26 29.51 29.61 31.01 29.61 28.81 27.41 28.36 29.41 30.41 30.41 28.01 28.01 27.46 27.46 28.51 26.01 27.61 26.01 24.8 25.01 50000 Revenues Expenses Cost of Goods Sold Research and Development Expenses Selling, General, and Administrative Expenses Interest Expense 2000 1000 1000 3000 20013 20451 20103 20532 Sales Order Sales Orde product descr Product Sa Store Locat State Sales Tax Sales Order D/1/2019 Date Quanti Iption - le Pricelon state - Rate 20001 10 Product 1 95 KS AL 0.04 20005 11/1/2019 8 Product 1 95 TN AK 20017 11/7/2019 1 Product 1 95 TX AZ 0.056 2008 11/29/2019 11 Product 1 95 OK AR 0.065 20140 12/20/2015 5 Product 1 95 TX CA 0.0725 20183 1/1/2020 7 Product 1 95 NE CO 0.029 20223 1/13/2020 1 Product 1 95 MO CT 0.0635 20224 1/13/2020 1 Product 1 95 TX DE O 20227 1/14/ 2020 2 Product i 95 OK FL 0.06 20229 1/14/2020 9 Product 1 95 TX GA 0.04 202 80 1/30/2020 7 Product 1 95 AR HI 0.04 20305 2/10/2020 4 Product i 95 OK ID 0.06 20378 3/3/2020 7 Product 1 95 AR IL 0.0625 20379 3/3/2020 12 Product 1 95 MO IN 0.07 20440 3/19/2020 3 Product 1 95 TX IA 0.06 20457 3/26/ 2020 10 Product 1 95 TX KS 0.065 205 13 4/13/2020 10 Product 1 95 OK KY 0.06 205 18 4/14/2020 8 Product i 95 IA LA 0.05 11/4/2019 4 Product 2 120 OK ME 0.055 20031 11/12/2019 4 Product 2 120 MO MD 0.06 20090 12/1/2019 10 Product 2 120 TN MA 0.0625 20093 12/2/2019 1 Product 2 120 KS MI 0.06 20183 1/1/2020 10 Product 2 120 NE MN 0.06875 20230 1/15/2020 6 Product 2 120 MO MS 0.07 20282 1/31/2020 7 Product 2 120 OK 0.04225 3/24/2020 2 Product 2 120 NE MT O 205 16 4/13/2020 11 Product 2 120 TX NE 0.055 20564 4/28/2020 6 Product 2 120 IA NV 0.0685 20013 11/4/2019 2 Product 3 100 OK NH O 20020 11/7/2019 6 Product 3 100 TX NJ 0.06625 20033 11/12/2019 1 Product 3 100 MO NM 0.05125 20040 11/14/2019 2 Product 100 NE NY 0.04 20056 11/21/2019 8 Product 3 100 OK NC 0.0475 20063 11/22/2019 4 Product 3 100 NE ND 0.05 20097 12/4/2019 9 Product 3 100 LA OH 0.05 75 20098 12/4/2019 4 Product 3 100 NE OK 0.045 12/5/2019 7 Product 3 100 AR OR 20137 12/18/2019 10 Product 3 100 KS PA 0.06 20155 12/23/2019 8 Product 3 100 KS RI 0.07 20103 12/25/2019 3 Product 3 100 TX SC 0.06 20200 1/7/2020 12 Product 3 100 TX SD 0.045 20217 1/12/2020 11 Product 3 100 TX TN 0.07 20233 1/16/2020 7 Product 3 100 KS TX 0.0625 20261 1/25/2020 6 Product 3 100 TN UT 0.0595 20285 2/1/2020 2 Product 3 100 OK 0.06 20308 2/11/2020 11 Product 3 100 AR VA 0.053 203 12 2/12/2020 4 Product 3 100 OK WA 0.065 203 25 2/15/2020 7 Product 3 100 KS wy 0.06 20368 2/29/2020 il Product 3 100 LA WI 0.05 20384 3/4/ 2020 10 Product 3 100 NE WY 0.04 20393 3/7/2020 9 Product 3 100 MO DC 0.057 20404 3/9/2020 1 Product 3 100 TX 20416 3/13/2020 2 Product 3 100 AR 20439 3/19/2020 1 Product 3 100 KS 20441 3/19/2020 10 Product 3 100 AR 20450 3/24/ 2020 9 Product 3 100 TX 20454 3/25/2020 1 Product 3 100 MO 20458 3/26/2020 11 Product 3 100 MO 20460 3/27/2020 6 Product 3 100 OK 20471 3/29/2020 6 Product 3 100 OK 20491 4/7/2020 3 Product 100 AR 20492 4/8/2020 10 Product 3 100 TN 4/17/2020 11 Product 3 100 AR 205 35 4/19/2020 6 6 Product 3 100 AR 20543 4/20/2020 3 Product 3 100 LA 20545 4/21/2020 1 Product 3 100 TX 20009 11/2/2019 3 Product 4 105 IA 20024 11/8/2019 1 Product 4 105 AR 20037 11/13/2019 3 Product 4 105 TX 20053 11/20/2019 2 Product 4 105 KS 20055 11/20/2019 11 Product 4 105 TX 20062 11/22/2019 12 Product 4 105 IA 20068 11/24/2019 9 Product 4 105 OK 20106 12/7/2019 1 Product 4 105 TX 20124 12/15/2019 11 Product 4 105 KS 20126 12/16/2019 6 Product 4 105 TX 20142 12/20/2019 9 Product 4 105 AR 20151 12/22/2019 8 Product 4 105 IA 20179 12/30/2019 6 Product 4 105 NE 20192 1/6/ 2020 12 Product 4 105 MO 20200 1/7/2020 10 Product 4 105 TX 20218 1/12/2020 4 4 Product 4 105 TX 20241 1/19/2020 2 Product 4 4 105 MO 20242 1/19/2020 3 Product 4 105 MO 20249 1/22/2020 8 Product 4 105 OK 20251 1/22/2020 11 Product 4 105 MO 20256 1/24/ 2020 5 Product 4 105 NE 20265 1/27/2020 1 Product 4 105 OK 20266 1/27/2020 5 Product 4 105 MO 20305 2/10/2020 6 Product 4 105 OK 20307 2/11/2020 9 Product 4 105 IA 20308 2/11/2020 8 Product 4 105 AR 203 10 2/11/2020 2 Product 4 105 TX 20314 2/13/2020 2 Product 4 105 TX 20383 3/4/ 2020 5 Product 4 105 IA 20403 3/9/2020 4 Product 4 105 AR 20407 3/10/2020 9 Product 4 105 TX 20424 3/16/2020 10 Product 4 105 OK 20452 3/25/2020 4 Product 4 105 MO 20461 3/27/2020 2 Product 4 105 TX 20465 3/28/2020 8 Product 4 105 KS 20494 4/8/2020 2 Product 4 105 TX 20496 4/8/2020 5 Product 4 105 IA 20503 4/10/2020 2 Product 4 105 AR 20537 4/19/2020 6 Product 4 105 TX 20539 4/19/2020 10 Product 4 105 OK 20559 4/25/2020 11 Product 4 105 AR 20012 11/4/2019 1 Product 85 TX 20023 11/8/2019 2 Product 5 85 OK 20037 11/13/2019 3 Product 5 85 TX 20043 11/16/2019 12 Product 5 85 TX 2009 11/22/2019 6 Product 5 85 AR 20086 11/30/2019 11 Product 5 85 KS 20089 12/1/2019 10 Products 85 OK 20120 12/12/2019 10 Product 5 85 IA 20126 12/16/2019 9 Product 5 85 TX 20168 12/27/2019 8 Product 5 85 IA 20199 1/7/2020 8 Products 85 NE 20202 1/8/2020 7 Product 5 85 KS 20211 1/10/2020 12 Product 5 85 MO 20250 1/22/2020 5 Products 85 MO 20253 1/22/2020 10 Product 5 85 MO 1/26/2020 12 Product 5 85 TX 20271 1/28/2020 11 Products 85 AR 20291 7 2/4/2020 7 Product 5 85 NE 20305 2/10/2020 3 Product 5 85 OK 20307 2/11/2020 9 Product 5 85 IA 203 38 2/22/2020 6 Product 5 85 MO 20357 2/27/2020 8 Product 5 85 AR 20406 3/10/2020 4 Product 5 85 OK 20494 4/8/2020 6 Product 5 85 TX 20495 4/8/2020 4 Product 5 85 NE 20503 4/10/2020 6 Product 5 85 AR 20003 11/1/2019 8 Product 6 90 MO 20005 11/1/2019 9 Producto 90 TN 2013 12/19/2019 4 Product 6 90 KS 20161 12/25/2019 12 Product 6 90 TX 20211 1/10/2020 12 Product 6 90 MO 20277 1/29/2020 1 Product 6 90 OK 202 20 1/30/2020 4 Product 6 90 AR 20283 1/31/2020 4 Product 6 90 NE 203 28 2/17/2020 11 Product 6 90 NE 20375 3/2/2020 11 Product 6 90 KS 20404 3/9/2020 3 Product 6 90 TX 20407 3/10/2020 12 Product 6 90 TX 20418 3/14/2020 12 Product 3 90 LA 20438 3/18/2020 4 Product 6 90 OK 20451 3/24/2020 9 Product 6 90 NE 20453 3/25/2020 3 Product 6 90 NE 20262