AFM241 Study Guide - Midterm Guide: Unique Key, Foreign Key

Robatelli's Pizzeria Case StudyIntroduction On the morning of October 31st, Elaine Black, Chief Information Officer at Robatelli's Pizzeria, was waiting for both Jim Saxton, database administrator, and Peter Greyton, operations manager, to come to her office for a meeting. While waiting, Elaine was thinking about the surge of telephone and Internet orders expected to be received through the company's customer order center within the next 12 hours. Halloween had always been the most popular day of the year for people in the greater Pittsburgh area to order pizza from Robatelli's. There were 53 restaurant locations to serve these customers, but only one location to receive all of the orders and forward them to the right restaurant. Elaine's thoughts were interrupted as Jim and Peter entered her office. The following conversation took place: ELAINE Well, guys, it's here again, our biggest day of the year. Not only is Halloween a busy day, but we have the upcoming day after Thanksgiving, the week before Christmas, and Super Bowl Sunday. Can our current computer system's infrastructure and people keep pace with the orders we expect? JIM I think our systems are all running at peak performance. We shouldn't have any computer concerns for today or those other busy days. PETER Everyone in the customer order center is focused on making sure that our customers get their pizzas as ordered. We have plenty of people scheduled to work tonight, so we're good to go. ELAINE Terrific. But every time we face one of these peak sales days, I start wondering about the long-term capacity and effectiveness of our computer systems. Jim, we need to think long term about our computer system. I was just reading an article that I'd like you to take a look at. It's about Anheuser-Busch Companies and their use of data mining. JIM I do agree with you, Elaine; we should always be thinking about how newer IT systems can help us. Could you e-mail me the link to the article? ELAINE Sure, and I would like you to think about how we might use the same approach in our business. Peter, your order center people are doing a great job, but again there's something I'd like us to think about in the long run. As you know, we now have to manually enter all customer order center sales and store sales into our general ledger (GL). I think we could improve a lot of things if those sales are automatically fed into our GL software. Why don't you think about any advantages you see for an automatic interface, and we'll look at the costs compared to those advantages. How's that sound? PETER I'll do that. I'll give it some thought and work on a report about an automatic interface between our GL software and the point of sale systems in our restaurants as well as the phone and Internet sales. How soon do you want to meet again to look at these issues? ELAINE Let's say, in two weeks at the same time. As Jim and Peter left her office, Elaine continued to think about the features of the company's accounting information systems and whether or not data extracted from these systems could facilitate the multiple needs of the company. The focus had always been on providing accurate financial accounting information from the various locations; however, the company's aggressive growth strategies meant increased emphasis on the system's ability to analyze detailed customer information that could be translated into increased sales opportunities. Elaine knew the challenges they faced could very well affect the company's ability to maintain its competitive advantage. She realized that her department must continually improve the company's information systems to help it achieve growth strategies. Operating state-of-the-art systems was imperative to position the company to execute those growth plans. However, she was concerned about the possibility that restrictions of the current information systems could actually prevent the company from doing what it wanted to do. Allowing restrictive systems to prevent them from achieving business strategies was a risk that Elaine would not tolerate!

Review the Robatelli's Pizzeria Case Study.

Develop an internal controls system in Robatelli's Pizzeria sales and cash business areas.

Prepare a 12- to 16-slide presentation describing the typical activities and outlining an effective system of internal controls for the Sales, Sales Returns, and Cash Collections business areas. Include any associated risks in these areas.

Describe specific internal controls that include authorization of transactions, segregation of duties, adequate records and documentation, security of assets, and independent checks and reconciliation for each business area.

Robatelli's Pizzeria Case Study Introduction

