I attached the assignment for auditing and supporting documents, but I was wondering where do I even start with this?

Perform requirements 1 and 2 on page 653 of the le Biltrite Modules VIVII (on blackboard) (you do not need to print the completed document) using the Module 6 spreadsheet le. Provide your answers below the cutoff spreadsheets. Submit one excel le through blackboard. Grading: Correctly identied the three purchases 3 cutoff misstatements Correct journal entries for purchase cutoff 1 misstatements Correctly identified the sales cutoff 2 misstatements (I'm not saying how many are wrong) Correct journal entries for sales cutoff l misstatements Are cutoff errors intentional or 1 unintentional? Total 8 Cutoff Tests Along with Richard Derick and the rest of the audit team, you observed Biltrite's December 31, 2009, physical inventory. Derick is satised with the inventory-taking procedures and has considerable condence in the reliability of the ending inventory quantities. He is concerned, however, with the meth- ods used to value the ending inventories {especially the dimoa'tion of unfavor- able budget variances] and with possible misstatements relating to sales and purchases eutodI With regard to euto; Derick is particularly interested in learn- ing why customers could not conrm details of sales transactions recorded by Eiltrite on December 31, 2009. In response to the conrmation and cutoff eon- eerns, he has asked you to examine the appropriate books of original entry and underlying documentation for a few days before and after the balance sheet date. Specically, you are interested in the following: I. Were purchases and sales recorded in the proper accounting period? 2. Were purchases recorded at year end included in the physical inventory? 3. Were all materials and purchased parts included in inventory recorded as purchases? 4. Were the nished goods inventory accounts properly relieved ar all recorded sales? You download Biltrite's December voucher register and sales summary. These are partially reproduced in Exhibits BIL? and BRtS referred to in Motthe II. Using these as a focal point, you requested that the client provide you with the documentation supporting certain of the recorded transactions. You now are prepared to record any necessary audit adjustments and redaeieations. Requirements 1. Using the spreadsheet program and downloaded data, retrieve the le labeled "Emmi\" Study WP 6.4, \"Inventory Cutoff\" and compare it with the voucher register and sales summary portions reproduced in Exhibits BR. 13 and BR.14 in Module II. Comment on any eutotf misstatements that you detect and determine their eect on net income. Do the misstatements appear to be intentional or unintentional? Explain. 2. Draft any audit adjustments suggested by the analysis performed in requirement (1). (Remember that Biltrite maintains perpetual inventory records and adjusts its PErPetual inventory to the physical inventory through the appropriate "Cost of Goods Sold\" accounts.) I. Print the completed document with the proposed euto' audit adjustments. U\" IUouner VII'IU 1| A' Av = = 9? V E.) Wisp Tan 7 | E 4 Pasta :2 g H Merge 3; Center - s v 95 3 '33 3 Conditiqnal Ft Formatting as i49 1 a c n 1: 1: G E .1 I? E.' I'm-rid lull mu mucus. me. nun: \"unmet! Gaunt! Elvin-Id lull m 31, zoos nu.- mmu can" mm? III!!! nun-nu mum mum mm In. mun-1 In. nu: amt-n nu: mzm mxm 1m mum um 131nm:- 1uss 01.13:.\" 13121,!\" 12130309 run ennui-mum: mum-d 31.1."..9-60 13131,!\" 13:51- o1-1:a1- 12126,!\" 12131.!\" run [hip- point mum-d $962.2\" vane nun 01-12133 mulling 121nm! run nhip. point mum-d 5183.751 name may 01-12139 lausms 121nm! run nhip. point mum-d 5365.100 lilr'l IIGEO I-lai. IIIQOFDQ 132310 run lhip. pnin: mind-d Blgl'B-MO :1) III-["10 18151 63-131\": 1!:310 133310 run lhip. pnint mind-II Silhl [I] :1) moan-r 1:150 n. im- t'h- pun-hm ut n. Int-rial.- gn moan-r 1:\"1 un- 2m- t'h- pun-h..- at pun uua cum ..---..---..----.------ -----------.---- -.----.----.------- nun-mm? nus 1mm: mum mm mm: mm nus mum mrm 1m mun runs cum mum 33m: 1213mm! 1213mm! run ip. point \"ammo 5205.136 \"mun-d 33m: Inna 12mm run ip. point 3331mm \"15.010 ileum-d 33M" lfi'l 12f30'9 run lhip. poda: Ml .T'O MILES: {Mind-d 33M! lifilfi lifilfi run lhip. annt 31! .EDO $111.3i1 Imindld 33mm lfi'l lifilfi run lhip. annL 3113.310 5595.361 imindld 3303': 1133.10 131nm: run .hip. point \"Jan-no 5:60.799 inn-ulna sauna 121nm! 121nm! rm [hip- point 3112.5\" 39.1,\": \"mun-d 33mg Luna 121nm! run ip. point 51,322,500 91,0\"..556 ileum-d 33010 Inna Inna run ip. point usamno 5315.153 ileum-d 33011 lil'l lil'l run lhip. poda: 3193.211. SHIESIZ {Mind-d All IdjulK-MI of pulp-uni m phyliual. int-ninth- 1|le hI-Il .dl ummgh 'L'olt or unna- mm.- Isa-Luna LIII' tailoring (Inna-nt- tnr a full- 111,- intact- and nth-r th- hnlun- In\": dal- Im Hllill'li\" til-1'. Hun-minn- I-ru rlcunld in m plug-I: muting [urinal mnhurl Inciting Input\" 1-2-1911: Inn-nim- lll Emir-l nill- n1 Ending All all. an lhiwld 'rml .nmu; point.' Mid triighl .anuioil- in: insulin [hip-uls- to locals- pullibll gun-a. in krnnlit for thin!) um.- hid Palm-d 11-!an gun-m