Archives: Solution Manual
978-0133428537 Chapter 18 Solution Manual Part 2
18.8 Explain how to calculate the total amount of accounts payable: Total Accounts Payable can be calculated in five steps, as follows: Step 1: Normally, only orders actually received are considered purchases for purposes of calculating accounts payable. Therefore, begin […]
978-0133428537 Chapter 18 Solution Manual Part 1
CHAPTER 18 IMPLEMENTING AN REA MODEL IN A RELATIONAL DATABASE SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 18.1 How would the process of generating a cash disbursements journal from the REA data model presented in Figure 18-4 and Table 18-1 differ from […]
978-0133428537 Chapter 17 Solution Manual Part 2
f. g. In this scenario, each sale can be comprised of multiple orders and each order can be associated with multiple sales. Thus, we have here a situation where the selling company batches orders and only ships periodically – e.g., […]
978-0133428537 Chapter 17 Solution Manual Part 1
CHAPTER 17 DATABASE DESIGN USING THE REA DATA MODEL SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 17.1 Why is it not necessary to model activities such as entering information about customers or suppliers, mailing invoices to customers, and recording invoices received from […]
978-0133428537 Chapter 16 Solution Manual Part 3
Step 3: You can collapse and display the groups by clicking on the button to the left of each group name. The preceding screen shot showed all members of each group (note the minus signs to the left of the […]
978-0133428537 Chapter 16 Solution Manual Part 2
16.9 Excel Problem Objective: Create pivot tables for what-if analysis Read the article “Make Excel an Instant Know-It-All” by Roberta Ann Jones in the March 2004 issue of the Journal of Accountancy. (Available at www.aicpa.org) a. Follow the instructions in […]
978-0133428537 Chapter 16 Solution Manual Part 1
CHAPTER 16 GENERAL LEDGER AND REPORTING SYSTEM SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 16.1 Although XBRL facilitates the electronic exchange of financial information, some external users do not think it goes far enough. They would like access to the entire general […]
978-0133428537 Chapter 15 Solution Manual Part 3
15.7 Excel Problem Objective: Learn how to use the VLOOKUP function for payroll calculations. a. Read the article “Make Excel a Little Smarter” by Lois S. Mahoney and Charles Kelliher in the Journal of Accountancy (July 2003). You can find […]
978-0133428537 Chapter 15 Solution Manual Part 2
Employee Activity Factory Workers Supervisor Payroll Clerk Chief Accountant Accounts Payable Arlington Industries manufactures and sells engine parts for large industrial equipment. The company employs over 1,000 workers for three shifts, and most employees work overtime when necessary. Figure 15-10 […]
978-0133428537 Chapter 15 Solution Manual Part 1
CHAPTER 15 THE HUMAN RESOURCES MANAGEMENT/PAYROLL CYCLE SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 15.1 This chapter noted many of the benefits that can arise by integrating the HRM and payroll databases. Nevertheless, many companies maintain separate payroll and HRM inf9+6ormation systems. […]
978-0133428537 Chapter 14 Solution Manual Part 3
Clicking “Solve” and then “Keep the Solver Solution” yields the following spreadsheet, as shown in the article: Finally, adjusting the total amount of labor hours and dollars and re-running the Solver yields the final spreadsheet depicted in the article: c. […]
978-0133428537 Chapter 14 Solution Manual Part 2
Option B: Option C: Investment = $2,000,000 Savings = $1,800,000: Reduced scrap costs = 50% x 15% x $12 x 1,000,000 units = $900,000 Reduced warranty/repair costs = 50% x 3% x $60 x 1,000,000 units = $900,000 a. Assume […]
978-0133428537 Chapter 14 Solution Manual Part 1
CHAPTER 14 THE PRODUCTION CYCLE SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 14.1. When activity-based cost reports indicate that excess capacity exists, management should either find alternative revenue-enhancing uses for that capacity or eliminate it through downsizing. What factors influence management’s decision? […]
978-0133428537 Chapter 13 Solution Manual Part 4
13.12 Figure 13-11 depicts the basic activities performed in Lexsteel’s expenditure cycle. The following additional information supplements that figure: • Because of cash flow problems, Lexsteel always pays suppliers on the last possible day before incurring a penalty for late […]
978-0133428537 Chapter 13 Solution Manual Part 3
13.11 The ABC Company performs its expenditure cycle activities using its integrated ERP system as follows: • Employees in any department can enter purchase requests for items they note as being either out of stock or in small quantity. • […]
978-0133428537 Chapter 13 Solution Manual Part 2
Accounting Information Systems Ch 13: The Expenditure Cycle 13-1 © 2015 Pearson Education, Inc. 13.3 EXCEL PROJECT. Using Benford’s Law to Detect Potential Disbursements Fraud. a. Read the article “Using Spreadsheets and Benford’s Law to Test Accounting Data,” by Mark […]
978-0133428537 Chapter 13 Solution Manual Part 1
CHAPTER 13 THE EXPENDITURE CYCLE: PURCHASING AND CASH DISBURSEMENTS SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 13.1 In this chapter and in Chapter 12 the controller of AOE played a major role in evaluating and recommending ways to use IT to improve […]
978-0133428537 Chapter 12 Solution Manual Part 5
b. Create a scattergraph to illustrate the relationship between targeted emails and unit sales. Display the regression equation and the R2 between the two variables on the chart. c. Create a scattergraph to illustrate the relationship between click ads and […]
978-0133428537 Chapter 12 Solution Manual Part 4
6. Weakness: Trial balances of the accounts receivable subsidiary ledger are not prepared independently of, or verified and reconciled to, the accounts receivable control account in the general ledger. Threat: Any of fees earned, cash receipts, and uncollectible accounts expense […]
978-0133428537 Chapter 12 Solution Manual Part 3
Step 4: Now right-click on the scroll bar tool in cell F4, select properties, and enter the following values: Step 5: Now, the amount of initial sales can be varied by clicking on the left and right arrows in the […]
978-0133428537 Chapter 12 Solution Manual Part 2
12.4 EXCEL PROJECT. (Hint: For help on steps b and c, see the article “Dial a Forecast,” by James A. Weisel, in the December 2006 issue of the Journal of Accountancy. The Journal of Accountancy is available in print or […]
978-0133428537 Chapter 12 Solution Manual Part 1
CHAPTER 12 THE REVENUE CYCLE: SALES TO CASH COLLECTIONS SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 12.1 Customer relationship management systems hold great promise, but their usefulness is determined by the amount of personal data customers are willing to divulge. How can […]
978-0133428537 Chapter 11 Solution Manual Part 2
11.8 As an internal auditor for the state auditor’s office, you are assigned to review the implementation of a new computer system in the state welfare agency. The agency is installing an online computer system to maintain the state’s database […]
978-0133428537 Chapter 11 Solution Manual Part 1
CHAPTER 11 AUDITING COMPUTER-BASED INFORMATION SYSTEMS SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 11.1 Auditing an AIS effectively requires that an auditor have some knowledge of computers and their accounting applications. However, it may not be feasible for every auditor to be […]
978-0133428537 Chapter 10 Solution Manual Part 5
If the preceding data validation rule was applied to cell C7, the spreadsheet would look like this: And clicking the drop-down arrow would display the following: 10. 10 For each of the following scenarios, determine whether the company’s current backup […]
978-0133428537 Chapter 10 Solution Manual Part 4
COLUMN J: the number of bits with the value 1. Since columns C through I contain either the number 1 or the number 0, a simple SUM(C:I) yields the number of bits with the value of 1. COLUMN K: Calculate […]
978-0133428537 Chapter 10 Solution Manual Part 3
Field 2 – Date of flight start: • Check that day, month, and year correspond to the current date. In the data validation tool, you would select the cells you want to test and enter the date value you want […]
978-0133428537 Chapter 10 Solution Manual Part 2
10.5 What are some business processes for which an organization might use batch processing? 10.6 Why do you think that surveys continue to find that a sizable percentage of organizations either do not have formal disaster recovery and business continuity […]
978-0133428537 Chapter 10 Solution Manual Part 1
CHAPTER 10 PROCESSING INTEGRITY AND AVAILABILITY CONTROLS SPECIAL INTRODUCTION TO EXCEL This chapter includes a number of problems that use Excel’s built-in Data Validation tool to help students better understand processing integrity controls by programming them in a spreadsheet. Some […]
978-0133428537 Chapter 1 Solution Manual Part 2
a. How does the image-processing system at USAA add value to the organization? b. How do the remote deposit capture and mobile banking system at USAA add value to the organization? USSA’s customers are widely scattered and USAA does not […]
978-0133428537 Chapter 1 Solution Manual Part 1
CHAPTER 1 ACCOUNTING INFORMATION SYSTEMS: AN OVERVIEW SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 1.1 The value of information is the difference between the benefits realized from using that information and the costs of producing it. Would you, or any organization, ever […]
978-1285770178 Solution Manual Unit 7
1 UNIT 7 PROPERTY AND ITS PROTECTION ANSWERS TO LEGAL REASONING QUESTIONS 1. A Facebook game, FarmVille, allows members to manage virtual crops together. Would there be any benefit in being able to pass on to one’s heirs “the fruits […]
978-1285770178 Solution Manual Unit 6
1 in whole or in part. UNIT 6 GOVERNMENT REGULATION ANSWERS TO LEGAL REASONING QUESTIONS 1. Should TV programmers and distributors be held in violation of the Sherman Act for requiring consumers to buy multichannel packages? Why or why not? […]
978-1285770178 Solution Manual Unit 5
1 in whole or in part. UNIT 5 CREDITORS’ RIGHTS AND BANKRUPTCY ANSWERS TO LEGAL REASONING QUESTIONS 1. Do you think that the law favors debtors at the expense of creditors or vice versa? Is there any way to achieve […]
978-1285770178 Solution Manual Unit 4
1 UNIT 4 DOMESTIC SALES AND LEASE CONTRACTS ANSWERS TO LEGAL REASONING QUESTIONS 1. How can a court objectively measure good faith and commercial reasonableness? The concepts of good faith and commercial reasonableness permeate the UCC and help to prevent […]
978-1285770178 Solution Manual Unit 3
1 UNIT 3 NEGOTIABLE INSTRUMENTS ANSWERS TO LEGAL REASONING QUESTIONS 1. What do you think would result if the law was changed to allow personal defenses to be successfully raised against HDCs? Who would lose, and who would gain? How […]
978-1285770178 Solution Manual Unit 2
1 in whole or in part. UNIT 2 AGENCY AND EMPLOYMENT ANSWERS TO LEGAL REASONING QUESTIONS 1. How much obedience and loyalty does an agent-employee owe to an employer? What if the employer engages in an activity—or requests that […]
978-1285770178 Solution Manual Unit 1
1 UNIT 1 BUSINESS ORGANIZATIONS ANSWERS TO LEGAL REASONING QUESTIONS 1. Three decades ago, corporations and corporate directors were rarely prosecuted for crimes, and penalties for corporate crimes were relatively light. Today, this is no longer true. Under the corporate […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch31
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 31 WILLS AND TRUSTS 1 ANSWER TO CRITICAL THINKING QUESTION IN THE FEATURE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch30
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 30 INSURANCE ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES CASE 30.1—QUESTIONS […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch29
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 29 REAL PROPERTY AND LANDLORD-TENANT LAW 1 ANSWERS TO QUESTIONS AT THE ENDS […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch28
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 28 PERSONAL PROPERTY AND BAILMENTS ANSWERS TO QUESTIONS AT THE ENDS OF THE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch27
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 27 PROFESSIONAL LIABILITY AND ACCOUNTABILITY 1A. To what extent must professionals reveal to […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch26
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 26 ANTITRUST LAW ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES CASE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch25
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 25 ENVIRONMENTAL LAW ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES CASE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch24
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 24 CONSUMER LAW ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES CASE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch23
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 23 ADMINISTRATIVE AGENCIES 1 ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch22
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 22 BANKRUPTCY LAW ANSWER TO CRITICAL THINKING QUESTION IN THE FEATURE INSIGHT INTO […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch21
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 21 SECURED TRANSACTIONS ANSWERS TO QUESTIONS AT THE ENDS OF THE CASES CASE […]
978-1285770178 Solution Manual BL ComLaw 1e SM-Ch20
© 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. CHAPTER 20 CREDITORS’ RIGHTS AND BANKRUPTCY 1 ANSWER TO CRITICAL THINKING QUESTION IN THE […]