Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
This problem requires the use of ACL software, which is includedin the CD attached to the text. Information about installing and using ACL and solvingthis problem can be found in Appendix, pages 830–834. You should read all of thereference material, especially the material on sampling, to answer questions a. through e.For this problem use the “Inventory” file in the “Inventory_Review” subfolder undertables in Sample_Project. Suggested commands, where applicable, are indicated at the endof the problem requirements.a. Calculate the sample size and sampling interval for an MUS sample based on inventory value at cost (Value). Use a confidence level of 90%, materiality of $40,000,and expected errors of $2,500. (Sampling/Calculate Sample Size; select “monetary”radio button)b. What is the sampling size and sampling interval if you increase materiality to$50,000 and decrease expected errors to $1,000?c. Select the sample based on the sampling interval determined in part a. (Sampling /Sample…
The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger and assigning a due date.Each day, the cash disbursement clerk visually searches the AP subsidiary ledger from her terminal for…
The purchasing agent receives an inventory status report on his computer terminal from the inventory control application, which identifies the items that need to be reordered. The agent selects the suppliers and enters this information into the computer terminal to create a digital purchase order. He then prints and sends a copy of the PO to the supplier.
When the goods are received directly into the warehouse, the warehouse manager counts and inspects them. The manager then creates a digital receiving report and updates the inventory subsidiary ledger from the warehouse terminal.
A few days later, the supplier sends an invoice to the AP clerk who reconciles it with the digital copy of the receiving report. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger and assigning a due date.
Each day, the cash disbursement clerk visually searches the AP subsidiary ledger from her terminal…
Knowledge Booster
Similar questions
- The following is a description of manufacturing company’s purchasing procedures. All computers in the company are networked to a centralized accounting system so that each terminal has full access to a common database. The inventory control clerk periodically checks inventory levels from a computer terminal to identify items that need to be ordered. Once the clerk feels inventory is too low, he chooses a supplier and creates a purchase order from the terminal by adding a record to the purchase order file. The clerk prints a hard copy of the purchase order and mails it to the vendor. An electronic notification is also sent to accounts payable and receiving, giving the clerks of each department access to the purchase order from their respective terminals. When the raw materials arrive at the unloading dock, a receiving clerk prints a copy of the purchase order from his terminal and reconciles it to the packing slip. The clerk then creates a receiving report on a computer system. An…arrow_forwardThe following is a description of manufacturing company’s purchasing procedures. All computers in the company are networked to a centralized accounting system so that each terminal has full access to a common database.The inventory control clerk periodically checks inventory levels from a computer terminal to identify items that need to be ordered. Once the clerk feels inventory is too low, he chooses a supplier and creates a purchase order from the terminal by adding a record to the purchase order file. The clerk prints a hard copy of the purchase order and mails it to the vendor. An electronic notification is also sent to accounts payable and receiving, giving the clerks of each department access to the purchase order from their respective terminals. When the raw materials arrive at the unloading dock, a receiving clerk prints a copy of the purchase order from his terminal and reconciles it to the packing slip. The clerk then creates a receiving report on a computer system. An…arrow_forwardhas hired you to review its sales order procedures for internal control compliance and to make recommendations for changes. You are required to:a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the internal control weaknesses in the system. ; andd. Prepare a system flowchart of a redesigned computer-based systemarrow_forward
- The computer processing portion of a sales order system is represented by the flowchart. Answer the following questions.a. What type of data processing system is this? Explain, and be specific.b. The auditor suggests that this system can be greatly simplified by changing to direct access files. Explain the major operational changes that would occur in the system if this were done.c. The auditor warns of control implications from this change that must be considered. Explain the nature of the control implications.d. Sketch a flowchart (the computerized portion only) of the proposed new system. Use correct symbols and label the diagram.arrow_forwardGiven the following business rules, construct an ER diagram so each rule is captured for the database. Presume each rule is to be treated individually. Construct an ER diagram for each rule.a. A retail sales company prepares sales orders for its customers’ purchases. A customer can make many purchases, but a sales order is written for a single customer.b. A retail sales company orders inventory using a purchase order. An inventory item may be ordered many times, and a purchase order may be created for more than one inventory item.c. A company that sells antique cars prepares a sales order for each car sold. The inventory for this company consists of unique automobiles, and only one of these automobiles may be listed on a sales order.d. A grocery store identifies returning customers via a plastic card that the clerk scans at the time of each purchase. The purpose of this card is to track inventory and to maintain a database of customers and their purchases. Obviously, a customer may…arrow_forwardWhen aninventory itemfalls to the recorder point, a purchase requisition is automatically generated and printed on the terminal in the purchasing department. The purchasing clerk select suppliers and prepare a purchase order. One copy of the purchase order is sent to the supplier and another copy is sent to the receiving department. The purchasing clerk then adds a record to the open/closed purchase order file through an update program in the data processing department.When the receiving clerk receivesthe delivery from the supplier, the clerkreconciles the items with the packing slip and the purchasing order. After the reconciliation, the receiving clerk prepares a hard-copy receiving report recording the quantity and quality of the goods received. One copy of the receiving report accompaniesthe items to the warehouse and another copy is filed in the receiving department. Using the department terminal, the receiving clerk adds a record to the digital receiving report file. The system…arrow_forward
- Which of the following automated application controls would offer reasonable assurancethat inventory data were completely and accurately entered?a. Sequence checking.b. Batch totals.c. Limit tests.d. Check digits.arrow_forwardA company is trying to set up proper internal controls for their accounts payable/inventory purchasing system. Currently the purchase order is generated by the same person who receives the inventory. Together the purchase order and the receiving ticket are sent to accounts payable for payment. What changes would you make to improve the internal control structure? A. No changes would be made since the person paying the bills is different from the person ordering the inventory. B. The person in accounts payable should generate the purchase order. C. The person in accounts payable should generate the receiving ticket once the invoice from the supplier is received. D. The responsibilities of generating the purchase order and receiving the inventory should be separated among two different people.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
- Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning