70.2K

Verified Solution

Link Copied!

not sure what is needed please let me know that is the information I am given

Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. Adjustments - Follow all instructions from the Simulation packet. - Use the datafile, SimP3J4ReconciliationStatement.x|sx, _, E Eto complete the reconcilation statement. - This is an Excel file, failure to use cell references results in a 50% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. Omptete the reconcilation statement. Read his note and prepare the report he requests. JOB4 Data File: Part 3 Sim Check Register Balancing the monthly bank account statements with company records is an important task. Read Amy is note and create a spreadsheet to prepare the reconciliation that she requests. JOB 5 From the Desk of Amy Mosley July 17 I have finished reconciling the bank statement with our records for our money market account NO. 948725. Will you please do a reconciliation report in Excel for the checking account? The bank statement for the checking account is attached. I sent you the Excel file that contains the check regiten for the checking account for June. Remember to update the check negister to show the senvice charge and any conrecttions that ane needed. Thanks Ariy Pueblo Outfitters Account No. 948723 200 Victoria Avenue Statement Date 7/4/ - Pueblo, CO 81003-3435 Statement Period 6/1 - 6/30, 20-- \begin{tabular}{c|c|c|c|c|c|} \hline BalancefromPreviousStatement & NumberofCredits & TotalDepositsandCredits & NumberofofDebits & WotalandDebits & StatementBalance \\ \hline 35,897.53 & 26 & 95,286.50 & 36 & 98,772.75 & 32,411.28 \\ \hline \end{tabular} PUEBLO OUTFITTERS EXPENSE BUDGET For June 20 cotaminis I (1,14)2 Nhingung reconcilation statement. el file, failure to use cell references results in a 50% deduction. astNameP3J4. Submit to the correct dropbox. AT WORK AT PUEBLO OUTFITTERS You have become an important part of the office team at Pueblo Outfitters. As you continue your job as an administrative assistant, you will assist employees with tasks to help keep the company running smoothly. The Organization Pueblo Outfitters sells various products for camping, hiking, and other outdoor sports to local residents and to vacationers. The business is located in downtown Pueblo. The building contains a retail sales center, a warehouse and receiving area, and the company offices. Customers may contact the company by mail, phone, or fax. The company staff consists of sales associates, warehouse workers, and office personnel. The personnel with whom you will be working are listed below. - Owner: Rafael Santana - Sales Associates: Andre Jackson, Catrina Devore, Mae Park, and Larry Gaustad - Office Personnel: Marcus Wilson and Amy Mosley, Accounting; Lu Chin, Sales and Marketing - Warehouse Personnel: Terry MeMullen and Robin Esposito Your Position You are a full-time employee who will provide administrative support to the company owner and the other personnel. You will be asked to complete tasks such as the following: - Complete a payroll register - Prepare payroll checks - Create a budget variance report - Prepare a bank account reconciliation - Calculate costs for healin insurance - Search the Internet to find purchase information for office equipment and prepare a purchase requisition - Create a pre chart Read his note and prepare the report he requests. Data File: Part 3 Sim Check Register Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. statement. to use cell references results in a 50% deduction. Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. Adjustments - Follow all instructions from the Simulation packet. - Use the datafile, SimP3J4ReconciliationStatement.xIsx. _. Eito complete the reconcilation statement. - This is an Excel file, failure to use cell references results in a 50% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. From the Desk of Amy Mosley July 17 I have finished reconciling the bank statement with our records for our money market account NO. 948725. Will you please do a reconciliation report in Excel for the checking account? The bank statement for the checking account is attached. I sent you the Excel file that contains the check register for the checking account for June. Remember to update the check register to show the service charge and any corrections that are needed. Thanks Any Triple Star Bank Pueblo, Colorado Pueblo Outhitters 200 Victoria Avenue Account No. 948723 Statement Date 7/4/ - Puebio, CO 81003-3435 Statement Period 6/16/30,20-- Pueblo Oufitters Expense Budget For the Month Ending June 30,2023 Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. Adjustments - Follow all instructions from the Simulation packet. - Use the datafile, SimP3J4ReconciliationStatement.x|sx, _, E Eto complete the reconcilation statement. - This is an Excel file, failure to use cell references results in a 50% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. Omptete the reconcilation statement. Read his note and prepare the report he requests. JOB4 Data File: Part 3 Sim Check Register Balancing the monthly bank account statements with company records is an important task. Read Amy is note and create a spreadsheet to prepare the reconciliation that she requests. JOB 5 From the Desk of Amy Mosley July 17 I have finished reconciling the bank statement with our records for our money market account NO. 948725. Will you please do a reconciliation report in Excel for the checking account? The bank statement for the checking account is attached. I sent you the Excel file that contains the check regiten for the checking account for June. Remember to update the check negister to show the senvice charge and any conrecttions that ane needed. Thanks Ariy Pueblo Outfitters Account No. 948723 200 Victoria Avenue Statement Date 7/4/ - Pueblo, CO 81003-3435 Statement Period 6/1 - 6/30, 20-- \begin{tabular}{c|c|c|c|c|c|} \hline BalancefromPreviousStatement & NumberofCredits & TotalDepositsandCredits & NumberofofDebits & WotalandDebits & StatementBalance \\ \hline 35,897.53 & 26 & 95,286.50 & 36 & 98,772.75 & 32,411.28 \\ \hline \end{tabular} PUEBLO OUTFITTERS EXPENSE BUDGET For June 20 cotaminis I (1,14)2 Nhingung reconcilation statement. el file, failure to use cell references results in a 50% deduction. astNameP3J4. Submit to the correct dropbox. AT WORK AT PUEBLO OUTFITTERS You have become an important part of the office team at Pueblo Outfitters. As you continue your job as an administrative assistant, you will assist employees with tasks to help keep the company running smoothly. The Organization Pueblo Outfitters sells various products for camping, hiking, and other outdoor sports to local residents and to vacationers. The business is located in downtown Pueblo. The building contains a retail sales center, a warehouse and receiving area, and the company offices. Customers may contact the company by mail, phone, or fax. The company staff consists of sales associates, warehouse workers, and office personnel. The personnel with whom you will be working are listed below. - Owner: Rafael Santana - Sales Associates: Andre Jackson, Catrina Devore, Mae Park, and Larry Gaustad - Office Personnel: Marcus Wilson and Amy Mosley, Accounting; Lu Chin, Sales and Marketing - Warehouse Personnel: Terry MeMullen and Robin Esposito Your Position You are a full-time employee who will provide administrative support to the company owner and the other personnel. You will be asked to complete tasks such as the following: - Complete a payroll register - Prepare payroll checks - Create a budget variance report - Prepare a bank account reconciliation - Calculate costs for healin insurance - Search the Internet to find purchase information for office equipment and prepare a purchase requisition - Create a pre chart Read his note and prepare the report he requests. Data File: Part 3 Sim Check Register Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. statement. to use cell references results in a 50% deduction. Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. Adjustments - Follow all instructions from the Simulation packet. - Use the datafile, SimP3J4ReconciliationStatement.xIsx. _. Eito complete the reconcilation statement. - This is an Excel file, failure to use cell references results in a 50% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. From the Desk of Amy Mosley July 17 I have finished reconciling the bank statement with our records for our money market account NO. 948725. Will you please do a reconciliation report in Excel for the checking account? The bank statement for the checking account is attached. I sent you the Excel file that contains the check register for the checking account for June. Remember to update the check register to show the service charge and any corrections that are needed. Thanks Any Triple Star Bank Pueblo, Colorado Pueblo Outhitters 200 Victoria Avenue Account No. 948723 Statement Date 7/4/ - Puebio, CO 81003-3435 Statement Period 6/16/30,20-- Pueblo Oufitters Expense Budget For the Month Ending June 30,2023

Answer & Explanation Solved by verified expert

See Answer