On the morning of October 31st, Elaine Black, Chief I...Robatelli's Pizzeria Case StudyIntroduction On the morning ofOctober 31st, Elaine Black, Chief Information Officer atRobatelli's Pizzeria, was waiting for both Jim Saxton, databaseadministrator, and Peter Greyton, operations manager, to come toher office for a meeting. While waiting, Elaine was thinking aboutthe surge of telephone and Internet orders expected to be receivedthrough the company's customer order center within the next 12hours. Halloween had always been the most popular day of the yearfor people in the greater Pittsburgh area to order pizza fromRobatelli's. There were 53 restaurant locations to serve thesecustomers, but only one location to receive all of the orders andforward them to the right restaurant. Elaine's thoughts wereinterrupted as Jim and Peter entered her office. The followingconversation took place: ELAINE Well, guys, it's here again, ourbiggest day of the year. Not only is Halloween a busy day, but wehave the upcoming day after Thanksgiving, the week beforeChristmas, and Super Bowl Sunday. Can our current computer system'sinfrastructure and people keep pace with the orders we expect? JIMI think our systems are all running at peak performance. Weshouldn't have any computer concerns for today or those other busydays. PETER Everyone in the customer order center is focused onmaking sure that our customers get their pizzas as ordered. We haveplenty of people scheduled to work tonight, so we're good to go.ELAINE Terrific. But every time we face one of these peak salesdays, I start wondering about the long-term capacity andeffectiveness of our computer systems. Jim, we need to think longterm about our computer system. I was just reading an article thatI'd like you to take a look at. It's about Anheuser-Busch Companiesand their use of data mining. JIM I do agree with you, Elaine; weshould always be thinking about how newer IT systems can help us.Could you e-mail me the link to the article? ELAINE Sure, and Iwould like you to think about how we might use the same approach inour business. Peter, your order center people are doing a greatjob, but again there's something I'd like us to think about in thelong run. As you know, we now have to manually enter all customerorder center sales and store sales into our general ledger (GL). Ithink we could improve a lot of things if those sales areautomatically fed into our GL software. Why don't you think aboutany advantages you see for an automatic interface, and we'll lookat the costs compared to those advantages. How's that sound? PETERI'll do that. I'll give it some thought and work on a report aboutan automatic interface between our GL software and the point ofsale systems in our restaurants as well as the phone and Internetsales. How soon do you want to meet again to look at these issues?ELAINE Let's say, in two weeks at the same time. As Jim and Peterleft her office, Elaine continued to think about the features ofthe company's accounting information systems and whether or notdata extracted from these systems could facilitate the multipleneeds of the company. The focus had always been on providingaccurate financial accounting information from the variouslocations; however, the company's aggressive growth strategiesmeant increased emphasis on the system's ability to analyzedetailed customer information that could be translated intoincreased sales opportunities. Elaine knew the challenges theyfaced could very well affect the company's ability to maintain itscompetitive advantage. She realized that her department mustcontinually improve the company's information systems to help itachieve growth strategies. Operating state-of-the-art systems wasimperative to position the company to execute those growth plans.However, she was concerned about the possibility that restrictionsof the current information systems could actually prevent thecompany from doing what it wanted to do. Allowing restrictivesystems to prevent them from achieving business strategies was arisk that Elaine would not tolerate! Background Robatelli'sPizzeria is a great American success story. Started by DinoRobatelli in the 1960s, the business impetus was a family pizzarecipe. Introduced to the public at a church festival inPittsburgh's Little Italy, Robatelli's pizzas are now a recognizedtradition in the Greater Pittsburgh area. A full menu and localexpansion have led to its growing popularity over the years andhave helped it achieve nearly 50 percent of the area market share.Annual sales now exceed $100 million. Following is a timeline ofmilestones in the company's history: 1962 Dino and Gloria Robatellicontributed $500 and the family pizza recipe to a partnership thatopened the first Robatelli's Pizzeria. 1965 The Robatellis boughtout their business partners. 1967 The first Robatelli's franchiseopened. 1971–77 Dozens of new Robatelli's franchises openedthroughout the surrounding region. 1983 Home delivery servicebegan. 1992 A central, one-number calling system for allrestaurants was launched. 2003 Internet ordering began. The first“prototype pizzeria” opened. Today A total of 53 locations are inoperation.

Review the Robatelli's Pizzeria Case Study. Considering thenature of the relationship between Robatelli's Pizzeria home officeand its franchise owners, the company may be quite vulnerable totheft or fraudulent financial reporting committed by thesefranchise owners.

In 700 to 1,050 words, discuss the following: Describe threecomponents of the fraud triangle and how each would relate to afranchise owner's likelihood to defraud Robatelli's Pizzeria.Identify three types of fraud to which Robatelli's Pizzeria may besusceptible. Indicate whether the fraud is classified as managementfraud, employee fraud, vendor fraud, customer fraud, or computerfraud for each. Suggest an internal control that could beimplemented to prevent or detect the potential fraud for each.Design a 5- to 6-bulleted item code of ethics for Robatelli'sPizzeria. You may find guidance by searching the Internet forexamples.

Robatelli's Pizzeria Case StudyIntroduction

