Question

In: Accounting

Examine the following case from Turner, Weickgenannt, and Copeland (2017): Arminello, Inc. does not use a...

Examine the following case from Turner, Weickgenannt, and Copeland (2017):

Arminello, Inc. does not use a database system; rather, it maintains separate data files in each of its departments. When a sale occurs, the transaction is recorded in the sales department. Next, documentation is forwarded from the sales department to the accounting department so that the transaction can be recorded there. Finally, the customer service group is notified so that its records can be updated. (p. 499)

Describe the data redundancy and concurrency issues that are likely to arise under this scenario at Arminello, Inc. Then determine the requirements for the database system and recommend a solution to achieve the desired results. The recommendation must reflect best practices for timeliness and completeness of the information, the controls that need to be in place, and the best platform for the system.

Solutions

Expert Solution

Answer:

In the situation where Arminello is working right now, every one of the divisions are working in seclusion where how much deals occurred, bookkeeping dept will come to think about it just when they share the documents with them, subsequently no coordination by any means. This can cause a considerable measure of confuse issues in the monetary postings which can demonstrate Arminello Inc. blameworthy amid Audits. Information repetition is likewise a noteworthy worry here since divisions don't have clear perceivability, information may get copied as a result of human mistake.

The best and all around polished answer for this issue is actualizing SAP arrangement which coordinates deals, generation, back and bookkeeping divisions. Every one of them will have constant perceivability in the information and information duplication winds up irrelevant along these lines. There will be no compelling reason to share or keep up the documentation physically since everything is accessible for everybody on one basic SAP stage. On the off chance that a few divisions need protection they can arrange the framework with fundamental endorsements for getting to their information.


Related Solutions

Examine the following case from Turner, Weickgenannt, and Copeland (2017, p. 299): Following is a sales...
Examine the following case from Turner, Weickgenannt, and Copeland (2017, p. 299): Following is a sales order form for Winter's World of Wines, Inc. This form is prepared manually by a sales clerk, and is based on a telephone order from a customer. This form represents the source document that triggers the revenue process at Winter's World of Wines. (The sales order is also available for download at the end of the prompt.) Sales Order Winter's World of Wines, Inc....
Consider the following case from Turner, Weickgenannt, and Copeland (2017): CEEMCO Corp. is a small, privately...
Consider the following case from Turner, Weickgenannt, and Copeland (2017): CEEMCO Corp. is a small, privately owned manufacturing company in Cincinnati. CEEMCO manufactures custom products as well as store display products to sell to other companies such as retailers. Using an Internet search engine, do a search on the terms “CEEMCO” and “Cincinnati.” Examine the kind of manufacturing the company does. Once you have completed that, study an accounting software site such as www.2020software.com or www.accountingsoftware411.com. (p. 180) Describe the...
Analyze the following case from Turner, Weickgenannt, and Copeland (2017): At the old city hall, mail...
Analyze the following case from Turner, Weickgenannt, and Copeland (2017): At the old city hall, mail was sorted in a glorified closet—not the sort of place you'd expect to be frequented by a high‐ranking city official with multiple degrees. However, the city of Weston's chief financial officer, Steve Kaufmann, had an unusual interest in the mail. He was often known to greet the postal carrier at the door to receive the day's delivery, take it to the mail closet, then...
Analyze the following case from Turner, Weickgenannt, & Copeland (2017): After spending approximately 10 hours calling...
Analyze the following case from Turner, Weickgenannt, & Copeland (2017): After spending approximately 10 hours calling on previous sponsors, Cody felt that he had hit a brick wall. For many reasons, most of last year's sponsors were unwilling to continue their involvement with this annual fund?raiser. Cody needed to look for additional sources of funding. He spent several hours researching potential new contributors and finally located a database containing a list of businesses within the local zip code. Since the...
Examine the following case from Turner, Weickgenann, and Copeland, (2017): Melcher Enterprises is a wholesaler that...
Examine the following case from Turner, Weickgenann, and Copeland, (2017): Melcher Enterprises is a wholesaler that purchases consumer merchandise from many different suppliers. Melcher then sells this merchandise to many different retail chain stores. The following paragraphs describe the expenditures processes at Melcher: Warehouse employees constantly monitor the level of each merchandise item by assessing how many remaining boxes of items are on warehouse shelves. When a warehouse worker sees the need to order a particular product, he fills out...
Examine the following case from Turner, Weickgenann, and Copeland, (2017): When a new employee is hired,...
Examine the following case from Turner, Weickgenann, and Copeland, (2017): When a new employee is hired, the human resources department completes a personnel action form and forwards it to the payroll department. The form contains information such as pay rate, number of exemptions for tax purposes, and the type and amount of payroll deductions. When an employee is terminated or voluntarily separates from Rossi, the human resources department completes a personnel action form to indicate separation and forwards it to...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing 11,100 shares of $10 par value common stock. Haynes’s shares had a $15 per share fair value. On that date, Turner reported a net book value of $128,150. However, its equipment (with a five-year remaining life) was undervalued by $5,950 in the company’s accounting records. Also, Turner had developed a customer list with an assessed value of $32,400, although no value had been recorded...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing 9,200 shares of $10 par value common stock. Haynes’s shares had a $15 per share fair value. On that date, Turner reported a net book value of $101,250. However, its equipment (with a five-year remaining life) was undervalued by $6,150 in the company’s accounting records. Also, Turner had developed a customer list with an assessed value of $30,600, although no value had been recorded...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing 9,200 shares of $10 par value common stock. Haynes’s shares had a $15 per share fair value. On that date, Turner reported a net book value of $101,250. However, its equipment (with a five-year remaining life) was undervalued by $6,150 in the company’s accounting records. Also, Turner had developed a customer list with an assessed value of $30,600, although no value had been recorded...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing...
Haynes, Inc., obtained 100 percent of Turner Company’s common stock on January 1, 2017, by issuing 11,200 shares of $10 par value common stock. Haynes’s shares had a $15 per share fair value. On that date, Turner reported a net book value of $120,200. However, its equipment (with a five-year remaining life) was undervalued by $8,700 in the company’s accounting records. Also, Turner had developed a customer list with an assessed value of $39,100, although no value had been recorded...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT