I have an auditing project that I have to complete. It is about analytics for expenditure. I attached you all the files that you needed to complete this project. The file name: Project 3 requirement will tell you the details of what you have to do for this project. There are 3 management assertions, but you only have to work on 1 assertion, which is Valuation or Allocation. The file name: Analytics_ReportOutline.docx will show you the outline for this project. Please let me know if you have any questions.
When you finished this project, please also give me an excel or Access, or Tableau file that you use to complete this project, it depends on the software that you decided to use.
1)Please fill out the information in the format outline that I sent the file to you
2)There are 2 audit objectives that you have to test which is Inventory and Accounts payable
3)Please add the screenshot of the test you performed
Bradmark is a chain of department stores that have locations throughout Northeast Pennsylvania, New York state, and Southern C Lehigh Wholesale General Supply An ACL™ Case Study Lehigh is a wholesale general supply company that ships to business customers throughout Northeast Pennsylvania, New York state, and Southern Connecticut. Lehigh has developed a competitive edge by offering a wide variety of quality products at competitive prices. The company’s products range from paint to watering cans. Lehigh is a publicly owned company, whose board of directors has retained your firm to conduct the annual audit. You are the in-charge auditor who is currently examining Lehigh’s revenue and expenditures procedures and related accounts. Lehigh’s main offices are in its Allentown, PA warehouse. The following describes your client’s system configuration and business procedures. System Overview and Background Lehigh’s information system is a recently purchased application that runs on a client-server network configuration. James Walker, a systems designer in Lehigh’s IT department, played a central role in implementing and modifying the system to meet Lehigh’s specific needs. Because of Walker’s familiarity with the system, he was asked by top management to temporarily oversee the initial running of the new system to ensure a smooth transition from the old legacy system. After several months, James Walker was offered a promotion to Warehouse Manager and given permanent responsibility for product purchasing. Purchasing/Payment Procedures The flowchart in Figure 3 and the file structure diagram in Figure 4 illustrate the purchasing/payment procedures at the central warehouse. Warehouse Each morning Walker reviews an automatically generated inventory status report from his office terminal. He determines the items that need replenishing and selects suppliers from the Vendor file. Walker then adds a record to the purchase order file. The system assigns each new record a unique number (PO Number) as the primary key. Walker manually enters the date, the product to be ordered, order quantity, expected unit cost (the extended cost is automatically calculated by the system), and the ID number of the selected vendor. The purchase orders are then printed on Walker’s terminal, signed by him, and mailed by his secretary to the respective suppliers. Receiving When the products are received at the receiving dock, a receiving clerk counts and inspects them. The clerk adds a record to the Receiving Report file from the terminal in the receiving area. The system assigns a unique key (RR Num) to each record. The clerk manually enters the purchase order number, product number(s), quantity received, vendor ID number, and the date of receipt. The receiving system is not particularly user friendly. If errors are made during data entry, the clerk must void the receiving report and begin over with a new receiving report record. The voided record is then automatically purged from the Receiving Report file and the system assigns the next RR Number in sequence to the revised receiving report. As a result, sequence gaps exist in the receiving report file indicating the missing records. The products are then sent to the warehouse where they are secured. At the end of the work shift, the receiving clerk prints a hard copy of the receiving report listing of the day’s receipts (including any voided receiving reports), which is sent to James Walker’s office for his review. Warehouse After Mr. Walker has reviewed the receipts he manually adds the system-assigned RR Number to the corresponding Purchase Order record to indicate that the product has been received. The system automatically updates the Quantity on Hand field in the Inventory file from the Quantity field in the Purchase Order record. Accounts Payable Sybil Johnson, the Accounts Payable clerk, receives the vendor’s invoices. Using the PO number from the invoice as a search key, she matches the invoice with the corresponding purchase order/payment record. She verifies that the items invoiced have been received by observing that a RR Number has been placed in the Purchase Order record. She then adds a record to the Voucher Payable file. The system assigns a unique key (Voucher Number) to each record. Sybil enters manually the following data directly from the supplier’s invoice: purchase order number, vendor number, supplier invoice number, full amount due, discounted amount due, and due date. The due date is selected to take advantage of purchase discounts. Finally, Sybil files the vendors invoice in her office filing cabinet. Cash Disbursements Each day, Sean O’Connell in the Cash Disbursements department reviews the Voucher Payable file for items due to be paid that day. For each item due, he adds a record to the Check Register file. The system assigns it a unique key (Chk Number) and Sean manually adds the following data to the Check Register record: voucher number, vendor number, amount of payment, and date. The system automatically places the check number in the appropriate Voucher Payable record to indicate that payment has been made. The checks are printed in Sean’s office and then reviewed and signed by Irving Stern, the department manager. Slide 1 Review and Update Warehouse Server PO file Vouch Pay Inventory Vendor Rec Report Chk Register Purchase Order Supplier Receiving Department Supplier Packing Slip Rec Report Listing Rec Report Listing Accounts Payable Supplier Invoice 3 Way Match Set up AP Cash Disbursements Review AP For Payments Due Check Supplier Sign and Distribute Check Check Purchases/ Payment System Prepare Rec Report A A Figure 3, Purchases and Cash Disbursement Procedures Expenditure File Structures Employee BIRTHDATEBONUSCOMMEDLEVELEMP_ADDREMP_CITYEMP_STATEEMP_ZIPEMPNOFIRSTNMEHIREDATEJOBLASTNAMEMIDINITPAY_PER_PERIODPHONENOSALARYSEXWORKDEPT 5/17/635001907161904 Ruffin DriveLos AngelesCA90071000340JASON5/4/84FIELDREPGOUNOTR1986.67569823840ME21 5/17/635001907165135 South DorchesterLos AngelesCA90017200340ROY5/4/84FIELDREPALONZOR1986.67569823840ME21 9/15/62800321416100 Mansion Road EastLos AngelesCA90017000050JOHN8/17/86MANAGERGEYERB3347.92678940175ME01 11/5/66900372019330 C St. SWLos AngelesCA90054000110VINCENZO5/16/95SALESREPLUCCHESIG3875349046500MA00 10/18/79600234014111 Greek RowLos AngelesCA90017000120SEAN12/4/00CLERKO'CONNELL2494.35216729250MA00 4/20/683001272121201 West Fifth StreetLos AngelesCA90022000310MAUDE9/12/01OPERATORSETRIGHTF1325333215900FE11 4/20/683001272123 N. Denaware AveLos AngelesCA90017200310MICHELLE9/12/01OPERATORSPRINGERF1325333215900FE11 8/14/7010004220182320 Camino Vida RobleLos AngelesCA90007000010CHRISTINE1/1/02PRESHAASI4395.83397852750FA00 8/14/7010004220187600 France Avenue SouthLos AngelesCA90051200010DIAN1/1/02SALESREPHEMMINGERJ3875397846500FA00 8/11/694001596161201 East BellLos AngelesCA90040000320RAMLAL7/7/02FIELDREPMEHTAV1662.5999019950ME21 5/29/78600221716780 Third AvenueLos AngelesCA90064000200DAVID3/3/03DESIGNERBROWN2311.67450127740MD11 5/29/72400177414221 N. LaSalle StreetLos AngelesCA90017000230JAMES11/21/03CLERKJEFFERSONJ1848.33209422180MD21 3/28/73500210017221 N. LaSalle StreetLos AngelesCA90015000280ETHEL3/23/04OPERATORSCHNEIDERR2187.5899726250FE11 3/28/735002100173315 Fairview RoadLos AngelesCA90071200280EILEEN3/23/04OPERATORSCHWARTZR2187.5899726250FE11 3/19/856002387181800 Washington RoadLos AngelesCA90012000220JENNIFER8/29/05DESIGNERLUTZK2486.67067229840FD11 3/19/85600238718230 Herndon ParkwayLos AngelesCA90067200220REBA8/29/05DESIGNERJOHNK2486.67067229840FD11 11/11/76400153415216 South Kingshighway BoulevardLos AngelesCA90017000250DANIEL10/30/06CLERKSMITHS1598.33096119180MD21 5/15/786002380161200 North Elm StreetLos AngelesCA90017000090EILEEN8/15/07MANAGERHENDERSONW2479.17549829750FE11 9/15/62500190416401 Broadway NELos AngelesCA90071000130DOLORES7/27/08ANALYSTQUINTANAM1983.33457823800FC01 5/16/84500202216135 South Union StreetLos AngelesCA90042000150BRUCE2/11/09DESIGNERADAMSON2106.67451025280MD11 10/18/79600234014220 North MainLos AngelesCA90071200120GREG5/5/09CLERKORLANDO2437.5216729250MA00 10/27/73400142014501 Wilmington StreetLos AngelesCA90067000300PHILIP6/19/09OPERATORSMITHX1479.17209517750ME11 2/21/865001707173022 West Crest AvenueLos AngelesCA90013000180MARILYN7/7/10DESIGNERSCOUTTENS1778.33168221340FD11 7/7/82600258016120 Hawley LaneLos AngelesCA90045000060IRVING9/14/10MANAGERSTERNF2687.5642332250MD11 2/1/85800330018306 Lake StreetLos AngelesCA90010000020MICHAEL10/10/10MANAGERTHOMPSONL3637.5347641250MB01 6/25/89400163616150 North Michigan Ave.Los AngelesCA90025000190JAMES7/26/11ANALYSTWALKERH1704.17298620450MD11 5/11/78800306020222 West Washington AvenueLos AngelesCA90080000030SALLY4/4/12MANAGERKWANA3187.5473838250FC01 10/5/7330013801614726 Ramona AvenueLos AngelesCA90017000260SYBIL9/10/12CLERKJOHNSONV1437.5895317250FD21 7/18/785002030144459 Forbes BoulevardLos AngelesCA90064000330WING2/22/13FIELDREPLEE2114.17210325370ME21 7/18/785002030142 Continental TowersLos AngelesCA90017200330HELENA2/22/13FIELDREPWONG2114.17210325370FE21 1/19/8360022741847 South 9th StreetLos AngelesCA90024000140HEATHER12/15/13ANALYSTNICHOLLSA2368.33179328420FC01 1/19/83600227418301 South 11th StreetLos AngelesCA90013200140KIM12/15/13ANALYSTNATZN2368.33179328420FC01 4/11/924001780175811 Pelican Bay BoulevardLos AngelesCA90015000160ELIZABETH10/11/14DESIGNERPIANKAR1854.17378222250FD11 1/5/8850019741612617 King JamesLos AngelesCA90012000170MASATOSHI9/15/15DESIGNERYOSHIMURAJ2056.67289024680MD11 1/5/88500197416737 North 5th StreetLos AngelesCA90089200170KIYOSHI9/15/15DESIGNERYAMAMOTO2056.67289024680MD11 2/23/904001462172300 Barrington Rd #500Los AngelesCA90018000210WILLIAM4/10/16DESIGNERJONEST1522.5094218270MD11 3/31/91600230117700 North St. Mary'sLos AngelesCA90017000240SALVATORE12/4/16CLERKMARINOM2396.67378028760MD21 3/31/916002301179450 Seward RoadLos AngelesCA90071200240ROBERT12/4/16CLERKMONTEVERDEM2396.67378028760MD21 7/9/83300122712"3015 SSE Loop 323,Los AngelesCA90009000290JOHN5/30/17OPERATORPARKERR1278.33450215340ME11 12/18/935002092141425 4th Street NorthLos AngelesCA90039000100THEODORE6/19/17MANAGERSPENSERQ2179.17097226150ME21 5/26/90700289316725 S. Figueroa StreetLos AngelesCA90012000070EVA9/30/17MANAGERPULASKID3014.17783136170FD21 5/26/90500219015444 Bonhill RoadLos AngelesCA90017000270MARIA9/30/17CLERKPEREZL2281.67900127380FD21 Vendor CITYLAST_ACTIVENAMEREVIEW_DATESTATESTREETVEN_NUMBERZIP Minneapolis1/7/16Stroud & Sons11/25/15MN1507 LBJ Freeway1213055402 Englewood4/15/16Adams & Meddick5/1/17CO369 Marshall Ave.1228980112 Austin7/18/16Miller Lights2/24/15TX707 Wilshire Blvd1164578711 Ann Arbor11/7/16Arizona Industries8/30/17MI2323 Banbury Loop1055948106 West Warwick11/30/16Wholesome Hardware8/17/15RI345 Dunn Rd118372893 Bellevue3/20/18MGMT Mfg.10/18/14WA2807 N. Glebe Road1229098004 Huntsville3/20/18Pavex Industries7/26/17AL457 Broadway1241735805 Oakland4/17/18Industrial Equipment Co-Op1/15/16CA400 High Street S.E.1118294612 Houston4/25/18Bolton Distribution3/8/15TX112 East Pecan Street1000177002 San Fransisco4/26/18Waterson Services7/17/15CA611 West Park Street1100994108 Gibsland4/27/18Herbie's Hardware11/9/14LA100 Main Street1078771028 Mountain View5/2/18Binford Tools1/16/14CA111 Southwest 5th Avenue1386494039 Warren5/12/18Karen's Factory9/18/16NJ5611 Columbia Pike134237059 Charleston5/13/18US Mfg. Corp4/24/16WV215 West Pershing Road1459925301 Des Moines5/22/18Steel Case Manufacturing12/15/17IA605 Third Avenue1429950319 New Orleans5/25/18PacRim Engineered Products6/23/14LA4001 Lexington Avenue North1044870115 Sacramento6/11/18Winston Mfg.9/19/16CA400 West Market Street1471195826 Chicago7/2/18Meridian Industries3/31/17IL444 Derby Lane1124760661 Sheveport7/2/18Koro International10/28/17LA300 North Meridian Street1243371105 Tulsa7/4/18Hyatt Industries5/13/17OK1700 S. Tamiami Trail1095174103 Washington7/4/18Muller Corp.10/16/17DC3821 Calle Fortunada, Ste D1313620001 Walnut Creek7/5/18Breathed & Company6/27/17CA660 South Figueroc Street1010194596 Austin7/6/18Global Trade Hardware10/18/14TX2270 South 88th Street1224878725 Austin7/7/18DIDA Limited10/6/17TX805 3rd Avenue1192278701 Washington7/9/18Great Western Limited9/9/15DC100 Main Street1344020426 Rolling Meadow7/13/18Mitchell Ent.2/5/15IL800 North Lindbergh Blvd.1002560008 Los Angeles7/18/18Conrad Mfg. Works1/16/17CA1101 Market Street1121390071 Baton Rouge7/21/18Harris Projects4/14/17LA176 Palisade Ave.1270170821 Jacksonville7/27/18Timmy's Tools4/7/17FL1050 Wilshire Drive1257632254 Oklahoma City7/27/18Promac Services5/26/17OK7300 Crestwood Blvd.1491373125 Montgomery8/10/18American Tech11/23/14AL1011 Lockheed Way1036636116 Bay Minette8/16/18Larson Supplies5/30/17AL1900 Alamea de las Pulgas1072636507 Boise8/23/18O'Conner And Daughters10/14/14ID9901 Linn Station Road1409083728 Phoenix8/23/18Laser Industries6/10/15AZ1100 Matamoros1053485012 Huntsville8/23/18Heritage Cases10/17/17AL600 Grant Street1263635801 Des Moines8/24/18NOVATECH Wholesale11/26/17IA605 Third Avenue1380850319 Shakopee8/25/18Triathalon Group9/24/14MN7630 Little River Turnpike1147555379 Milwaukee8/29/18Stars Trading9/1/14WI20 Washington Avenue South1013453201 Littleton9/23/18Elbowe & Foote Sales5/29/14CO211 River Oaks Pkw1223080123 Nashville9/24/18Paint And Walls Unlimited8/6/14TN51 Broadway, Suite 5001345337219 Charlotte9/27/18Lilydale Hardware12/30/15NC111 South Main Street1337328273 Austin10/1/18Liberty Trading9/25/15TX2501 Parkway1392878701 Houston10/7/18Group Services5/23/15TX3022 West Crest Avenue1143577002 Hartford10/11/18Yellow Industries5/25/14CT1065 Woodman Drive108796115 Los Angeles10/12/18More Power Industries8/4/17CA150 North Michigan Ave.1166390025 Farmington Hills10/24/18Carr International9/23/14MI120 Walton Road1065648331 Jacksonville11/9/18Witz & Partners1/29/17FL2120 South 72nd Street1072132202 Salt Lake City11/10/18United Equipment1/29/17UT250 Williams Street1341184133 Orange11/17/18Bloom County Construction3/25/16CT805 3rd Avenue144386477 Richmond11/20/18Pantages Inc.7/22/15VA1019 Riverbend Drive1072023261 Inventory DESCRIPTIONMARKET_VALUEPRODUCT_NUMQUAN_ON_HANDREORDER_POINTSALE_PRICEUNIT_COSTVALUE_AT_COST LATEX SEMI-GLOSS ORANGE18681.37010434718709809.996.8712846.9 LATEX SEMI-GLOSS CARAMEL14585.47010439714609859.996.8710030.2 LATEX SEMI-GLOSS LILAC14785.27010417714807509.996.8710167.6 LATEX SEMI-GLOSS APRICOT12887.17010467712907809.996.878862.3 LATEX SEMI-GLOSS PINK149857010465715004209.996.8710305 LATEX SEMI-GLOSS YELLOW24175.87010432724204309.996.8716625.4 LATEX SEMI-GLOSS GREEN18681.37010437718706709.996.8712846.9 METRIC TOOL SET 3/8" DR7797.43041431313014059.98476110 METRIC SOCKET SET 11 PC15899.763041428361245025.981811016 6 PC OPEN END WRENCH SET111863041255370065015.9811.538071 6 PC BOX END WRENCH SET4585.523041275324825018.4912.53100 8 PC METRIC HEX KEYS865.52304129032483003.492.48615.04 PARKER PROPANE KIT (7PC)7490342550035007514.988.44200 TAP & DIE SET 41 PIECES9355.323036416323465039.9849.611606.4 SCREW DRIVER 1/8 X 4 SL2497.8230321663147815001.690.731078.94 SCREW DRIVER 1/4 X 6 SL3232.3230321683124813002.591.471834.56 SCREW DRIVER NO.3 PHILL1344.23303223035876002.291.22716.14 ARC JOINT PLIERS 6"2931.25303248036251504.693.992493.75 ARC JOINT PLIERS 16"13107.53032488387514014.989.48225 LONG NOSE PLIERS 7"2875.76300303234123006.9852060 DIAGONAL CUTTING PLIERS4860.96309344236245007.794.983107.52 8 OZ BALL PEIN HAMMER5853.123030341312485104.693.94867.2 12 OZ BALL PEIN HAMMER2835.44303034035365505.294.122208.32 STRAIGHT CLAW HAMMER9540.33030334373555012.988.836490.05 #4 SMOOTH PLANE10435.9213030560380480012.9814.1211352.48 HEAVY DUTY BRACE14297.163030937384290016.9810.128521.04 4 PC CHISEL SET13499.13030290379562016.9810.128045.4 MITRE BOX 21"329703030230360065054.9541.2324738 1" GARDEN HOSE740.28937884111861903.981.4260.4 5 PIECE GARDEN TOOL SET4479.849050633140835010.986.82774.4 24" LEAF RAKE1269.88905015412122405.993636 20" LEAF RAKE2392905015518007202.991.831464 11" SPADING FORK2848.869050105171403.994.823441.48 54" EDGING TURF1518.9905040616107252.491.37835.7 25' VINYL HOSE2196905078414005005.492.881152 50' VINYL HOSE2997905078513005109.995.121536 50' RUBBER HOSE33969050781120042016.988.081616 6" EDGE TRIMMER11863.729050476191482012.986.175639.38 PLASTIC WATERING CAN221.76905095611124501.980.6370.56 PISTOL GRIP NOZZLE9056.859050819118158254.991.632958.45 IMPULSE SPRINKLER8991905099819006759.995.124608 OSCILLATING SPRINKLER42163.2905099313840220010.985.8422425.6 22" SELF-PROPELLED MOW344088.5390584072114790299.99173.8199348.6 18" REEL MOWER22879.12905853228875259.99137.812126.4 18" BUSHWACKER TRIMMER1504.1490599912434034.9821.4920.2 3 CU FT WHEELBARROW845.0690669611472517.989423 4 CU FT WHEELBARROW3738.24900695912882512.9823.846865.92 SUPER CALLUM LEAF MULCH9540900810011201079.5155.818696 HOSE HANGER297900100113002000.990.43129 DIET SCALE1157.1103119902902203.992.98864.2 BLANCHER2658.11011904019011013.9981520 CAKE PAN502.610631140140403.593.09432.6 LOAF PAN515.4410631190136243.793.1421.6 VEGETABLE STEAMER598.510134420150123.993.12468 CAKE DECORATING SET7675.2102266204802415.9910.85184 ALUMINUM TEAPOT 8 CUP1150.5610102710144127.995.99862.56 DISH DRAINER2467.8810551340412755.996.562702.72 MINCER1719.1410310890867519.9914.141216.04 PASTA NOODLE MAKER3519.3610311800641254.9924.881592.32 7 PC KITCHEN TOOL SET335.521080376048246.993.21154.08 STEP-ON CAN1714.68101551501323612.998.41108.8 1 SHELF BREADBOX4980.44101551603564813.999.933535.08 4 PC CANISTER SET2154.0410155170196010.997.051381.8 NAPKIN & RELISH HOLDER1227.48102072202121445.793.22682.64 PRESSURE COOKER 8QT259921010284040011064.9839.415760 192 OZ DUTCH OVEN9195.4101350602309039.9827