Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i got most of it im confused on the excel spreadsheet answers and on A. please help these images should be more clear. I took
i got most of it im confused on the excel spreadsheet answers and on A. please help
these images should be more clear. I took two pictures of each thing, so hopefully one of them will come out clear for you please help.
Using bank reconciliation to determise eash receipts stolen bmount of cash receipts by taking the daby deposits to the bank, The following daca have been gathered for October. ro coposis were in transt on cotober 31. Apen sareadshect a. Determine the amount of cash receipts stolen by the sales clerk. Round your andwer bo the nearest doliat, 5 Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: 10 No deposits were in transit on October 31. 11 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for 12 gradina. Evaluating intemal Control of Cask The following procedures were recenty installed by Raspbery Creek Company: a. After necessary apgrovais have been obtained for the payment of a vouche, the treasurer signs and mals the check. The theasurer then stampe the voucher and supporthy docunentaten as jad and returns the voucher and supporting documentavion to the accounts payable derk for filing. b. The accounts payable derk prepares a woucher for each disbursement. The woucher along with the supporting deoumemtatien is forwarded to the tremurers sime for aperond c. Nong with petty cash expense recaigts for postage, office supplies, etc, several poudded employee ctieda are in the pecty casn Anat. d. At the end of the day, cash regive cierks are required to use thei own funds to make up any canh shotages in bair registers. 6. A the end of each day, ali cash receipts are placed in the bank's niyh depository 1. At the end of each doy, an accountieg clerk compares the duplicate copy of the dally cash deporit dio wah the depoet receipt okeained fim the bank. tor recording in the accounts. h. The bank recunciliation is prepared by the castier, atio works under the mpervian of the treasurer. Mequired: Usins bank reconcillation to determine cash recelpts stolen Alaska limpressions Co. records all cath receipts on the basis of its cash register tapes, Alaske Imprestions discovered during October 20v3 that one of its sales derks hed woien an undetermined amount of cach recelpts by taking the daly deposits to the bank. The folowing data have been gathered for october: Tho deposits wore in transt en odaber 31 This information has beth coliected in the Microsort Excel Online file. Open the spresdsheet, pertorm the required analyas, and input your answers in the questions selow. Doss sprescsheet a. Deterinine the amount of cssh recelpts stoinn by the sales cierk. Mound your answer to the nesrect dollar. b. What accounting controis would have prevethed or detected this theft? Using bank reconcilistion to determine cash recelots stolen ambunt of cash recepts ty taking the dely doposks to the bars. The folowing data have been gathered for Octiber: Osen worestshect 3. Geteomine the amount of cach recepts stoien by the saiv curk. Asuhd you answer to the fearest dods. Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, pertorm the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for neaclinn Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash recelpts by taking the dally deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, pertorm the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) Into the appropriate fiold in CNOWv2 for 12 ararlinn Evaluating Internal Comtrot of Cach The following procedures were recenty instalied by Raspbery Creck Compamy a. After necetsary approvals have been obtained for the payment of a voucher, the treasurer signs and mols the cheok. The treasurer then atamps the voucher asd fipporting doeinertaboe as feit and returns the voucher and supporting documentation to the accounts payable clerk for filing t. The mccounts payable clerk prepares a woucher for each disbursement. The voucher along with be supporting documentaion is forwarded to the beasure's office for approval c. Nong with petty cash expense recelpts for postage, office supplies, etc, several poutdated employte checks are in the petty cash himid. d. At the end of the day, cash register clerks are required to use their own funds to make up any cash shortages in heir registers. e. A. the end of each doy, all cash recelpts are placed in the bank's night depository. 1. At the end of each dwy, an accounting clerk compares the duplicate cooy of the dally cah depolit slip with the deposit receipt obtained from the bunk: for recording in the accounta. h. The tank reconcliation is prepored by the cashier, who worka under the wupervision of the treasure? Required: Using bank reconciliation to determise eash receipts stolen bmount of cash receipts by taking the daby deposits to the bank, The following daca have been gathered for October. ro coposis were in transt on cotober 31. Apen sareadshect a. Determine the amount of cash receipts stolen by the sales clerk. Round your andwer bo the nearest doliat, 5 Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: 10 No deposits were in transit on October 31. 11 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for 12 gradina. Evaluating intemal Control of Cask The following procedures were recenty installed by Raspbery Creek Company: a. After necessary apgrovais have been obtained for the payment of a vouche, the treasurer signs and mals the check. The theasurer then stampe the voucher and supporthy docunentaten as jad and returns the voucher and supporting documentavion to the accounts payable derk for filing. b. The accounts payable derk prepares a woucher for each disbursement. The woucher along with the supporting deoumemtatien is forwarded to the tremurers sime for aperond c. Nong with petty cash expense recaigts for postage, office supplies, etc, several poudded employee ctieda are in the pecty casn Anat. d. At the end of the day, cash regive cierks are required to use thei own funds to make up any canh shotages in bair registers. 6. A the end of each day, ali cash receipts are placed in the bank's niyh depository 1. At the end of each doy, an accountieg clerk compares the duplicate copy of the dally cash deporit dio wah the depoet receipt okeained fim the bank. tor recording in the accounts. h. The bank recunciliation is prepared by the castier, atio works under the mpervian of the treasurer. Mequired: Usins bank reconcillation to determine cash recelpts stolen Alaska limpressions Co. records all cath receipts on the basis of its cash register tapes, Alaske Imprestions discovered during October 20v3 that one of its sales derks hed woien an undetermined amount of cach recelpts by taking the daly deposits to the bank. The folowing data have been gathered for october: Tho deposits wore in transt en odaber 31 This information has beth coliected in the Microsort Excel Online file. Open the spresdsheet, pertorm the required analyas, and input your answers in the questions selow. Doss sprescsheet a. Deterinine the amount of cssh recelpts stoinn by the sales cierk. Mound your answer to the nesrect dollar. b. What accounting controis would have prevethed or detected this theft? Using bank reconcilistion to determine cash recelots stolen ambunt of cash recepts ty taking the dely doposks to the bars. The folowing data have been gathered for Octiber: Osen worestshect 3. Geteomine the amount of cach recepts stoien by the saiv curk. Asuhd you answer to the fearest dods. Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, pertorm the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for neaclinn Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash recelpts by taking the dally deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, pertorm the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) Into the appropriate fiold in CNOWv2 for 12 ararlinn Evaluating Internal Comtrot of Cach The following procedures were recenty instalied by Raspbery Creck Compamy a. After necetsary approvals have been obtained for the payment of a voucher, the treasurer signs and mols the cheok. The treasurer then atamps the voucher asd fipporting doeinertaboe as feit and returns the voucher and supporting documentation to the accounts payable clerk for filing t. The mccounts payable clerk prepares a woucher for each disbursement. The voucher along with be supporting documentaion is forwarded to the beasure's office for approval c. Nong with petty cash expense recelpts for postage, office supplies, etc, several poutdated employte checks are in the petty cash himid. d. At the end of the day, cash register clerks are required to use their own funds to make up any cash shortages in heir registers. e. A. the end of each doy, all cash recelpts are placed in the bank's night depository. 1. At the end of each dwy, an accounting clerk compares the duplicate cooy of the dally cah depolit slip with the deposit receipt obtained from the bunk: for recording in the accounta. h. The tank reconcliation is prepored by the cashier, who worka under the wupervision of the treasure? Required Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started