Question
1.0 Introduction On the morning of October 31 st , Peter Greyton, Chief Information Officer at Mamas Pizzeria, was waiting for both Jim Saxton, database
1.0 Introduction
On the morning of October 31st, Peter Greyton, Chief Information Officer at Mamas Pizzeria, was waiting for both Jim Saxton, database administrator, and Elaine Black, operations manager, to come to his office for a meeting. While waiting, Peter was thinking about the surge of telephone and Internet orders expected to be received through the companys customer order centre 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 Mamas Pizzeria. There were 49 restaurant locations to serve these customers, but only one location to receive all of the orders and forward them to the right restaurant. Peters thoughts were interrupted as Jim and Elaine entered his office. The following conversation took place:
PETER: Well, guys, its 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 systems infrastructure and people keep pace with the orders we expect?
JIM: I think our systems are all running at peak performance. We shouldnt have any computer concerns for today or those other busy days.
ELAINE: Everyone in the customer order centre is focused on making sure that our customers get their pizzas as ordered. We have plenty of people scheduled to work tonight, so were good to go.
PETER: 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 Id like you to take a look at. Its about Anheuser-Busch Companies and their use of data mining.
JIM: I do agree with you, Pete; we should always be thinking about how newer IT systems can help us. Could you email me the link to the article?
PETER: Sure, and I would like you to think about how we might use the same approach in our business. Elaine, your order centre people are doing a great job, but again theres something Id like us to think about in the long run. As you know, we now have to manually enter all customer order centre sales and store sales into our general ledger (GL). I think we could improve a lot of things if those sales fed automatically into our GL software. Why dont you think about any advantages you see for an automatic interface, and well look at the costs compared to those advantages. Hows that sound?
ELAINE: Ill do that. Ill 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?
PETER: Lets say in 2 weeks at the same time.
As Jim and Elaine left his office, Peter continued to think about the features of the companys 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 companys aggressive growth strategies meant increased emphasis on the systems ability to analyze detailed customer information that could be translated into increased sales opportunities.
Peter knew the challenges they faced could very well affect the companys ability to maintain its competitive advantage. He realized that his department must continually improve the companys 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, he 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 Peter would not tolerate!
2.0 Background
Mamas Pizzeria is a great American success story. Started by Dino in the 1960s, the business impetus was a family pizza recipe. Introduced to the public at a church festival in Pittsburghs Little Italy, Mamas Pizzeria pizzas are now a recognized tradition in the Greater Pittsburgh area. A full menu and local expansion have led to its growing popularity over the years and have helped it achieve nearly 50% of the area market share. Annual sales now exceed $100 million. Following is a timeline of milestones in the companys history:
Dino and Gloria contributed $500 and the family pizza recipe to a partnership that opened the first Mamas Pizzeria.
The Mamas Pizzeria bought out their business partners.
The first Mamas Pizzeria franchise opened.
1971-77 Dozens of new Mamas Pizzeria franchises opened throughout the surrounding region.
1983 Home delivery service began
1992 A central, one-number calling system for all restaurants was launched.
2003 Internet ordering began. The first prototype pizzeria opened.
Today A total of 49 locations are in operation.
The company has been known for its ability to get ahead of national trends. For instance, in the early 1980s, Mamas Pizzeria began offering delivery service; however, while the competitors were merely delivering pizzas, Mamas Pizzeria delivered many additional items from its extensive menu. The company was also on the cutting edge when it launched its one-number telephone ordering system whereby a single telephone number was used to service sales orders for the entire region. Additional conveniences became available about ten years later when Mamas Pizzeria introduced online ordering.
Recently, it has expanded its menu offerings and opened prototypes restaurants specially designed with new features (such as a full-service bar and a retail counter) that appeal to various customer groups. Each of these advancements has propelled Mamas Pizzeria growth over the past four decades.
Dinos name is also well known for its tradition of supporting neighborhood organizations. Mamas Pizzeria promotes schools, amateur athletics and other community groups. Interestingly, some local student athletes were a tremendous help to Mamas Pizzeria in 1971 when the business was in trouble. A fire had destroyed much of the building containing Mamas Pizzeria original pizzeria and commissary. The commissary made menu ingredients for all of the Mamas Pizzerias, so the entire business was in jeopardy when this facility became inoperable. Area students and coaches helped with the clean-up and rebuilding efforts that made it possible for the facility to be reopened in a fraction of the anticipated time. Dino thanked them by establishing a hall of fame that has become a fixture of Greater Pittsburgh high school athletics.
Mamas Pizzeria reputation for great Italian food and innovations in both customer service and community service have contributed to the companys ability to grow into the most popular pizzeria in the Greater Pittsburgh region. Mamas Pizzeria sales include an average of 110,000 pizzas per week. It has managed to stay ahead of the national competitors, which is an unusual feat. In fact, many people in and around Pittsburgh believe that pizza can only be Mamas Pizzeria!
3.0 Multiple Systems, Multiple Functions, Multiple Uses of Information
There are three ways to place an order at Mamas Pizzeria: in-store, via telephone, or online.
In-store orders
In-store orders are taken by restaurant staff serving patrons dining in one of Mamas Pizzeria restaurant or walking in to place an order. Servers manually complete an order ticket at the tableside and input the information into the companys point of sales system through computer terminals located in the food preparation stations. Walk-in orders are typically entered directly into the system by staff using the computer terminal located at the counter.
Telephone orders
Approximately two-thirds of the companys business is processed via the telephone. Mamas Pizzeria phone ordering system is called a one-number system, referring to the convenience of ordering through a single phone number, regardless of the restaurant location nearest the customer
Most phone orders are received by an operator, who enters the order directly into a computer terminal while speaking with the customer. Customer phone numbers are used to present the customer with his or her choice of the nearest pizzeria for preparation and carry-out or delivery. The software in the system references a street database to verify that the street address exists. Credit card numbers are obtained from customers paying by credit card. The customer service representative verifies the order and credit card number before ending the call.
Upon confirmation of an order, the order is sent directly to the restaurant, where it is processed through the companys transaction processing system and printed at the appropriate food preparation station(s). Credit card numbers are included in the transmission, and all credit card transactions are processed at the restaurants at the time the order is received.
There are several advantages of handling phone orders through a customer order center rather than at an individual restaurant location. Above all, the reduction in background noise improves the accuracy of the order-taking process. In addition, the customers wait time is greatly reduced. Before Mamas Pizzeria implemented its one-number system, customers wait time at peak could be up to 15 minutes. The order centers average wait time goal is now one minute or less.
Internet orders
To place an online order, a customer must be registered. Registration is a simple process that can occur anytime during business hours. Customers are asked to provide identifying information that will be retained in the system. Repeat customers will not have to go through the registration process again.
Web-based ordering is tied to the companys one-number system. When a customer enters an order online, customer information is pulled from the one-number system. Identifying data such as phone number and address does not have to be entered. Menu offerings are presented on the screen in various drop-down boxes so that any combination of items can be ordered with many different choices of toppings or accompaniments. A customer must answer a series of questions regarding the order, similar to the questions that would be asked if the customer had been speaking with an operator.
Online orders also require confirmation of the menu items and restaurant location before the call is ended. Credit card information may be entered online and the transaction will be processed at the restaurant filling the order (as is done for telephone orders). Two firewalls protect the security of customer information submitted online.
Customer Service
Up to 135 customer service representatives may be on hand at the customer order center to process orders coming in to the business at peak. In addition, Mamas Pizzeria employs approximately 10 home-based agents to handle incoming orders. Home-based agents may perform any of the customer service functions from a computer terminal located within their homes.
All operators are required to undergo a one-week training program before they begin serving customers. After the training program, operators are subject to one week of supervised on-the-job training, followed by ongoing performance evaluations. Supervisors at the customer order center perform order scanning, whereby orders are randomly reviewed for reasonableness. Order scanning is performed more frequently for orders taken by new operators. Supervisors also follow up on errors and customer complaints, and may listen in on calls to review the operators performance. If customers are in need of customer service, they may call or e-mail the company. Supervisors handle these types of calls and e-mail messages, and will respond either via telephone or reply e-mail. Restaurant managers can also print customer complaints at their respective locations.
Accounting Functions
Mamas Pizzeria ordering systems and transaction processing systems are the source of all sales information sent to the accounting department. Restaurant managers prepare daily sales summaries and submit them to the companys administrative offices on the following day. These summaries are transmitted electronically via the intranet and are received in the accounting department. Accounting staff prepare general ledger entries based upon these sales summaries and key the information into the companys accounting software. The transaction processing system provides sales by restaurant for call-in and Internet orders, which are reconciled to the restaurant summaries on a daily basis. Once the accounting system is updated and the daily reconciliations are performed, the data is stored in an on-site server.
Although there is a lot of information to manage, coming from many different locations, and the capacity of the system is nearly 25 times its current load.
Information Technology
The information technology staff at Mamas Pizzeria is continuously engaged in system maintenance activities. Because the business changes so frequently, systems maintenance is an ongoing process. Every time a new coupon is offered, a price is changed, or a new menu item becomes available, the related information must be integrated into the transaction processing system.
Each menu addition has its own level of complexity, and many of the items include options to customize to individual tastes in a plethora of combinations. This poses a challenge in ordering; however, the menu presentation continues to be improved to eliminate chances of an incomplete or incorrect order. The options are available online and to customer service representatives via drop-down boxes on their computer screens. Most screens require an entry, even if it is none, in order to ensure that no part of the order is forgotten.
Section 3 To be completed by the Chief Marketing Officer of the IT Governance Team
You are the Chief Marketing Officer of Mamas Pizzeria involved as part of the IT Governance team to provide your opinion and solutions for the following questions:
Consider the following issues related to the revenues processes at Mamas Pizzeria.
As Peter Greyton reflects on his meeting with Jim Saxton and Elaine Black, he considers where the company has been and where it is heading, and ponders the current issues regarding Mamas Pizzeria accounting information systems and its ability to take and record sales. He 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 he contemplates the integration of the POS systems at the restaurant locations with the GL software at the home office, he wonders about the requirements for developing and implementing such a system, and how to best utilize the system to support Mamas Pizzeria plans for growth. Peter realizes that his ability to address these issues will be critical not only to the success of the company, but also to his career.
Required:
1. Discuss whether Mamas Pizzeria Internet order activities can be termed as e-commerce.
2. Given the privacy practices, describe the kind of customer data that Mamas Pizzeria could reasonably collect and store, and also describe some data that Mamas Pizzeria should not collect and store. Explain the reasons for these differences.
3. Describe the internal controls related to Internet orders that Mamas Pizzeria should have in place.
4. Briefly describe the differences in Mamas Pizzeria 3 order entry systems (in-store, telephone, and Internet). For each method, specifically identify the employees needed and describe the tasks performed by these employees.
5. Draw 3 process maps of the ordering and sales processes at Mamas Pizzeria. One process map should depict in-store sales, second map should depict phone orders, and the third map should depict on-line orders.
From the descriptions of Mamas Pizzeria various revenue and collection processes, answer the following questions regarding internal controls:
6) Separately identify at least one internal control strength and/or weakness for each of the 3 ordering systems (in-store, telephone, and Internet).
7) What is the control purpose of the drop-down boxes in the Internet ordering system?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started