On the morning of October 31st, Elaine Black, Chief InformationOfficer at Robatelli's Pizzeria, was waiting for both Jim Saxton,database administrator, and Peter Greyton, operations manager, tocome to her office for a meeting. While waiting, Elaine wasthinking about the surge of telephone and Internet orders expectedto be received through the company's customer order center withinthe next 12 hours. Halloween had always been the most popular dayof the year for people in the greater Pittsburgh area to orderpizza from Robatelli's. There were 53 restaurant locations to servethese customers, but only one location to receive all of the ordersand forward them to the right restaurant. Elaine's thoughts wereinterrupted as Jim and Peter entered her office. The followingconversation took place: ELAINE Well, guys, it's here again, ourbiggest day of the year. Not only is Halloween a busy day, but wehave the upcoming day after Thanksgiving, the week beforeChristmas, and Super Bowl Sunday. Can our current computer system'sinfrastructure and people keep pace with the orders we expect? JIMI think our systems are all running at peak performance. Weshouldn't have any computer concerns for today or those other busydays. PETER Everyone in the customer order center is focused onmaking sure that our customers get their pizzas as ordered. We haveplenty of people scheduled to work tonight, so we're good to go.ELAINE Terrific. But every time we face one of these peak salesdays, I start wondering about the long-term capacity andeffectiveness of our computer systems. Jim, we need to think longterm about our computer system. I was just reading an article thatI'd like you to take a look at. It's about Anheuser-Busch Companiesand their use of data mining. JIM I do agree with you, Elaine; weshould always be thinking about how newer IT systems can help us.Could you e-mail me the link to the article? ELAINE Sure, and Iwould like you to think about how we might use the same approach inour business. Peter, your order center people are doing a greatjob, but again there's something I'd like us to think about in thelong run. As you know, we now have to manually enter all customerorder center sales and store sales into our general ledger (GL). Ithink we could improve a lot of things if those sales areautomatically fed into our GL software. Why don't you think aboutany advantages you see for an automatic interface, and we'll lookat the costs compared to those advantages. How's that sound? PETERI'll do that. I'll give it some thought and work on a report aboutan automatic interface between our GL software and the point ofsale systems in our restaurants as well as the phone and Internetsales. How soon do you want to meet again to look at these issues?ELAINE Let's say, in two weeks at the same time. As Jim and Peterleft her office, Elaine continued to think about the features ofthe company's accounting information systems and whether or notdata extracted from these systems could facilitate the multipleneeds of the company. The focus had always been on providingaccurate financial accounting information from the variouslocations; however, the company's aggressive growth strategiesmeant increased emphasis on the system's ability to analyzedetailed customer information that could be translated intoincreased sales opportunities. Elaine knew the challenges theyfaced could very well affect the company's ability to maintain itscompetitive advantage. She realized that her department mustcontinually improve the company's information systems to help itachieve growth strategies. Operating state-of-the-art systems wasimperative to position the company to execute those growth plans.However, she was concerned about the possibility that restrictionsof the current information systems could actually prevent thecompany from doing what it wanted to do. Allowing restrictivesystems to prevent them from achieving business strategies was arisk that Elaine would not tolerate! Background Robatelli'sPizzeria is a great American success story. Started by DinoRobatelli in the 1960s, the business impetus was a family pizzarecipe. Introduced to the public at a church festival inPittsburgh's Little Italy, Robatelli's pizzas are now a recognizedtradition in the Greater Pittsburgh area. A full menu and localexpansion have led to its growing popularity over the years andhave helped it achieve nearly 50 percent of the area market share.Annual sales now exceed $100 million. Following is a timeline ofmilestones in the company's history: 1962 Dino and Gloria Robatellicontributed $500 and the family pizza recipe to a partnership thatopened the first Robatelli's Pizzeria. 1965 The Robatellis boughtout their business partners. 1967 The first Robatelli's franchiseopened. 1971–77 Dozens of new Robatelli's franchises openedthroughout the surrounding region. 1983 Home delivery servicebegan. 1992 A central, one-number calling system for allrestaurants was launched. 2003 Internet ordering began. The first“prototype pizzeria” opened. Today A total of 53 locations are inoperation.

Review the Robatelli's Pizzeria Case Study. Considering thenature of the relationship between Robatelli's Pizzeria home officeand its franchise owners, the company may be quite vulnerable totheft or fraudulent financial reporting committed by thesefranchise owners. I

n 700 to 1,050 words, discuss the following: Describe threecomponents of the fraud triangle and how each would relate to afranchise owner's likelihood to defraud Robatelli's Pizzeria.Identify three types of fraud to which Robatelli's Pizzeria may besusceptible.

Indicate whether the fraud is classified as management fraud,employee fraud, vendor fraud, customer fraud, or computer fraud foreach.

Suggest an internal control that could be implemented to preventor detect the potential fraud for each. Design a 5- to 6-bulleteditem code of ethics for Robatelli's Pizzeria. You may find guidanceby searching the Internet for examples.