Accounting Information Systems
Solutions
Accounting Information Systems
As we noted when presenting the recommended control plans in the matrix in Figure 12.13 (pp. 482–483) that are discussed in Exhibit 12.1 (pp. 486–487), we intentionally limited the number of plans to avoid redundancy. For example, we did not include several plans from Chapter 9 such as preformatted screens, online prompting, programmed edit checks (e.g., a reasonableness test on the purchase quantity), procedures for rejected inputs, confirm input acceptance, digital signature, and populate input screens with master data. We could also include enter receipts data hi receiving. Prepare a control matrix for just these controls. Include explanations of how each recommended existing control plan helps to accomplish—or would accomplish in the case of missing plans—each related control goal.
Annotate the flowchart in Figure 12.12 (pp. 478–479) to indicate the points where the control plans are being applied (codes P-l, ..., P-n) or the points where they could be applied hut are not (codes M-l, ..., M-n).
To prepare: Control matrix and explanations of how each recommended existing control plan helps to accomplish in the case of missing plan for each related control goals.
Steps:
- Firstly, identify the required SQL command to add an employee hire date to a pre-existing table.
- Then it is necessary to identify the required SQL commands to add the given values.
- The SQL command that adds the employee date to the employee table is:
- ALTER TABLE EMPLOYEE
ADD COLUMN Employment_Date Integer NOT NULL
- ALTER TABLE EMPLOYEE
- The above command alters the employee table and includes “Employment_Date” as the new field.
- Employee 1:
- UPDATE EMPLOYEE
SET Employment_Date=20000522
WHERE Employee_No= 'B432'
- The above command helps in adding the employment date to the particular employee number within the table.
- UPDATE EMPLOYEE
- Employee 2:
- UPDATE EMPLOYEE
SET Employment_Date=20010103
WHERE Employee_No= 'A491'
- The above command helps in adding the employment date to the particular employee number within the table...
- UPDATE EMPLOYEE
Chapter 12 Solutions
Additional Business Solutions
Find more solutions based on key concepts
Show solutions addThe premium on bonds payable account is shown on the balance sheet as A contra asset. A reduction of an expense...
Cornerstones of Financial Accounting
Flow of accounts into financial statements The balances for the accounts that follow appear in the Adjusted Tri...
Corporate Financial Accounting
T accounts, adjusting entries, financial statements, and closing entries; optional end-of-period spreadsheet Th...
Financial & Managerial Accounting
(Sole Proprietorships) What are the disadvantages of the sole proprietorship form of business?
ECON: MICRO4 (New, Engaging Titles from 4LTR Press)
What are the two subfields into which economics is divided? Explain what each subfield studies.
Brief Principles of Macroeconomics (MindTap Course List)
DEFAULT RISK PREMIUM A companys 5-year bonds are yielding 7% per year. Treasury bonds with the same maturity ar...
Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
A survey conducted by Better Homes and Gardens Real Estate LLC showed that one in five U.S. homeowners have eit...
STATISTICS F/BUSINESS+ECONOMICS-TEXT
What has been the approximate long-run growth rate of real GDP per person in the United States? Name a country ...
Principles of Macroeconomics (MindTap Course List)
INSTRUCTOR: Visit the Instructor Companion Website for lecture notes, solutions, discussion guides, and other r...
Essentials of Business Communication (MindTap Course List)
VALUATION OF A CONSTANT GROWTH STOCK Investors require an 8% rate of return on Mather Companys stock (i.e., rs ...
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Do average citizens benefit from the activities of the SBA, or is the SBA just another way to spend our tax mon...
Foundations of Business (MindTap Course List)
Adam Smith's invisible hand" refers to a. the subtle and often hidden methods that businesses use to profit at ...
Principles of Microeconomics (MindTap Course List)
Why isn't trade among countries like a game with some winners and some losers?
Principles of Economics (MindTap Course List)
The authors of the article Predictive Model for Pitting Corrosion in Buried Oil and Gas Pipelines (Corrosion, 2...
Probability and Statistics for Engineering and the Sciences
What are some pros and cons of holding high levels of current assets in relation to sales? Use the DuPont equat...
Fundamentals of Financial Management (MindTap Course List)
In what ways can the cost of a process be improved?
Financial And Managerial Accounting
In what sense is economics like a science? Draw a production possibilities frontier for a society that produce...
Essentials of Economics (MindTap Course List)
Miquel Vasquez was proud of his job as a new product manager for a biotechnology start-up, and he loved the hig...
Management, Loose-Leaf Version
The following selected transactions were completed by Niles Co. during March of the current year: Instructions ...
Financial Accounting
SUM-OF-THE-YEARS-DIGITS DEPRECIATION Using the information given in Exercise 5Apx-1B, prepare a depreciation sc...
College Accounting, Chapters 1-27
What is treasury stock, and why might a corporation acquire treasury stock?
Intermediate Accounting: Reporting And Analysis
What are nonvalue-added activities? Nonvalue-added costs? Give an example of each.
Managerial Accounting: The Cornerstone of Business Decision-Making
Discuss the differences between sales and market orientations
MKTG 12:STUDENT ED.-TEXT
In October, A. Nguyen established an apartment rental service. The account headings are presented below. Transa...
College Accounting (Book Only): A Career Approach
Summarize how marketing creates value through the four types of utility.
Contemporary Marketing
Distinguish between financial and nonfinancial transactions. Give three examples of each.
Accounting Information Systems
REGRESSION AND RECEIVABLES Edwards Industries has 320 million in sales. The company expects that its sales will...
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
Identify whether each of the following headlines represents a microeconomic topic or a macroeconomic topic. a. ...
Exploring Economics
Pew Research Center is a nonpartisan polling organization that provides information about issues, attitudes, an...
Statistics for Business & Economics, Revised (MindTap Course List)
The following transactions, adjusting entries, and closing entries were completed by Robinson Furniture Co. dur...
Financial Accounting
What is the meaning of (a) 1/15, n/60; (b) n/30; (c) n/eom?
Accounting (Text Only)
What are the major differentes between managerial accounting and financial accounting?
Financial & Managerial Accounting
A firm is about to double its assets to serve its rapidly growing market. It must choose between a highly autom...
Fundamentals of Financial Management (MindTap Course List)
Describe the impact that entity-level controls (i.e., control environment, pervasive controls, and general/IT g...
Pkg Acc Infor Systems MS VISIO CD
Which of the following accounts would appear on a post-closing trial balance? a. Depreciation Expense, Equipmen...
College Accounting (Book Only): A Career Approach
A friend of yours is considering two cell phone service providers. Provider A charges 120 per month for the ser...
Principles of Macroeconomics (MindTap Course List)
JOURNAL ENTRIESPERPETUAL INVENTORY Doreen Woods owns a small variety store. The following transactions took pla...
College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
If personal taxes are 400 billion and disposable income is 4,000 billion, then what does personal income equal?
Economics (MindTap Course List)
Home Depot: Ratio of liabilities to stockholders' equity The Home Depot, Inc., is the worlds largest home impro...
Corporate Financial Accounting
How is the special period rule for the reporting of fringe benefits applied?
PAYROLL ACCT.,2019 ED.(LL)-TEXT
Discuss the various sources of information buyers can utilize when seeking potential sources of supply.
Purchasing and Supply Chain Management
Do government officials analyze data to determine what their country can produce at a comparative advantage?
Microeconomics
Thames Assurance Company sells a variety of life and health insurance products. Recently, Thames developed a lo...
Cornerstones of Cost Management (Cornerstones Series)
Utilization rate Southwest Airlines Co. (LUV) reported the following data (in millions) for a recent year. Year...
Survey of Accounting (Accounting I)
