X-Mart is a domestic chain of retail business. It has multiple branches across country. All the branches are using different software to capture their transaction processing data (Sales, Purchase, Inventory) It very difficult to Analyse the entire data for the retail store. Management wants the data to be at one place so that its easy for analysis for Managers in different departments. A. What approach you will take to bring data from all sources. (Explain-ETL) B. What benefits Managers will get once the Data warehousing is implemented. C. Give two sample reports from each business area (Sales, Purchase, Inventory), which managers will use for Analysis. (No Report Layout required - Name the Fields which will be displayed on the report)

X-Mart is a domestic chain of retail business. It has multiple branches across country. All the branches are using different software to capture their transaction processing data (Sales, Purchase, Inventory) It very difficult to Analyse the entire data for the retail store. Management wants the data to be at one place so that its easy for analysis for Managers in different departments. A. What approach you will take to bring data from all sources. (Explain-ETL) B. What benefits Managers will get once the Data warehousing is implemented. C. Give two sample reports from each business area (Sales, Purchase, Inventory), which managers will use for Analysis. (No Report Layout required - Name the Fields which will be displayed on the report)

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter3: Ethics, Fraud, And Internal Control

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

When you look at the organizational structure of ABC Inc., you notice that the Marketing department is divided into communications, event planning, marketing, and web content. You also see that the Accounting department has separate units for accounts payable and accounts receivable. ABC Inc. uses ________ departmentalization. Question 9 options: A) product B) geographic C) functional D) customer E) process
A wide range of accounting information system (AIS) software programs are available in the marketplace. Businesses select one that fits their needs based on budget and systems requirements. Do some research to understand the differences between the way systems process accounting information and produce reports. Choose two types of software from the following list to compare: QuickBooks, Peachtree, Oracle NetSuite, SAP, or MS Access. compare these aspects of each software program: Compare the pros and cons of each system to show the system's benefits and drawbacks for businesses in the way they handle transaction processing for accounting cycles. Discuss the way artificial intelligence (AI) or machine learning is utilized in the system and how these tools elevate data processing and data analytics.
For the following situations, identify whether the description is probably a centralized or decentralized organization. A. Seaside Furniture, a small builder of side tables managed solely by its sole proprietor B. Harbor Marketing, which wants Advertising Team Leaders to be able to respond quickly to needs of potential clients so Team Leaders have the authority to make decisions about advertising and pricing C. Coutures Creations, with a single owner who manages the production, accounting, engineering, sales, and other administrative functions D. British Navy E. McDonalds franchise #3101 in Canton. Ohio F. United States Army
1. A clerk in the sales department receives a hard-copy customer order by mail and manually prepares four hard copies of a sales order. This is a typical event in the Group of answer choices b. Expenditure cycle d. Costing cycle a. Revenue cycle c. Conversion cycle 2. Which of these is not a true statement relating to manual and electronic accounting systems? Group of answer choices a. Large businesses integrate their accounting software with their overall computerised information system. b. The accounting principles underlying manual and electronic systems are fundamentally different. c. Computerised systems normally provide more reports, providing greater information to users, than manual systems. d. Most entities today use computerised accounting systems. 3. All of the following are advantages of using subsidiary ledgers, except Group of answer choices a. they make possible a division of labour b. they show all the transactions affecting customers and creditors.…
Give specific example of Business Analytics application in each of the following : 1. Customer Acquisition 2. Cross sell/Up sell 3. Retention/ Attrition 4. Credit Risk 5. Customer Segmentation 6. Market Basket Analysis 7. Social Network Analysis 8. Fraud Detection 9. Forecasting & Optimization Make a list of the sources
More and more businesses are adopting the use of Customer Relationship Management (CRM) software’s within the Accounting information Systems. Required; i) Explain two benefits that a business enjoys by using Customer Relationship Management (CRM) software’s.
After completing your first degree in accounting you have been employed by XYZ Company as an account officer. The Management of the company has tasked you to implement a computerized accounting system Explain the difference between a stand-alone package and an integrated package? Explain two advantaged and two disadvantages of an integrated package e) Before a new accounting package can be deployed, it needs to be configured. What does it mean to configure an accounting package? Explain the processes involved in the configuration of an accounting package.
You are the newly appointed Records Manager of Transgenerational Thinkers International (GTI).After previewing the structure of the company you realized that it doesn’t have a proper database.Due to this hidden setback, the company always fails to meet its expected profit margin.Develop a comprehensive database to remedy this issue.The database should include;A. i) Customer table andii) Customer registration formB. Fill the table with 30 records.C. The fields of the table should be the same as the forms.Footnotes:D. Your table should include the following fields as headingsI) CustomerID ( eg. CID101, CID102, CID103…………….CID130) II) Surname III) OtherName IV) V) VI) VII) VIII) GenderProductID (eg. P01, P02……………P30)ProductNameProduct Photo (just type in product image)Contact IX) Location X) Date of registration XI) Email XII) Customer photo ( just type in customer image) 3E. Click on insert, select textbox to develop the form below, apply a fill colour for all the…
Describe cloud computing and explain how it is similar to obtaining commodity products? Why is it important to organizationally separate the accounting function from the other functions of the organization? what is an external financial audit, and what are the sources of audit evidence? Why do firms outsource their IT functions? Explain the options of traditional IT outsourcing and cloud computing, and how they differ.
As Elaine Black reflects on her meeting with Jim Saxton and Peter Greyton, she considers where the company has been and where it is heading, and ponders the current issues regarding Robatelli's accounting information systems and its ability to take and record sales. She is concerned about the limitations of the current accounting information system. Are internal controls strong enough? Would a new, integrated IT system yield improvements? As she contemplates the integration of the POS systems at the restaurant locations with the GL software at the home office, she wonders about the requirements for developing and implementing such a system, and how to best utilize the system to support Robatelli's plans for growth. Elaine realizes that her ability to address these issues will be critical not only to the success of the company, but also to her career. Briefly describe the differences in Robatelli's three order-entry systems (in-store, telephone, and Internet). For each method,…
As Elaine Black reflects on her meeting with Jim Saxton and Peter Greyton, she considers where the company has been and where it is heading, and ponders the current issues regarding Robatelli's accounting information systems and its ability to take and record sales. She is concerned about the limitations of the current accounting information system. Are internal controls strong enough? Would a new, integrated IT system yield improvements? As she contemplates the integration of the POS systems at the restaurant locations with the GL software at the home office, she wonders about the requirements for developing and implementing such a system, and how to best utilize the system to support Robatelli's plans for growth. Elaine realizes that her ability to address these issues will be critical not only to the success of the company but also to her career. Briefly describe the differences in Robatelli's three order-entry systems (in-store, telephone, and Internet). For each method,…
Match the following terms with their definitions. (Use each definition only once.) A (Consider the following definitions.) Term Definition More Info 1. Internal control 2. Control procedures 3. Firewalls a. Two or more people working together to overcome internal controls. 4. Encryption b. Part of internal control that ensures resources are not wasted. 5. Environment c. Requires companies to review internal control and take responsibility for the accuracy and completeness of their financial reports. 6. Information system d. Should be prenumbered to prevent theft and inefficiency. 7. Separation of duties e. Limits access to a local network. 8. Collusion f. Example: The person who opens the bank statement should not also be the person who is reconciling cash. 9. Documents g. Identification of uncertainties that may arise due to a company's products, services or operations. 10. Audits h. Examination of a company's financial statements and accounting system by a trained accounting…