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)

Financial Accounting

14th Edition

ISBN:9781305088436

Author:Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:Carl Warren, Jim Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4CP

See similar textbooks

Similar questions

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
Downtown! is a rapidly growing web-based retailer with about 100 management and technical support employees at its headquarters office in Florida. Mary Estrada, the firm’s IT manager, is planning a new information system that will give users better access to sales and marketing data and trends. She has a concern, however. She knows that users often request reports but use only a small portion of the data. In many offices she sees inboxes filled with printed reports gathering dust. Mary asked for your opinion: What if new system users could design most of their own reports without assistance from the IT staff, by using a powerful, user-friendly report writer program? Do you think they would request as many reports or the same types of reports? What are the pros and cons of giving users total control over output?
Iris Plant owns and operates three floral shops in Magnolia, Texas. The accounting functions are performed manually. Each of the shops has a manager who oversees the cash receipts and purchasing functions for the shop. A clerk at the central shop pays all the bills and also prepares payroll checks and maintains the general journal. Iris is seriously considering switching to a computerized system. With so many information system packages on the market, Iris is overwhelmed. Advise Iris as to which business modules you think her organization could find beneficial. Discuss advantages, disadvantages, and internal control issues.
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,…
Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…
Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day andforwards the total to the General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…
Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…
Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…
Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day andforwards the total to the General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…
Lamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Is the sales department separate from the credit office and the IT department?
ABC Company is a manufacturing company that produces furniture. To improve efficiency and usefulness, ABC Company is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…