Minimum of 600 words required, need to use IDEA Software for this assignment,
My user id for IDEA software is
[email protected] and password is Good4education. I have attached more assignment requirements
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 brief 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 ...................................................................1 IDEA Installation Instructions – Windows OS ..................................................................................2 MS Office 64-bit Upgrade .............................................................................................................5 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 correct 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/evalcenter/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/evalcenter/evaluate-windows-10-enterprise http://www.microsoft.com/en-us/evalcenter/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 8.1 64-Bit 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/ (756.7 MB) • 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, browse 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:
[email protected], or call 888.641.2800 Option 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:
[email protected] 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 arrived 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_NOORDER_DATECUSTOMER_NOPRODUCT_NUMBERORDER_QUANTITYSALES_PRICESHIP_DATESHIP_QUANTITYINVOICE_NOINVOICE_DATESUBTOTALTAXINVOICE_TOTALDUE_DATE 376883/8/21100214366670453022.973/18/21305660413/18/21689.1056.85745.954/17/21 376894/2/211001401089980138140.724/12/21365660424/12/215065.92417.945483.865/12/21 376904/5/2110022412863679876.354/15/21875660434/15/21552.4545.58598.035/15/21 376915/3/21100187366665131430.055/13/21145660445/13/21420.7034.71455.416/12/21 376925/9/21100293291714212131.775/19/21215660455/19/21667.1755.04722.216/18/21 3769311/27/2110018010891211401.7512/7/214056604612/7/2170.005.7875.781/6/22 3769411/29/21100269109517081617.6812/9/211656604812/9/21282.8823.34306.221/8/22 3769511/29/2110013329007381488.5012/9/214856604712/9/21408.0033.66441.661/8/22 3769611/30/21100252109606731530.9812/10/212356605012/10/2112212.541007.5313220.071/9/22 3769711/30/21100316291613787319.3812/10/217356604912/10/211414.74116.721531.461/9/22 3769812/1/21100170291662184923.9012/11/214956605112/11/211171.1096.621267.721/10/22 376991/9/22100109109710238031.821/19/22805660521/19/222545.60210.012755.612/18/22 377001/12/22100232109514459630.051/22/22965660531/22/222884.80238.003122.802/21/22 377011/25/2210018421794781259.012/4/22255660542/4/22225.2518.99244.243/6/22 377022/1/22100139109608242460.182/11/2215660552/11/22460.1837.96498.143/12/22 377032/1/22100235122440387724.762/11/22775660562/11/221906.52157.292063.813/12/22 377042/4/22100182109506277717.682/14/22775660572/14/221361.36112.311473.673/15/22 377052/5/22100276292010662724.692/15/22275660582/15/22666.6355.00721.633/16/22 377062/8/22100167109514502217.682/18/22225660592/18/22388.9632.09421.053/19/22 377073/1/221001444866629010141.563/11/22105660603/11/221415.60116.791532.394/10/22 377083/2/2210025163174759770.163/12/22775660613/12/2212.321.0213.344/11/22 377093/2/22100198486722319324.743/12/22935660623/12/222300.82189.822490.644/11/22 377103/3/22100170486722675419.433/13/22545660643/13/221049.2286.561135.784/12/22 377113/3/22100300414485544826.513/13/22485660633/13/221272.48104.981377.464/12/22 377123/4/2210023310950991964.413/14/22965660653/14/22423.3634.93458.294/13/22 377133/4/221002984868095540159.263/14/22405660673/14/226370.40525.566895.964/13/22 377143/4/22100330486733805112.373/14/22515660663/14/22630.8752.05682.924/13/22 377153/5/22100255486735256519.433/15/22655660703/15/221262.95104.191367.144/14/22 377163/5/22100105122626481007.063/15/221005660683/15/22706.0058.24764.254/14/22 377173/5/22100127486735258019.433/15/22805660693/15/221554.40128.241682.644/14/22 377183/5/2210012810951491838.833/15/22835660713/15/22732.8960.46793.354/14/22 377193/6/221002454868095543159.263/16/22435660723/16/226848.18564.977413.154/15/22 377203/6/2210019512263423470.763/16/2245660743/16/22283.0423.35306.394/15/22 377213/6/22100233368012821445.983/16/22145660733/16/22643.7253.11696.834/15/22 377223/7/2210024011348398857.043/17/22855660753/17/22598.4049.37647.774/16/22 377233/7/22100235122877322322.993/17/22235660773/17/22528.7743.62572.394/16/22 377243/7/22100250486907447617.153/17/22765660763/17/221303.40107.531410.934/16/22 377253/8/221002433668923664.583/18/2265660793/18/2227.482.2729.754/17/22 377263/8/22100130486912033570.763/18/22355660803/18/222476.60204.322680.924/17/22 377273/8/22100144122877445924.763/18/22595660783/18/221460.84120.521581.364/17/22 377283/8/22100144122242799714.143/18/22975660813/18/221371.58113.161484.744/17/22 377293/9/221002867286265098242.473/19/22985660863/19/2223762.061960.3725722.434/18/22 377303/9/22100226486914704717.683/19/22475660833/19/22830.9668.55899.514/18/22 377313/9/221001431222443665115.013/19/22655660843/19/227475.65616.748092.394/18/22 377323/9/2210019063506166836.713/19/22835660853/19/22556.9345.95602.884/18/22 377333/9/22100123122877566719.453/19/22675660823/19/221303.15107.511410.664/18/22 377343/10/2210015463529846658.503/20/22655660893/20/22552.5045.58598.084/19/22 377353/10/22100307486919904445.983/20/22445660883/20/222023.12166.912190.034/19/22 377363/10/22100344123507366310.253/20/22635660873/20/22645.7553.27699.024/19/22 377373/11/2210024963561488950.073/21/22955660903/21/226.650.557.204/20/22 377383/11/22100225123742108128.303/21/22815660913/21/222292.30189.112481.414/20/22 377393/11/2210028948692522738.903/21/2275660923/21/22272.3022.46294.764/20/22 377403/12/22100140727359518335.363/22/22835660963/22/222934.88242.133177.014/21/22 377413/12/221001404869430156132.713/22/22565660943/22/227431.76613.128044.884/21/22 377423/12/22100122124761778235.383/22/22825660933/22/222901.16239.353140.514/21/22 377433/12/22100182637915691788.503/22/22175660953/22/221504.50124.121628.624/21/22 377443/13/22100274124772781997.333/23/22195660993/23/221849.27152.562001.834/22/22 377453/13/22100329486989119633.593/23/22965660983/23/223224.64266.033490.674/22/22 377463/13/22100260728423709930.053/23/22995660973/23/222974.95245.433220.384/22/22 377473/14/22100216728626505242.473/24/22955661023/24/2223034.651900.3624935.014/23/22 377483/14/221001404872709267884.963/24/22675661013/24/2259292.324891.6264183.944/23/22 377493/14/2210023112477508837.063/24/22835661003/24/22585.9848.34634.324/23/22 377503/15/22100111487271289535.363/25/22955661033/25/223359.20277.133636.334/24/22 377513/15/22100254728680107422.993/25/22745661043/25/221701.26140.351841.614/24/22 377523/16/22100136487340256384.923/26/22635661053/26/225349.96441.375791.334/25/22 377533/16/22100274728680226122.993/26/22615661063/26/221402.39115.701518.094/25/22 377543/17/22100272487353562092.003/27/22205661083/27/221840.00151.801991.804/26/22 377553/17/2210028872868228688.833/27/22685661073/27/22600.4449.54649.984/26/22 377563/18/22100186631674632817.703/28/22285661093/28/22495.6040.89536.494/27/22 377573/18/22100181848262363017.683/28/22305661103/28/22530.4043.76574.164/27/22 377583/19/22100302631674751321.243/29/22105661123/29/22212.4017.52229.924/28/22 377593/19/22100129848262603817.683/29/22385661113/29/22671.8455.43727.274/28/22 377603/20/22100208848262964817.683/30/22485661133/30/22848.6470.01918.654/29/22 377613/21/22100174848263207517.683/31/22755661143/31/221326.00109.401435.404/30/22 377623/22/22100232848266354017.684/1/22405661154/1/22707.2058.34765.545/1/22 377633/23/22100113848266594117.684/2/22415661164/2/22724.8859.80784.685/2/22 377643/24/2210025596921990350.514/3/22355661174/3/2217.851.4719.325/3/22 377653/25/2210022596922232420.894/4/22425661184/4/2237.383.0840.465/4/22 377663/26/22100137969241683642.444/5/22365661194/5/221527.84126.051653.895/5/22 377673/27/22100188969241804215.914/6/22425661204/6/22668.2255.13723.355/6/22 377683/28/2210022296924531280.784/7/22285661214/7/2221.841.8023.645/7/22 377693/29/2210021396928524485.294/8/22485661224/8/22253.9220.95274.875/8/22 377703/30/22100167635061308210.074/9/22825661244/9/22825.7468.12893.865/9/22 377713/30/221002879694936035.524/9/2235661234/9/2216.561.3717.935/9/22 377723/31/22100283969499657710.604/10/22775661254/10/22816.2067.34883.545/10/22 377734/1/221001239695000175.354/11/2275661264/11/2237.453.0940.545/11/22 377744/2/221001399695066715.524/12/2215661274/12/225.520.465.985/12/22 377754/3/2210032196952470144.944/13/22145661284/13/2269.165.7174.875/13/22 377764/4/2210024996952530870.874/14/22875661294/14/2275.696.2481.935/14/22 377774/5/2210030896952833670.694/15/22675661304/15/2246.233.8150.045/15/22 377784/5/2210020263791944088.504/15/2205661324/15/220.000.000.005/15/22 377794/5/2210022136689212942.994/15/22945661314/15/22281.0623.19304.255/15/22 377804/6/22100244973268808792.004/16/22875661334/16/228004.00660.338664.335/16/22 377814/7/22100181974204618383.154/17/22835661344/17/226901.45569.377470.825/17/22 377824/8/2210015212863740316.714/18/22315661354/18/22208.0117.16225.175/18/22 377834/8/221001409793186866104.394/18/22665661364/18/226889.74568.407458.145/18/22 377844/9/22100105727213705426.514/19/22545661384/19/221431.54118.101549.645/19/22 377854/9/2210032897935885675.524/19/22675661394/19/22369.8430.51400.355/19/22 377864/9/22100143157669781040.674/19/22105661374/19/22406.7033.55440.255/19/22 377874/10/22100307727213822215.894/20/22225661404/20/22349.5828.84378.425/20/22 377884/11/22100115727214074717.684/21/22475661414/21/22830.9668.55899.515/21/22 377894/12/22100134367994319132.734/22/22915661424/22/222978.43245.723224.155/22/22 377904/12/22100103727214313514.124/22/22355661434/22/22494.2040.77534.975/22/22 377914/13/2210010636799613166.184/23/22165661444/23/2298.888.16107.045/23/22 377924/13/22100322727235004758.374/23/22475661454/23/222743.39226.332969.725/23/22 377934/14/22100242368012823045.984/24/22305661484/24/221379.40113.801493.205/24/22 377944/14/22100345727235244379.464/24/22435661474/24/223416.78281.883698.665/24/22 377954/14/22100106292152233026.464/24/22305661464/24/22793.8065.49859.295/24/22 377964/15/221002383680131946106.164/25/22465661494/25/224883.36402.885286.245/25/22 377974/15/22100140292680037158.324/25/22715661504/25/224140.72341.614482.335/25/22 377984/16/22100282374306527713.794/26/22775661524/26/221061.8387.601149.435/26/22 377994/16/22100303292762679412.354/26/22945661514/26/221160.9095.771256.675/26/22 378004/17/22100210363366918912.354/27/22895661534/27/221099.1590.681189.835/27/22 378014/17/22100286414485543026.514/27/22305661544/27/22795.3065.61860.915/27/22 378024/18/22100114366657876097.264/28/22605661564/28/225835.60481.446317.045/28/22 378034/18/221003384866629089141.564/28/22895661554/28/2212598.841039.4013638.245/28/22 378044/19/22100311366665136730.054/29/22675661574/29/222013.35166.102179.455/29/22 378054/19/22100235486722311724.744/29/22175661584/29/22420.5834.70455.285/29/22 378064/20/2210024048672267519.434/30/2255661604/30/2297.158.01105.165/30/22 378074/20/22100256366670459322.974/30/22935661594/30/222136.21176.242312.455/30/22 378084/21/2210033436667130998.305/1/22995661615/1/22821.7067.79889.495/31/22 378094/21/22100317486733803412.375/1/22345661625/1/22420.5834.70455.285/31/22 378104/22/22100340486735259719.435/2/22975661645/2/221884.71155.492040.206/1/22 378114/22/22100341366743412230.055/2/22225661635/2/22661.1054.54715.646/1/22 378124/23/221001404868095532159.265/3/22325661665/3/225096.32420.455516.776/2/22 378134/23/2210033036689212712.995/3/22715661655/3/22212.2917.51229.806/2/22 378144/24/2210031236689236744.585/4/22745661675/4/22338.9227.96366.886/3/22 378154/24/22100146486907442617.155/4/22305661685/4/22514.5042.45556.956/3/22 378164/25/2210020448691203670.765/5/2265661705/5/22424.5635.03459.596/4/22 378174/25/2210032436689987604.055/5/22605661695/5/22243.0020.05263.056/4/22 378184/26/2210012736693012768.305/6/22765661715/6/22630.8052.04682.846/5/22 378194/27/22100120366931084626.515/7/22465661725/7/221219.46100.611320.076/6/22 378204/28/22100163367991898228.285/8/22825661735/8/222318.96191.312510.276/7/22 378215/4/22100119291757162311.495/14/22235661745/14/22264.2721.80286.076/13/22 378225/4/221003114866629067141.565/14/22675661755/14/229484.52782.4710266.996/13/22 378235/5/221002442918681296.555/15/2295661775/15/2258.954.8663.816/14/22 378245/5/2210016096921990940.515/15/22945661765/15/2247.943.9651.906/14/22 378255/6/2210024496922232160.895/16/22165661785/16/2214.241.1715.416/15/22 378265/6/2210017629195742512.115/16/22515661795/16/22107.618.88116.496/15/22 378275/7/22100319366743412430.055/17/22245661805/17/22721.2059.50780.706/16/22 378285/7/22100254969241684142.445/17/22415661815/17/221740.04143.551883.596/16/22 378295/7/2210014429195863655.225/17/22655661825/17/22339.3027.99367.296/16/22 378305/8/22100108969241807915.915/18/22795661845/18/221256.89103.691360.586/17/22 378315/8/2210017229196008686.815/18/22685661835/18/22463.0838.20501.286/17/22 378325/9/2210022696924531400.785/19/22405661855/19/2231.202.5733.776/18/22 378335/10/2210020096928524705.295/20/22705661865/20/22370.3030.55400.856/19/22 378345/11/2210011096949360975.525/21/22975661885/21/22535.4444.17579.616/20/22 378355/11/22100122109514453130.055/21/22315661875/21/22931.5563.89995.446/20/22