ACC 4230
Spring 2023
IDEA Assignment #3 Requirements
You must complete the requirements listed below and submit this assignment via the Pilot Dropbox by the beginning of class on Thursday, April 13. Also, the text of your paper should be double-spaced. Failure to follow appropriate formatting will be reflected in your grade for the assignment. Failure to submit the case when specified will result in a substantial point reduction as the penalty for late submission. Also, the assignment submitted must be each student’s own work, collaboration among students in completing this assignment is not permitted.
Requirements:
Part 1
Import the data file “4230 sp23 IDEA shipping” from Pilot into IDEA. In discussions with the Order Fulfillment and Shipping departments at your client, you learn that it is common for a partial or “split” shipment to go out because of an insufficient quantity of items in stock to fulfill the customer order. However, controls should prohibit shipping a higher quantity than was ordered. Using the Shipping file, determine how many records contain a quantity shipped that exceeds the quantity ordered and include a screenshot of your IDEA results to support your answer.
(Hint: Under the “Data” menu, use the “Add” command to add a new field to the table. When adding the new field, use the “Equation Editor” to complete the “Parameter” for the new field to identify the records with a conditional (@If) expression.)
Part 2
In a
ief paragraph, explain why an auditor would consider performing the procedure in Part 1 above.
Updated: 13-Oct-20
1 | P a g e
Table of Contents
Apple OSX Installation Instructions for Windows 10 ............................................... XXXXXXXXXX1
IDEA Installation Instructions – Windows OS .............................................................. XXXXXXXXXX2
MS Office 64-bit Upgrade ......................................................................................... XXXXXXXXXX5
IDEA 11.2 EDU Software Link with v11 Workbook, Data Sets and Additional Resources
https:
academicportal.casewareanalytics.com/ Students will require an invitation from their professor to join the
IDEA Academic Portal.
Please follow the directions on Pg. 2 for IDEA installation instructions – Windows OS.
IDEA 11.2 Installation for Apple OSX
For students with Apple computers, it is up to you to obtain a copy of Windows and integrate it. The emulator
is the co
ect way to do this, unless you partition and install Windows directly.
Step 1- Download an emulator.
Virtual Box (https:
www.virtualbox.org). Proceed to the Downloads page located on left-side of page.
Download the OSX (amd64) version. Open VirtualBox. Use the 2nd link below to install.
Step 2- Download Windows 10.
https:
www.microsoft.com/en-us/evalcente
evaluate-windows-10-enterprise Select Products, Windows
Evaluations, Windows 10 Enterprise Eval x64 Eval en-us
You will need a Microsoft login account. Please use your own or create one.
Step 3- Install Windows.
Follow these step by step directions to complete the installation:
http:
osxdaily.com/2015/03/25/install-run-windows-10-mac-virtualbox-os-x
Step 4- Log in to Windows and Install IDEA software using the instructions below.
https:
academicportal.casewareanalytics.com
http:
www.microsoft.com/en-us/evalcente
evaluate-windows-10-enterprise
http:
www.microsoft.com/en-us/evalcente
evaluate-windows-10-enterprise
http:
osxdaily.com/2015/03/25/install-run-windows-10-mac-virtualbox-os-x
Updated: 13-Oct-20
2 | P a g e
IDEA 11.2 Installation for Windows XXXXXXXXXXBit or Higher:
Installing the IDEA Version Eleven Educational
Demo Welcome to IDEA Data Analysis
Software!
Prior to installing this version of IDEA, you will need to uninstall any prior version. You must be signed on as an
Administrator to install the software.
We have changed the manner of distributing the educational software effective Fall 2019. Professors must create an account
at https:
academicportal.casewareanalytics.com/ & “invite” their students to their courses. If you follow the steps one by
one the license key should be automatically populated.
1. Download IDEA Version Eleven Educational Edition into your PC here:
https:
academicportal.casewareanalytics.com/ XXXXXXXXXXMB)
• IDEA 11.x EDU is *only* compatible with 64-bit Windows & Windows Server OS
• A minimum of 8GB RAM is required to run Visualizations
• MS Office 64-Bit is required to run MS Access imports and exports (see page 5)
• Exceptional Exceptions (available on Passport) requires 64-Bit Office & Power BI Desktop (free Microsoft Store)
2. After saving to your PC, Double-click IDEA_11_2_EN_EDU-ASCII.exe to run. You may be prompted, click install anyway.
• This will start the file extraction process.
• Enter a destination folder and click EXTRACT
https:
academicportal.casewareanalytics.com
https:
academicportal.casewareanalytics.com
Updated: 13-Oct-20
3 | P a g e
• When the extraction completes,
owse to open folder containing the installation files.
3. Right-click Setup.exe and select "Run as Administrator".
• This will start the Install Shield Wizard and the installation process will begin.
• Respond to various prompts, read and accept the license terms, then click Next and Install.
• To complete the installation, click Finish.
EDU License will auto activate and can be checked by opening the new CaseWare IDEA License Manager from your desktop
menu.
On completion of the install you should be able to find IDEA on your Windows Start Menu.
Updated: 13-Oct-20
4 | P a g e
NOTE:
• CaseWare CloudShare – is not activated for the Educational License.
• CaseWare Passport – you will need to create an account the first time you access (via IDEA 11) - suggest you use a
personal email account, not your school account.
• IDEA Labs – you do not require a logon.
If you have any questions or issues installing or using IDEA, p lease contact the IDEA Help
Desk at: XXXXXXXXXX, or call XXXXXXXXXXOption 4
Audimation Help Desk Support Hours: 7:00 AM – 7:00 PM (Central) Monday – Friday, excluding holidays
Please include your contact info, version of IDEA, name of school and instructor in any communication.
IDEA is not designed for Apple/Mac operating systems. Our help desk may only assist you with installing IDEA on a
Windows platform. Please see page 1 if installing on an Apple/Mac computer.
IDEA is a registered trademark of CaseWare International Inc.
mailto: XXXXXXXXXX
Updated: 13-Oct-20
5 | P a g e
MS Office 64-bit Upgrade
You can confirm which version of office you have by:
Open Access and click on the File Tab. Then click on Account and then click on the About Access button
This will open up a window that will show whether you have Office 64-bit or 32-bit installed on your machine.
You will want to install Office 64 bit to import Access files. Uninstall Office 32 bit and install Office 64 bit:
1) Uninstall Office from your machine:
a. Instructions for how to uninstall office: https:
support.office.com/en-us/article/uninstall-office-from-a-pc-
9dd49b83-264a-477a-8fcc-2fdf5dbf61d8
2) Go to https:
www.office.com/
a. Please login in with your Microsoft account if you are not already.
3) Click on the Install Office button
a. Select Other Install Options
4) Once you a
ived to the new page, you want to click on View apps & Devices
https:
support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8
https:
support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8
https:
www.office.com
Updated: 13-Oct-20
6 | P a g e
5) Make sure you have 64-bit selected from the drop down before you hit install Office.
a. Please note that this screen may vary. If you have additional products they will be listed here.
6) Save the installer and run it. You will need administrator rights to do this.
7) Follow the on screen prompt for the installer.
a. For more instructions go here: https:
support.office.com/en-us/article/download-and-install-or-reinstall-
microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-
23adc4716658#installsteps=pc_step-by-step
https:
support.office.com/en-us/article/download-and-install-or-reinstall-microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658#installsteps=pc_step-by-step
https:
support.office.com/en-us/article/download-and-install-or-reinstall-microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658#installsteps=pc_step-by-step
https:
support.office.com/en-us/article/download-and-install-or-reinstall-microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658#installsteps=pc_step-by-step
4230 f22 IDEA shipping
ORDER_NO ORDER_DATE CUSTOMER_NO PRODUCT_NUMBER ORDER_QUANTITY SALES_PRICE SHIP_DATE SHIP_QUANTITY INVOICE_NO INVOICE_DATE SUBTOTAL TAX INVOICE_TOTAL DUE_DATE
37688 3/8/21 100214 XXXXXXXXXX 30 22.97 3/18/21 30 566041 3/18/21 689.10 56.85 745.95 4/17/21
37689 4/2/21 100140 XXXXXXXXXX 38 140.72 4/12/21 36 566042 4/12/21 5065.92 417.94 5483.86 5/12/21
37690 4/5/21 100224 XXXXXXXXXX 87 6.35 4/15/21 87 566043 4/15/21 552.45 45.58 598.03 5/15/21
37691 5/3/21 100187 XXXXXXXXXX 14 30.05 5/13/21 14 566044 5/13/21 420.70 34.71 455.41 6/12/21
37692 5/9/21 100293 XXXXXXXXXX 21 31.77 5/19/21 21 566045 5/19/21 667.17 55.04 722.21 6/18/21
37693 11/27/21 100180 XXXXXXXXXX 40 1.75 12/7/21 40 566046 12/7/21 70.00 5.78 75.78 1/6/22
37694 11/29/21 100269 XXXXXXXXXX 16 17.68 12/9/21 16 566048 12/9/21 282.88 23.34 306.22 1/8/22
37695 11/29/21 100133 XXXXXXXXXX 48 8.50 12/9/21 48 566047 12/9/21 408.00 33.66 441.66 1/8/22
37696 11/30/21 100252 XXXXXXXXXX 1 530.98 12/10/21 23 566050 12/10/21 XXXXXXXXXX 1007.53 XXXXXXXXXX 1/9/22
37697 11/30/21 100316 XXXXXXXXXX 73 19.38 12/10/21 73 566049 12/10/21 1414.74 116.72 1531.46 1/9/22
37698 12/1/21 100170 XXXXXXXXXX 49 23.90 12/11/21 49 566051 12/11/21 1171.10 96.62 1267.72 1/10/22
37699 1/9/22 100109 XXXXXXXXXX 80 31.82 1/19/22 80 566052 1/19/22 2545.60 210.01 2755.61 2/18/22
37700 1/12/22 100232 XXXXXXXXXX 96 30.05 1/22/22 96 566053 1/22/22 2884.80 238.00 3122.80 2/21/22
37701 1/25/22 100184 XXXXXXXXXX 25 9.01 2/4/22 25 566054 2/4/22 225.25 18.99 244.24 3/6/22
37702 2/1/22 100139 XXXXXXXXXX 2 460.18 2/11/22 1 566055 2/11/22 460.18 37.96 498.14 3/12/22
37703 2/1/22 100235 XXXXXXXXXX 77 24.76 2/11/22 77 566056 2/11/22 1906.52 157.29 2063.81 3/12/22
37704 2/4/22 100182 XXXXXXXXXX 77 17.68 2/14/22 77 566057 2/14/22 1361.36 112.31 1473.67 3/15/22
37705 2/5/22 100276 XXXXXXXXXX 27 24.69 2/15/22 27 566058 2/15/22 666.63 55.00 721.63 3/16/22
37706 2/8/22 100167 XXXXXXXXXX 22 17.68 2/18/22 22 566059 2/18/22 388.96 32.09 421.05 3/19/22
37707 3/1/22 100144 XXXXXXXXXX 10 141.56 3/11/22 10 566060 3/11/22 1415.60 116.79 1532.39 4/10/22
37708 3/2/22 100251 XXXXXXXXXX 77 0.16 3/12/22 77 566061 3/12/22 12.32 1.02 13.34 4/11/22
37709 3/2/22 100198 XXXXXXXXXX 93 24.74 3/12/22 93 566062 3/12/22 2300.82 189.82 2490.64 4/11/22
37710 3/3/22 100170 XXXXXXXXXX 54 19.43 3/13/22 54 566064 3/13/22 1049.22 86.56 1135.78 4/12/22
37711 3/3/22 100300 XXXXXXXXXX 48 26.51 3/13/22 48 566063 3/13/22 1272.48 104.98 1377.46 4/12/22
37712 3/4/22 100233 XXXXXXXXXX 96 4.41 3/14/22 96 566065 3/14/22 423.36 34.93 458.29 4/13/22
37713 3/4/22 100298 XXXXXXXXXX 40 159.26 3/14/22 40 566067 3/14/22 6370.40 525.56 6895.96 4/13/22
37714 3/4/22 100330 XXXXXXXXXX 51 12.37 3/14/22 51 566066 3/14/22 630.87 52.05 682.92 4/13/22
37715 3/5/22 100255 XXXXXXXXXX 65 19.43 3/15/22 65 566070 3/15/22 1262.95 104.19 1367.14 4/14/22
37716 3/5/22 100105 XXXXXXXXXX 100 7.06 3/15/22 100 566068 3/15/22 706.00 58.24 764.25 4/14/22
37717 3/5/22 100127 XXXXXXXXXX 80 19.43 3/15/22 80 566069 3/15/22 1554.40 128.24 1682.64 4/14/22
37718 3/5/22 100128 XXXXXXXXXX 83 8.83 3/15/22 83 566071 3/15/22 732.89 60.46 793.35 4/14/22
37719 3/6/22 100245 XXXXXXXXXX 43 159.26 3/16/22 43 566072 3/16/22 6848.18 564.97 7413.15 4/15/22
37720 3/6/22 100195 XXXXXXXXXX 4 70.76 3/16/22 4 566074 3/16/22 283.04 23.35 306.39 4/15/22
37721 3/6/22 100233 XXXXXXXXXX 14 45.98 3/16/22 14 566073 3/16/22 643.72 53.11 696.83 4/15/22
37722 3/7/22 100240 XXXXXXXXXX 85 7.04 3/17/22 85 566075 3/17/22 598.40 49.37 647.77 4/16/22
37723 3/7/22 100235 XXXXXXXXXX 23 22.99 3/17/22 23 566077 3/17/22 528.77 43.62 572.39 4/16/22
37724 3/7/22 100250 XXXXXXXXXX 76 17.15 3/17/22 76 566076 3/17/22 1303.40 107.53 1410.93 4/16/22
37725 3/8/22 100243 XXXXXXXXXX 6 4.58 3/18/22 6 566079 3/18/22 27.48 2.27 29.75 4/17/22
37726 3/8/22 100130 XXXXXXXXXX 35 70.76 3/18/22 35 566080 3/18/22 2476.60 204.32 2680.92 4/17/22
37727 3/8/22 100144 XXXXXXXXXX 59 24.76 3/18/22 59 566078 3/18/22 1460.84 120.52 1581.36 4/17/22
37728 3/8/22 100144 XXXXXXXXXX 97 14.14 3/18/22 97 566081 3/18/22 1371.58 113.16 1484.74 4/17/22
37729 3/9/22 100286 XXXXXXXXXX 98 242.47 3/19/22 98 566086 3/19/22 XXXXXXXXXX 1960.37 XXXXXXXXXX 4/18/22
37730 3/9/22 100226 XXXXXXXXXX 47 17.68 3/19/22 47 566083 3/19/22 830.96 68.55 899.51 4/18/22
37731 3/9/22 100143 XXXXXXXXXX 65 115.01 3/19/22 65 566084 3/19/22 7475.65 616.74 8092.39 4/18/22
37732 3/9/22 100190 XXXXXXXXXX 83 6.71 3/19/22 83 566085 3/19/22 556.93 45.95 602.88 4/18/22
37733 3/9/22 100123 XXXXXXXXXX 67 19.45 3/19/22 67 566082 3/19/22 1303.15 107.51 1410.66 4/18/22
37734 3/10/22 100154 XXXXXXXXXX 65 8.50 3/20/22 65 566089 3/20/22 552.50 45.58 598.08 4/19/22
37735 3/10/22 100307 XXXXXXXXXX 44 45.98 3/20/22 44 566088 3/20/22 2023.12 166.91 2190.03 4/19/22
37736 3/10/22 100344 XXXXXXXXXX 63 10.25 3/20/22 63 566087 3/20/22 645.75 53.27 699.02 4/19/22
37737 3/11/22 100249 XXXXXXXXXX 95 0.07 3/21/22 95 566090 3/21/22 6.65 0.55 7.20 4/20/22
37738 3/11/22 100225 XXXXXXXXXX 81 28.30 3/21/22 81 566091 3/21/22 2292.30 189.11 2481.41 4/20/22
37739 3/11/22 100289 XXXXXXXXXX 7 38.90 3/21/22 7 566092 3/21/22 272.30 22.46 294.76 4/20/22
37740 3/12/22 100140 XXXXXXXXXX 83 35.36 3/22/22 83 566096 3/22/22 2934.88 242.13 3177.01 4/21/22
37741 3/12/22 100140 XXXXXXXXXX 56 132.71 3/22/22 56 566094 3/22/22 7431.76 613.12 8044.88 4/21/22
37742 3/12/22 100122 XXXXXXXXXX 82 35.38 3/22/22 82 566093 3/22/22 2901.16 239.35 3140.51 4/21/22
37743 3/12/22 100182 XXXXXXXXXX 17 88.50 3/22/22 17 566095 3/22/22 1504.50 124.12 1628.62 4/21/22
37744 3/13/22 100274 XXXXXXXXXX 19 97.33 3/23/22 19 566099 3/23/22 1849.27 152.56 2001.83 4/22/22
37745 3/13/22 100329 XXXXXXXXXX 96 33.59 3/23/22 96 566098 3/23/22 3224.64 266.03 3490.67 4/22/22
37746 3/13/22 100260 XXXXXXXXXX 99 30.05 3/23/22 99 566097 3/23/22 2974.95 245.43 3220.38 4/22/22
37747 3/14/22 100216 XXXXXXXXXX 5 242.47 3/24/22 95 566102 3/24/22 XXXXXXXXXX 1900.36 XXXXXXXXXX 4/23/22
37748 3/14/22 100140 XXXXXXXXXX 67 884.96 3/24/22 67 566101 3/24/22 XXXXXXXXXX 4891.62 XXXXXXXXXX 4/23/22
37749 3/14/22 100231 XXXXXXXXXX 83 7.06 3/24/22 83 566100 3/24/22 585.98 48.34 634.32 4/23/22
37750 3/15/22 100111 XXXXXXXXXX 95 35.36 3/25/22 95 566103 3/25/22 3359.20 277.13 3636.33 4/24/22
37751 3/15/22 100254 XXXXXXXXXX 74 22.99 3/25/22 74 566104 3/25/22 1701.26 140.35 1841.61 4/24/22
37752 3/16/22 100136 XXXXXXXXXX 63 84.92 3/26/22 63 566105 3/26/22 5349.96 441.37 5791.33 4/25/22
37753 3/16/22 100274 XXXXXXXXXX 61 22.99 3/26/22 61 566106 3/26/22 1402.39 115.70 1518.09 4/25/22
37754 3/17/22 100272 XXXXXXXXXX 20 92.00 3/27/22 20 566108 3/27/22 1840.00 151.80 1991.80 4/26/22
37755 3/17/22 100288 XXXXXXXXXX 68 8.83 3/27/22 68 566107 3/27/22 600.44 49.54 649.98 4/26/22
37756 3/18/22 100186 XXXXXXXXXX 28 17.70 3/28/22 28 566109 3/28/22 495.60 40.89 536.49 4/27/22
37757 3/18/22 100181 XXXXXXXXXX 30 17.68 3/28/22 30 566110 3/28/22 530.40 43.76 574.16 4/27/22
37758 3/19/22 100302 XXXXXXXXXX 13 21.24 3/29/22 10 566112 3/29/22 212.40 17.52 229.92 4/28/22
37759 3/19/22 100129 XXXXXXXXXX 38 17.68 3/29/22 38 566111 3/29/22 671.84 55.43 727.27 4/28/22
37760 3/20/22 100208 XXXXXXXXXX 48 17.68 3/30/22 48 566113 3/30/22 848.64 70.01 918.65 4/29/22
37761 3/21/22 100174 XXXXXXXXXX 75 17.68 3/31/22 75 566114 3/31/22 1326.00 109.40 1435.40 4/30/22
37762 3/22/22 100232 XXXXXXXXXX 40 17.68 4/1/22 40 566115 4/1/22 707.20 58.34 765.54 5/1/22
37763 3/23/22 100113 XXXXXXXXXX 41 17.68 4/2/22 41 566116 4/2/22 724.88 59.80 784.68 5/2/22
37764 3/24/22 100255 XXXXXXXXXX 35 0.51 4/3/22 35 566117 4/3/22 17.85 1.47 19.32 5/3/22
37765 3/25/22 100225 XXXXXXXXXX 42 0.89 4/4/22 42 566118 4/4/22 37.38 3.08 40.46 5/4/22
37766 3/26/22 100137 XXXXXXXXXX 36 42.44 4/5/22 36 566119 4/5/22 1527.84 126.05 1653.89 5/5/22
37767 3/27/22 100188 XXXXXXXXXX 42 15.91 4/6/22 42 566120 4/6/22 668.22 55.13 723.35 5/6/22
37768 3/28/22 100222 XXXXXXXXXX 28 0.78 4/7/22 28 566121 4/7/22 21.84 1.80 23.64 5/7/22
37769 3/29/22 100213 XXXXXXXXXX 48 5.29 4/8/22 48 566122 4/8/22 253.92 20.95 274.87 5/8/22
37770 3/30/22 100167 XXXXXXXXXX 82 10.07 4/9/22 82 566124 4/9/22 825.74 68.12 893.86 5/9/22
37771 3/30/22 100287 XXXXXXXXXX 3 5.52 4/9/22 3 566123 4/9/22 16.56 1.37 17.93 5/9/22
37772 3/31/22 100283 XXXXXXXXXX 77 10.60 4/10/22 77 566125 4/10/22 816.20 67.34 883.54 5/10/22
37773 4/1/22 100123 XXXXXXXXXX 7 5.35 4/11/22 7 566126 4/11/22 37.45 3.09 40.54 5/11/22
37774 4/2/22 100139 XXXXXXXXXX 1 5.52 4/12/22 1 566127 4/12/22 5.52 0.46 5.98 5/12/22
37775 4/3/22 100321 XXXXXXXXXX 14 4.94 4/13/22 14 566128 4/13/22 69.16 5.71 74.87 5/13/22
37776 4/4/22 100249 XXXXXXXXXX 87 0.87 4/14/22 87 566129 4/14/22 75.69 6.24 81.93 5/14/22
37777 4/5/22 100308 XXXXXXXXXX 67 0.69 4/15/22 67 566130 4/15/22 46.23 3.81 50.04 5/15/22
37778 4/5/22 100202 XXXXXXXXXX 0 88.50 4/15/22 0 566132 4/15/22 0.00 0.00 0.00 5/15/22
37779 4/5/22 100221 XXXXXXXXXX 94 2.99 4/15/22 94 566131 4/15/22 281.06 23.19 304.25 5/15/22
37780 4/6/22 100244 XXXXXXXXXX 87 92.00 4/16/22 87 566133 4/16/22 8004.00 660.33 8664.33 5/16/22
37781 4/7/22 100181 XXXXXXXXXX 83 83.15 4/17/22 83 566134 4/17/22 6901.45 569.37 7470.82 5/17/22
37782 4/8/22 100152 XXXXXXXXXX 31 6.71 4/18/22 31 566135 4/18/22 208.01 17.16 225.17 5/18/22
37783 4/8/22 100140 XXXXXXXXXX 66 104.39 4/18/22 66 566136 4/18/22 6889.74 568.40 7458.14 5/18/22
37784 4/9/22 100105 XXXXXXXXXX 54 26.51 4/19/22 54 566138 4/19/22 1431.54 118.10 1549.64 5/19/22
37785 4/9/22 100328 XXXXXXXXXX 67 5.52 4/19/22 67 566139 4/19/22 369.84 30.51 400.35 5/19/22
37786 4/9/22 100143 XXXXXXXXXX 10 40.67 4/19/22 10 566137 4/19/22 406.70 33.55 440.25 5/19/22
37787 4/10/22 100307 XXXXXXXXXX 22 15.89 4/20/22 22 566140 4/20/22 349.58 28.84 378.42 5/20/22
37788 4/11/22 100115 XXXXXXXXXX 47 17.68 4/21/22 47 566141 4/21/22 830.96 68.55 899.51 5/21/22
37789 4/12/22 100134 XXXXXXXXXX 91 32.73 4/22/22 91 566142 4/22/22 2978.43 245.72 3224.15 5/22/22
37790 4/12/22 100103 XXXXXXXXXX 35 14.12 4/22/22 35 566143 4/22/22 494.20 40.77 534.97 5/22/22
37791 4/13/22 100106 XXXXXXXXXX 16 6.18 4/23/22 16 566144 4/23/22 98.88 8.16 107.04 5/23/22
37792 4/13/22 100322 XXXXXXXXXX 47 58.37 4/23/22 47 566145 4/23/22 2743.39 226.33 2969.72 5/23/22
37793 4/14/22 100242 XXXXXXXXXX 30 45.98 4/24/22 30 566148 4/24/22 1379.40 113.80 1493.20 5/24/22
37794 4/14/22 100345 XXXXXXXXXX 43 79.46 4/24/22 43 566147 4/24/22 3416.78 281.88 3698.66 5/24/22
37795 4/14/22 100106 XXXXXXXXXX 30 26.46 4/24/22 30 566146 4/24/22 793.80 65.49 859.29 5/24/22
37796 4/15/22 100238 XXXXXXXXXX 46 106.16 4/25/22 46 566149 4/25/22 4883.36 402.88 5286.24 5/25/22
37797 4/15/22 100140 XXXXXXXXXX 71 58.32 4/25/22 71 566150 4/25/22 4140.72 341.61 4482.33 5/25/22
37798 4/16/22 100282 XXXXXXXXXX 77 13.79 4/26/22 77 566152 4/26/22 1061.83 87.60 1149.43 5/26/22
37799 4/16/22 100303 XXXXXXXXXX 94 12.35 4/26/22 94 566151 4/26/22 1160.90 95.77 1256.67 5/26/22
37800 4/17/22 100210 XXXXXXXXXX 89 12.35 4/27/22 89 566153 4/27/22 1099.15 90.68 1189.83 5/27/22
37801 4/17/22 100286 XXXXXXXXXX 30 26.51 4/27/22 30 566154 4/27/22 795.30 65.61 860.91 5/27/22
37802 4/18/22 100114 XXXXXXXXXX 60 97.26 4/28/22 60 566156 4/28/22 5835.60 481.44 6317.04 5/28/22
37803 4/18/22 100338 XXXXXXXXXX 89 141.56 4/28/22 89 566155 4/28/22 XXXXXXXXXX 1039.40 XXXXXXXXXX 5/28/22
37804 4/19/22 100311 XXXXXXXXXX 67 30.05 4/29/22 67 566157 4/29/22 2013.35 166.10 2179.45 5/29/22
37805 4/19/22 100235 XXXXXXXXXX 17 24.74 4/29/22 17 566158 4/29/22 420.58 34.70 455.28 5/29/22
37806 4/20/22 100240 XXXXXXXXXX 5 19.43 4/30/22 5 566160 4/30/22 97.15 8.01 105.16 5/30/22
37807 4/20/22 100256 XXXXXXXXXX 93 22.97 4/30/22 93 566159 4/30/22 2136.21 176.24 2312.45 5/30/22
37808 4/21/22 100334 XXXXXXXXXX 99 8.30 5/1/22 99 566161 5/1/22 821.70 67.79 889.49 5/31/22
37809 4/21/22 100317 XXXXXXXXXX 34 12.37 5/1/22 34 566162 5/1/22 420.58 34.70 455.28 5/31/22
37810 4/22/22 100340 XXXXXXXXXX 97 19.43 5/2/22 97 566164 5/2/22 1884.71 155.49 2040.20 6/1/22
37811 4/22/22 100341 XXXXXXXXXX 22 30.05 5/2/22 22 566163 5/2/22 661.10 54.54 715.64 6/1/22
37812 4/23/22 100140 XXXXXXXXXX 32 159.26 5/3/22 32 566166 5/3/22 5096.32 420.45 5516.77 6/2/22
37813 4/23/22 100330 XXXXXXXXXX 71 2.99 5/3/22 71 566165 5/3/22 212.29 17.51 229.80 6/2/22
37814 4/24/22 100312 XXXXXXXXXX 74 4.58 5/4/22 74 566167 5/4/22 338.92 27.96 366.88 6/3/22
37815 4/24/22 100146 XXXXXXXXXX 26 17.15 5/4/22 30 566168 5/4/22 514.50 42.45 556.95 6/3/22
37816 4/25/22 100204 XXXXXXXXXX 6 70.76 5/5/22 6 566170 5/5/22 424.56 35.03 459.59 6/4/22
37817 4/25/22 100324 XXXXXXXXXX 60 4.05 5/5/22 60 566169 5/5/22 243.00 20.05 263.05 6/4/22
37818 4/26/22 100127 XXXXXXXXXX 76 8.30 5/6/22 76 566171 5/6/22 630.80 52.04 682.84 6/5/22
37819 4/27/22 100120 XXXXXXXXXX 46 26.51 5/7/22 46 566172 5/7/22 1219.46 100.61 1320.07 6/6/22
37820 4/28/22 100163 XXXXXXXXXX 82 28.28 5/8/22 82 566173 5/8/22 2318.96 191.31 2510.27 6/7/22
37821 5/4/22 100119 XXXXXXXXXX 23 11.49 5/14/22 23 566174 5/14/22 264.27 21.80 286.07 6/13/22
37822 5/4/22 100311 XXXXXXXXXX 67 141.56 5/14/22 67 566175 5/14/22 9484.52 782.47 XXXXXXXXXX 6/13/22
37823 5/5/22 100244 XXXXXXXXXX 9 6.55 5/15/22 9 566177 5/15/22 58.95 4.86 63.81 6/14/22
37824 5/5/22 100160 XXXXXXXXXX 94 0.51 5/15/22 94 566176 5/15/22 47.94 3.96 51.90 6/14/22
37825 5/6/22 100244 XXXXXXXXXX 16 0.89 5/16/22 16 566178 5/16/22 14.24 1.17 15.41 6/15/22
37826 5/6/22 100176 XXXXXXXXXX 51 2.11 5/16/22 51 566179 5/16/22 107.61 8.88 116.49 6/15/22
37827 5/7/22 100319 XXXXXXXXXX 24 30.05 5/17/22 24 566180 5/17/22 721.20 59.50 780.70 6/16/22
37828 5/7/22 100254 XXXXXXXXXX 41 42.44 5/17/22 41 566181 5/17/22 1740.04 143.55 1883.59 6/16/22
37829 5/7/22 100144 XXXXXXXXXX 65 5.22 5/17/22 65 566182 5/17/22 339.30 27.99 367.29 6/16/22
37830 5/8/22 100108 XXXXXXXXXX 79 15.91 5/18/22 79 566184 5/18/22 1256.89 103.69 1360.58 6/17/22
37831 5/8/22 100172 XXXXXXXXXX 68 6.81 5/18/22 68 566183 5/18/22 463.08 38.20 501.28 6/17/22
37832 5/9/22 100226 XXXXXXXXXX 40 0.78 5/19/22 40 566185 5/19/22 31.20 2.57 33.77 6/18/22
37833 5/10/22 100200 XXXXXXXXXX 70 5.29 5/20/22 70 566186 5/20/22 370.30 30.55 400.85 6/19/22
37834 5/11/22 100110 XXXXXXXXXX 97 5.52 5/21/22 97 566188 5/21/22 535.44 44.17 579.61 6/20/22
37835 5/11/22 100122 XXXXXXXXXX 31 30.05 5/21/22 31 566187 5/21/22 931.55 63.89 995.44 6/20/22